عنوان

Mysql 5.1 Plugins Development :

184951061X

9781849510615

b560014

Mysql 5.1 Plugins Development :

[Book]

Extend Mysql to Suit Your Needs with This Unique Guide into the World of Mysql Plugins.

Andrew Hutchings

Birmingham

Packt Publishing, Limited Palo Alto : Ebrary, Incorporated [distributor]

2010

Cover; Copyright; Credits; About the Authors; About the Reviewer; Table of Contents; Preface; Chapter 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.am; CMakeLists.txt; Summary; Chapter 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 UDFsA constant integer output UDF; An integer echoing UDF; A simple static text output UDF; A summing aggregate UDF; Further reading; Summary; Chapter 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 plugin; A simple monitoring plugin; System Status Variables plugin; Summary; Chapter 4:Information Schema Plugins; Why write Information Schema plugins Installing and using Information Schema pluginsThe creation of Information Schema plugins; Defining Information Schema plugins; A Static Table example; A System Information plugin; Summary; Chapter 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; Summary; Chapter 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 pluginStructure of the full-text parser plugin; A PHP full-text parser; Summary; Chapter 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; Chapter 8:Storage Engine Plugins; Introducing storage engines; A read-only storage engine; ha_text.cc; Summary; Chapter 9:HTML Storage Engine-Reads and Writes; An idea of the HTML engine; Flashback Creating, opening, and closing the tableReading data; Updating the table; Optimizing and analyzing; What's left; ha_html.h; htmlutils.cc; Compiling and linking; Putting it all together; Summary; Chapter 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 is left; Compiling and linking; Putting it all together; Possible extensions; Summary; Appendix:Beyond MySQL 5.1; Server services; my_snprintf

Extend MySQL to suit your needs with this unique guide into the world of MySQL plugins.

Database management.

MySQL (Electronic resource)

Relational databases.

Andrew Hutchings

Andrew Hutchings

[Book]

Y