Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.6.8
-
None
-
centos 7.4
Description
Importing a 170M sql file will take several hours.
mysql < a.sql
Enter the database to view:
show processlist;
It shows that the import operation has been stuck at the INSERT INTO operation.
Check that there are no lock records in the information_schema.INNODB_LOCKS table
Executing SHOW STATUS and how engine innodb status will hang.
Execute show create table td_framework_monitor_history and Waiting for table flush will be displayed in show processlist. However, show create table and other tables are normal
Other tables can be selected, but insert will also hang. Show processlist shows State: update status.
It has appeared many times, sometimes not when data is imported, but also when inserting normal business logic. But no pattern found