Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Main Section Database Server
  • Search

MySQL has Gone Away (error 2006)

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Post Reply
  • Print view
Advanced search
4 posts • Page 1 of 1
m19
Posts: 1
Joined: Fri Jul 18, 2014 7:26 am

MySQL has Gone Away (error 2006)
  • Quote

Post by m19 » Fri Jul 18, 2014 7:38 am

Hello Vestians,

I have this error coming all the time when processing "large" database related queries

Code: Select all

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Any idea why?

Is it related to my MySQL time out ?

Thanks
Top

demian
Posts: 543
Joined: Thu May 16, 2013 5:19 am

Re: MySQL has Gone Away (error 2006)
  • Quote

Post by demian » Fri Jul 18, 2014 8:59 am

in /etc/my.cnf

increase or comment wait_timeout, interactive_timeout and increase max_allowed_packet

Code: Select all

wait_timeout=90  # or comment directive
interactive_timeout=120 # or comment directive
max_allowed_packet =16M # or 32M 
Top

r3wt
Posts: 3
Joined: Mon Jan 04, 2016 2:58 am

Re: MySQL has Gone Away (error 2006)
  • Quote

Post by r3wt » Wed Jan 27, 2016 4:32 am

you should not be altering the conf files you idiots. your control panel has caused nothing but pain to our project. you should not be fucking with the defaults, they are sane already. by idiot proofing, you limit the throughput of the system.
Top

joem
Posts: 378
Joined: Thu Nov 13, 2014 8:33 am

Os: CentOS 6x
Web: nginx + php-fpm
Re: MySQL has Gone Away (error 2006)
  • Quote

Post by joem » Wed Jan 27, 2016 5:10 am

r3wt wrote:you should not be altering the conf files you idiots. your control panel has caused nothing but pain to our project. you should not be fucking with the defaults, they are sane already. by idiot proofing, you limit the throughput of the system.
r3wt wrote:then edited vesta's conf to use hhvm.
Does this make you an idiot? If you don't like the vesta control panel then switch its not like someone is holding a gun to your head and saying use this product over others. I think vesta should take the time to idiot proof the forums disallowing idiots to comment in 2 year old threads for useless reasons. I also think they should take to time to ban members like you who come here acting like you paid to use this control panel and they owe you something, When in reality you owe the Vesta team for providing such a great product for free.

Ps. I would like to take a second to Thank the Vesta Team for this wonderful product on r3wt behalf seeing how hes to ignorant to do so.
Top


Post Reply
  • Print view

4 posts • Page 1 of 1

Return to “Database Server”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

Login  •  Register

I forgot my password