(Dec 29) New version 0.9.8-18 has been released. More you can find here

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

Questions regarding the Web Interface
GUI
Forum rules
Before creating a new topic or reply on the forum you should fill out additional fields "Os" and "Web" in your profile section.
In case of violation, the topic can be closed or response from the support will not be received.
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: 759
Joined: Mon May 11, 2015 8:43 am
Contact:

Os: CentOS 7x
Web: apache + nginx

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?
Owner Made I.T. | http://www.madeit.be | Blog: http://www.tpweb.org | Github: @madeITBelgium & @tjebbeke


Return to “Web Interface”



Who is online

Users browsing this forum: No registered users and 2 guests

cron