-1

I have a 3GB server with the below settings. The issue I am facing is when I pull some records through the admin panel of my site, sometimes it works well, but most of the times it process very slow.

Can you please suggest the settings?

[mysqld]
max_connections=500
join_buffer_size = 2M
tmp_table_size = 24M
max_heap_table_size = 24M
query_cache_size = 256M
key_buffer=128M
key_buffer_size = 512M
thread_cache_size = 4
table_cache = 500
table_open_cache = 96
innodb_buffer_pool_size = 27M
slow_query_log
local-infile=0
jscott
  • 25,114
user183207
  • 1

1 Answers1

0

It's impossible to give you a meaningful answer without a better idea as to the workload on the database.

You might try mysqltuner.pl which will, after leaving the database running under normal conditions for a couple of days, give you some recommendations for changes.

Flup
  • 8,398