WP Statistics has become very slow

First, make sure you’ve updated your database via Statistics->Optimization->Database.

After that you have two choices, you can increase the available memory to your MySQL instance and PHP instance or purge data from the database via Statistics->Optimization->Purging.

Thanks for your (fast) answer !
I didn’t explore that category yet, that’s a great tool, good to know it’s there.
I’d like to keep the full history, but if it becomes unstable, at least i know i can wipe some data.
In database, it seems like everything is OK, the only option i got is “Re-run Install: Install Now!”

I can see in the Resources/Information that it used much memory :

Memory usage in PHP: 14 127 288 Byte
Last Overview page memory usage: 134 217 728 Byte
PHP Memory Limit: 256M

So, PHP is already at 256M.
MySQL has this (hope it’s actually the relevant info) :
query_cache_limit = 8M
query_cache_size = 64M

I guess more wouldn’t be reasonable, what do you think ?

Everything sounds fine from the above, a complete site lock seems out of place as that usually means MySQL isn’t responding while it generates the stats data.

I’d look at MySQL’s config, it’s the most likely culprit.

Hello, your plugin has always worked well up until the past few days. I had to disable it. I was getting 503 errors and accessing the dashboard became either impossible, or extremely slow. The hosting technician identified the plugin as the culprit and when we disabled it, everything worked fine.
I read the above suggestions, updated database, cleared cache, etc. Still, when I activate the plugin, same problems. Site is https://www.financecolombia.com if it matters.

Thank you in advance.

@mosscatski you should start a new thread instead of tagging on to the end of someone else’s.

Check your memory limit, this is another common issue.

Thanks for your answer.

So here is the my.cnf relevant config :

# * Fine Tuning
#
key_buffer              = 64M
max_allowed_packet      = 32M
thread_stack            = 192K
thread_cache_size       = 8
# * Query Cache Configuration
#
query_cache_limit       = 8M
query_cache_size        = 64M

[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer              = 16M

Any clue ?

PS : Other websites on the same machine still respond correctly even if one is fronzen because accessing Statistics overview.
Which seems to indicate that MySQL doesn’t freeze entirely.

Since other websites are still responding it sounds more like something in the PHP/MySQL config or a table lock that’s blocking the site.

Has the MySQL client been upgraded recently? It could be a bug in the MySQL client code.

I guess there was an update for mysql a few weeks ago, but it seems like it didn’t cause any trouble.

Can you revert the MySQL change and see if that helps?

It’d be a pain, even to know on what version i was.

Unfortunately this looks to be a MySQL issue and that’s beyond the scope of support we provide here.

The only other suggestion I can give is if you have access to phpMyAdmin you could look at the performance info and see if anything stands out.

PHPMyAdmin is quite hard to set up to monitor slow functions.
But you gave me an idea :
Activate the plugin server query monitor !
But then next time i tried displaying the Statistics panel, i just got an error 500… I guess it’s due to the 30s timeout.
I think it just has too much data to fetch it all in 30s, what do you think ?

Could be, backup your data and do a purge and see if that helps.