mysql> show table status like 'sort'; +------+--------+---------+------------+------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------- | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time +------+--------+---------+------------+------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------- | sort | MyISAM | 10 | Fixed | 611 | 260 | 158860 | 73183493944770559 | 8192 | 0 | 24390 | 2006-10-21 19:27:3 +------+--------+---------+------------+------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------- 1 row in set (0.02 sec) mysql> show table status like 'sort'; +------+--------+---------+------------+------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------- | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time +------+--------+---------+------------+------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------- | sort | MyISAM | 10 | Fixed | 611 | 260 | 158860 | 73183493944770559 | 8192 | 0 | 24398 | 2006-10-21 19:27:3 +------+--------+---------+------------+------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------- 1 row in set (0.00 sec) mysql> show table status like 'sort'; +------+--------+---------+------------+------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------- | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time +------+--------+---------+------------+------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------- | sort | MyISAM | 10 | Fixed | 611 | 260 | 158860 | 73183493944770559 | 8192 | 0 | 24405 | 2006-10-21 19:27:3 +------+--------+---------+------------+------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------- 1 row in set (0.00 sec) mysql> show table status like 'sort'; +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ | sort | MyISAM | 10 | Fixed | 24410 | 260 | 6346600 | 73183493944770559 | 252928 | 0 | 24411 | 2006-10-21 19:27: +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ 1 row in set (0.00 sec) mysql> show table status like 'sort'; +------+--------+---------+------------+------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------- | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time +------+--------+---------+------------+------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------- | sort | MyISAM | 10 | Fixed | 611 | 260 | 158860 | 73183493944770559 | 8192 | 0 | 24418 | 2006-10-21 19:27:3 +------+--------+---------+------------+------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------- 1 row in set (0.00 sec) mysql> show table status like 'sort'; +------+--------+---------+------------+------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------- | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time +------+--------+---------+------------+------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------- | sort | MyISAM | 10 | Fixed | 611 | 260 | 158860 | 73183493944770559 | 8192 | 0 | 24429 | 2006-10-21 19:27:3 +------+--------+---------+------------+------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------- 1 row in set (0.02 sec) mysql> select count(*) from sort; +----------+ | count(*) | +----------+ | 24504 | +----------+ 1 row in set (0.00 sec) mysql> show table status like 'sort'; +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ | sort | MyISAM | 10 | Fixed | 24504 | 260 | 6371040 | 73183493944770559 | 253952 | 0 | 24542 | 2006-10-21 19:27: +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ 1 row in set (0.00 sec) mysql> show table status like 'sort'; +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ | sort | MyISAM | 10 | Fixed | 24504 | 260 | 6371040 | 73183493944770559 | 253952 | 0 | 24554 | 2006-10-21 19:27: +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ 1 row in set (0.00 sec) mysql> show table status like 'sort'; +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ | sort | MyISAM | 10 | Fixed | 24504 | 260 | 6371040 | 73183493944770559 | 253952 | 0 | 24613 | 2006-10-21 19:27: +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ 1 row in set (0.00 sec) mysql> show global status like '%key%'; +------------------------+--------+ | Variable_name | Value | +------------------------+--------+ | Com_preload_keys | 0 | | Com_show_keys | 0 | | Handler_read_key | 0 | | Key_blocks_not_flushed | 0 | | Key_blocks_unused | 6999 | | Key_blocks_used | 249 | | Key_read_requests | 201263 | | Key_reads | 249 | | Key_write_requests | 25234 | | Key_writes | 25234 | +------------------------+--------+ 10 rows in set (0.01 sec) mysql> show table status like 'sort'; +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ | sort | MyISAM | 10 | Fixed | 24504 | 260 | 6371040 | 73183493944770559 | 253952 | 0 | 24946 | 2006-10-21 19:27: +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ 1 row in set (0.00 sec) mysql> show table status like 'sort'; +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ | sort | MyISAM | 10 | Fixed | 24504 | 260 | 6371040 | 73183493944770559 | 253952 | 0 | 24962 | 2006-10-21 19:27: +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ 1 row in set (0.00 sec) mysql> show table status like 'sort'; +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ | sort | MyISAM | 10 | Fixed | 24504 | 260 | 6371040 | 73183493944770559 | 253952 | 0 | 24983 | 2006-10-21 19:27: +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ 1 row in set (0.00 sec) mysql> show table status like 'sort'; +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ | sort | MyISAM | 10 | Fixed | 24504 | 260 | 6371040 | 73183493944770559 | 253952 | 0 | 24992 | 2006-10-21 19:27: +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ 1 row in set (0.00 sec) mysql> select count(*) from sort; +----------+ | count(*) | +----------+ | 25012 | +----------+ 1 row in set (0.00 sec) mysql> show table status like 'sort'; +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ | sort | MyISAM | 10 | Fixed | 25012 | 260 | 6503120 | 73183493944770559 | 259072 | 0 | 25036 | 2006-10-21 19:27: +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ 1 row in set (0.00 sec) mysql> show table status like 'sort'; +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ | sort | MyISAM | 10 | Fixed | 25012 | 260 | 6503120 | 73183493944770559 | 259072 | 0 | 25057 | 2006-10-21 19:27: +------+--------+---------+------------+-------+----------------+-------------+-------------------+--------------+-----------+----------------+------------------ 1 row in set (0.00 sec) mysql>