硬盘上的MySQL表大小 [英] Mysql table size on the HDD
问题描述
我大约有80个csv文件,每个文件包含400万行,我想对磁盘大小进行计算.我该怎么做?我有一个主意,可以上传一个文件并检查表的大小,但是我不知道在硬盘上的哪里可以找到该表.我正在使用Win7 64bit进行测试
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? 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
推荐答案
找到mySQL的数据目录.
Locate mySQL's data directory.
默认情况下,它应该是将mySQL安装到的任何子目录,并命名为/data
.
By default, it should be a subdirectory of wherever you installed mySQL to and named /data
.
如果使用myISAM表(它们是默认表),则可以对{tablename}.FRM
进行全局搜索.
If you use myISAM tables (they're the default), you can do a global search for {tablename}.FRM
.
这篇关于硬盘上的MySQL表大小的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!