MySQL Performance and Tuning

Mysql Architecture

    Client/Server Overview, Storage engine Tiers. Usage of tools to check the Server performance and tuning the same.

Obtaining Database Metadata

    Overview of Metadata Access methods and using SHOW and DESCRIBE to obtain Metadata. Understanding and analyze configurations and server variables and making changes to improve performace of the server. Creation of the exact engine that suits your bussiness needs. Evalution of application architecture, design, number of connections and factors effecting performance. Identifying the hardware, OS that suits the requirements. Data changes and importing techniques that effects performance.
MySQL Developer
MySQL DBA
MySQL High Availability

Register for MySQL Training.