www.webdeveloper.com
Results 1 to 3 of 3

Thread: creating cache in mysql

  1. #1
    Join Date
    Apr 2010
    Posts
    16

    creating cache in mysql

    Any of you knows how to create of increase the cache in mysql?

  2. #2
    Join Date
    Aug 2009
    Posts
    84
    There is couple of variables defining size of various caches in MySQL server, for example: key_buffer, query_cache_limit, query_cache_size etc.

    Detailed description of each of them can be found at: http://dev.mysql.com/doc/refman/5.0/...variables.html

  3. #3
    Join Date
    Apr 2010
    Posts
    16
    Quote Originally Posted by chris22 View Post
    There is couple of variables defining size of various caches in MySQL server, for example: key_buffer, query_cache_limit, query_cache_size etc.

    Detailed description of each of them can be found at: http://dev.mysql.com/doc/refman/5.0/...variables.html
    This is what I have:

    +-------------------------+---------+
    | Variable_name | Value |
    +-------------------------+---------+
    | Qcache_free_blocks | 66 |
    | Qcache_free_memory | 68528 |
    | Qcache_hits | 515637 |
    | Qcache_inserts | 416 |
    | Qcache_lowmem_prunes | 305 |
    | Qcache_not_cached | 3357178 |
    | Qcache_queries_in_cache | 51 |
    | Qcache_total_blocks | 169 |
    +-------------------------+---------+

    I had set this variables to:
    SET GLOBAL query_cache_size = 40000;
    SET GLOBAL query_cache_size = 131072;
    SET GLOBAL query_cache_min_res_unit = 2048;
    SET GLOBAL query_cache_limit = 2048;

    but I still see sometimes the mysql eats 100% of the cpu, how can avoid this?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles