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.
|