GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Using MyISAM - Have InnoDB reads, writes etc.

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Using MyISAM - Have InnoDB reads, writes etc.

    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.

    Comment


    • #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.

      Comment

      Working...
      X