Tom Zheng
Optimizing and Tuning Your MySQL Database(7) > Workshop
Tom Zheng | Jun 29, 2008 12:35:44 PM
Sams Teach Yourself MySQL in 24 Hours

This chapter is from the book
Sams Teach Yourself MySQL in 24 Hours

Even the most well-designed database, functioning on its own or as part of an application, needs to be maintained. This hour is part of a 3-hour set of administrative lessons that will give you pointers for optimizing and tuning your database so that you get the most bang for your buck. Think of your database like a garden -- basic water and sunlight will allow it to grow just fine, but a little extra plant food will help it flourish.

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.



http://www.informit.com/articles/article.aspx?p=29406&seqNum=7

Tag: Mysql Performance Tuning

Comment: (no reply)
To post your comment, Please login first.