How to get Maximum Performance from MySQL

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How to get Maximum Performance from MySQL

Optimization is a complicated task because it ultimately requires understanding of the whole system. While it may be possible to do some local optimizations with small knowledge of your system/application, the more optimal you want your system to become the more you will have to know about it.
So this chapter will try to explain and give some examples of different ways to optimize MySQL. But remember that there are always some (increasingly harder) additional ways to make the system even faster.

(Continued on next question...)

Other Job Interview Questions

• What happens if a table has one column defined as TIMESTAMP?
• How do you change a password for an existing user via mysqladmin?
• When would you use ORDER BY in DELETE statement?
• MySQL is Portability
• What is the difference between mysql_fetch_array and mysql_fetch_object?
• Explain TIMESTAMP DEFAULT ‘2006:09:02 17:38:44? ON UPDATE CURRENT_TIMESTAMP.
• Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
• MySQL - Get Your Data as Small as Possible
• MySQL - Using Your Own Benchmarks
• MySQL - How do I rotate replication logs?
• More...