Forum Moderators: phranque

Message Too Old, No Replies

Whats eating mySql Space?

Help!

         

Dpeper

3:49 am on Jun 14, 2002 (gmt 0)

10+ Year Member



Ok i have a site where people can sign up for something and it probaly stores about 18 Text values on them. We have about 40 regestrations a day, but its eating like 3 megs a day does this sound right or do i have problems?

Its eating me alive!!!! Litteraly.

-Donny

Lisa

6:34 am on Jun 14, 2002 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



uh... Could it be your apache log files instead?

EliteWeb

7:05 am on Jun 14, 2002 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



You sure its the database file ? Like Lisa said log files can take up space. My log files take up 600 megs a month alone ;)

The Contractor

10:04 am on Jun 14, 2002 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Dpeper,

Can you check what size your DB is?

I doubt very much it is the Database itself. Check and see. I have 12 fields ranging in size from 4-255 characters and 548 entries. The MySQL database is 579,236 bytes in size with the index taking up another 97,280 bytes. What are your Field sizes in characters? What is your Row Size in bytes?

Dpeper

11:11 am on Jun 14, 2002 (gmt 0)

10+ Year Member



Thanks guys it was my web stats eating it up this is the first month ive had traffic :) i got a number 1 ranking in MSN i had 67,000 Traffic Logs about 9,000 a day that i wasnt use to seeing being added to the amount being taken up.

"Its a good thing theres smart people to answer dumb peoples questions"

-Donny