That fixed it. Thanks
_____ From: Jianbin Xiao [mailto:xia...@gmail.com] Sent: Sunday, May 16, 2010 8:38 AM To: vchkpw@inter7.com Subject: Re: [vchkpw] vmysql: sql error[3]: MySQL server has gone away patch: http://www.xiaojb.com/archives/mailtech/patch_for_vpopmail.shtml On Sat, May 15, 2010 at 2:38 AM, Joe Littleton <jlittle...@citnatbank.com> wrote: None of that helped I have decided to go back to CentOS 4.8 and just use MySQL 4.1 instead of the newer version. _____ From: Sérgio Rosa [mailto:sergior...@awd.pt] Sent: Friday, May 14, 2010 6:19 AM To: vchkpw@inter7.com Subject: Re: [vchkpw] vmysql: sql error[3]: MySQL server has gone away Have a look at this link http://dev.mysql.com/doc/refman/5.0/en/gone-away.html you may find some help there. Also look at this links http://dev.mysql.com/doc/refman/5.0/en/error-log.html and http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html try to enable slow-query-log. It might come up with an unknown slow query . when you have those errors if you log to the mysql server can you query anything to the db? or the server is dead? Also take a look at this link http://www.unix.com/web-programming-web-2-0-mashups/75618-mysql-tuning-tools -mysqltuner-pl-tuning-primer-sh.html Come back with reports and news. sergio rosa On 13/05/2010 17:15, Joe Littleton wrote: I tried your config for my.cnf but I am still having the same issue. It appears that if mysql is restarted whatever authdaemon is looking at is gone. Its like there is a specific PID or something and once that PID is gone authdaemon believes mysql has stopped. >Hi! >I had a similar problem and it was being caused by excess tuning to mysql. Now I run my mysql with this my.cnf >The issue was not with vpopmail but with web applications. A few years ago I had a mysqld has gone away but it was because a small max_connection value. >max_connections = 75 <-------------------- what is your number of max conn? key_buffer = 120M max_allowed_packet = 24M table_cache = 3072 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 128M query_cache_limit = 2M join_buffer_size = 1M thread_concurrency = 2 long_query_time = 5 log-slow-queries = /tmp/slow-queries.log open_files_limit = 6500 max_heap_table_size = 64M query_cache_min_res_unit = 2K wait_timeout = 60 <------------------- Watch this value it was giving my headache connect_timeout = 10 <------------------- Watch this value it was giving my headache interactive_timeout = 120 <------------------- Watch this value it was giving my headache max_connect_errors = 1000 <------------------- Watch this value it was giving my headache expire_logs_days = 7 low_priority_updates = 1 max_join_size = 4294967295 This is a dedicated server with 2G, so the others values my not apply to your setup. Hope that helps. sergio rosa -- AWD arquitectura web e design, lda rua do moinho velho, 19 2ºdto 2655-242 ericeira tlm +351 913 489 195 mail <mailto:sergior...@awd.pt> sergior...@awd.pt url <http://www.awd.pt> http://www.awd.pt Disclaimer For Citizens National Bank "The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this message in error, please contact the sender and delete the material from all computers." This original email was sent to the internet for delivery at 13 May 2010 12:15:43 -0400 -- AWD arquitectura web e design, lda rua do moinho velho, 19 2ºdto 2655-242 ericeira tlm +351 913 489 195 mail <mailto:sergior...@awd.pt> sergior...@awd.pt url <http://www.awd.pt> http://www.awd.pt -- =========================== Jianbin Xiao http://www.xiaojb.com =========================== !DSPAM:4bf199b832717602361063!
