2) Installing MySQL.
3) Starting and stopping mysql.
4) Various logs in mysql and uses.
5) MySQL client Programs.
6) Upgrading MySQL.
7) Mysqladmin commands.
8) Locking in MySQL
9) Storage engines in MySQL.
10) Innodb Configuration
11) MySQL Table maintenance.
12) Information Schema and Performance Schema.
13) MySQL backup and Recovery.
14) MySQL Replication and different replication Architecture.
15) MySQL Routines and Triggers
16) MySQL Resource allocation.
17) MySQL Architecture.
18) Query Cache Tuning.
19) Securing MySQL.
20) Optimizing queries.
21) Optimizing MySQL Variables effectively.
22) Hardware optimizaion.
23) LVM Snapshot.
24) Tools for high performance ( Percona toolkit, Mytop, Innotop).
25) Shell scripting for automation.
No comments:
Post a Comment