Hello,
I'm trying to improve the performances of my mysql server. I used a script mysqltuner.pl that advised me to increase the table_cache of my database. I did but it seems to be not functional.
Here are my logs (/var/log/mysql/error.log) when I start mysql:
I would like to fix that line but I don't understand how as I already tried to set table_cache to 524288:
Here is my /usr/local/etc/my.cnf:
I'm trying to improve the performances of my mysql server. I used a script mysqltuner.pl that advised me to increase the table_cache of my database. I did but it seems to be not functional.
Here are my logs (/var/log/mysql/error.log) when I start mysql:
Code:
111227 16:22:56 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
111227 16:22:56 [Warning] Changed limits: max_open_files: 32768 max_connections: 250 table_cache: 16254
111227 16:22:56 InnoDB: The InnoDB memory heap is disabled
111227 16:22:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins
111227 16:22:56 InnoDB: Compressed tables use zlib 1.2.5
111227 16:22:56 InnoDB: Initializing buffer pool, size = 32.0M
111227 16:22:56 InnoDB: Completed initialization of buffer pool
111227 16:22:56 InnoDB: highest supported file format is Barracuda.
111227 16:22:56 InnoDB: Waiting for the background threads to start
111227 16:22:57 InnoDB: 1.1.8 started; log sequence number 27667402
111227 16:22:57 [Note] Event Scheduler: Loaded 0 events
111227 16:22:57 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.5.19-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
I would like to fix that line but I don't understand how as I already tried to set table_cache to 524288:
Code:
[Warning] Changed limits: max_open_files: 32768 max_connections: 250 table_cache: 16254
Here is my /usr/local/etc/my.cnf:
Code:
[mysqld]
query_cache_size=256M
query_cache_type=1
query_cache_limit=4M
innodb_file_per_table
max_connections=250
key_buffer_size=256M
tmp_table_size=128M
max_heap_table_size=128M
thread_cache_size=4
[color="Red"]table_cache=524288[/color]
sort_buffer_size=4M
read_buffer_size=1M
innodb_buffer_pool_size=32M
slow-query-log = 1
slow-query-log-file = /var/log/mysql/slow_queries.log
log-error = /var/log/mysql/error.log