Have you updated to the new search table code?
Thread Starter
rorror
(@rdehaar)
Was that the option under Optimalisation, that you had to convert the datebase? Then i have done that.
Have tested it on a other site, with those 2 off, load speed of admin screen goes from 3 sec to less then 1 sec. That site got less traffic then the other.
Thread Starter
rorror
(@rdehaar)
Got more info:
Dashboard open with only “Top 10 Pages” selected as view. It makaes 9500 query’s to load the page.
Queries by Caller
Caller SELECT
wp_statistics_uri_to_id() 2,625 1.0825
wp_statistics_pages() 2,625 1.0034
WP_Statistics->Get_Historical_Data() 2,625 0.7684
WP_Post::get_instance() 1,590 0.7494
wp_count_posts() 2 0.0404
wp_load_alloptions() 1 0.0180
Queries by Component
Component SELECT
Plugin: wp-statistics 9,465 3.6136
Core 17 0.0668
How many rows are in your wp_statistics_pages and other databases? (you can see the number of rows in optimization page).
Thread Starter
rorror
(@rdehaar)
Number of rows in the prefix_statistics_pages table: 4,187 Row
Thread Starter
rorror
(@rdehaar)
Still slow yes, what do you mean with other tables?
Want an other prinscreen?
Did you find the issue? (Because it says resolved)
Row count for your other wp_statistics tables.
Not resolved, but if I don’t get a response after a week I close a the ticket.
Thread Starter
rorror
(@rdehaar)
Wow you made me respond fast! š Here you go!
TABLE ROWS TYPE COLLATION SIZE
wp_statistics_exclusions 0 InnoDB utf8_general_ci 48 KiB
wp_statistics_historical 0 InnoDB utf8_general_ci 64 KiB
wp_statistics_pages 59,303 InnoDB utf8_general_ci 28,3 MiB
wp_statistics_search 89,365 MyISAM utf8_general_ci 6,8 MiB
wp_statistics_useronline 12 InnoDB utf8_general_ci 16 KiB
wp_statistics_visit 174 InnoDB utf8_general_ci 32 KiB
wp_statistics_visitor 53,643 InnoDB utf8_general_ci 21,6 MiB
Need more information? Or a mysql dump of the tables?
Thread Starter
rorror
(@rdehaar)
If you have an website, with an database the size as mine.
You could install the plugin Query Monitor
then you can see the ammount of query’s and the time it takes.
How many rows are in each table?
Thread Starter
rorror
(@rdehaar)
wp_statistics_exclusions ROWS 0
wp_statistics_historical ROWS 0
wp_statistics_pages ROWS 59,303
wp_statistics_search ROWS 89,365
wp_statistics_useronline ROWS 12
wp_statistics_visit ROWS 174
wp_statistics_visitor ROWS 53,643
Search/Pages seem a little strange to be so high with visitors being lower. Can you check to see what the oldest rows are in each of those three tables?
Thread Starter
rorror
(@rdehaar)
wp_statistics_pages OLDEST ROW 2015-04-24
wp_statistics_search OLDEST ROW 2015-04-24
wp_statistics_visitor OLDEST ROW 2015-04-24
Have you purged any data in the past?
