RootForum Community

Code: Select all

my.cnf

key_buffer		= 128M
join_buffer_size        = 4M
sort_buffer             = 2M
read_buffer_size        = 2M
read_rnd_buffer_size    = 8M
myisam_sort_buffer_size = 64M
max_allowed_packet	= 1M
thread_stack		= 128K
thread_cache_size	= 10
max_connections         = 80
table_cache            = 2500
thread_concurrency     = 10
max_heap_table_size       = 128M 
tmp_table_size            = 128M
open_files_limit          = 5000
#
# * Query Cache Configuration
#
query_cache_type          = 1
query_cache_size          = 48M
query_cache_limit         = 48M
max_connect_errors        = 10
log_warnings              = 2
long_query_time           = 2

Code: Select all

OPEN FILES LIMIT
Current open_files_limit = 5090 files
The open_files_limit should typically be set to at least 2x-3x
that of table_cache if you have heavy MyISAM usage.
You currently have open more than 75% of your open_files_limit
You should set a higher value for open_files_limit in my.cnf

TABLE CACHE
Current table_cache value = 2500 tables
You have a total of 9222 tables
You have 2500 open tables.
Current table_cache hit rate is 4%, while 100% of your table cache is in use
You should probably increase your table_cache

TEMP TABLES
/usr/bin/tuning-primer.sh: line 325: bc: command not found
Current max_heap_table_size =  M
/usr/bin/tuning-primer.sh: line 325: bc: command not found
Current tmp_table_size =  M
Of 49017 temp tables, 48% were created on disk
Perhaps you should increase your tmp_table_size and/or max_heap_table_size
to reduce the number of disk-based temporary tables
Note! BLOB and TEXT columns are not allow in memory tables.
If you are using these columns raising these values might not impact your
ratio of on disk temp tables.