MySQL Performance: MySQL => Performance issues

Performance issues [message #2560]

Thu, 31 January 2008 03:04

arthurica
Messages: 7
Registered: January 2008

Junior Member

We are having some performance issues with our current server configuration and I finally found this forum and hope I can get some help

We keep getting many errors like this and they all seem to be related to the same problem

MySQL server has gone away
Got error 12 from storage engine

The server is a dual processor with 6 Gb of RAM
Here is the my.cnf file that we are using

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

ft_min_word_len = 1
ft_stopword_file =

max_heap_table_size = 64M
max_connections = 1000
max_allowed_packet = 12M
group_concat_max_len = 4096000
wait_timeout = 30

key_buffer = 1024M

sort_buffer_size = 4M
join_buffer_size = 8M
read_buffer_size = 16M
myisam_sort_buffer_size = 32M

thread_concurrency = 4
thread_cache = 32
table_cache = 2048

query_cache_limit = 2M
query_cache_size = 256M
query_cache_type = 1

query_prealloc_size = 256K
query_alloc_block_size = 96K
read_rnd_buffer_size = 8M
tmp_table_size = 64M
thread_stack = 2M

default-character-set = utf8

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Is there anything obviously that we are missing? How can I change the variables and see if I am on the right direction

Sorry if some of the questions sound stupid Smile

Thanks a lot

Report message to a moderator