mysql> select count(*) from t_prod; +-----------+ | count(*) | +-----------+ | 952174654 | +-----------+ 1 row in set (0.00 sec) # ls -lh /var/lib/mysql/prod | grep t_prod -rw-rw---- 1 mysql mysql 11K Jun 4 2007 t_prod.frm -rw-rw---- 1 mysql mysql 222G Apr 18 07:35 t_prod.MYD -rw-rw---- 1 mysql mysql 102G Apr 18 07:35 t_prod.MYI