Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Expert MySQL (Expert's Voice in Databases)

Buy

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.

Table of Contents

  1. Part One - Getting Started with MySQL Development: MySQL and the Open Source Revolution
  2. Part One: Getting Started with MySQL Development: The Anatomy of a Database System
  3. Part One: Getting Started with MySQL Development: A Tour of the MySQL Source Code
  4. Part One - Getting Started with MySQL Development: Test-Driven MySQL Development
  5. Part Two - Extending MySQL: Debugging
  6. Part Two - Extending MySQL: Embedded MySQL
  7. Part Two - Extending MySQL: Adding Functions and Commands to MySQL
  8. Part Two - Extending MySQL: Extending MySQL High Availability
  9. Part Two - Extending MySQL: MySQL Pluggable Authentication
  10. Part Two - Extending MySQL: Building Your Own Storage Engine
  11. Part Three - Advanced Database Internals: Database Systems Internals
  12. Part Three - Advanced Database Internals: Internal Query Representation
  13. Part Three - Advanced Database Internals: Query Optimization
  14. Part Three - Advanced Database Internals: Query Execution
(HTML tags aren't allowed.)

Coding the Arduino: Building Fun Programs, Games, and Electronic Projects (Technology in Action)
Coding the Arduino: Building Fun Programs, Games, and Electronic Projects (Technology in Action)
Get started with Arduino and computer coding. This book is intended for those new to the Arduino and computer coding. and looking to gain the skills to write microcontroller programs that can act on given inputs and operate electromechanical output devices. 

Coding the Arduino contains four...
Expert Python Programming: Become a master in Python by learning coding best practices and advanced programming concepts in Python 3.7, 3rd Edition
Expert Python Programming: Become a master in Python by learning coding best practices and advanced programming concepts in Python 3.7, 3rd Edition

Refine your Python programming skills and build professional grade applications with this comprehensive guide

Key Features

  • Create manageable code that can run in various environments with different sets of dependencies
  • Implement effective Python data structures and...
Beginning Robotics with Raspberry Pi and Arduino: Using Python and OpenCV
Beginning Robotics with Raspberry Pi and Arduino: Using Python and OpenCV

Learn how to use a Raspberry Pi in conjunction with an Arduino to build a basic robot with advanced capabilities. Getting started in robotics does not have to be difficult. This book is an insightful and rewarding introduction to robotics and a catalyst for further directed study. 

You'll be led step by step...


Connecting Arduino to the Web: Front End Development Using JavaScript
Connecting Arduino to the Web: Front End Development Using JavaScript
Create physical interfaces that interact with the Internet and web pages. With Arduino and JavaScript you can create interactive physical displays and connected devices that send data to or receive data from the web. You'll take advantage of the processes needed to set up electronic components, collect data, and create web pages able to...
Learn Raspberry Pi Programming with Python: Learn to Program on the World's Most Popular Tiny Computer
Learn Raspberry Pi Programming with Python: Learn to Program on the World's Most Popular Tiny Computer
Learn how to program your nifty new $35 computer to make a web spider, a weather station, a media server, and more. This book explores how to make a variety of fun and even useful projects, from a web bot to search and download files to a toy to drive your pets insane.

Even if you're completely new to programming in
...
Pro Python 3: Features and Tools for Professional Development
Pro Python 3: Features and Tools for Professional Development

Refine your programming techniques and approaches to become a more productive and creative Python programmer. This book explores the concepts and features that will improve not only your code but also your understanding of the Python community with insights and details about the Python philosophy.

Pro Python 3,...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy