Cargando…
MySQL 5.1 Plugin Development.
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-te...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Pub.,
2010.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- 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.