Announcement

songserm

New member

Registered: 2022-01-07

Posts: 2

Please Help me ! problem mysql timeout

Please Help me ! problem mysql timeout

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

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.

songserm

New member

Registered: 2022-01-07

Posts: 2

Re: Please Help me ! problem mysql timeout

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)