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/mysqlsocket=/var/lib/mysql/mysql.sockft_min_word_len = 1ft_stopword_file =max_heap_table_size = 64Mmax_connections = 1000max_allowed_packet = 12Mgroup_concat_max_len = 4096000wait_timeout = 30key_buffer = 1024Msort_buffer_size = 4Mjoin_buffer_size = 8Mread_buffer_size = 16Mmyisam_sort_buffer_size = 32Mthread_concurrency = 4thread_cache = 32table_cache = 2048query_cache_limit = 2Mquery_cache_size = 256Mquery_cache_type = 1query_prealloc_size = 256Kquery_alloc_block_size = 96Kread_rnd_buffer_size = 8Mtmp_table_size = 64Mthread_stack = 2Mdefault-character-set = utf8[mysql.server]user=mysqlbasedir=/var/lib[safe_mysqld]err-log=/var/log/mysqld.logpid-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 )
Thanks a lot