开发者

Mysql table size on the HDD

开发者 https://www.devze.com 2023-03-02 18:51 出处:网络
I have a around 80 csv files, each contains 4million rows, I want to make calculation regarding the disk size. How can I make this? 开发者_C百科I have an Idea, to upload one file and check the table s

I have a around 80 csv files, each contains 4million rows, I want to make calculation regarding the disk size. How can I make this? 开发者_C百科I have an Idea, to upload one file and check the table size, but I don't know where can I find the table on the HDD. I'm using win7 64bit just for testing


Locate mySQL's data directory.

By default, it should be a subdirectory of wherever you installed mySQL to and named /data.

If you use myISAM tables (they're the default), you can do a global search for {tablename}.FRM.


Get HeidiSQL, it can show table size in database list view....

0

精彩评论

暂无评论...
验证码 换一张
取 消