MYSQL SERVER IS GONE AWAY - Issue 500 - Timeout set to 900
Posted: 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.
Greetings
-------------
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
innodb_file_per_table
max_connections=200
max_user_connections=50
wait_timeout=900
interactive_timeout=300
long_query_time=5
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.
Greetings
-------------
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
innodb_file_per_table
max_connections=200
max_user_connections=50
wait_timeout=900
interactive_timeout=300
long_query_time=5