Mysql Architecture Client/Server Overview, Sql parser
and Storage engine Tiers.
Starting, Stopping and Configuring MySQL Starting and
Stopping MySQL server on Windows and Unix, Log and status
files, Setting Default SQL Mode.
Client Programs for DBA Work Overview of different
Administrative Clients like mysql, mysqladmin, mysqlimport,
mysqldump and limitations of the same.
MySQL Administrator Installation and starting MySQL
Administrator, Displaying server information, connections,
health, backups and user administration.
Locking Locking table Explicitly and Advisory locking.
Storage Engines Overview of Storage engines like
MyISAM, MERGE, InnoDB, MEMORY, FEDERATED and Cluster.
Table Maintenance Sql Statements for table maintenance,
Client and Utility Programs for table maintenance.
Information_Schema Database Limitations of the
Information_schema.
Data Backup and Recovery Methods Taking Binary and text
backups and recovery methods with the same.
Using Stored Routines Using Stored routines and
triggers for security and enhanced performance.
User Management User account management and Client
access control.
Securing the MySQL installation Securing Operating
system, Filesystem and Logfiles.
Upgrade-Related Security Issues Upgrading Privilege
tables and Related Sql Mode values.
Optimizing Queries Using Explain to optimize
queries.
Optimizing Databases Table optimization and Engine
Specific optimizations.
Optimizing the Server Measuring the load and tuning
memory parameters.
Interpreting Diagnostic Messages Using the Logs for
different diagnostic purposes.
Scaling MySQL Using Multiple servers and replication.
|
