| Description |
1 online resource (458 pages) |
| Contents |
MySQL 5.1 Plugin Development; MySQL 5.1 Plugin Development; Credits; About the Authors; About the Reviewer; Preface; History of the Plugin API; Idea of this book; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Errata; Piracy; Questions; 1. Compiling and Using MySQL Plugins; UDF libraries; Linux; Mac OS X; Windows; Installing a UDF; Plugin libraries; Linux; Mac OS X; Windows; Installing a plugin; Automatic builds, packaging; UDFs and standalone plugins; Plugins that are built from the MySQL source tree; plug.in |
|
Makefile.amCMakeLists.txt; Summary; 2. User Defined Functions; Writing UDFs; Why write UDFs; Installing and using UDFs; Defining UDFs; Execution sequence of a UDF; UDF error handling; UDF security; Gotchas with UDFs; A constant integer output UDF; An integer echoing UDF; A simple static text output UDF; A summing aggregate UDF; Further reading; Summary; 3. Daemon Plugins; A look inside a Daemon plugin; Why write a Daemon plugin; Installing and using Daemon plugins; The role of a version; Defining Daemon plugins; Status variables; System variables; A Hello World! Daemon plugin |
|
A system and status variables demo pluginA simple monitoring plugin; System Status Variables plugin; Summary; 4. Information Schema Plugins; Why write Information Schema plugins; Installing and using Information Schema plugins; The creation of Information Schema plugins; Defining Information Schema plugins; A Static Table example; A System Information plugin; Summary; 5. Advanced Information Schema Plugins; Accessing MySQL internals; Condition pushdown; Using condition pushdown; A condition pushdown example; A User Variables Information Schema plugin; A Binary Logs Information Schema plugin |
|
9. HTML Storage Engine-Reads and WritesAn idea of the HTML engine; Flashback; Creating, opening, and closing the table; Reading data; Updating the table; Optimizing and analyzing; What's left; ha_html.h; htmlutils.cc; Compiling and linking; Putting it all together; Summary; 10. TOCAB Storage Engine -- Implementing Indexes; B-tree library; Storage engine API for indexes; Describing the engine; Creating, opening, and closing the table; Searching in the index; Rows and keys; Table scan and random access; Inserting rows; What's left; Compiling and linking; Putting it all together |
| Summary |
6. Full-text Parser Plugins; The full-text parser plugin architecture; Three roles of a full-text parser plugin; Installing and using a full-text parser plugin; Structure of a full-text parser plugin; A PHP full-text parser; Summary; 7. Practical Full-text Parsers; Boolean parsers; A Boolean full-text parser; An Image Metadata processor; How to access Exif data; Writing the plugin; Test run; A Soundex full-text parser; The Soundex algorithm; The plugin; Trying it out; Summary; 8. Storage Engine Plugins; Introducing storage engines; A read-only storage engine; ha_text.cc; Summary |
|
Extend MySQL to suit your needs with this unique guide into the world of MySQL plugins |
| Notes |
Print version record |
| SUBJECT |
MySQL (Electronic resource) http://id.loc.gov/authorities/names/n2004021601
|
|
MySQL (Electronic resource) fast |
| Subject |
Database management.
|
|
Relational databases.
|
|
Open source software.
|
|
Database management
|
|
Open source software
|
|
Relational databases
|
| Form |
Electronic book
|
| Author |
Golubchik, Sergei
|
| ISBN |
9781849510615 |
|
184951061X |
|
