We are starting CHRISTMAS Sale. Get 30% OFF on lifetime licenses with code: FYSKK72

MYSQL SERVER IS GONE AWAY - Issue 500 - Timeout set to 900

Questions regarding the Web Interface
Senior Rossi
Posts: 1
Joined: Thu Nov 09, 2017 7:22 pm

MYSQL SERVER IS GONE AWAY - Issue 500 - Timeout set to 900

Postby Senior Rossi » Thu Nov 09, 2017 7:49 pm

Hello dear Vesta community.

I'm new here in this community and with vestaq and working already some months with vesta.

I have a large DB and want import. A lot of categories and entries.
Now i want import 200MB Database as zip.

(mysql/socket 900 - Filesize UL 1024M)

Before - i get error 2006 - mysql server gone away.
Now i have figured out, i have to setup in etc/mysql.conf the keep alive timeout to 900.
Ok. But now i get the issue 500.
Sometimes it works,- if i setup new vesta to debug this error, sometimes not.
What i do sometimes right, what not. (???)

What i have especially to do/setup, that i can import large DB files/socket_timeout/keep_alive_timeout?
Who can help me please.

Thanks for that.



Edit: (With this settings it worked a install before, but now i get a 500)

key_buffer_size = 256M
max_allowed_packet = 1024M
table_open_cache = 256
sort_buffer_size = 1024M
read_buffer_size = 1024M
read_rnd_buffer_size = 1024M
myisam_sort_buffer_size = 1024M
thread_cache_size = 1024
query_cache_size= 1024M
thread_concurrency = 8

#innodb_use_native_aio = 0


Posts: 757
Joined: Mon May 11, 2015 8:43 am

Re: MYSQL SERVER IS GONE AWAY - Issue 500 - Timeout set to 900

Postby tjebbeke » Fri Nov 10, 2017 2:43 pm

How many ram do your server/vps have?

Return to “Web Interface”

Who is online

Users browsing this forum: No registered users and 4 guests