Expert MySQL

前表紙
Apress, 2007/04/01 - 600 ページ

Since the enormous number of features made available with MySQL release 5.0, MySQL has been gaining steam as a viable alternative to database behemoths like Oracle and IBM DB2. MySQL users now have the ability to extend MySQL with new SQL commands, optimize query execution, and embed MySQL within low-resource environments like embedded devices and kiosks.

Expert MySQL, by Dr. Charles A. Bell, is the first book to examine these opportunities in detail, showing you how to wield maximum control over this powerful open source database. You'll learn how to create your own custom storage handlers, ensuring maximum flexibility and speed within your specialized applications. You'll also gain valuable insight into MySQLs architecture and learn how to tweak its behavior through custom changes to the source code.

 

ページのサンプル

目次

MySQL and the Open Source Revolution
3
The Anatomy of a Database System
25
A Tour of the MySQL Source Code
63
TestDriven MySQL Development
121
Debugging
153
Embedded MySQL
193
Building Your Own Storage Engine
255
Adding Functions and Commands to MySQL
357
Database System Internals
393
Internal Query Representation
403
Query Optimization
439
Query Execution
489
Appendix
535
Index
545
著作権

他の版 - すべて表示

Expert MySQL
Charles Bell
プレビュー不可 - 2007

多く使われている語句

affected 0.00 sec algorithm application attributes benchmarking BitKeeper bool byte cache called changes CHAPTER char col_a col_b compiled configuration create database systems DBUG DBUG_ENTER DBUG_RETURN(0 debugging delete disk Doxygen embedded MySQL embedded server embedded system error example function handler header file implemented InnoDB interface join Linux MyISAM MySQL AB MySQL server MySQL source code MySQL system node NULL open source software operation options parameters parser performance pNode pointer proprietary software Protocol Protocol::write provides query execution Query OK query optimizer query plan query tree query_node record buffer result set row affected 0.00 rows in set shown in Listing shows software testing source files Spartan storage engine SQL commands statement structure test suite test-driven development thread transaction tuple uint Updated variable Visual Studio void Windows write YACC

著者について (2007)

Charles Bell conducts research in emerging technologies. He is a member of the Oracle MySQL Development team and is the team lead for the MySQL Utilities team. He lives in a small town in rural Virginia with his loving wife. He received his Doctor of Philosophy in Engineering from Virginia Commonwealth University in 2005. Dr. Bell is an expert in the database field and has extensive knowledge and experience in software development and systems engineering. His research interests include 3D printers, microcontrollers, three-dimensional printing, database systems, software engineering, and sensor networks. He spends his limited free time as a practicing Maker focusing on microcontroller projects and refinement of three-dimensional printers. Dr. Bell maintains a blog on his research projects and many other interests. You can find his blog at http://drcharlesbell.blogspot.com/.

書誌情報

書籍名Expert MySQL
著者Charles Bell
出版社Apress, 2007
ISBN1430203463, 9781430203469
ページ数600 ページ
  
引用のエクスポートBiBTeX EndNote RefMan