Writing by corra on Tuesday, 6 of November , 2007 at 6:48 pm
Here is a simple configuration file (XML) for MySQL Administrator client.
In addition to the the default graphs I added some new pages containing the most important status variables to monitoring and evaluate the performance of InnoDB.
The new pages are:
idb storage: reads, writes, doublewrites and fsync activity
idb logs:writes to innodb logs and file system activity
idb buffer pool: buffer pool activity
idb disk: pages and rows activity
Just download the file mysqladmin_health.xml.gz then
gunzip it and copy it in the following (default) directory:
(Windows) C:Documents and SettingsUserNameApplication DataMySQL
I hope this could be useful.
Comments (3) Category: MySQLen
Comment by sandeep
Made Wednesday, 7 of November , 2007 at 2:14 am
I just added it to administrator it looks good. i still need to figure out what each one of these graphs are doing.
Made Wednesday, 7 of November , 2007 at 11:58 am
[...] my last post MySQL Administrator useful InnoDB graphs here are the explanations about the meaning of some of the [...]
Made Friday, 9 of November , 2007 at 8:06 pm
[...] While we’re on tools, Il Corra posted a configuration for creating useful InnoDB graphs in MySQL Administrator. [...]