Using MyISAM - Have InnoDB reads, writes etc.

MySQL & MariaDB Other MySQL® Questions
1

Hi,

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?

Thanks,

Seosamh

2

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.

3

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.