Understanding MySQL Internals

3,37 valoración promedio
( 19 valoraciones por GoodReads )
 
9780596009571: Understanding MySQL Internals
From the Publisher:

Although MySQL's source code is open in the sense of being publicly available, it's essentially closed to you if you don't understand it. In this book, Sasha Pachev -- a former member of the MySQL Development Team -- provides a comprehensive tour of MySQL 5 that shows you how to figure out the inner workings of this powerful database. You'll go right to heart of the database to learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and much more.



The core of Understanding MySQL Internals begins with an Architecture Overview that provides a brief introduction of how the different components of MySQL work together. You then learn the steps for setting up a working compilable copy of the code that you can change and test at your pleasure. Other sections of the book cover:



  • Core server classes, structures, and API
  • The communication protocol between the client and the server
  • Configuration variables, the controls of the server; includes a tutorial on how to add your own
  • Thread-based request handling -- understanding threads and how they are used in MySQL
  • An overview of MySQL storage engines
  • The storage engine interface for integrating third-party storage engines
  • The table lock manager
  • The parser and optimizer for improving MySQL's performance
  • Integrating a transactional storage engine into MySQL
  • The internals of replication




Understanding MySQL Internals provides unprecedented opportunities for developers, DBAs, database application programmers, IT departments, software vendors, and computer science students to learn about the inner workings of this enterprise-proven database. With this book, you will soon reach a new level of comprehension regarding database development that will enable you to accomplish your goals. It's your guide to discovering and improving a great database.

About the Author:

Sasha Pachev graduated from the Brigham Young University in 1998 with a degree in Computer Science, worked on the MySQL development team in 2000-2002, and was the original developer of replication in MySQL. In 2003 he wrote his first book MySQL Enterprise Solutions. He currently lives in Provo, Utah with his wife Sarah and his five children working as an independent consultant with the emphasis onMySQL.

In spite of his great interest in computers, Sasha is equallypassionate about distance running. He has won a number of marathons, has a personal best of 2:24:47, and is attempting to qualify for the US Olympic Trials. He feels it is important to help other runners reach their potential, and operates a web site http://FastRunningBlog.Com dedicated to that purpose.

"Sobre este título" puede pertenecer a otra edición de este libro.

Los mejores resultados en AbeBooks

1.

Sasha Pachev
ISBN 10: 0596009577 ISBN 13: 9780596009571
Nuevos Paperback Cantidad: > 20
Impresión bajo demanda
Librería
BargainBookStores
(Grand Rapids, MI, Estados Unidos de America)
Valoración
[?]

Descripción Paperback. Estado de conservación: New. This item is printed on demand. Item doesn't include CD/DVD. Nº de ref. de la librería 975567

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 25,72
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,75
A Estados Unidos de America
Destinos, gastos y plazos de envío

2.

Sasha Pachev
Editorial: O'Reilly Media
ISBN 10: 0596009577 ISBN 13: 9780596009571
Nuevos PAPERBACK Cantidad: > 20
Librería
Mediaoutlet12345
(Springfield, VA, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media. PAPERBACK. Estado de conservación: New. 0596009577 *BRAND NEW* Ships Same Day or Next!. Nº de ref. de la librería SWATI2122342483

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 26,64
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,75
A Estados Unidos de America
Destinos, gastos y plazos de envío

3.

Sasha Pachev
Editorial: O Reilly Media, Inc, USA, United States (2007)
ISBN 10: 0596009577 ISBN 13: 9780596009571
Nuevos Paperback Cantidad: 1
Librería
The Book Depository US
(London, Reino Unido)
Valoración
[?]

Descripción O Reilly Media, Inc, USA, United States, 2007. Paperback. Estado de conservación: New. 229 x 178 mm. Language: English . Brand New Book. Although MySQL s source code is open in the sense of being publicly available, it s essentially closed to you if you don t understand it. In this book, Sasha Pachev - a former member of the MySQL Development Team - provides a comprehensive tour of MySQL 5 that shows you how to figure out the inner workings of this powerful database. You ll go right to heart of the database to learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and much more. The core of Understanding MySQL Internals begins with an Architecture Overview that provides a brief introduction of how the different components of MySQL work together. You then learn the steps for setting up a working compilable copy of the code that you can change and test at your pleasure. Other sections of the book cover: core server classes, structures, and API; the communication protocol between the client and the server; configuration variables, the controls of the server; includes a tutorial on how to add your own; thread-based request handling - understanding threads and how they are used in MySQL; an overview of MySQL storage engines; the storage engine interface for integrating third-party storage engines; the table lock manager; the parser and optimizer for improving MySQL s performance; integrating a transactional storage engine into MySQL; and the internals of replication. Understanding MySQL Internals provides unprecedented opportunities for developers, DBAs, database application programmers, IT departments, software vendors, and computer science students to learn about the inner workings of this enterprise-proven database. With this book, you will soon reach a new level of comprehension regarding database development that will enable you to accomplish your goals. It s your guide to discovering and improving a great database. Nº de ref. de la librería AAH9780596009571

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 31,53
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

4.

Sasha Pachev
Editorial: O Reilly Media, Inc, USA, United States (2007)
ISBN 10: 0596009577 ISBN 13: 9780596009571
Nuevos Paperback Cantidad: 1
Librería
The Book Depository
(London, Reino Unido)
Valoración
[?]

Descripción O Reilly Media, Inc, USA, United States, 2007. Paperback. Estado de conservación: New. 229 x 178 mm. Language: English . Brand New Book. Although MySQL s source code is open in the sense of being publicly available, it s essentially closed to you if you don t understand it. In this book, Sasha Pachev - a former member of the MySQL Development Team - provides a comprehensive tour of MySQL 5 that shows you how to figure out the inner workings of this powerful database. You ll go right to heart of the database to learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and much more. The core of Understanding MySQL Internals begins with an Architecture Overview that provides a brief introduction of how the different components of MySQL work together. You then learn the steps for setting up a working compilable copy of the code that you can change and test at your pleasure. Other sections of the book cover: core server classes, structures, and API; the communication protocol between the client and the server; configuration variables, the controls of the server; includes a tutorial on how to add your own; thread-based request handling - understanding threads and how they are used in MySQL; an overview of MySQL storage engines; the storage engine interface for integrating third-party storage engines; the table lock manager; the parser and optimizer for improving MySQL s performance; integrating a transactional storage engine into MySQL; and the internals of replication. Understanding MySQL Internals provides unprecedented opportunities for developers, DBAs, database application programmers, IT departments, software vendors, and computer science students to learn about the inner workings of this enterprise-proven database. With this book, you will soon reach a new level of comprehension regarding database development that will enable you to accomplish your goals. It s your guide to discovering and improving a great database. Nº de ref. de la librería AAH9780596009571

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 34,31
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

5.

Sasha Pachev
Editorial: O'Reilly Media 2007-04-17 (2007)
ISBN 10: 0596009577 ISBN 13: 9780596009571
Nuevos Cantidad: 5
Librería
Chiron Media
(Wallingford, Reino Unido)
Valoración
[?]

Descripción O'Reilly Media 2007-04-17, 2007. Estado de conservación: New. Brand new book, sourced directly from publisher. Dispatch time is 24-48 hours from our warehouse. Book will be sent in robust, secure packaging to ensure it reaches you securely. Nº de ref. de la librería NU-ING-00449364

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 31,35
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,47
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

6.

Sasha Pachev
Editorial: O'Reilly Media (2007)
ISBN 10: 0596009577 ISBN 13: 9780596009571
Nuevos Tapa blanda Cantidad: 1
Librería
Book Deals
(Lewiston, NY, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media, 2007. Estado de conservación: New. Brand New, Unread Copy in Perfect Condition. A+ Customer Service! Summary: Preface1. MySQL History and ArchitectureMySQL HistoryMySQL Architecture2. Nuts and Bolts of Working with the MySQL Source CodeUnix ShellBitKeeperPreparing the System to Build MySQL from BitKeeper TreeBuilding MySQL from BitKeeper TreeBuilding from Source DistributionInstalling MySQL into a System DirectorySource Code Directory LayoutPreparing the System to Run MySQL in a DebuggerDebugger-Guided Source TourBasics of Working with gdbFinding Things in the SourceInteresting Breakpoints and VariablesMaking a Source ModificationCoding GuidelinesKeeping Your BitKeeper Repository Up to DateSubmitting a Patch3. Core Classes, Structures, Variables, and APIsTHDNETTABLEFieldUtility API CallsPreprocessor MacrosGlobal Variables4. Client/Server CommunicationProtocol OverviewPacket FormatRelationship Between MySQL Protocol and OS LayerAuthenticating HandshakeCommand PacketServer Responses5. Configuration VariablesConfiguration Variables TutorialInteresting Aspects of Specific Configuration Variables6. Thread-Based Request HandlingThreads Versus ProcessesImplementation of Request HandlingThread Programming Issues7. The Storage Engine InterfaceThe handler ClassAdding a Custom Storage Engine to MySQL8. Concurrent Access and LockingTable Lock Manager9. Parser and OptimizerParserOptimizer10. Storage EnginesShared Aspects of ArchitectureInnoDBMemory (Heap)MyISAM MergeNDBArchiveFederated11. TransactionsOverview of Transactional Storage Engine ImplementationImplementing the handler SubclassDefining the handlertonWorking with the Query CacheWorking with the Replication Binary LogAvoiding Deadlocks12. ReplicationOverviewStatement-Based Versus Row-Based ReplicationTwo-Threaded SlaveMulti-MasterSQL Commands to Help Understand ReplicationBinary Log FormatCreating a Custom Replication UtilityIndex. Nº de ref. de la librería ABE_book_new_0596009577

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 35,68
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

7.

Sasha Pachev
ISBN 10: 0596009577 ISBN 13: 9780596009571
Nuevos Paperback Primera edición Cantidad: 1
Librería
Grand Eagle Retail
(Wilmington, DE, Estados Unidos de America)
Valoración
[?]

Descripción 2007. Paperback. Estado de conservación: New. 1st. 180mm x 15mm x 233mm. Paperback. Although MySQL's source code is open in the sense of being publicly available, it's essentially closed to you if you don't understand it. In this book, Sasha Pachev ? .Shipping may be from multiple locations in the US or from the UK, depending on stock availability. 234 pages. 0.417. Nº de ref. de la librería 9780596009571

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 37,97
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

8.

Sasha Pachev
Editorial: O'Reilly Media (2007)
ISBN 10: 0596009577 ISBN 13: 9780596009571
Nuevos Paperback Cantidad: 1
Librería
Irish Booksellers
(Rumford, ME, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media, 2007. Paperback. Estado de conservación: New. book. Nº de ref. de la librería 0596009577

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 38,63
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

9.

Sasha Pachev
Editorial: O'Reilly Media
ISBN 10: 0596009577 ISBN 13: 9780596009571
Nuevos Paperback Cantidad: 20
Librería
BuySomeBooks
(Las Vegas, NV, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media. Paperback. Estado de conservación: New. Paperback. 258 pages. Dimensions: 9.0in. x 7.0in. x 0.6in.Although MySQLs source code is open in the sense of being publicly available, its essentially closed to you if you dont understand it. In this book, Sasha Pachev -- a former member of the MySQL Development Team -- provides a comprehensive tour of MySQL 5 that shows you how to figure out the inner workings of this powerful database. Youll go right to heart of the database to learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and much more. The core of Understanding MySQL Internals begins with an Architecture Overview that provides a brief introduction of how the different components of MySQL work together. You then learn the steps for setting up a working compilable copy of the code that you can change and test at your pleasure. Other sections of the book cover: Core server classes, structures, and APIThe communication protocol between the client and the serverConfiguration variables, the controls of the server; includes a tutorial on how to add your ownThread-based request handling -- understanding threads and how they are used in MySQLAn overview of MySQL storage enginesThe storage engine interface for integrating third-party storage enginesThe table lock managerThe parser and optimizer for improving MySQLs performanceIntegrating a transactional storage engine into MySQLThe internals of replicationUnderstanding MySQL Internals provides unprecedented opportunities for developers, DBAs, database application programmers, IT departments, software vendors, and computer science students to learn about the inner workings of this enterprise-proven database. With this book, you will soon reach a new level of comprehension regarding database development that will enable you to accomplish your goals. Its your guide to discovering and improving a great database. This item ships from multiple locations. Your book may arrive from Roseburg,OR, La Vergne,TN. Paperback. Nº de ref. de la librería 9780596009571

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 35,15
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,72
A Estados Unidos de America
Destinos, gastos y plazos de envío

10.

Sasha Pachev
Editorial: O'Reilly Media (2007)
ISBN 10: 0596009577 ISBN 13: 9780596009571
Nuevos Paperback Cantidad: 10
Librería
Ergodebooks
(RICHMOND, TX, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media, 2007. Paperback. Estado de conservación: New. Nº de ref. de la librería INGM9780596009571

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 40,04
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,75
A Estados Unidos de America
Destinos, gastos y plazos de envío

Existen otras copia(s) de este libro

Ver todos los resultados de su búsqueda