Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Using MyISAM - Have InnoDB reads, writes etc.

smacreamsmacream EntrantInactive User Role Beginner
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

Comments

  • xaprbxaprb Mentor Inactive User Role Beginner
    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.
  • smacreamsmacream Entrant Inactive User Role Beginner
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.