Page 1 of 1

mySQL Cache

Posted: Wed Oct 06, 2004 4:58 am
by visionmaster
Hello,

does anyone know something about setting table_cache and thread_cachte_size in the mySQL configuration? Setting the query_cache has speeded up my system. Should I change any of the settings below:

Code: Select all

+-----------------------+------------+ 
| Variable_name         | Value      | 
+-----------------------+------------+ 
| binlog_cache_size     | 32768      | 
| have_query_cache      | YES        | 
| max_binlog_cache_size | 4294967295 | 
| query_cache_limit     | 1048576    | 
| query_cache_size      | 29999104   | 
| query_cache_type     | ON         | 
| table_cache              | 256        | 
| thread_cache_size     | 0          | 
+-----------------------+------------+ 
8 rows in set (0.26 sec)
System: 1&1 RootServer, Suse 9.0, 256MB Ram, ...

Thanks!

Posted: Wed Oct 06, 2004 5:56 am
by feyd
you can play with it and find out.. they look kinda safe to screw around with.