Tuning and Optimizing Performace of MySQL
A lot of times i found a LAMP server with the MySQL server poorly configurated.
There are a lot of tips, for example enable and tune the query cache, that can enhance the performance of MySQL.
Here is a little check list:
Enable the query cache and other caches
Tune the settings of query cache and other caches
Disable unused [...]
Memcached
Memcached is a high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web applications by alleviating database load.
Links:
Memcached homepage
Distributed Caching with Memcached
Memcached Basics for Rails
memcached Basics for Rails: Part II
Using memcached for Ruby on Rails session storage
Comparing Memcached and Ehcache Performance
Fastest languages for memcached
How Digg.com uses the [...]