select TABLE_NAME as tables,TABLE_TYPE,ENGINE,TABLE_ROWS,DATA_LENGTH,DATA_FREE,UPDATE_TIME,TABLE_COMMENT from information_schema.TABLES where TABLE_SCHEMA='yourdb' order by TABLE_NAME其中 data_length 就应该是占用的大小
When you create a MyISAM table, MySQL uses the product of the MAX_ROWS and AVG_ROW_LENGTH options to decide how big the resulting table is. If you don't specify either option, the maximum size for MyISAM data and index files is 256TB by default. (If your operating system does not support files that large, table sizes are constrained by the file size limit.) If you want to keep down the pointer sizes to make the index smaller and faster and you don't really need big files, you can decrease the default pointer size by setting the myisam_data_pointer_size system variable. (See Section 5.1.4, “Server System Variables”.) If you want all your tables to be able to grow above the default limit and are willing to have your tables slightly slower and larger than necessary, you can increase the default pointer size by setting this variable. Setting the value to 7 allows table sizes up to 65,536TB.
如果是 FAT32则是 2G 或 4G, NTFS则没有限制。 如果是 innodb 则理论上没有限制。
先确定是什么引擎SHOW CREATE TABLE tbl_name
show table status like 'tb_name';
用java能不能得到一张表的存储空间大小啊？