1 tosca May 11, 2012 01:11
3 tosca May 11, 2012 02:20
Okay, went to Tools -> Misc and don't see where this is suppose to be managed. (I did hit Cache before I made this post and it deleted a lot, but that didn't clear the problem.) So, where do I empty those tables that you suggested?
4 tilqicom May 11, 2012 09:42
Tosca wrote:
Okay, went to Tools -> Misc and don't see where this is suppose to be managed. (I did hit Cache before I made this post and it deleted a lot, but that didn't clear the problem.) So, where do I empty those tables that you suggested?
you can use phpmyadmin to empty the tables
5 tosca May 16, 2012 07:55
These tables were very big! :)
Can Keyphrases be emptied too, because it is large?
6 tilqicom May 16, 2012 20:23
Tosca wrote:
These tables were very big! :)
Can Keyphrases be emptied too, because it is large?
sure
7 tosca May 16, 2012 22:22
Awesome! By emptying these 3 tables, I have recovered nearly half of my disk space with freeing it up. Thank you so much for this wonderful tip. :) MySql is down to 53 MB.
There are 3 more that I see, but I don't know if I can do the same with Slugs, Antispam, and Comments. These aren't nearly as large as the others were, but the files aren't small either.
8 sam2kb May 21, 2012 01:22
Slugs, Antispam, and Comments
you shouldn't empty those
What host is limiting db size these days? I would leave them asap and get "everything unlimited" for under $8/month :)
9 tilqicom May 21, 2012 14:14
sam2kb wrote:
Slugs, Antispam, and Comments
you shouldn't empty those
What host is limiting db size these days? I would leave them asap and get "everything unlimited" for under $8/month :)
virtually unlimited.In reality, everything is limited in this world : D
I dont think he hit the limit, but maybe he is just bothered with the size of those things like me.
I never quite understood why these tables grow that large.. I mean with 20k pageviews a day, my db grows as large as 100mb per week. I cant imagine what would happen if my b2 site had like 100k or a mil. pageviews per day.
10 sam2kb May 21, 2012 19:36
A lot of data stored in hitlog and other stats tables. There will be even more in v5. Still I wouldn't care about DB size if it less than a couple of gigs.
On my system 2 rows in hitlog table take about 1kb of space. So in your case the hitlog table alone should grow to about 70MB а week ;)
11 tosca May 22, 2012 01:41
Hi There:
For the record, I'm not a 'he' but a 'she'. ;)
My disk space isn't unlimited. It is up to 500MB; therefore, disk usage does matter. So v5 will be worse and your hit log is at 70MB??? OMGosh..... :(
But wait, Sam2kb, you're not renting and have a virtual server instead? Right?
I would hate to leave my host provider because they are amazing and more than helpful when I need the help. I had a terrible time with another host before switching that was suppose to be 'good' and they were horrible and VERY slow in responding to technical problems. The host that I have now responds less than 10 minutes.
12 sam2kb May 22, 2012 05:41
But wait, Sam2kb, you're not renting and have a virtual server instead? Right?
No, I mean a regular shared hosting. If you need VPS you can get one for under $15
So v5 will be worse and your hit log is at 70MB??? OMGosh.....
Well, these days hosting space is VERY cheap, so we try to implement more features and collect more stats data. Windoze 98 installer was just about 200Mb and Windoze 7 is 20 times bigger and ships on DVD ;)
13 tosca May 23, 2012 00:04
Hmmm..... maybe I should start looking around... drats!
Probably your evo_hitlogs and evo_sessions tables grew large.. just empty those and you should be fine