223564 MYSQL Wordpress Optimize

I have a wordpress project I'm working on and will be using WP as a CMS, the whole project works fine except for the fact that there are 2,7 mill categories.

As a result I can barely even access my site due to a MYSQL problem with the server hanging on "copying tmp table" due to certain queries being executed.

In the slow-queries log I have a record of the offending queries and when I do a mysql "EXPLAIN" on the queries I can see some of the issues but not sure what to do about them.

I need someone with expertise in this area to look at either tweaking mysql (some forums claim this is a mysql bug - but I have my doubts), altering WP database, editing the queries produced by [url removed, login to view] or SOMETHING so that queries are fast and slick.

Kemahiran: Semua Boleh, MySQL, PHP, Sistem Admin, Wordpress

Lihat lebih lanjut: wordpress log, wordpress slow, wordpress bug, taxonomy, slow admin, optimize wordpress, optimize mysql, doubts, wordpress server slow, php mysql optimize, mysql area, taxonomy wordpress, mysql record, wordpress slow queries, wordpress admin log, slow queries, issues using wordpress mysql, php mysql taxonomy, php mysql access log, queries wordpress, mysql project cms, tweaking access, mysql slow queries, mysql log, wordpress site issues

ID Projek: #1969800