Cover of Expert MySQL
Read Time: ~10.7 hr

Expert MySQL

by Charles Bell (2012)

About this book

Expert MySQL is the leading reference for learning, understanding, and extending the MySQL server. It unlocks the full promise of open source by showing how to modify the code, create your own storage engine, build your own authentication plugins, and even add your own functions and commands to the SQL language. No other book provides the level of detail or the extensive examples of the inner workings of MySQL that have taken engineers years to master. Expert MySQL is a must have book for all systems integrators, engineers, and software developers working with the MySQL server code. Expert MySQL is also a wealth of information on key aspects of MySQL internals. You’ll learn about internal query representation, how the optimizer creates execution plans, and how to exert control over those plans for optimal performance in your environment. You'll even learn to build your own query optimizer, giving insight that can help you understand and resolve tough performance problems. High-availability and replication are also covered, making Expert MySQL a must-have book for anyone doing high-end work involving MySQL. Shows how to customize MySQL and its storage and authentication engines Provides in-depth knowledge of internals for use in query tuning and performance troubleshooting Covers high-end features such as high-availability and replication

Setting / LocationGlobal
Story EraModern Era
Protagonist / CoreExpert MySQL Lead Character

Readers who enjoyed this also loved

Cover of Database and Expert Systems Applications

Database and Expert Systems Applications

A Min Tjoa, Isidro Ramos

This two volume set LNCS 8055 and LNCS 8056 constitutes the refereed proceedings of the 24th International Conference on Database and Expert Systems Applications, DEXA 2013, held in Prague, Czech Republic, August 23-29, 2013. The 43 revised full papers presented together with 33 short papers, and 3 keynote talks, were carefully reviewed and selected from 174 submissions. These papers discuss a range of topics including: search queries; indexing; discovery of semantics; parallel processing; XML and RDF; enterprise models; query evaluation and optimization; semantic Web; sampling; industrial applications; communities; AI and databases; matching and searching; information extraction; queries, streams, and uncertainty, storage and compression; query processing; security; distributed data processing; metadata modeling and maintenance; pricing and recommending; and security and semantics.

Cover of Advances in databases and information systems

Advances in databases and information systems

Albertas Caplinskas, Johann Eder (eds

This book constitutes the refereed proceedings of the 5th East European Conference on Advances in Databases and Information Systems, ADBIS 2001, held in Vilnius, Lithuania, in September 2001. The 25 revised full papers presented together with one invited paper and two abstracts of invited talks were carefully reviewed and selected from 82 submissions. The papers are organized in topical sections on query optimization, multimedia and multilingual information systems, spatiotemporal aspects of databases, data mining, transaction processing, conceptual modeling and information systems specification, active databases, query methods, XML, and information systems design.

Cover of An approach to knowledge base management

An approach to knowledge base management

Nelson Mendonça Mattos

"This book addresses the development of a new generation of systems, Knowledge Base Management Systems (KBMS), specially constructed for effective and efficient management of knowledge bases, with the aim of filling part of the technological gap between artificial intelligence and databases. The book first investigates in detail the design process, the architecture, and the working methods of knowledge based systems (KS) in order to point out the key characteristics of the field as well as its current limitations, which serve then as basis for an exact formulation of KS requirements. An analysis and evaluation of other approaches (e.g., conventional DBS, non-standard DBS, coupling expert systems and DBS) to knowledge management is given. The book shows that in developing KBMS, the experience obtained by the investigation of each of these approaches is extremely important since they provide the basic concepts for building KBMS. The approaches should not be viewed as complete and final but as part of research work towards KBMS. A novel architecture is described for KBMS which integrates the functionality, flexibility and modeling power of DBS and AI. The main part of the book deals with all important architectural problems of KBMS: methods for knowledge representation with special emphasis on abstraction concepts, language proposals, and concepts for performance improvement. The book is based on practical experience accumulated over five years of successful research in coupling existing expert systems and DBS, extending DBS with deductive capabilities, and above all in the design and implementation of a KBMS prototype. Thus the book's proposals are illustrated with detailed descriptions of their realization in existing systems or prototypes."--PUBLISHER'S WEBSITE.

Cover of SQL Server 7

SQL Server 7

Anil Desai

Protect your organization's most valuable asset--its data. Develop and implement a thorough data protection solution for your SQL Server 7 database environment. SQL Server 7 Backup & Recovery is your one-stop resource for planning, developing, implementing, and managing backup and restore procedures. Learn to execute data protection strategies, implement a backup solution, and handle data recovery before potentially disastrous data loss occurs. You'll get details on the latest methods for increasing database uptime and improving performance. The case studies included show you how to apply the techniques described in the book in your own environment. Evaluate business requirements and develop a data protection strategy. Configure Windows NT/2000 for the secure and efficient use of SQL Server 7. Select the best hardware, software, and network technologies for your backup plan. Handle SQL Server 7 backup procedures involving files and filegroups, transaction logs, concurrency, locking, and other database issues. Increase database uptime and optimize performance. Develop and practice restore plans for various scenarios--from minor data loss to complete hardware failures. Increase reliability, availability, and performance through the use of standby servers and clustering. Distribute data throughout your enterprise with SQL Server 7's replication features. Follow case studies to learn about the application of data protection best practices in various environments.

Expert MySQL by Charles Bell | Literally Just Books