Using MyISAM - Have InnoDB reads, writes etc.


I have a database server full of MyISAM tables but I did not set the skip-innodb option. Accordingly the InnoDB storage engine system variables are set to their defaults.

Looking at the system status variables, I see that:
Innodb_buffer_pool_pages_data = 19
Innodb_buffer_pool_read_requests = 77
Innodb_buffer_pool_reads = 12
Innodb_data_read = 2494K
Innodb_data_Reads = 25
Innodb_data_writes = 3
Innodb_data_written = 1536
Innodb_log_writes = 1
Innodb_pages_read = 19

How can this be? Does MySQL use InnoDB for some internal stuff? Could the fact that InnoDB is not skipped be affecting server’s performance?

Also, I’ve restarted the database server a few times while making configuration changes. Do the status variables reset to zero after restart of server?



There is no internal usage of InnoDB, and the status counters reset to zero. I suspect you have some job doing work that you don’t know about. Debian? There’s a startup script that checks every table.

Ok. Thanks. I think the hits on the counters are due to start up reads on default datafiles for Innodb when I restart server.

Thanks again for your reply.