Report for msl logs: /var/lib/mysql/mysql-slow.log 4.10M queries total, 334 unique Sorted by 't_sum' Grand Totals: Time 6.05k s, Lock 1.45k s, Rows sent 3.64M, Rows Examined 5.45M ______________________________________________________________________ 001 ___ Count : 351.95k (8.59%) Time : 881.934676 s total, 2.506 ms avg, 22 �s to 173.71 ms max (14.59%) 95% of Time : 512.013865 s total, 1.531 ms avg, 22 �s to 7.196 ms max Lock Time (s) : 234.815375 s total, 667 �s avg, 0 to 80.012 ms max (16.20%) 95% of Lock : 119.763354 s total, 358 �s avg, 0 to 2.231 ms max Rows sent : 1 avg, 0 to 16 max (8.45%) Rows examined : 1 avg, 0 to 16 max (5.64%) Database : examiner_load QC_hit: No Users : 25.85% (90984) of query, 25.19% (1032255) of all users 24.92% (87717) of query, 25.08% (1027700) of all users 24.82% (87360) of query, 24.96% (1023130) of all users 24.40% (85888) of query, 24.77% (1015193) of all users Query abstract: SET timestamp=N; SELECT alias FROM url_alias WHERE source = 'S' AND language IN (S2) ORDER BY language DESC, pid DESC; Query sample: SET timestamp=1281051017; SELECT alias FROM url_alias WHERE source = 'node/13977156' AND language IN ('en', 'und') ORDER BY language DESC, pid DESC; ______________________________________________________________________ 002 ___ Count : 293.04k (7.15%) Time : 782.78315 s total, 2.671 ms avg, 27 �s to 186.63 ms max (12.95%) 95% of Time : 447.935896 s total, 1.609 ms avg, 27 �s to 7.735 ms max Lock Time (s) : 211.754291 s total, 723 �s avg, 0 to 91.016 ms max (14.61%) 95% of Lock : 106.023088 s total, 381 �s avg, 0 to 2.397 ms max Rows sent : 1 avg, 0 to 1.29k max (5.68%) Rows examined : 1 avg, 0 to 1.29k max (3.79%) Database : examiner_load QC_hit: No Users : load@web6.staging.examiner.com 192.168.1.247 : 25.13% (73643) of query, 25.19% (1032255) of all users load@web3.staging.examiner.com 192.168.1.244 : 25.03% (73336) of query, 25.08% (1027700) of all users load@web4.staging.examiner.com 192.168.1.245 : 24.98% (73190) of query, 24.96% (1023130) of all users load@web5.staging.examiner.com 192.168.1.246 : 24.87% (72873) of query, 24.77% (1015193) of all users Query abstract: SET timestamp=N; SELECT source FROM url_alias WHERE alias = 'S' AND language IN (S2) ORDER BY language DESC, pid DESC; Query sample: SET timestamp=1281051017; SELECT source FROM url_alias WHERE alias = 'node/7343506' AND language IN ('en', 'und') ORDER BY language DESC, pid DESC; ______________________________________________________________________ 003 ___ Count : 192.97k (4.71%) Time : 538.446605 s total, 2.79 ms avg, 31 �s to 183.484 ms max (8.91%) 95% of Time : 303.931025 s total, 1.658 ms avg, 31 �s to 8.602 ms max Lock Time (s) : 151.188764 s total, 783 �s avg, 0 to 95.447 ms max (10.43%) 95% of Lock : 79.450498 s total, 433 �s avg, 0 to 2.595 ms max Rows sent : 1 avg, 0 to 1 max (5.29%) Rows examined : 1 avg, 0 to 1 max (3.54%) Database : examiner_load QC_hit: No Users : 25.09% (48408) of query, 25.08% (1027700) of all users 25.07% (48384) of query, 24.96% (1023130) of all users 24.99% (48215) of query, 25.19% (1032255) of all users 24.86% (47968) of query, 24.77% (1015193) of all users Query abstract: SET timestamp=N; SELECT revision.vid AS vid, base.uid AS uid, revision.title AS title, revision.log AS log, revision.status AS status, revision.comment AS comment, revision.promote AS promote, revision.sticky AS sticky, base.nid AS nid, base.type AS type, base.language AS language, base.created AS created, base.changed AS changed, base.tnid AS tnid, base.translate AS translate, base.template AS template, revision.timestamp AS revision_timestamp, revision.uid AS revision_uid FROM node base INNER JOIN node_revision revision ON revision.vid = base.vid WHERE (base.nid IN (S1)); Query sample: SET timestamp=1281051017; SELECT revision.vid AS vid, base.uid AS uid, revision.title AS title, revision.log AS log, revision.status AS status, revision.comment AS comment, revision.promote AS promote, revision.sticky AS sticky, base.nid AS nid, base.type AS type, base.language AS language, base.created AS created, base.changed AS changed, base.tnid AS tnid, base.translate AS translate, base.template AS template, revision.timestamp AS revision_timestamp, revision.uid AS revision_uid FROM node base INNER JOIN node_revision revision ON revision.vid = base.vid WHERE (base.nid IN ('5234')); ______________________________________________________________________ 004 ___ Count : 192.97k (4.71%) Time : 465.8711 s total, 2.414 ms avg, 22 �s to 155.19 ms max (7.71%) 95% of Time : 246.7651 s total, 1.346 ms avg, 22 �s to 7.811 ms max Lock Time (s) : 137.322228 s total, 712 �s avg, 0 to 87.493 ms max (9.48%) 95% of Lock : 67.578305 s total, 369 �s avg, 0 to 2.437 ms max Rows sent : 1 avg, 0 to 1 max (5.07%) Rows examined : 1 avg, 0 to 1 max (3.39%) Database : examiner_load QC_hit: No Users : 25.08% (48406) of query, 25.08% (1027700) of all users 25.07% (48384) of query, 24.96% (1023130) of all users 24.98% (48212) of query, 25.19% (1032255) of all users 24.86% (47967) of query, 24.77% (1015193) of all users Query abstract: SET timestamp=N; SELECT nid, cid, last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid IN (S1); Query sample: SET timestamp=1281051017; SELECT nid, cid, last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid IN ('67456'); ______________________________________________________________________ 005 ___ Count : 165.57k (4.04%) Time : 445.780439 s total, 2.692 ms avg, 29 �s to 180.166 ms max (7.37%) 95% of Time : 234.71353 s total, 1.492 ms avg, 29 �s to 9.343 ms max Lock Time (s) : 134.046147 s total, 810 �s avg, 0 to 99.078 ms max (9.25%) 95% of Lock : 66.268368 s total, 421 �s avg, 0 to 2.855 ms max Rows sent : 1 avg, 0 to 1 max (4.54%) Rows examined : 1 avg, 0 to 1 max (3.03%) Database : examiner_load QC_hit: No Users : 25.09% (41541) of query, 25.08% (1027700) of all users 25.06% (41489) of query, 25.19% (1032255) of all users 25.05% (41471) of query, 24.96% (1023130) of all users 24.80% (41066) of query, 24.77% (1015193) of all users Query abstract: SET timestamp=N; SELECT base.fid AS fid, base.uid AS uid, base.filename AS filename, base.uri AS uri, base.filemime AS filemime, base.filesize AS filesize, base.status AS status, base.timestamp AS timestamp, base.transcoded AS transcoded, base.transcoding_status AS transcoding_status FROM file_managed base WHERE (base.fid IN (S1)); Query sample: SET timestamp=1281051017; SELECT base.fid AS fid, base.uid AS uid, base.filename AS filename, base.uri AS uri, base.filemime AS filemime, base.filesize AS filesize, base.status AS status, base.timestamp AS timestamp, base.transcoded AS transcoded, base.transcoding_status AS transcoding_status FROM file_managed base WHERE (base.fid IN ('570126')); ______________________________________________________________________ 006 ___ Count : 136.86k (3.34%) Time : 396.27859 s total, 2.896 ms avg, 42 �s to 157.08 ms max (6.55%) 95% of Time : 237.040076 s total, 1.823 ms avg, 42 �s to 8.304 ms max Lock Time (s) : 90.944064 s total, 665 �s avg, 0 to 68.036 ms max (6.28%) 95% of Lock : 46.713006 s total, 359 �s avg, 0 to 2.237 ms max Rows sent : 1 avg, 0 to 1 max (3.76%) Rows examined : 2 avg, 0 to 2 max (5.02%) Database : examiner_load QC_hit: No Users : 25.20% (34494) of query, 25.19% (1032255) of all users 25.04% (34269) of query, 25.08% (1027700) of all users 24.90% (34078) of query, 24.96% (1023130) of all users 24.85% (34015) of query, 24.77% (1015193) of all users Query abstract: SET timestamp=N; SELECT * FROM menu_router WHERE path IN (S3) ORDER BY fit DESC LIMIT N, N; Query sample: SET timestamp=1281051017; SELECT * FROM menu_router WHERE path IN ('node/734350', 'node/%', 'node') ORDER BY fit DESC LIMIT 0, 1; ______________________________________________________________________ 007 ___ Count : 386.41k (9.43%) Time : 274.294438 s total, 710 �s avg, 14 �s to 104.241 ms max (4.54%) 95% of Time : 127.932185 s total, 349 �s avg, 14 �s to 2.399 ms max Lock Time (s) : 215.161 ms total, 1 �s avg, 0 to 59.949 ms max (0.01%) 95% of Lock : 0 total, 0 avg, 0 to 0 max Rows sent : 0 avg, 0 to 12 max (0.00%) Rows examined : 0 avg, 0 to 12 max (0.00%) Database : examiner_load QC_hit: No Users : 25.13% (97114) of query, 25.19% (1032255) of all users 25.06% (96816) of query, 25.08% (1027700) of all users 24.94% (96365) of query, 24.96% (1023130) of all users 24.87% (96118) of query, 24.77% (1015193) of all users Query abstract: SET timestamp=N; SELECT rid, permission FROM role_permission WHERE rid IN (S1); Query sample: SET timestamp=1281051010; SELECT rid, permission FROM role_permission WHERE rid IN ('1'); ______________________________________________________________________ 008 ___ Count : 112.17k (2.74%) Time : 239.73427 s total, 2.137 ms avg, 17 �s to 141.681 ms max (3.97%) 95% of Time : 112.764521 s total, 1.058 ms avg, 17 �s to 8.038 ms max Lock Time (s) : 61.322533 s total, 547 �s avg, 0 to 82.888 ms max (4.23%) 95% of Lock : 22.820295 s total, 214 �s avg, 0 to 2.107 ms max Rows sent : 1 avg, 0 to 1 max (1.82%) Rows examined : 1 avg, 0 to 1 max (1.22%) Database : examiner_load QC_hit: No Users : 25.65% (28772) of query, 25.08% (1027700) of all users 24.95% (27991) of query, 24.96% (1023130) of all users 24.79% (27803) of query, 25.19% (1032255) of all users 24.61% (27609) of query, 24.77% (1015193) of all users Query abstract: SET timestamp=N; SELECT base.tid AS tid, base.vid AS vid, base.name AS name, base.description AS description, base.format AS format, base.weight AS weight, v.machine_name AS vocabulary_machine_name FROM taxonomy_term_data base INNER JOIN taxonomy_vocabulary v ON base.vid = v.vid WHERE (base.tid IN (S1)); Query sample: SET timestamp=1281051017; SELECT base.tid AS tid, base.vid AS vid, base.name AS name, base.description AS description, base.format AS format, base.weight AS weight, v.machine_name AS vocabulary_machine_name FROM taxonomy_term_data base INNER JOIN taxonomy_vocabulary v ON base.vid = v.vid WHERE (base.tid IN ('1116')); ______________________________________________________________________ 009 ___ Count : 192.97k (4.71%) Time : 212.156903 s total, 1.099 ms avg, 15 �s to 138.484 ms max (3.51%) 95% of Time : 98.875998 s total, 539 �s avg, 15 �s to 3.821 ms max Lock Time (s) : 33.899255 s total, 176 �s avg, 0 to 65.213 ms max (2.34%) 95% of Lock : 7.710627 s total, 42 �s avg, 0 to 737 �s max Rows sent : 0 avg, 0 to 1 max (1.46%) Rows examined : 0 avg, 0 to 1 max (0.98%) Database : examiner_load QC_hit: Yes Users : 25.08% (48406) of query, 25.08% (1027700) of all users 25.07% (48384) of query, 24.96% (1023130) of all users 24.98% (48212) of query, 25.19% (1032255) of all users 24.86% (47967) of query, 24.77% (1015193) of all users Query abstract: SET timestamp=N; SELECT uid, name, picture, data FROM users WHERE uid IN (S1); Query sample: SET timestamp=1281051017; SELECT uid, name, picture, data FROM users WHERE uid IN ('1371'); ______________________________________________________________________ 010 ___ Count : 134.39k (3.28%) Time : 191.316474 s total, 1.424 ms avg, 21 �s to 136.665 ms max (3.16%) 95% of Time : 95.848248 s total, 751 �s avg, 21 �s to 4.541 ms max Lock Time (s) : 41.966254 s total, 312 �s avg, 0 to 101.16 ms max (2.90%) 95% of Lock : 14.584226 s total, 114 �s avg, 0 to 1.186 ms max Rows sent : 0 avg, 0 to 1 max (1.52%) Rows examined : 0 avg, 0 to 1 max (1.02%) Database : examiner_load QC_hit: Yes Users : 25.06% (33683) of query, 24.96% (1023130) of all users 25.02% (33621) of query, 24.77% (1015193) of all users 25.00% (33601) of query, 25.08% (1027700) of all users 24.92% (33484) of query, 25.19% (1032255) of all users Query abstract: SET timestamp=N; SELECT revision.evid AS evid, revision.vuid AS vuid, revision.term_tid AS term_tid, revision.status AS status, revision.created AS created, base.etid AS etid, base.uid AS uid FROM ex_title base INNER JOIN ex_title_revision revision ON revision.evid = base.evid WHERE (base.uid IN (S1)) AND (base.term_tid IN (S1)); Query sample: SET timestamp=1281051017; SELECT revision.evid AS evid, revision.vuid AS vuid, revision.term_tid AS term_tid, revision.status AS status, revision.created AS created, base.etid AS etid, base.uid AS uid FROM ex_title base INNER JOIN ex_title_revision revision ON revision.evid = base.evid WHERE (base.uid IN ('1371')) AND (base.term_tid IN ('1821181')); ______________________________________________________________________ 011 ___ Count : 291.43k (7.11%) Time : 190.716182 s total, 654 �s avg, 17 �s to 103.987 ms max (3.15%) 95% of Time : 93.628466 s total, 338 �s avg, 17 �s to 2.191 ms max Lock Time (s) : 51.914 ms total, 0 avg, 0 to 51.874 ms max (0.00%) 95% of Lock : 0 total, 0 avg, 0 to 0 max Rows sent : 0 avg, 0 to 12 max (0.00%) Rows examined : 0 avg, 0 to 12 max (0.00%) Database : examiner_load QC_hit: No Users : 25.13% (73244) of query, 25.19% (1032255) of all users 25.02% (72927) of query, 25.08% (1027700) of all users 24.97% (72770) of query, 24.96% (1023130) of all users 24.87% (72492) of query, 24.77% (1015193) of all users Query abstract: SET timestamp=N; SELECT nt.* FROM node_type nt ORDER BY nt.type ASC; Query sample: SET timestamp=1281051007; SELECT nt.* FROM node_type nt ORDER BY nt.type ASC; ______________________________________________________________________ 012 ___ Count : 34.43k (0.84%) Time : 120.071779 s total, 3.488 ms avg, 25 �s to 171.906 ms max (1.99%) 95% of Time : 61.692149 s total, 1.886 ms avg, 25 �s to 15.416 ms max Lock Time (s) : 35.544859 s total, 1.032 ms avg, 0 to 95.505 ms max (2.45%) 95% of Lock : 16.664924 s total, 510 �s avg, 0 to 4.675 ms max Rows sent : 1 avg, 0 to 1 max (0.94%) Rows examined : 1 avg, 0 to 1 max (0.63%) Database : examiner_load QC_hit: Yes Users : 25.28% (8705) of query, 24.96% (1023130) of all users 25.12% (8648) of query, 25.08% (1027700) of all users 24.80% (8539) of query, 25.19% (1032255) of all users 24.79% (8536) of query, 24.77% (1015193) of all users Query abstract: SET timestamp=N; SELECT revision.pid AS pid, revision.pvid AS pvid, revision.vuid AS vuid, base.uid AS uid FROM ex_profile base INNER JOIN ex_profile_revision revision ON revision.pvid = base.pvid WHERE (base.uid IN (S1)); Query sample: SET timestamp=1281051017; SELECT revision.pid AS pid, revision.pvid AS pvid, revision.vuid AS vuid, base.uid AS uid FROM ex_profile base INNER JOIN ex_profile_revision revision ON revision.pvid = base.pvid WHERE (base.uid IN ('2147851'));