Home > Articles > Data > MySQL

This chapter is from the book

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

  1. Which MySQL function will enable you to run an expression many times over in order to find the speed of the iterations?

  2. Which four variables can help you to determine whether the value of key_buffer_size is adequate?

  3. Which SQL command will clean up the structure of your tables?

Answers

  1. The benchmark() function.

  2. key_read_requests, key_reads, key_write_requests, and key_writes

  3. OPTIMIZE

Activities

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

  2. Use OPTIMIZE on all the tables in your contact management database to clean up any structural issues.

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.