yonkovim - Project Hosting on Google Code

User Profile		Updates

Older Aug 17, 2009 maatkit issue 563 (Lock tables is not distilled) reported - Lock table tablename lock tables is not distilled.... Baron knows this Lock table tablename lock tables is not distilled.... Baron knows this Jul 28, 2009 maatkit issue 539 (mk-fkerror-logger) reported - Just like deadlocks foreign key errors can be tricky to capture when they occur. A client would like to have use add mk-fkerror-logger that basically works the same way that mk-deadlock-logger works in capturing the FK errors at some interval and pushing the data to a logfile or table. Just like deadlocks foreign key errors can be tricky to capture when they occur. A client would like to have use add mk-fkerror-logger that basically works the same way that mk-deadlock-logger works in capturing the FK errors at some interval and pushing the data to a logfile or table. Jul 01, 2009 maatkit issue 474 (Can not filter on host) reported - If this is a problem report, what steps will reproduce the problem? 1. ./mk-query-digest slow1.out --filter '$event->{host} =~ m/test.com/' What is the expected output? What do you see instead? Gives me an error the output because $event is missing host. I Should be able to filter on host ( only show me queries coming from this host ) -bash-3.2$ ./mk-query-digest slow1.out --filter 'die Dumper $event; exit 0' # mk_query_digest:5743 6681 $VAR1 = { # InnoDB_IO_r_bytes => '0', # InnoDB_IO_r_ops => '0', # InnoDB_IO_r_wait => '0.000000', # InnoDB_pages_distinct => '93', # InnoDB_queue_wait => '0.000000', # InnoDB_rec_lock_wait => '0.000000', # arg => '/* Time: 090627 11:02:12.044 Session: 405d434fd5367e320c7a2a9347ca24d8 Source: GroupDirectoryListing::getCategoryIds / SELECT category_id FROM tbl_groupdir_group_category WHERE party_group_id=12989242 AND active=1 ORDER BY id', # bytes => 226, # cmd => 'Query', # fingerprint => 'select category_id from tbl_groupdir_group_category where party_group_id=? and active=? order by id', # pos_in_log => 0 # }; If this is a problem report, what steps will reproduce the problem? 1. ./mk-query-digest slow1.out --filter '$event->{host} =~ m/test.com/' What is the expected output? What do you see instead? Gives me an error the output because $event is missing host. I Should be able to filter on host ( only show me queries coming from this host ) -bash-3.2$ ./mk-query-digest slow1.out --filter 'die Dumper $event; exit 0' # mk_query_digest:5743 6681 $VAR1 = { # InnoDB_IO_r_bytes => '0', # InnoDB_IO_r_ops => '0', # InnoDB_IO_r_wait => '0.000000', # InnoDB_pages_distinct => '93', # InnoDB_queue_wait => '0.000000', # InnoDB_rec_lock_wait => '0.000000', # arg => '/ Time: 090627 11:02:12.044 Session: 405d434fd5367e320c7a2a9347ca24d8 Source: GroupDirectoryListing::getCategoryIds */ SELECT category_id FROM tbl_groupdir_group_category WHERE party_group_id=12989242 AND active=1 ORDER BY id', # bytes => 226, # cmd => 'Query', # fingerprint => 'select category_id from tbl_groupdir_group_category where party_group_id=? and active=? order by id', # pos_in_log => 0 # }; Jun 23, 2009 maatkit issue 465 (Add Sysstat details & other details in mk_audit) reported - Wish list here: I personally would find the addition of the following system level stats helpful: - iostat -x - vmstat - sat -n DEV - free (swap info) This would give you IO, CPU, network and swap information. These are also some of the key pieces of info I look at. Also I would love to have mk_audit include more stats during a configured period of time. For instance: --snapshot 100 would mean collect data for 100 seconds. Additionally over that same time period maybe collect mysqladmin extended -r -i stats,specifically: show command , inserts, updates, deletes, selects per second tmp tables created, create to disk per second opened/open tables threads created Would be great to also get a dump of the master details ( maybe I missed this ) Wish list here: I personally would find the addition of the following system level stats helpful: - iostat -x - vmstat - sat -n DEV - free (swap info) This would give you IO, CPU, network and swap information. These are also some of the key pieces of info I look at. Also I would love to have mk_audit include more stats during a configured period of time. For instance: --snapshot 100 would mean collect data for 100 seconds. Additionally over that same time period maybe collect mysqladmin extended -r -i stats,specifically: show command , inserts, updates, deletes, selects per second tmp tables created, create to disk per second opened/open tables threads created Would be great to also get a dump of the master details ( maybe I missed this )

issue 474 (Can not filter on host) reported - If this is a problem report, what steps will reproduce the problem? 1. ./mk-query-digest slow1.out --filter '$event->{host} =~ m/test.com/' What is the expected output? What do you see instead? Gives me an error the output because $event is missing host. I Should be able to filter on host ( only show me queries coming from this host ) -bash-3.2$ ./mk-query-digest slow1.out --filter 'die Dumper $event; exit 0' # mk_query_digest:5743 6681 $VAR1 = { # InnoDB_IO_r_bytes => '0', # InnoDB_IO_r_ops => '0', # InnoDB_IO_r_wait => '0.000000', # InnoDB_pages_distinct => '93', # InnoDB_queue_wait => '0.000000', # InnoDB_rec_lock_wait => '0.000000', # arg => '/* Time: 090627 11:02:12.044 Session: 405d434fd5367e320c7a2a9347ca24d8 Source: GroupDirectoryListing::getCategoryIds */ SELECT category_id FROM tbl_groupdir_group_category WHERE party_group_id=12989242 AND active=1 ORDER BY id', # bytes => 226, # cmd => 'Query', # fingerprint => 'select category_id from tbl_groupdir_group_category where party_group_id=? and active=? order by id', # pos_in_log => 0 # };

If this is a problem report, what steps will reproduce the problem? 1. ./mk-query-digest slow1.out --filter '$event->{host} =~ m/test.com/' What is the expected output? What do you see instead? Gives me an error the output because $event is missing host. I Should be able to filter on host ( only show me queries coming from this host ) -bash-3.2$ ./mk-query-digest slow1.out --filter 'die Dumper $event; exit 0' # mk_query_digest:5743 6681 $VAR1 = { # InnoDB_IO_r_bytes => '0', # InnoDB_IO_r_ops => '0', # InnoDB_IO_r_wait => '0.000000', # InnoDB_pages_distinct => '93', # InnoDB_queue_wait => '0.000000', # InnoDB_rec_lock_wait => '0.000000', # arg => '/* Time: 090627 11:02:12.044 Session: 405d434fd5367e320c7a2a9347ca24d8 Source: GroupDirectoryListing::getCategoryIds */ SELECT category_id FROM tbl_groupdir_group_category WHERE party_group_id=12989242 AND active=1 ORDER BY id', # bytes => 226, # cmd => 'Query', # fingerprint => 'select category_id from tbl_groupdir_group_category where party_group_id=? and active=? order by id', # pos_in_log => 0 # };

Older