I'm having a few problems with MYSQL tuning and performance:
The server I'm on runs redhat 6.2, has 1.2 gig of ram and a P3 700 Processor: It also servers as our apache server
We never swap, infact we never use all the physical memory however load averages get pushed up and performance degrades somwhat at buzy times:
Heres my Mysql status
<!-- m --><a class="postlink" href="http://cpfc.org/status/mysql.php">http://cpfc.org/status/mysql.php</a><!-- m -->
My.cnf is posted below can anyone suggest any 'tweaks' to this? Many thanks
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = max_connections=250
set-variable = key_buffer=128M
set-variable = max_allowed_packet=1M
set-variable = table_cache=512
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
set-variable = myisam_sort_buffer_size=64M
set-variable = thread_cache=8
set-variable = thread_concurrency=8 # Try number of CPU's*2
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates # Remove the comment character if you are not familiar with
SQL
[isamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout
The server I'm on runs redhat 6.2, has 1.2 gig of ram and a P3 700 Processor: It also servers as our apache server
We never swap, infact we never use all the physical memory however load averages get pushed up and performance degrades somwhat at buzy times:
Heres my Mysql status
<!-- m --><a class="postlink" href="http://cpfc.org/status/mysql.php">http://cpfc.org/status/mysql.php</a><!-- m -->
My.cnf is posted below can anyone suggest any 'tweaks' to this? Many thanks
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = max_connections=250
set-variable = key_buffer=128M
set-variable = max_allowed_packet=1M
set-variable = table_cache=512
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
set-variable = myisam_sort_buffer_size=64M
set-variable = thread_cache=8
set-variable = thread_concurrency=8 # Try number of CPU's*2
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates # Remove the comment character if you are not familiar with
SQL
[isamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout