Home > LAMP: Linux Apache MySQL PHP, PHP/MySQL, Performance Optimization > Understanding MySQL Query Caching Process

Understanding MySQL Query Caching Process

November 5th, 2008

These days, websites are expected to perform. No excuses. I also mentioned before that website performance is key for SEO. Well, one easy thing that can be done is turning on MySQL caching. Most servers ship with MySQL in its default configuration which has caching turned off. There are many resources out there if you search enough, however I have found a presentation by Baron Shcwartz: MySQL Query Cache which explains in detail advanced concepts of MySQL Caching. Here is the slide that summarizes the process of MySQL Query Caching:

Bookmark and Share

Related Posts

Ron Peled LAMP: Linux Apache MySQL PHP, PHP/MySQL, Performance Optimization , , ,

  1. Ron Peled
    November 30th, 2008 at 10:31 | #1
    Reply | Quote

    Here is additional settings for improved MySQL DB performance:

    key_buffer = 256M
    max_allowed_packet = 1M
    table_cache = 256
    sort_buffer_size = 1M
    read_buffer_size = 1M
    read_rnd_buffer_size = 4M
    myisam_sort_buffer_size = 64M
    thread_cache_size = 8
    query_cache_size= 16M

    Of course, tweak the numbers according to your hardware setup.

Comments are closed.