mySQL Cache

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
visionmaster
Forum Contributor
Posts: 139
Joined: Wed Jul 14, 2004 4:06 am

mySQL Cache

Post 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!
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

you can play with it and find out.. they look kinda safe to screw around with.
Post Reply