Page 1 of 1

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

Posted: Thu Nov 09, 2017 7:49 pm
by Senior Rossi
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


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

Posted: Fri Nov 10, 2017 2:43 pm
by tjebbeke
How many ram do your server/vps have?