File: slow002-limit-3.txt

package info (click to toggle)
percona-toolkit 3.2.1-1
  • links: PTS, VCS
  • area: main
  • in suites: bookworm, bullseye, sid, trixie
  • size: 68,916 kB
  • sloc: perl: 241,287; sql: 22,868; sh: 19,746; javascript: 6,799; makefile: 353; awk: 38; python: 30; sed: 1
file content (6 lines) | stat: -rw-r--r-- 10,938 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
$VAR1 = {attribute_types => {Filesort_on_disk => 'bool',Tmp_table_on_disk => 'bool',Error_no => 'string',Filesort => 'bool',Full_join => 'bool',Full_scan => 'bool',InnoDB_IO_r_bytes => 'num',InnoDB_IO_r_ops => 'num',InnoDB_IO_r_wait => 'num',InnoDB_pages_distinct => 'num',InnoDB_queue_wait => 'num',InnoDB_rec_lock_wait => 'num',Killed => 'bool',Last_errno => 'string',Lock_time => 'num',Merge_passes => 'num',QC_Hit => 'bool',Query_time => 'num',Rows_examined => 'num',Rows_sent => 'num',Statement_id => 'string',Status_code => 'string',Thread_id => '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 => {'update d?tuningdetail_?_? n inner join d?gonzo a using(gonzo) set n.column? = a.column?, n.word? = a.word?' => {Filesort_on_disk => {cnt => 1,max => 0,min => 0,sum => 0,unq => {'0' => 1}},Tmp_table_on_disk => {cnt => 1,max => 0,min => 0,sum => 0,unq => {'0' => 1}},Filesort => {cnt => 1,max => 0,min => 0,sum => 0,unq => {'0' => 1}},Full_join => {cnt => 1,max => 0,min => 0,sum => 0,unq => {'0' => 1}},Full_scan => {cnt => 1,max => 1,min => 1,sum => 1,unq => {'1' => 1}},Lock_time => {all => {'93' => 1},cnt => 1,last => '0.000091',max => '0.000091',min => '0.000091',sum => '9.1e-05'},Merge_passes => {all => {'0' => 1},cnt => 1,last => 0,max => 0,min => 0,sum => 0},QC_Hit => {cnt => 1,max => 0,min => 0,sum => 0,unq => {'0' => 1}},Query_time => {all => {'277' => 1},cnt => 1,last => '0.726052',max => '0.726052',min => '0.726052',sum => '0.726052'},Rows_examined => {all => {'510' => 1},cnt => 1,last => 62951,max => 62951,min => 62951,sum => 62951},Rows_sent => {all => {'0' => 1},cnt => 1,last => 0,max => 0,min => 0,sum => 0},Tmp_table => {cnt => 1,max => 0,min => 0,sum => 0,unq => {'0' => 1}},bytes => {all => {'383' => 1},cnt => 1,last => 129,max => 129,min => 129,sum => 129},db => {cnt => 1,max => 'db1',min => 'db1',unq => {db1 => 1}},host => {cnt => 1,max => '',min => '',unq => {'' => 1}},pos_in_log => {all => {'403' => 1},cnt => 1,last => 332,max => 332,min => 332,sum => 332},ts => {cnt => 1,max => '071218 11:48:27',min => '071218 11:48:27',unq => {'071218 11:48:27' => 1}},user => {cnt => 1,max => '[SQL_SLAVE]',min => '[SQL_SLAVE]',unq => {'[SQL_SLAVE]' => 1}}},'update d?va?oncept?upload set va?oncept?id = ? where va?oncept?upload=?' => {Filesort_on_disk => {cnt => 1,max => 0,min => 0,sum => 0,unq => {'0' => 1}},Tmp_table_on_disk => {cnt => 1,max => 0,min => 0,sum => 0,unq => {'0' => 1}},Filesort => {cnt => 1,max => 0,min => 0,sum => 0,unq => {'0' => 1}},Full_join => {cnt => 1,max => 0,min => 0,sum => 0,unq => {'0' => 1}},Full_scan => {cnt => 1,max => 0,min => 0,sum => 0,unq => {'0' => 1}},InnoDB_IO_r_bytes => {all => {'0' => 1},cnt => 1,last => 0,max => 0,min => 0,sum => 0},InnoDB_IO_r_ops => {all => {'0' => 1},cnt => 1,last => 0,max => 0,min => 0,sum => 0},InnoDB_IO_r_wait => {all => {'0' => 1},cnt => 1,last => '0.000000',max => '0.000000',min => '0.000000',sum => '0'},InnoDB_pages_distinct => {all => {'333' => 1},cnt => 1,last => 11,max => 11,min => 11,sum => 11},InnoDB_queue_wait => {all => {'0' => 1},cnt => 1,last => '0.000000',max => '0.000000',min => '0.000000',sum => '0'},InnoDB_rec_lock_wait => {all => {'0' => 1},cnt => 1,last => '0.000000',max => '0.000000',min => '0.000000',sum => '0'},Lock_time => {all => {'69' => 1},cnt => 1,last => '0.000028',max => '0.000028',min => '0.000028',sum => '2.8e-05'},Merge_passes => {all => {'0' => 1},cnt => 1,last => 0,max => 0,min => 0,sum => 0},QC_Hit => {cnt => 1,max => 0,min => 0,sum => 0,unq => {'0' => 1}},Query_time => {all => {'214' => 1},cnt => 1,last => '0.033384',max => '0.033384',min => '0.033384',sum => '0.033384'},Rows_examined => {all => {'0' => 1},cnt => 1,last => 0,max => 0,min => 0,sum => 0},Rows_sent => {all => {'0' => 1},cnt => 1,last => 0,max => 0,min => 0,sum => 0},Tmp_table => {cnt => 1,max => 0,min => 0,sum => 0,unq => {'0' => 1}},bytes => {all => {'379' => 1},cnt => 1,last => 103,max => 103,min => 103,sum => 103},db => {cnt => 1,max => 'db1',min => 'db1',unq => {db1 => 1}},host => {cnt => 1,max => '',min => '',unq => {'' => 1}},pos_in_log => {all => {'431' => 1},cnt => 1,last => 1316,max => 1316,min => 1316,sum => 1316},ts => {cnt => 1,max => '071218 11:48:27',min => '071218 11:48:27',unq => {'071218 11:48:27' => 1}},user => {cnt => 1,max => '[SQL_SLAVE]',min => '[SQL_SLAVE]',unq => {'[SQL_SLAVE]' => 1}}},'update foo.bar set biz = ?' => {Filesort_on_disk => {cnt => 2,max => 0,min => 0,sum => 0,unq => {'0' => 2}},Tmp_table_on_disk => {cnt => 2,max => 0,min => 0,sum => 0,unq => {'0' => 2}},Filesort => {cnt => 2,max => 0,min => 0,sum => 0,unq => {'0' => 2}},Full_join => {cnt => 2,max => 0,min => 0,sum => 0,unq => {'0' => 2}},Full_scan => {cnt => 2,max => 0,min => 0,sum => 0,unq => {'0' => 2}},InnoDB_IO_r_bytes => {all => {'0' => 2},cnt => 2,last => 0,max => 0,min => 0,sum => 0},InnoDB_IO_r_ops => {all => {'0' => 2},cnt => 2,last => 0,max => 0,min => 0,sum => 0},InnoDB_IO_r_wait => {all => {'0' => 2},cnt => 2,last => '0.000000',max => '0.000000',min => '0.000000',sum => '0'},InnoDB_pages_distinct => {all => {'343' => 2},cnt => 2,last => 18,max => 18,min => 18,sum => 36},InnoDB_queue_wait => {all => {'0' => 2},cnt => 2,last => '0.000000',max => '0.000000',min => '0.000000',sum => '0'},InnoDB_rec_lock_wait => {all => {'0' => 2},cnt => 2,last => '0.000000',max => '0.000000',min => '0.000000',sum => '0'},Lock_time => {all => {'68' => 2},cnt => 2,last => '0.000027',max => '0.000027',min => '0.000027',sum => '5.4e-05'},Merge_passes => {all => {'0' => 2},cnt => 2,last => 0,max => 0,min => 0,sum => 0},QC_Hit => {cnt => 2,max => 0,min => 0,sum => 0,unq => {'0' => 2}},Query_time => {all => {'129' => 2},cnt => 2,last => '0.000530',max => '0.000530',min => '0.000530',sum => '0.00106'},Rows_examined => {all => {'0' => 2},cnt => 2,last => 0,max => 0,min => 0,sum => 0},Rows_sent => {all => {'0' => 2},cnt => 2,last => 0,max => 0,min => 0,sum => 0},Tmp_table => {cnt => 2,max => 0,min => 0,sum => 0,unq => {'0' => 2}},bytes => {all => {'360' => 2},cnt => 2,last => 41,max => 41,min => 41,sum => 82},db => {cnt => 2,max => 'db1',min => 'db1',unq => {db1 => 2}},host => {cnt => 2,max => '',min => '',unq => {'' => 2}},pos_in_log => {all => {'443' => 1,'450' => 1},cnt => 2,last => 3332,max => 3332,min => 2363,sum => 5695},ts => {cnt => 2,max => '071218 11:48:27',min => '071218 11:48:27',unq => {'071218 11:48:27' => 2}},user => {cnt => 2,max => '[SQL_SLAVE]',min => '[SQL_SLAVE]',unq => {'[SQL_SLAVE]' => 2}}}},globals => {Filesort_on_disk => {cnt => 8,max => 0,min => 0,sum => 0},Tmp_table_on_disk => {cnt => 8,max => 0,min => 0,sum => 0},Filesort => {cnt => 8,max => 0,min => 0,sum => 0},Full_join => {cnt => 8,max => 0,min => 0,sum => 0},Full_scan => {cnt => 8,max => 1,min => 0,sum => 1},InnoDB_IO_r_bytes => {all => {'0' => 6},cnt => 6,max => 0,min => 0,sum => 0},InnoDB_IO_r_ops => {all => {'0' => 6},cnt => 6,max => 0,min => 0,sum => 0},InnoDB_IO_r_wait => {all => {'0' => 6},cnt => 6,max => '0.000000',min => '0.000000',sum => '0'},InnoDB_pages_distinct => {all => {'333' => 1,'343' => 4,'349' => 1},cnt => 6,max => 24,min => 11,sum => 107},InnoDB_queue_wait => {all => {'0' => 6},cnt => 6,max => '0.000000',min => '0.000000',sum => '0'},InnoDB_rec_lock_wait => {all => {'0' => 6},cnt => 6,max => '0.000000',min => '0.000000',sum => '0'},Lock_time => {all => {'0' => 1,'68' => 4,'69' => 1,'90' => 1,'93' => 1},cnt => 8,max => '0.000091',min => '0.000000',sum => '0.000304'},Merge_passes => {all => {'0' => 8},cnt => 8,max => 0,min => 0,sum => 0},QC_Hit => {cnt => 8,max => 0,min => 0,sum => 0},Query_time => {all => {'128' => 1,'129' => 4,'214' => 1,'277' => 1,'51' => 1},cnt => 8,max => '0.726052',min => '0.000012',sum => '0.76208'},Rows_examined => {all => {'0' => 7,'510' => 1},cnt => 8,max => 62951,min => 0,sum => 62951},Rows_sent => {all => {'0' => 8},cnt => 8,max => 0,min => 0,sum => 0},Tmp_table => {cnt => 8,max => 0,min => 0,sum => 0},bytes => {all => {'317' => 1,'360' => 2,'367' => 1,'368' => 1,'370' => 1,'379' => 1,'383' => 1},cnt => 8,max => 129,min => 5,sum => 502},db => {cnt => 7,max => 'db1',min => 'db1'},host => {cnt => 8,max => '',min => ''},pos_in_log => {all => {'0' => 1,'403' => 1,'421' => 1,'431' => 1,'438' => 1,'443' => 1,'447' => 1,'450' => 1},cnt => 8,max => 3332,min => 0,sum => 12811},ts => {cnt => 8,max => '071218 11:48:27',min => '071218 11:48:27'},user => {cnt => 8,max => '[SQL_SLAVE]',min => '[SQL_SLAVE]'}},samples => {'update d?tuningdetail_?_? n inner join d?gonzo a using(gonzo) set n.column? = a.column?, n.word? = a.word?' => {Filesort_on_disk => 'No',Tmp_table_on_disk => 'No',Filesort => 'No',Full_join => 'No',Full_scan => 'Yes',Lock_time => '0.000091',Merge_passes => '0',QC_Hit => 'No',Query_time => '0.726052',Rows_examined => '62951',Rows_sent => '0',Thread_id => '10',Tmp_table => 'No',arg => 'update db2.tuningdetail_21_265507 n
      inner join db1.gonzo a using(gonzo) 
      set n.column1 = a.column1, n.word3 = a.word3',bytes => 129,cmd => 'Query',db => 'db1',fingerprint => 'update d?tuningdetail_?_? n inner join d?gonzo a using(gonzo) set n.column? = a.column?, n.word? = a.word?',host => '',ip => '',pos_in_log => 332,timestamp => '1197996507',ts => '071218 11:48:27',user => '[SQL_SLAVE]'},'update d?va?oncept?upload set va?oncept?id = ? where va?oncept?upload=?' => {Filesort_on_disk => 'No',Tmp_table_on_disk => 'No',Filesort => 'No',Full_join => 'No',Full_scan => 'No',InnoDB_IO_r_bytes => '0',InnoDB_IO_r_ops => '0',InnoDB_IO_r_wait => '0.000000',InnoDB_pages_distinct => '11',InnoDB_queue_wait => '0.000000',InnoDB_rec_lock_wait => '0.000000',Lock_time => '0.000028',Merge_passes => '0',QC_Hit => 'No',Query_time => '0.033384',Rows_examined => '0',Rows_sent => '0',Thread_id => '10',Tmp_table => 'No',arg => 'UPDATE db4.vab3concept1upload
SET    vab3concept1id = \'91848182522\'
WHERE  vab3concept1upload=\'6994465\'',bytes => 103,cmd => 'Query',db => 'db1',fingerprint => 'update d?va?oncept?upload set va?oncept?id = ? where va?oncept?upload=?',host => '',ip => '',pos_in_log => 1316,ts => '071218 11:48:27',user => '[SQL_SLAVE]'},'update foo.bar set biz = ?' => {Filesort_on_disk => 'No',Tmp_table_on_disk => 'No',Filesort => 'No',Full_join => 'No',Full_scan => 'No',InnoDB_IO_r_bytes => '0',InnoDB_IO_r_ops => '0',InnoDB_IO_r_wait => '0.000000',InnoDB_pages_distinct => '18',InnoDB_queue_wait => '0.000000',InnoDB_rec_lock_wait => '0.000000',Lock_time => '0.000027',Merge_passes => '0',QC_Hit => 'No',Query_time => '0.000530',Rows_examined => '0',Rows_sent => '0',Thread_id => '10',Tmp_table => 'No',arg => 'UPDATE foo.bar
SET    biz = \'91848182522\'',bytes => 41,cmd => 'Query',db => 'db1',fingerprint => 'update foo.bar set biz = ?',host => '',ip => '',pos_in_log => 3332,ts => '071218 11:48:27',user => '[SQL_SLAVE]'}}},worst => 'Query_time'};