1
|
$VAR1 = {attribute_types => {Filesort_on_disk => 'bool',Tmp_table_on_disk => 'bool',Error_no => 'string',Filesort => 'bool',Full_join => 'bool',Full_scan => 'bool',Lock_time => 'num',Merge_passes => 'num',QC_Hit => 'bool',Query_time => 'num',Rows_examined => 'num',Rows_sent => 'num',Statement_id => 'string',Status_code => 'string',Tmp_table => 'bool',bytes => 'num',db => 'string',host => 'string',key_print => 'string',pos_in_log => 'num',ts => 'string',user => 'string',val => 'string'},groupby => 'fingerprint',results => {classes => {'select col from bar_tbl' => {Filesort_on_disk => {cnt => 3,max => 0,min => 0,sum => 0,unq => {'0' => 3}},Tmp_table_on_disk => {cnt => 3,max => 0,min => 0,sum => 0,unq => {'0' => 3}},Filesort => {cnt => 3,max => 0,min => 0,sum => 0,unq => {'0' => 3}},Full_join => {cnt => 3,max => 0,min => 0,sum => 0,unq => {'0' => 3}},Full_scan => {cnt => 3,max => 0,min => 0,sum => 0,unq => {'0' => 3}},Lock_time => {all => {'0' => 3},cnt => 3,last => '0.000000',max => '0.000000',min => '0.000000',sum => '0'},Merge_passes => {all => {'0' => 3},cnt => 3,last => 0,max => 0,min => 0,sum => 0},QC_Hit => {cnt => 3,max => 0,min => 0,sum => 0,unq => {'0' => 3}},Query_time => {all => {'51' => 3},cnt => 3,last => '0.000012',max => '0.000012',min => '0.000012',sum => '3.6e-05'},Rows_examined => {all => {'0' => 3},cnt => 3,last => 0,max => 0,min => 0,sum => 0},Rows_sent => {all => {'0' => 3},cnt => 3,last => 0,max => 0,min => 0,sum => 0},Tmp_table => {cnt => 3,max => 0,min => 0,sum => 0,unq => {'0' => 3}},bytes => {all => {'348' => 3},cnt => 3,last => 23,max => 23,min => 23,sum => 69},db => {cnt => 3,max => 'bar',min => 'bar',unq => {bar => 3}},host => {cnt => 3,max => '',min => '',unq => {'' => 3}},pos_in_log => {all => {'419' => 1,'427' => 1,'433' => 1},cnt => 3,last => 1445,max => 1445,min => 725,sum => 3253},ts => {cnt => 3,max => '071218 11:49:07',min => '071218 11:48:57',unq => {'071218 11:48:57' => 1,'071218 11:49:05' => 1,'071218 11:49:07' => 1}},user => {cnt => 3,max => '[SQL_SLAVE]',min => '[SQL_SLAVE]',unq => {'[SQL_SLAVE]' => 3}}},'select col from foo_tbl' => {Filesort_on_disk => {cnt => 3,max => 0,min => 0,sum => 0,unq => {'0' => 3}},Tmp_table_on_disk => {cnt => 3,max => 0,min => 0,sum => 0,unq => {'0' => 3}},Filesort => {cnt => 3,max => 0,min => 0,sum => 0,unq => {'0' => 3}},Full_join => {cnt => 3,max => 0,min => 0,sum => 0,unq => {'0' => 3}},Full_scan => {cnt => 3,max => 0,min => 0,sum => 0,unq => {'0' => 3}},Lock_time => {all => {'0' => 3},cnt => 3,last => '0.000000',max => '0.000000',min => '0.000000',sum => '0'},Merge_passes => {all => {'0' => 3},cnt => 3,last => 0,max => 0,min => 0,sum => 0},QC_Hit => {cnt => 3,max => 0,min => 0,sum => 0,unq => {'0' => 3}},Query_time => {all => {'51' => 3},cnt => 3,last => '0.000012',max => '0.000012',min => '0.000012',sum => '3.6e-05'},Rows_examined => {all => {'0' => 3},cnt => 3,last => 0,max => 0,min => 0,sum => 0},Rows_sent => {all => {'0' => 3},cnt => 3,last => 0,max => 0,min => 0,sum => 0},Tmp_table => {cnt => 3,max => 0,min => 0,sum => 0,unq => {'0' => 3}},bytes => {all => {'348' => 3},cnt => 3,last => 23,max => 23,min => 23,sum => 69},db => {cnt => 3,max => 'foo',min => 'foo',unq => {foo => 3}},host => {cnt => 3,max => '',min => '',unq => {'' => 3}},pos_in_log => {all => {'0' => 1,'404' => 1,'437' => 1},cnt => 3,last => 1803,max => 1803,min => 0,sum => 2166},ts => {cnt => 3,max => '071218 11:49:30',min => '071218 11:48:27',unq => {'071218 11:48:27' => 1,'071218 11:48:57' => 1,'071218 11:49:30' => 1}},user => {cnt => 3,max => '[SQL_SLAVE]',min => '[SQL_SLAVE]',unq => {'[SQL_SLAVE]' => 3}}}},globals => {Filesort_on_disk => {cnt => 6,max => 0,min => 0,sum => 0},Tmp_table_on_disk => {cnt => 6,max => 0,min => 0,sum => 0},Filesort => {cnt => 6,max => 0,min => 0,sum => 0},Full_join => {cnt => 6,max => 0,min => 0,sum => 0},Full_scan => {cnt => 6,max => 0,min => 0,sum => 0},Lock_time => {all => {'0' => 6},cnt => 6,max => '0.000000',min => '0.000000',sum => '0'},Merge_passes => {all => {'0' => 6},cnt => 6,max => 0,min => 0,sum => 0},QC_Hit => {cnt => 6,max => 0,min => 0,sum => 0},Query_time => {all => {'51' => 6},cnt => 6,max => '0.000012',min => '0.000012',sum => '7.2e-05'},Rows_examined => {all => {'0' => 6},cnt => 6,max => 0,min => 0,sum => 0},Rows_sent => {all => {'0' => 6},cnt => 6,max => 0,min => 0,sum => 0},Tmp_table => {cnt => 6,max => 0,min => 0,sum => 0},bytes => {all => {'348' => 6},cnt => 6,max => 23,min => 23,sum => 138},db => {cnt => 6,max => 'foo',min => 'bar'},host => {cnt => 6,max => '',min => ''},pos_in_log => {all => {'0' => 1,'404' => 1,'419' => 1,'427' => 1,'433' => 1,'437' => 1},cnt => 6,max => 1803,min => 0,sum => 5419},ts => {cnt => 6,max => '071218 11:49:30',min => '071218 11:48:27'},user => {cnt => 6,max => '[SQL_SLAVE]',min => '[SQL_SLAVE]'}},samples => {'select col from bar_tbl' => {Filesort_on_disk => 'No',Tmp_table_on_disk => 'No',Filesort => 'No',Full_join => 'No',Full_scan => 'No',Lock_time => '0.000000',Merge_passes => '0',QC_Hit => 'No',Query_time => '0.000012',Rows_examined => '0',Rows_sent => '0',Thread_id => '20',Tmp_table => 'No',arg => 'SELECT col FROM bar_tbl',bytes => 23,cmd => 'Query',db => 'bar',fingerprint => 'select col from bar_tbl',host => '',ip => '',pos_in_log => 1445,ts => '071218 11:49:07',user => '[SQL_SLAVE]'},'select col from foo_tbl' => {Filesort_on_disk => 'No',Tmp_table_on_disk => 'No',Filesort => 'No',Full_join => 'No',Full_scan => 'No',Lock_time => '0.000000',Merge_passes => '0',QC_Hit => 'No',Query_time => '0.000012',Rows_examined => '0',Rows_sent => '0',Thread_id => '30',Tmp_table => 'No',arg => 'SELECT col FROM foo_tbl',bytes => 23,cmd => 'Query',db => 'foo',fingerprint => 'select col from foo_tbl',host => '',ip => '',pos_in_log => 1803,ts => '071218 11:49:30',user => '[SQL_SLAVE]'}}},worst => 'Query_time'};
|