Titlebook: Expert MySQL; Charles Bell Book 2012Latest edition Charles Bell 2012

苦笑

The Anatomy of a Database Systemored the inner workings of a database system. Most of us have been trained on and have experience with managing database systems, but neither academic nor professional training includes much about the way database systems are constructed. A database professional may never need this knowledge, but it

宽大

向下五度才偏

Test-Driven MySQL Development are needed for the integration. Oracle recognizes this and includes flexible options in the MySQL server that add new functions and commands. This chapter introduces a key element in generating high-quality extensions to the MySQL system. I discuss software testing and explain some common practices

诱拐

Debuggings are easy to develop and less prone to failure. I’ll also explore the most common techniques for debugging the MySQL system. If you have already developed solid debugging skills, feel free to skim the following sections and move on to the section “Debugging MySQL.”

串通

heckle

Adding Functions and Commands to MySQLhe system having limitations with, or not having certain functions or commands that are needed for, the integration. Often, this means getting around the problem by creating more “glue” programs to translate or augment existing functions and commands.

anarchist

Developing MySQL Pluginscially designed dynamic libraries that allow you to add new functionality to the server without taking the server offline. There are several forms of plugins supported today, but as the server continues to evolve, expect to see more features offered using this architecture.

碳水化合物

CODA

Database System Internalsin-depth coverage of how queries are represented internally within the server and how queries are executed. I explore these topics from a more general viewpoint and then close the chapter with a discussion of how you can use the MySQL system to conduct your own experiments with the MySQL system inte

错

Internal Query Representationept of the query tree structure, which is used for storing a query in memory. Next, I’ll present the query tree structure used for the project along with the first in a series of short projects for implementing the DBXP code. The chapter concludes with a set of exercises you can use to learn more ab