Recently in processing data always encounter a problem, is there is a table in a select query when all of a sudden hint:
'2003 - Can' t connect to Mysql server on '127.0.0.1 (1061 "unknown error")
'Using Navicat mysql operation, little doubt that yao has been login to connect the database, and the operation of the other tables will not happen this situation, looked at the data in the table data amount can be a bit more compared with other tables in the repository, so wonder if my guess is that this, is that the data quantity is too large, or table structure is not good enough, or other problems? Search on the Internet for a long time but could not find a similar problem. Hope someone can give me some advice,
The table of information shown in the figure below:

CodePudding user response:

Mysql version is 8.0, and the number of fields in the table can be a little more

CodePudding user response:

Look at the system TIMEOUT parameter Settings are in MYSQL?

CodePudding user response:

refer to the second floor ACMAIN_CHM response:

see MYSQL in the system the TIMEOUT parameter Settings?

Wait_timeout=28800;
Mysqlx_wait_timeout=28800;
Mysqlx_write_timeout=60;
Mysqlx_read_timeout=30;
Net_read_timeout=30;
Net_write_timeout=60;
Connect_timeout=10;
Delayed_insert_timeout=300;
Have_statement_timeout=yes;
Innodb_flush_log_at_timeout=1;
Innodb_lock_wait_timeout=50;
Innodb_rollback_on_timeout=off;
Interactive_timeout=28800;
Lock_wait_timeout=31536000;
Mysqlx_connect_timeout=30;
Mysqlx_idle_worker_thread_timeout=60;
Mysqlx_interactive_timeout=28800;
Mysqlx_port_open_timeout=0;
Slave_net_timeout=60;
Rpl_stop_slave_timeout=31536000;
Mysqlx_port_open_timeout=0

CodePudding user response:

Completely uninstall Mysql, reinstall...

CodePudding user response:

reference 4 floor t15137830 response:

completely uninstall Mysql, reinstall...

Big brother I uninstall the hell I'm going to run, the database of the company, the boss may not get hacked to death me? Besides, didn't also the permissions,