Optimizing MySQL, part 1

MySQL is a most popular database management system. It can be configured to match your needs using huge amount of options and settings. But which options are optimal? Wrong values or settings might affect the speed of your queries – both positively and negatively.

By this article I start my personal investigation and setting analysis. My goal is find be options, that would suit modern shared hosting needs. I am going to write my own test sets, trying to simulate different scenarios.