MySQL Forums
Forum List  »  MyISAM

Re: Almost whole table in single index: is there a better way?
Posted by: Andy Deakin
Date: August 27, 2012 12:29PM


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.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.