September 08, 2004
MySQL hates me lately

Yesterday, I had to resize tables. Who knew they would reach 4GB each in such a short period of time? They do grow quickly.. don't they.

Today, I had to deal with aftermath of a server running out of space (damnit, I will install some better monitoring, I promise!) and learned that you need 2.2GB of free space to run repair on a 2.4GB table.

Time to prune some data.

Posted September 08, 2004 11:06 PM in Geek Stuff
TrackBack URL for this entry: http://www.unix-girl.com/mt/mt-tb.cgi/1324
Comments
On September 9, 2004 07:37 AM pbw added:

2.4 Gig table? That's one heck of a table! Are you storing your photos in the database? I'm just starting to load a data warehouse and one of my fact tables is a bit over a Gig right now (Not including indexes) and it has 6 million rows.

Just wondering because I'm working on putting up my website and I'm wondering what grew one of your tables to 2+ Gig?

#
On September 9, 2004 04:51 PM david added:

I believe Kasia was using SQL-based Apache logging ( http://modules.apache.org/search.php?id=411 ) for DSLR, but I can't be certain..

#
On September 9, 2004 08:43 PM Eric added:

hmm.. and here i wondered why my little mailserver/router/sql server might keep running out of space.. duh.

probably time to backup some of my old data that hasn't been used for anything in years, and get it out of the server.

#
On September 10, 2004 07:39 AM pbw added:

Ahhhh! SQL-based Apache logging... Ok, I feel better. Didn't think about that one. Note to self...

#
On September 10, 2004 07:41 AM kasia added:

Close..

I have several 4GB+ tables that are rotating apache logs (they rotate like once a week or maybe month, I forget).

The 2.2GB table was actually system monitoring for servers, that was data since March this year.

Then there are the tables for the actual site data.. the posts table is well over 4GB now.

#
On September 13, 2004 11:30 AM Stewart Vardaman added:

Over time MySQL's binary logs can add up to a lot of space. I periodically run RESET MASTER to clear them out.

#
On September 16, 2004 01:29 AM Larry added:

I use PostgreSQL - no need to worry about table-resizing silliness.

#
Trackbacks