Category / MySQL

  • February 2, 2012 - Warren Held

    Tuning MySQL For Better Performance

    I found a great shell script (for Linux) that will analyze your MySQL and give you recommendations on what to change to improve MySQL’s performance. It is called “MySQL Tuning Primer” and can be found here. Below is the output of the script when I ran it to give you an example. I run this site (Apache & MySQL) on a “micro” Linux instance (with 613mb of RAM) in Amazon’s EC2 cloud and MySQL has been crashing. From the output below I think it is safe to say I need to change how MySQL is using my RAM.

    Read More