creating cache in mysql

[wordgeist]

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

[chris22]

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

[wordgeist]

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?