什么是freeingitems，很多新手对此不是很清楚，为了帮助大家解决这个难题，下面小编将为大家详细讲解，有这方面需求的人可以来学习下，希望你能有所收获。

show processlist 查看到大量的 freeing items状态会话

查看官方文档，官方文档在8.14.2 General Thread States章节给出了线程状态的解释

说明命令已经在执行正在进行清理 更新日志索引等

mysql>SELECT@@profiling;+-------------+|@@profiling|+-------------+|0|+-------------+1rowinset(0.00sec)mysql>SETprofiling=1;QueryOK,0rowsaffected(0.00sec)mysql>DROPTABLEIFEXISTSt1;QueryOK,0rowsaffected,1warning(0.00sec)mysql>CREATETABLET1(idINT);QueryOK,0rowsaffected(0.01sec)mysql>SHOWPROFILES;+----------+----------+--------------------------+|Query_ID|Duration|Query|+----------+----------+--------------------------+|0|0.000088|SETPROFILING=1||1|0.000136|DROPTABLEIFEXISTSt1||2|0.011947|CREATETABLEt1(idINT)|+----------+----------+--------------------------+3rowsinset(0.00sec)mysql>SHOWPROFILE;+----------------------+----------+|Status|Duration|+----------------------+----------+|checkingpermissions|0.000040||creatingtable|0.000056||Aftercreate|0.011363||queryend|0.000375||freeingitems|0.000089||loggingslowquery|0.000019||cleaningup|0.000005|+----------------------+----------+7rowsinset(0.00sec)mysql>SHOWPROFILEFORQUERY1;+--------------------+----------+|Status|Duration|+--------------------+----------+|queryend|0.000107||freeingitems|0.000008||loggingslowquery|0.000015||cleaningup|0.000006|+--------------------+----------+4rowsinset(0.00sec)mysql>SHOWPROFILECPUFORQUERY2;+----------------------+----------+----------+------------+|Status|Duration|CPU_user|CPU_system|+----------------------+----------+----------+------------+|checkingpermissions|0.000040|0.000038|0.000002||creatingtable|0.000056|0.000028|0.000028||Aftercreate|0.011363|0.000217|0.001571||queryend|0.000375|0.000013|0.000028||freeingitems|0.000089|0.000010|0.000014||loggingslowquery|0.000019|0.000009|0.000010||cleaningup|0.000005|0.000003|0.000002|2662SHOWStatements+----------------------+----------+----------+------------+7rowsinset(0.00sec)

最后看宿主机的监控状态，load达到了 50多

看完上述内容是否对您有帮助呢？如果还想对相关知识有进一步的了解或阅读更多相关文章，请关注亿速云行业资讯频道，感谢您对亿速云的支持。