Shulou(Shulou.com)05/31 Report--

What is freeingitems, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

Show processlist sees a large number of freeing items stateful sessions

Look at the official documentation, which gives an explanation of thread status in the 8.14.2 General Thread States section.

It indicates that the command is already in the process of cleaning and updating the log index, etc.

Mysql > SELECT @ @ profiling;+-+ | @ @ profiling | +-+ | 0 | +-+ 1 row in set (0.00 sec) mysql > SET profiling = 1persent query OK, 0 rows affected (0.00 sec) mysql > DROP TABLE IF EXISTS T1 politics query OK, 0 rows affected, 1 warning (0.00 sec) mysql > CREATE TABLE T1 (id INT) Query OK, 0 rows affected (0.01 sec) mysql > SHOW PROFILES +-- + | Query_ID | Duration | Query | +-+ | 0 | 0.000088 | SET PROFILING = 1 | | 1 | 0.000136 | DROP TABLE IF EXISTS T1 | | 2 | 0.011947 | CREATE TABLE T1 (id INT) | +-- + 3 rows in set (sec) mysql > SHOW PROFILE | +-- +-+ | Status | Duration | +-+-+ | checking permissions | 0.000040 | | creating table | 0.000056 | After create | 0.011363 | query end | 0.000375 | | freeing items | 0.000089 | | logging slow query | 0 .00 | | cleaning up | 0.000005 | +-- +-+ 7 rows in set (000019 sec) mysql > SHOW PROFILE FOR QUERY 1 +-+-+ | Status | Duration | +-+-+ | query end | 0.000107 | | freeing items | 0.000008 | logging slow query | 0.000015 | | cleaning up | 0.000006 | +- -+ 4 rows in set (0.00 sec) mysql > SHOW PROFILE CPU FOR QUERY 2 +-+ | Status | Duration | CPU_user | CPU_system | +-- +-- -+-+ | checking permissions | 0.000040 | 0.000038 | 0.000002 | | creating table | 0.000056 | 0.000028 | 0.000028 | After create | 0.011363 | 0.000217 | 0.001571 | query end | 0.000375 | 0.000013 | 0.000028 | freeing items | 0.000089 | 0.000010 | 0.000014 | logging slow query | 0.000019 | 0.000009 | 0.000010 | cleaning up | 0.000005 | 0.000003 | 0 .00 | 2662SHOW Statements+--+7 rows in set (000002 sec)

Finally, looking at the monitoring status of the host, the load reached more than 50.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.