XF 2.2 A malfunction in the number of queries caused by the site and a load on the database

urivil

Active member
Greetings,
In recent weeks, users have been constantly complaining to me about the appalling slowness of the site. Today it also collapsed for a few hours.
The server says that this is caused by the multiplicity and load of queries that burden the MYSQL. Screenshot attached.
I'm having trouble understanding what suddenly happened to this problem, and I'm desperate to find a solution.
Would appreciate help
| 132999 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 404 | Waiting for table metadata lock | INSERT INTO xf_search_index (content_type, content_id, title, message, metadata, `item_ | 0.000 |<br>| 133105 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 400 | Waiting for table metadata lock | SELECT search_index.content_type, search_index.content_id<br>| 134574 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 337 | Waiting for table metadata lock | INSERT INTO xf_search_index (content_type, content_id, title, message, metadata, `item_ | 0.000 |<br>| 134664 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 335 | Waiting for table metadata lock | INSERT INTO xf_search_index (content_type, content_id, title, message, metadata, `item_ | 0.000 |<br>| 134711 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 332 | Waiting for table metadata lock | INSERT INTO xf_search_index (content_type, content_id, title, message, metadata, `item_ | 0.000 |<br>| 134859 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 329 | Waiting for table metadata lock | INSERT INTO xf_search_index (content_type, content_id, title, message, metadata, `item_ | 0.000 |<br>| 134893 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 329 | Waiting for table metadata lock | SELECT search_index.content_type, search_index.content_id<br>| 135274 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 313 | Waiting for table metadata lock | INSERT INTO xf_search_index (content_type, content_id, title, message, metadata, `item_ | 0.000 |<br>| 137047 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 240 | Waiting for table metadata lock | INSERT INTO xf_search_index (content_type, content_id, title, message, metadata, `item_ | 0.000 |<br>| 137836 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 208 | Waiting for table metadata lock | INSERT INTO xf_search_index (content_type, content_id, title, message, metadata, `item_ | 0.000 |<br>| 138583 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 180 | Waiting for table metadata lock | SELECT search_index.content_type, search_index.content_id<br>| 138930 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 164 | Waiting for table metadata lock | INSERT INTO xf_search_index (content_type, content_id, title, message, metadata, `item_ | 0.000 |<br>| 138966 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 163 | Waiting for table metadata lock | INSERT INTO xf_search_index (content_type, content_id, title, message, metadata, `item_ | 0.000 |<br>| 139461 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 144 | Waiting for table metadata lock | SELECT search_index.content_type, search_index.content_id<br>| 140019 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 123 | Waiting for table metadata lock | SELECT search_index.content_type, search_index.content_id<br>| 140314 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 109 | Waiting for table metadata lock | INSERT INTO xf_search_index (content_type, content_id, title, message, metadata, `item_ | 0.000 |<br>| 141073 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 79 | Waiting for table metadata lock | INSERT INTO xf_search_index (content_type, content_id, title, message, metadata, `item_ | 0.000 |<br>| 141111 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 77 | Waiting for table metadata lock | INSERT INTO xf_search_index (content_type, content_id, title, message, metadata, `item_ | 0.000 |<br>| 141374 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 68 | Waiting for table metadata lock | INSERT INTO xf_search_index (content_type, content_id, title, message, metadata, `item_ | 0.000 |<br>| 142054 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 41 | Waiting for table metadata lock | SELECT search_index.content_type, search_index.content_id<br>| 142380 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 25 | Waiting for table metadata lock | INSERT INTO xf_search_index (content_type, content_id, title, message, metadata, `item_ | 0.000 |<br>| 142478 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 24 | Waiting for table metadata lock | INSERT INTO xf_search_index (content_type, content_id, title, message, metadata, `item_ | 0.000 |<br>| 142716 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 10 | Waiting for table metadata lock | INSERT INTO xf_search_index (content_type, content_id, title, message, metadata, `item_ | 0.000 |<br>| 142806 | toraforu_xf211122 | localhost | toraforu_xf211122 | Prepare | 8 | Waiting for table metadata lock | INSERT INTO xf_search_index (content_type, content_id, title, message, metadata, `item_ | 0.000 |<br>| 142929 | toraforu_xf211122 | localhost | toraforu_xf211122 | Execute | 8 | Sending data | SELECT xf_thread., xf_forum_Forum_1., xf_node_Node_2.*, `xf_permission_cache_content_Permiss | 0.000 |
 
What are the technical data of the site (number of users) and the server (cores, cpu, ram, etc.)
I am attaching a screenshot of the website data.
All the indicators look quite normal, but despite this the slowness of the site is appalling, and the server also claims that there are many queries that cause this load.
1711572668701.webp
 
Back
Top Bottom