LP4.2 Assignment: Optimizing the Database

This assignment will assess the competency 4. Apply MySQL functionality to administer databases.

Directions: Create a manual (with screenshots) for a new MySQL admin. Include brief sections on:

Creating Passwords.

Checking system and status variables.

Configuring InnoDB.

Using query cache.

Reading the error, slow query and relay logs.