Performance after conversion
I finally upgraded my bbpress 1.x to bbpress 2.5.6 after running it for 7 years. The import process took almost a day with 0.5+ million posts.
Now I am facing issue with slow performance, despite running on physical server with 16 core CPU and 16 GB RAM. The upgrade ran fine for few hours has but been very slow from last 12 hours.
The wordpress and bbpress are both so slow that sometimes even the site fails to load. HTOP shows all CPU cores running mysql up to 90%.
I enabled slow query on mysql (mariadb) and it is giving the following output:
[root@server]# mysqldumpslow -t 5 -s at /var/log/mariadb/mysql-slow.log Reading mysql slow query log from /var/log/mariadb/mysql-slow.log Count: 7485 Time=25.48s (190747s) Lock=2.85s (21328s) Rows_sent=10.0 (74810), Rows_examined=1582056.1 (11841689862), user[database]@localhost SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE N=N AND ( ( wp_postmeta.meta_key = 'S' AND CAST(wp_postmeta.meta_value AS SIGNED) NOT IN ('S','S') ) ) AND wp_posts.post_type = 'S' AND ((wp_posts.post_status = 'S' OR wp_posts.post_status = 'S')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT N, N
I tried disabling other plugins but it did not make any difference, however the CPU returns to low if I disable bbpress plugin.
Can anyone guide me on what could be the issue here?
- You must be logged in to reply to this topic.