Textpattern CMS

#1 2008-03-05 08:15:47

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

[contrib] Database Sizes

Folks (txp.org, txp.net, etc), please check the sizes of your databases. We ran out of space on the server (for databases), causing MySQL to flip out and it brought down all our sites.

For instance, txp.org’s slimstat table is huge, containing over a million rows, and is several hundred megabytes in size. That’s many, many times larger than the Txp forum’s database.

Please make any backups you want, and TRUNCATE these excessively large tables, before we have this happen again.

#2 2008-03-05 08:27:26

jm

Plugin Author

From: Missoula, MT

Registered: 2005-11-27

Posts: 1,746

Website

Re: [contrib] Database Sizes

For .org, it might be wise to use an off-site service like Google Analytics or reinvigorate for stats.

---

What? My name is… | GitHub

#3 2008-03-05 10:09:15

colak

Admin

From: Cyprus

Registered: 2004-11-20

Posts: 9,090

Website GitHub Mastodon Twitter

Re: [contrib] Database Sizes

jm wrote:

For .org, it might be wise to use an off-site service like Google Analytics or reinvigorate for stats.

Or change its preferences so as to store only a months stats

---

Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

#4 2008-03-05 11:30:35

alicson

Member

Registered: 2004-05-26

Posts: 465

Website

Re: [contrib] Database Sizes

Sorry about that guys. I wasn’t aware of the table size. Taking care of it now.

---

textpattern.org :: find and share Textpattern resources
docs.textpattern.io :: Textpattern user documentation

#5 2008-03-05 15:12:47

hakjoon

Member

From: Arlington, VA

Registered: 2004-07-29

Posts: 1,634

Website

Re: [contrib] Database Sizes

and Textbook login still doesn’t work *sob*

Last edited by hakjoon (2008-03-05 15:13:02)

---

Shoving is the answer – pusher robot