I'm optimizing the configuration of a MySQL server, running only Bromine. This is non specific to application, and was just noted for completeness. I am trying to determine if switching from MyISAM to InnoDB is a better option, on few write dominant tables. these tables take most of the writes for the server, but also the highest percentage of all queries. I don't want to make all the tables InnoDB, even though it would save me this time. I prefer MyISAM over all; InnoDB has its own strengths, which make sense for these write heavy specific tables.
I know how to look at the read/write statistics for the MySQL instance, and run all the recommended analyses scripts. I plainly would like to know, how do I look at the read/write stats on a specific table?
If someone, with relevant experience, has any recommended stats to look at. I would appreciate the input.
UPDATE: I posted about this issue on the Bromine forumns, And they let me know which tables are write heavy. This does not really answer the question, as I would like to know anyway.
Just for the sake of completeness, Here is my Table / Engine
Name Engine QRTZ_BLOB_TRIGGERS MyISAM QRTZ_CALENDARS MyISAM QRTZ_CRON_TRIGGERS MyISAM QRTZ_FIRED_TRIGGERS MyISAM QRTZ_JOB_DETAILS MyISAM QRTZ_JOB_LISTENERS MyISAM QRTZ_LOCKS MyISAM QRTZ_PAUSED_TRIGGER_GRPS MyISAM QRTZ_SCHEDULER_STATE MyISAM QRTZ_SIMPLE_TRIGGERS MyISAM QRTZ_TRIGGERS MyISAM QRTZ_TRIGGER_LISTENERS MyISAM activities InnoDB browsers MyISAM browsers_nodes MyISAM combinations MyISAM combinations_requirements MyISAM commands InnoDB configs MyISAM echelons InnoDB groups MyISAM jobs InnoDB myacos MyISAM myaros MyISAM myaros_myacos MyISAM nodes MyISAM operatingsystems MyISAM plugins MyISAM projects MyISAM projects_reports MyISAM projects_users MyISAM reports MyISAM requirements MyISAM requirements_testcases MyISAM seleniumservers InnoDB sites MyISAM suites InnoDB testcases MyISAM testcasesteps MyISAM tests InnoDB types MyISAM users MyISAM