Tags timeout with 500000 tags
See this page. You can not create a tag now here in wp-admin.
/wp-admin/edit-tags.php?taxonomy=question_tag
See.
https://www.dropbox.com/s/d16n28cnsr2hdpn/Screenshot%202017-02-02%2007.05.13.png?dl=0
Before though there was more features related to tags.
https://www.dropbox.com/s/bn7wrxjcdq0l3vl/Screenshot%202017-02-02%2007.03.10.png?dl=0
Hello Frank,
Please show us error log.
I sent in another comment but it looks like it was lost. It showed the nginx error.
The non-usable tag areas start when tags are around 50,000. Both tags administration and the tag page doesn’t work.
The problem is this query. It takes like 4 minutes to run.
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, qameta.*, qameta.votes_up – qameta.votes_down AS votes_net
FROM wp_posts LEFT JOIN wp_ap_qameta qameta ON qameta.post_id = wp_posts.ID WHERE 1=1
AND wp_posts.post_type = ‘question’ AND ((wp_posts.post_status = ‘publish’))
GROUP BY wp_posts.ID ORDER BY CASE WHEN IFNULL(qameta.featured, 0) =1 THEN 1 ELSE 2 END ASC,
qameta.last_updated DESC LIMIT 0, 20
Hello Frank, this query does not seems to be linked with tags. Please have a chat this evening on skype. I will require access to PMA.
500.000 tags ??