We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
MYSQL SERVER IS GONE AWAY - Issue 500 - Timeout set to 900
-
- Posts: 1
- Joined: Thu Nov 09, 2017 7:22 pm
MYSQL SERVER IS GONE AWAY - Issue 500 - Timeout set to 900
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
-
- Collaborator
- Posts: 783
- Joined: Mon May 11, 2015 8:43 am
- Contact:
- Os: CentOS 6x
- Web: apache + nginx
Re: MYSQL SERVER IS GONE AWAY - Issue 500 - Timeout set to 900
How many ram do your server/vps have?