Re: Simple queries hang on "statistics"

[Jay Paroline]

Sorry for the delayed reply, for some reason I wasn't notified of a response!



mysql> SHOW TABLE STATUS LIKE 'Sessions'\G
*************************** 1. row ***************************
Name: Sessions
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 3013426
Avg_row_length: 563
Data_length: 1696612352
Max_data_length: 0
Index_length: 374652928
Data_free: 0
Auto_increment: 57363994
Create_time: 2008-10-30 02:25:42
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: InnoDB free: 547840 kB
1 row in set (0.05 sec)




mysql> SHOW CREATE TABLE Sessions;
+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Sessions | CREATE TABLE `Sessions` (
`SessionID` int(11) NOT NULL auto_increment,
`SessionString` char(32) NOT NULL,
`SessionData` text,
`SessionTime` int(11) NOT NULL,
`TSAdded` datetime NOT NULL,
PRIMARY KEY (`SessionID`),
UNIQUE KEY `SessionString` (`SessionString`),
KEY `SessionTime` (`SessionTime`)
) ENGINE=InnoDB AUTO_INCREMENT=57363893 DEFAULT CHARSET=utf8 |
+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)