I use MySQL. My database's name is "db", and I have a table called "Test".
I want recover the last update, so I used this query:
SELECT update_time FROM information_schema.tables WHERE table_schema='db' AND table_name='Test';
But the result is NULL, so I converted my Table from InnoDB to MYISAM by using this query:
mysql> ALTER TABLE db.Test ENGINE=MYISAM;
and it worked.
But the problem is that when I want to convert the table PROCESSLIST from InnoDB to MYISAM I get this message:
mysql> use information_schema Database changed mysql> ALTER TABLE PROCESSLIST ENGINE=MYISAM; ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'information_schema'
So, is there another solution to know what is the last update for this table (PROCESSLIST)?