I have seen a similar option in PHPMyAdmin which says 'Enable Statistics' I suppose when the status shows statistics, mysql is just updating the statistics in there for the query just run?
-----Original Message----- From: Ananth Reddy [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 11:13 PM To: [EMAIL PROTECTED] Subject: show processlist state value 'statistics' Does anyone know what is the meaning of value 'statistics' in state column of show processlist? It is displaying this state during a SELECT query. I noticed lot of them in DB while our application is being run in a stress mode. This is not documented in Mysql documentation for show processlist TIA ananth -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]