Textpattern CMS

#1 2008-12-02 03:12:41

mattmikulla

Member

From: Nashville Tennessee

Registered: 2004-08-25

Posts: 281

Website

Why is my database so large?

When exporting my database as an sql file the file size is about 56MB. I have a few plugins and my site may be about 150 pages.

Is my database excessively large?

I am trying to import it into a local install so I can upgrade to 4.0.7.

---

Art Rogue – Fine Art Photography

#2 2008-12-02 03:53:13

Gocom

Developer Emeritus

From: Helsinki, Finland

Registered: 2006-07-14

Posts: 4,533

Website

Re: Why is my database so large?

mattmikulla:

Is my database excessively large?

Depends how you take it, but no, just regular. Or would you say that you have a lot of files on your HDD if space required is only 56 MB ;)

You just happen to have some chars/data there, but if you have intendionally added’em there, then it is fine :)

And to add, db’s size doesn’t reflect to the performance. As it just is data – base. It can handle thousands trillions times more.

Last edited by Gocom (2008-12-02 03:55:08)

---

Rah | GitHub

#3 2008-12-02 09:49:28

redbot

Plugin Author

Registered: 2006-02-14

Posts: 1,410

Re: Why is my database so large?

Matt,
check your “logs” table. Often this is the cause of a large txp db.
If you want a smaller db you have two choices: empty that table or simply export all tables minus the “logs” one

---

Some Txp stuff

#4 2008-12-02 11:35:32

ruud

Developer Emeritus

From: a galaxy far far away

Registered: 2006-06-04

Posts: 5,068

Website

Re: Why is my database so large?

Or simply disable logging and then empty the table and optimize/compact the table using phpmyadmin.

#5 2008-12-02 15:08:23

mattmikulla

Member

From: Nashville Tennessee

Registered: 2004-08-25

Posts: 281

Website

Re: Why is my database so large?

Thanks everyone. I emptied the logs table and my sql files size went from 53MB to 1MB. Now phpmyadmin can import it.

---

Art Rogue – Fine Art Photography

#6 2008-12-04 01:53:33

mrtunes

Member

From: Toronto, On

Registered: 2007-03-12

Posts: 575

Website

Re: Why is my database so large?

yes this problem caused me lots of grief! i encourage everyone to take a look at their logs and delete them if they’re not using them, better yet disable.

#7 2008-12-04 18:21:20

typeshige

Member

From: USA

Registered: 2005-08-11

Posts: 151

Website

Re: Why is my database so large?

I disabled and went to Mint to collect stats. I have it working with 4.0.7 at the moment and I love it.

Mint caps the size of the database too.

mrtunes wrote:

yes this problem caused me lots of grief! i encourage everyone to take a look at their logs and delete them if they’re not using them, better yet disable.