Workshop
The Workshop is designed to help you anticipate possible questions, review what you've learned, and begin learning how to put your knowledge into practice.
Quiz
Which MySQL function will enable you to run an expression many times over in order to find the speed of the iterations?
Which four variables can help you to determine whether the value of key_buffer_size is adequate?
Which SQL command will clean up the structure of your tables?
Answers
The benchmark() function.
key_read_requests, key_reads, key_write_requests, and key_writes
OPTIMIZE
Activities
If you have root level access to your server, change the values of key_buffer_size and table_cache, and run benchmark() functions after each change to see how the execution times differ.
Use OPTIMIZE on all the tables in your contact management database to clean up any structural issues.