Start reading Expert MySQL (Expert's Voice in Databases) on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.
Expert MySQL (Expert's Voice in Databases)
 
 

Expert MySQL (Expert's Voice in Databases) [Kindle Edition]

Charles Bell

Print List Price: £35.50
Kindle Price: £29.61 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £5.89 (17%)
* Unlike print books, digital books are subject to VAT.

Formats

Amazon Price New from Used from
Kindle Edition £29.61  
Paperback £32.08  
Kindle Summer Sale: Over 500 Books from £0.99
Have you seen the Kindle Summer Sale yet? Browse selected books from popular authors and debut novelists, including new releases and bestsellers. Learn more


Product Description

Product Description


Expert MySQL is the leading reference for learning, understanding, and extending the MySQL server. It unlocks the full promise of open source by showing how to modify the code, create your own storage engine, build your own authentication plugins, and even add your own functions and commands to the SQL language. No other book provides the level of detail or the extensive examples of the inner workings of MySQL that have taken engineers years to master. Expert MySQL is a must have book for all systems integrators, engineers, and software developers working with the MySQL server code.





Expert MySQL is also a wealth of information on key aspects of MySQL internals. You’ll learn about internal query representation, how the optimizer creates execution plans, and how to exert control over those plans for optimal performance in your environment. You'll even learn to build your own query optimizer, giving insight that can help you understand and resolve tough performance problems. High-availability and replication are also covered, making Expert MySQL a must-have book for anyone doing high-end work involving MySQL.



  • Shows how to customize MySQL and its storage and authentication engines


  • Provides in-depth knowledge of internals for use in query tuning and performance troubleshooting


  • Covers high-end features such as high-availability and replication




What you’ll learn



  • Learn the inner workings of MySQL


  • Diagnose and improve poorly performing queries


  • Implement high-availablity solutions and replication


  • Modify and debug the server code


  • Build your own pluggable storage engines and authentication modules


  • Implement new SQL functions and syntax


  • Build your own query optimizer




Who this book is for

Expert MySQL is written for systems integrators, software developers, and database administrators who are using MySQL and desire a deeper knowledge of MySQL internals in support of high-end work such as performance troubleshooting, customization of the engine and its plugins, query optimizaion, building of high-availability environments, replication of data, and so forth.


About the Author

Charles Andrew Bell works for Oracle Corporation and is a senior member of the MySQL engineering team. He is the team lead for MySQL Utilities and has over eight years experience in developing the MySQL server. He lives in a small town in rural Virginia with his loving wife, and received his Doctor of Philosophy in Engineering from Virginia Commonwealth University in 2005. His research interests include database systems, versioning systems, semantic web, and agile software development. Dr. Bell's research projects and development of an advanced database versioning system make him uniquely qualified to author this book. He is an expert in the database field and has extensive knowledge and experience in modifying the MySQL source code. With over 25 years experience in enterprise development and systems architecture, his experience provides him excellent insight into developing and modifying open source systems.

Product details

  • Format: Kindle Edition
  • File Size: 4282 KB
  • Print Length: 642 pages
  • Page Numbers Source ISBN: 1430246596
  • Publisher: Apress; 2 edition (17 Dec 2012)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B00ACC6ANM
  • Text-to-Speech: Enabled
  • X-Ray:
  • Amazon Bestsellers Rank: #806,416 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


More About the Author

Discover books, learn about writers, and more.

Customer Reviews

There are no customer reviews yet on Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.5 out of 5 stars  2 reviews
5 of 5 people found the following review helpful
5.0 out of 5 stars Great Book for the Right Person 29 July 2013
By Sheryl C - Published on Amazon.com
Format:Paperback
"Expert MySQL" is not written for the person who wants to install and use MySQL binaries. It won't tell you how to set up a PHP/MySQL web page. However, if you already know how to do install and use MySQL binaries and want to dig into the source code this is book is a great place to start. You can learn how to write and debug storage engines and plugins, build embedded applications and optimize queries. It will help to come to the book with some experience in compiling and modifying source code and some previous exposure to databases, especially database theory.
1 of 1 people found the following review helpful
4.0 out of 5 stars Indepth Book 10 Feb 2014
By Edwards - Published on Amazon.com
Format:Paperback|Verified Purchase
This not a book for beginners. It is very in-depth. Your have to really understand MYSQL to use and understand this book.
Were these reviews helpful?   Let us know

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category