MySQL server has gone away - Query: UNLOCK TABLES

Question

I get this error in my error log.

Other apps work fine on same hosting, but not this one. Any ideas why?

Comments

I can reliably reproduce this error with q2a-open-login

Answer 1

Try to optimize mysql do like this put the code into /etc/my.cnf

[mysqld]
    local-infile = 0
    max_connections = 250
    key_buffer = 64M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 2M
    max_heap_table_size = 16M
    table_cache = 5000
    thread_cache_size = 286
    interactive_timeout = 25
    wait_timeout = 7000
    connect_timeout = 15
    max_allowed_packet = 16M
    max_connect_errors = 10
    query_cache_limit = 2M
    query_cache_size = 32M
    query_cache_type = 1
    tmp_table_size = 16M
    open_files_limit=2528

[mysqld_safe]

[mysqldump]
    quick
    max_allowed_packet = 16M
[myisamchk]
    key_buffer = 64M
    sort_buffer = 64M
    read_buffer = 16M
    write_buffer = 16M
[mysqlhotcopy]
    interactive-timeout

For more info visit http://www.gk-root.com/GK-Blog/optimize-mysql-apache-on-cpanelwhm-server/

Comments

i don't have access to server. I'm on shared hosting.

I have tried setting     define('QA_OPTIMIZE_LOCAL_DB', true); hoping queries get "normal", but they still have whole bunch of left joins and unions

---

I think you should switch an vps so you don't have problems like these.

---

Cost is the main problem. Site is non-profit

---

You should go with Digitalocean with a low price from 5 $/month