Convert the table PROCESSLIST from InnoDB to MYISAM 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&gt; 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&gt; use information_schema
Database changed
mysql&gt; 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)?
There is no way, because they are virtual tables. This is also the reason why you can't do anything with them, except for SELECT.