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

Questions regarding the Web Interface
GUI
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.

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

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

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 2 guests