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?