Managing the jos_rokuserstats table
-
-
- IC Info
- Newbie
- Posts: 15
- Thanks: 0
- IT services
-
I just noticed that our jos_rokuserstats table has grown a lot. 266Mb.
How should we manage that? Is there an import/export/reset tools that we should use with it? - ==========================
IC Info
Internet-Content.net
shop.internet-content.net
phone: +358 9 42833310
-
-
-
- Andy Miller
- Preeminent Rocketeer
- Posts: 9919
- Thanks: 96
- Web Kahuna
- Currently no, there are no tools, however, it 'should' be deleting older entries automatically. I'll have to look into this.
-
-
-
- Barry Nordby
- Jr. Rocketeer
- Posts: 28
- Thanks: 0
- This table has gotten large enough that it's a problem to upload. I'm bumping this up because I'd like to know how to trim this table too.
-
-
-
- Andy Miller
- Preeminent Rocketeer
- Posts: 9919
- Thanks: 96
- Web Kahuna
-
Until I can work out what's the problem, you can easily just clear out the data by using phpMyAdmin or something and running the following query:
delete from jos_rokuserstats
It will delete all the entries and clear that table out.
-
-
-
- Exirtis
- Newbie
- Posts: 19
- Thanks: 0
-
Andy Miller wrote:
Until I can work out what's the problem, you can easily just clear out the data by using phpMyAdmin or something and running the following query:Andy, not to pressure or to nag, but when you do figure out the problem and have a fix for it... how will we know? Is it something that'll be announced on the main site?
delete from jos_rokuserstats
It will delete all the entries and clear that table out.
-
-
-
- Andy Miller
- Preeminent Rocketeer
- Posts: 9919
- Thanks: 96
- Web Kahuna
- it will be in the changelog for the release. Not fixed yet, sorry.
-
-
-
- Glorious
- Hero Rocketeer
- Posts: 489
- Thanks: 2
- Hey Andy, Not sure how, but ours had grown to 8GB. And we stopped using Mission Control months ago because it was creating weird server crashes. (We love the template and hope to use it again).
-
-
-
- Andy Miller
- Preeminent Rocketeer
- Posts: 9919
- Thanks: 96
- Web Kahuna
- First off, if you are not using mission control you should disable the roktracking plugin. This is what is adding to the logs. Second, when you guys had these logs getting large where you still using missioncontrol? the purge functionality is in the rokuserstats module which is usually displayed on the controlpanel/home view of the administrator. Of course this will only purge if this module is viewed. I'm going to add a fall back purge in the plugin, but i had moved it to the module originally for performance reasons.
-
-
-
- Krx
- Sr. Rocketeer
- Posts: 174
- Thanks: 12
-
Hello
I also noticed sudden spike in table size, after I started to use mission control
Quick peek into table sizes shown that rokuserstats table has almost 100K of entries lines and 24MB in size.
I can always empty it via phpmyadmin but I would like to be able to do it within template itself. Why is this module doesn't apply some kind of internal table cleaning?
I have this template running for one week only and it quickly filled table with loads of info.
I know that 24mb isn't much but as I can see other users reported much bigger sizes and I'd like to continue to use this template without need to do manual table purge every week or so.
Regards
-
Time to create page: 0.056 seconds