Live Helper Chat support forum.. Forum is locked. New place for questions - Github Discussions

You are not logged in.

Announcement

#1 2022-01-07 03:43:25

songserm
New member
Registered: 2022-01-07
Posts: 2

Please Help me ! problem mysql timeout

Please Help me ! problem mysql timeout
1641526999_log.jpg

Last edited by songserm (2022-01-07 03:45:59)

Offline

#2 2022-01-07 05:49:13

remdex
Administrator
From: Lithuania
Registered: 2012-09-23
Posts: 3,661
Website

Re: Please Help me ! problem mysql timeout

It's your server problem that it can't connect.

Offline

#3 2022-01-07 06:29:43

songserm
New member
Registered: 2022-01-07
Posts: 2

Re: Please Help me ! problem mysql timeout

remdex wrote:

It's your server problem that it can't connect.

thank you for anwser
my problem  sometime is connection and sometime not connection.

I'm have 2 problem
     1. SQLSTATE[HY000] [2006] MySQL server has gone away
     2. SQLSTATE[HY000] [2002] Connection timed out

-- my Database Config --

sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

max_connections=5000

connect_timeout =60
wait_timeout=900
max_allowed_packet = 64M

table_definition_cache=5200
join_buffer_size=16M
innodb_buffer_pool_size=10G
innodb_log_file_size=1G
innodb_buffer_pool_instances=10

innodb_log_buffer_size=4M
innodb_thread_concurrency=8
innodb_flush_method=O_DIRECT

query_cache_limit=8M
query_cache_size=128M
query_cache_type=1
max_heap_table_size=64M
tmp_table_size=64M
interactive_timeout=20
thread_cache_size=128
key_buffer_size=128M
sort_buffer_size=4M
read_buffer_size=4M
max_connect_errors=5000

Last edited by songserm (2022-01-07 06:33:01)

Offline

Board footer