Deprecated-filters and other in mysql slow queries
-
Hi,
After updating to new version 4.0.12 (not sure may be started earlier from v 4+)
Have unlimited amount of repeating queries in Mysql slow query log.
The process is constant and endless, seriously damaging my db performance. Just a log itself growing like 10mb+ per 1h. I think as a result this two guys: “Handler read rnd” and “Handler read rnd next” are growing super fast in number reaching 60+M at the end of the day.Tried to disable all other plugins (I belive the list is in config file at the bottom), didn’t help, as well as reinstall or clearing some db table ect.
Right now had to downgrade to 3.7.1 because had db crashes once a day for sure.
Looks like this:
* FROM wp_aioseo_notifications WHERE 1 = 1 AND <code>notification_name</code> = 'description-format' /* 1 = 1 */; # Time: 2021-01-28T22:12:11.508750Z # User@Host: example_db[example_db] @ localhost [] Id: 344 # Query_time: 0.000147 Lock_time: 0.000067 Rows_sent: 0 Rows_examined: 0 SET timestamp=1611871931; SELECT * FROM wp_aioseo_notifications WHERE 1 = 1 AND <code>notification_name</code> = 'woo-upsell' /* 1 = 1 */; # Time: 2021-01-28T22:12:11.540258Z # User@Host: example_db[example_db] @ localhost [] Id: 344 # Query_time: 0.000144 Lock_time: 0.000070 Rows_sent: 0 Rows_examined: 0 SET timestamp=1611871931; SELECT * FROM wp_aioseo_notifications WHERE 1 = 1 AND <code>notification_name</code> = 'deprecated-filters' /* 1 = 1 */; # Time: 2021-01-28T22:12:11.540575Z # User@Host: example_db[example_db] @ localhost [] Id: 344 # Query_time: 0.000105 Lock_time: 0.000053 Rows_sent: 0 Rows_examined: 0 SET timestamp=1611871931; SELECT * FROM wp_aioseo_notifications WHERE 1 = 1 AND <code>notification_name</code> = 'deprecated-filters-v2' /* 1 = 1 */; # Time: 2021-01-28T22:12:11.837276Z # User@Host: example_db[example_db] @ localhost [] Id: 345 # Query_time: 0.000121 Lock_time: 0.000060 Rows_sent: 0 Rows_examined: 0 SET timestamp=1611871931; SELECT * FROM wp_aioseo_notifications WHERE 1 = 1 AND <code>notification_name</code> = 'blog-visibility' /* 1 = 1 */; # Time: 2021-01-28T22:12:11.838699Z # User@Host: example_db[example_db] @ localhost [] Id: 345 # Query_time: 0.000113 Lock_time: 0.000055 Rows_sent: 0 Rows_examined: 0 SET timestamp=1611871931; SELECT *
My config (exported from aioseo):
aioseo-system-statusHope it will help to figure out the issue.
Thanks.
- The topic ‘Deprecated-filters and other in mysql slow queries’ is closed to new replies.