rorror
Forum Replies Created
-
Nope, i never purged any data. On none of my sites..
wp_statistics_pages OLDEST ROW 2015-04-24
wp_statistics_search OLDEST ROW 2015-04-24
wp_statistics_visitor OLDEST ROW 2015-04-24wp_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,643If 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.
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 MiBNeed more information? Or a mysql dump of the tables?
Tnx will be looking forward for this update!
Keep up to good work!
Hi Greg,
Did you find out the issue?
Because i do on more websites Cron-jobs now (instead of running it in the client browser), i get on most websites, now the messages, Hits Unknow.Still slow yes, what do you mean with other tables?
Want an other prinscreen?Did you find the issue? (Because it says resolved)
this is how it looks:
Number of rows in the prefix_statistics_pages table: 4,187 Row
I can’t because i run the file from /var/www/etc/ directly instead of calling it in a browser.
So result is that there is no Ip communication, to save the ip.
Could you test an option while fetching the ip, check if the field is empty, if empty not paste it into the database? and no count it as a hit?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.0180Queries by Component
Component SELECT
Plugin: wp-statistics 9,465 3.6136
Core 17 0.0668Was 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.
Hi Greg,
Few month later, and i just saw on a other site the same behavior.
This happend, when i scheduled a cron-job, and disabled the WP-CRON.So i have a crontab, with */5 * * * * /file-to-run-in-cron/
So evry 5min, this cron is runned, so 12 times x 24hours = 288 hits (on my other site i got about 1400 hits a day. but that cron job runs 1 time a minute.So is it possible to exclude hits from the webserver it self? so th hits are not counted as Unknow Hits.
Still like your work, keep up the great job.
Would like to know this too, using for 1 site about 7 subdomains, where I would like to allow it on all sites at onces.