Re: Almost whole table in single index: is there a better way?

[Andy Deakin]

SHOW TABLE STATUS LIKE 'RemoteStatuses'

Name 	Engine 	Version 	Row_format 	Rows 	Avg_row_length 	Data_length 	Max_data_length 	Index_length 	Data_free 	Auto_increment 	Create_time 	Update_time 	Check_time 	Collation 	Checksum 	Create_options 	Comment
RemoteStatuses 	MyISAM 	10 	Fixed 	275899846 	19 	5242097074 	0 	4592669696 	0 	NULL 	2012-03-18 00:13:59 	2012-08-27 20:19:04 	2012-08-24 23:20:12 	latin1_swedish_ci 	NULL 	partitioned

The test and production database is on same server, so my.cnf covers both.

I have been doing all sorts of testing on the server on other tables, and so the SHOW GLOBAL STATUS stats are probably not representative of this particular table.