Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2007-08-19 00:02:38
- sbo
- Member
- Registered: 2006-06-06
- Posts: 47
How to reduce the size of the TXP-DB ?
Hi,
I have received an alert message from my web hoster because my database will soon exceed 5MB, which is the maximum size they allow.
I would need to get a larger DB, but this option is very expensive.
I have tried to clean my logs, take off everything necessary, but my DB is still too big.
I am a bit surprised by this size; my TXP runs a personal blog with something like 100 articles.
Is there anything i could do to reduce the size of my DB?
Thank you,
Stéphane.
Stéphane.
Offline
Re: How to reduce the size of the TXP-DB ?
Er – how would it be using 5 MB if there isn’t even thousands of articles? My personal blogs uses 2.5 MB with 400 articles… And same sized is another site of mine – webmagazine with over 1500 articles… How much your Textpattern’s DB is using?
Cheers!
Offline
Re: How to reduce the size of the TXP-DB ?
Disable logging in the TXP preferences, then use phpmyadmin to optimize the txp_log table.
I have set logging to 1 day, referer only… and that gives me a 3.6MB txp_log table. Just optimizing the table using phpmyadmin would reduce the size by 1MB.
After disabling logging, the txp_log table size stays the same until you optimize it using phpmyadmin.
Offline
#4 2007-08-19 11:46:23
- sbo
- Member
- Registered: 2006-06-06
- Posts: 47
Re: How to reduce the size of the TXP-DB ?
I already did the “OPTIMIZE” on all tables; i emptied all my logs.
I have exactly 97 articles and 130 comments.
My DB is 4.2 MB !!!!!!!
I don’t understand !
This is driving me mad …
Stéphane.
Offline
Re: How to reduce the size of the TXP-DB ?
Can you tell us which tables are contributing most to this size and if there’s overhead on any of the tables?
Last edited by ruud (2007-08-19 12:16:45)
Offline
#6 2007-08-19 12:13:48
- sbo
- Member
- Registered: 2006-06-06
- Posts: 47
Re: How to reduce the size of the TXP-DB ?
| Table | Records | Type | Size |
| textpattern | 94 | MyISAM | 4.6 MB |
18 table(s) 2,807 — 5.3 MB
As you can see, the textpattern table represents 87% of the total DB size ???
Thank you for your help,
(You can check content of my WS at mumuksu.com); maybe this size is normal considering the length of every aticle i have published; but i don’t think so …
Stéphane.
Offline
Re: How to reduce the size of the TXP-DB ?
Looking at the articles on your website (lovely design, btw), they are probably bigger than the average articles most people write. Suppose the average size is 15kB. It’s stored twice in the database, once as textile, once as html, so that’s 30kB per article. But that’s not all, because the body and title are indexed for faster searching, which is probably another 15kB per article. In total that’s 45kB per article. Multiply by 100 and you have 4.5MB.
Removing the ‘searching’ index from the textpattern table would then give you 1.5MB extra room at the expense of slower searching (which is slow anyway), but at the speed you’re writing articles, you’ll run out of room before the end of the year.
Last edited by ruud (2007-08-19 12:16:59)
Offline
Re: How to reduce the size of the TXP-DB ?
Why not simply change host? 5mb is not that big and most hosts don’t set DB size limits.
Offline
#9 2007-08-19 12:31:07
- sbo
- Member
- Registered: 2006-06-06
- Posts: 47
Re: How to reduce the size of the TXP-DB ?
Hi ruud,
I undesrtand better now the way it works; you must be right and i am not surprised any more by the size of the DB.
Thank you for taking of your time to answer my post.
This is a bad point for me as my web hoster charges me a 81$ supply a year for a 100MB SQL DB instead of the 5MB standard size … Compared to the price of the hosting by itself, it is huge!
Stéphane.
Offline
#10 2007-08-19 12:32:01
- sbo
- Member
- Registered: 2006-06-06
- Posts: 47
Re: How to reduce the size of the TXP-DB ?
jstubbs a écrit:
Why not simply change host? 5mb is not that big and most hosts don’t set DB size limits.
Right!
Stéphane.
Offline
Re: How to reduce the size of the TXP-DB ?
sbo wrote:
This is a bad point for me as my web hoster charges me a 81$ supply a year for a 100MB SQL DB instead of the 5MB standard size … Compared to the price of the hosting by itself, it is huge!
Definitely time to change host!
Offline