# Using MyISAM - Have InnoDB reads, writes etc.

**URL:** <https://forums.percona.com/t/using-myisam-have-innodb-reads-writes-etc/1360>\
**Category:** Other MySQL® Questions\
**Created:** [March 3, 2010, 11:11am UTC](https://forums.percona.com/t/using-myisam-have-innodb-reads-writes-etc/1360 "2010-03-03T11:11:53Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![smacream](https://avatars.discourse-cdn.com/v4/letter/s/a6a055/32.png) [@smacream](https://forums.percona.com/u/smacream)\
**Post date:** [March 3, 2010, 11:11am UTC](https://forums.percona.com/t/using-myisam-have-innodb-reads-writes-etc/1360/1 "2010-03-03T11:11:53Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\
**Post date:** [March 13, 2010, 4:29pm UTC](https://forums.percona.com/t/using-myisam-have-innodb-reads-writes-etc/1360/2 "2010-03-13T16:29:51Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![smacream](https://avatars.discourse-cdn.com/v4/letter/s/a6a055/32.png) [@smacream](https://forums.percona.com/u/smacream)\
**Post date:** [March 15, 2010, 5:34am UTC](https://forums.percona.com/t/using-myisam-have-innodb-reads-writes-etc/1360/3 "2010-03-15T05:34:19Z")

</div>

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.