MYSQL DB size

[chill]

hi guys.
on many fwp is written 3mb mysql or something else.
how can i calcutlate how big my db is ?
is there a formular or something else.
like bit ingt 3k
varchar 2k

thx
chill

[Epgs]

don't know but i think 3 megs is huge.

[ashben]

If you have shell access then this would work ..

myhost:~ # cd /usr/local/mysql/data/
myhost:/usr/local/mysql/data # du -k -s
92873.

There's the answer - 92Mb


More: http://www.mysql.com/doc/T/a/Table_size.html

[chill]

no....sorry
i dont have a shell.
and your link just shows how big a mysql table can be...

but i f i have 6 cells.
and around about 1000 rows....

is this just 3mb or something like this.
or is this about 12 mb......!?!?


thx
chill

[ashben]

Post your table structure .. 6 cells and 1000 rows doesn't make sense .. what data type and length they are actually defines the size.

[lucifer]

yeah

look at the mysql docs and they tell you how many bytes each cell will take up

ie int(1) [0-255] = 1 byte


work out your bytes used for each col. worst case senario so var-fields are at there max

text and glob fields can be huge so maybe limit them to a size in your scripts

multiply by num of rows

add some overhead for the structure 100k should be easily enough unless you have loads of tables

[chill]

thank you so far..... :D

this is my table at the moment...

CREATE TABLE files (
id int(10) unsigned NOT NULL auto_increment,
name varchar(100) NOT NULL,
file varchar(160) NOT NULL,
doin varchar(70) NOT NULL,
owner varchar(60) NOT NULL,
downloaded bigint(10) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
);

..what you think about...?
i've at the moment around 1000 entries....



thank you so far
chill

[Woofcat]

That would be under 500k worst case... Probably much less...

[lucifer]

int(10) =10
varchar(100) =101
varchar(160) =161
varchar(70) =71
varchar(60) =61
bigint(10) =10

total=314

x1000 = 300k + bit more for luck


also depends how fragmented the data gets - not a problem if your not deleting changing things much - not sure if MySQL compacts itself ;)

[chill]

thank you guys....

you've helped me alot



THXTHXTHX
chill

[Woofcat]

Lucifer - Actually int(10)=4 and bigint(10)=8...

[lucifer]

duh...