gistfile1.txt

Report for slow logs: /var/log/mysql/mysql-slow.log
16.30k queries total, 8 unique
Sorted by 't_sum'
Grand Totals: Time 240.86k s, Lock 8 s, Rows sent 39.76k, Rows Examined 1.55G


______________________________________________________________________ 001 ___
Count         : 7.80k  (47.84%)
Time          : 119793.371699 s total, 15.358125 s avg, 10.015 ms to 240.771133 s max  (49.74%)
  95% of Time : 96388.931761 s total, 13.007953 s avg, 10.015 ms to 34.256583 s max
Lock Time (s) : 2.946127 s total, 378 ?s avg, 28 ?s to 35.543 ms max  (35.23%)
  95% of Lock : 1.506875 s total, 203 ?s avg, 28 ?s to 1.279 ms max
Rows sent     : 5 avg, 0 to 5 max  (97.71%)
Rows examined : 173.48k avg, 0 to 208.69k max  (87.23%)
Database      : delayed_job
Users         : 
	delayed_job@job18.posterous.com 172.27.0.227 : 22.23% (1734) of query, 10.65% (1737) of all users
	delayed_job@job21.posterous.com 172.27.0.236 : 21.40% (1669) of query, 10.26% (1672) of all users
	delayed_job@job22.posterous.com 172.27.0.237 : 20.19% (1575) of query, 9.67% (1576) of all users
	delayed_job@job19.posterous.com 172.27.0.231 : 19.12% (1491) of query, 9.15% (1491) of all users
	delayed_job@job11.posterous.com 172.27.0.201 : 17.06% (1331) of query, 8.23% (1341) of all users

Query abstract:
SET timestamp=N; SELECT * FROM delayed_jobs WHERE ((run_at <= 'S' AND (locked_at IS NULL OR locked_at < 'S') OR (locked_by = 'S')) AND failed_at IS NULL) LIMIT N;

Query sample:
SET timestamp=1306935681;
SELECT * FROM `delayed_jobs` WHERE ((run_at <= '2011-06-01 06:41:17' AND (locked_at IS NULL OR locked_at < '2011-06-01 02:41:17') OR (locked_by = 'host:job18.posterous.com pid:24205')) AND failed_at IS NULL)  LIMIT 5;

______________________________________________________________________ 002 ___
Count         : 8.32k  (51.06%)
Time          : 115090.126307 s total, 13.826301 s avg, 5.000248 s to 42.256183 s max  (47.78%)
  95% of Time : 100119.183796 s total, 12.662095 s avg, 5.000248 s to 31.81718 s max
Lock Time (s) : 5.229809 s total, 628 ?s avg, 31 ?s to 67.644 ms max  (62.54%)
  95% of Lock : 2.440937 s total, 309 ?s avg, 31 ?s to 2.487 ms max
Rows sent     : 0 avg, 0 to 0 max  (0.00%)
Rows examined : 18.28k avg, 2.54k to 23.58k max  (9.81%)
Database      : 
Users         : 
	delayed_job@app13.posterous.com 172.27.0.101 : 12.07% (1005) of query, 6.16% (1005) of all users
	delayed_job@app12.posterous.com 172.27.0.100 : 11.95% (995) of query, 6.10% (995) of all users
	delayed_job@app15.posterous.com 172.27.0.103 : 11.58% (964) of query, 5.91% (964) of all users
	delayed_job@app14.posterous.com 172.27.0.102 : 11.32% (942) of query, 5.78% (942) of all users
	delayed_job@app16.posterous.com 172.27.0.104 : 11.21% (933) of query, 5.72% (933) of all users
	delayed_job@app17.posterous.com 172.27.0.105 : 10.56% (879) of query, 5.39% (879) of all users
	delayed_job@app18.posterous.com 172.27.0.106 : 10.16% (846) of query, 5.19% (846) of all users
	delayed_job@app19.posterous.com 172.27.0.4 : 9.27% (772) of query, 4.74% (772) of all users
	delayed_job@app20.posterous.com 172.27.0.5 : 8.43% (702) of query, 4.31% (702) of all users
	delayed_job@app11.posterous.com 172.27.0.99 : 1.31% (109) of query, 0.67% (109) of all users
	delayed_job@job16.posterous.com 172.27.0.221 : 0.64% (53) of query, 0.33% (53) of all users
	delayed_job@job14.posterous.com 172.27.0.211 : 0.53% (44) of query, 0.59% (96) of all users
	delayed_job@job17.posterous.com 172.27.0.226 : 0.53% (44) of query, 0.27% (44) of all users
	delayed_job@admin11.posterous.com 172.27.0.124 : 0.24% (20) of query, 0.23% (37) of all users
	delayed_job@job11.posterous.com 172.27.0.201 : 0.11% (9) of query, 8.23% (1341) of all users
	delayed_job@job18.posterous.com 172.27.0.227 : 0.04% (3) of query, 10.65% (1737) of all users
	delayed_job@job21.posterous.com 172.27.0.236 : 0.04% (3) of query, 10.26% (1672) of all users
	delayed_job@job22.posterous.com 172.27.0.237 : 0.01% (1) of query, 9.67% (1576) of all users

Query abstract:
SET timestamp=N; SELECT delayed_jobs.id FROM delayed_jobs WHERE (delayed_jobs.handler = BINARY 'S') LIMIT N;

Query sample:
SET timestamp=1306936812;
SELECT `delayed_jobs`.id FROM `delayed_jobs` WHERE (`delayed_jobs`.`handler` = BINARY '--- !ruby/struct:Delayed::PerformableMethod \nobject: !ruby/object:Mixpanel \n  event: \"Model: New Post unique sites\"\n  options: \n    site_private: \"false\"\n    group: \"false\"\n    private: \"false\"\n    via: via_api\n    token: 9a3025103118d0cfb3f778328f140ccb\n    time: 1306936808\n    incoming_username: post\n    distinct_id: 269666\n  saved_url: data=eyJldmVudCI6Ik1vZGVsOiBOZXcgUG9zdCB1bmlxdWUgc2l0ZXMiLCJwcm9wZXJ0aWVzIjp7InNpdGVfcHJpdmF0ZSI6ImZhbHNlIiwiZ3JvdXAiOiJmYWxzZSIsInByaXZhdGUiOiJmYWxzZSIsInZpYSI6InZpYV9hcGkiLCJ0b2tlbiI6IjlhMzAyNTEwMzExOGQwY2ZiM2Y3NzgzMjhmMTQwY2NiIiwidGltZSI6MTMwNjkzNjgwOCwiaW5jb21pbmdfdXNlcm5hbWUiOiJwb3N0IiwiZGlzdGluY3RfaWQiOjI2OTY2Nn19&ip=1\nmethod: :access_api!\nargs: []\n\n')  LIMIT 1;

______________________________________________________________________ 003 ___
Count         : 44  (0.27%)
Time          : 2539.226717 s total, 57.709698 s avg, 5.085854 s to 283.5234 s max  (1.05%)
  95% of Time : 1703.747336 s total, 41.554813 s avg, 5.085854 s to 97.414055 s max
Lock Time (s) : 21.867 ms total, 497 ?s avg, 118 ?s to 5.548 ms max  (0.26%)
  95% of Lock : 12.004 ms total, 293 ?s avg, 118 ?s to 1.109 ms max
Rows sent     : 8 avg, 0 to 15 max  (0.93%)
Rows examined : 384.29k avg, 0 to 551.12k max  (1.09%)
Database      : 
Users         : 
	munin@localhost 127.0.0.1 : 61.36% (27) of query, 0.52% (85) of all users
	delayed_job@admin11.posterous.com 172.27.0.124 : 38.64% (17) of query, 0.23% (37) of all users

Query abstract:
SET timestamp=N; SELECT priority, COUNT(priority) FROM delayed_jobs WHERE run_at < now() GROUP BY priority HAVING COUNT(priority) > N;

Query sample:
SET timestamp=1306937092;
SELECT priority, COUNT(priority) FROM delayed_jobs  WHERE run_at < NOW() GROUP BY priority HAVING COUNT(priority) > 0;

______________________________________________________________________ 004 ___
Count         : 34  (0.21%)
Time          : 1913.265339 s total, 56.27251 s avg, 929.88 ms to 263.275263 s max  (0.79%)
  95% of Time : 1390.565332 s total, 43.455167 s avg, 929.88 ms to 97.953503 s max
Lock Time (s) : 44.733 ms total, 1.316 ms avg, 115 ?s to 24.285 ms max  (0.53%)
  95% of Lock : 14.826 ms total, 463 ?s avg, 115 ?s to 3.265 ms max
Rows sent     : 1 avg, 0 to 1 max  (0.07%)
Rows examined : 655.45k avg, 29.06k to 767.72k max  (1.44%)
Database      : 
Users         : 
	munin@localhost 127.0.0.1 : 97.06% (33) of query, 0.52% (85) of all users
	root@localhost  : 2.94% (1) of query, 0.14% (23) of all users

Query abstract:
SET timestamp=N; SELECT COUNT(*) FROM delayed_jobs;

Query sample:
SET timestamp=1306935924;
select count(*) from delayed_jobs;

______________________________________________________________________ 005 ___
Count         : 25  (0.15%)
Time          : 1042.987545 s total, 41.719502 s avg, 6.992612 s to 256.266664 s max  (0.43%)
  95% of Time : 569.428891 s total, 24.757778 s avg, 6.992612 s to 83.85769 s max
Lock Time (s) : 10.62 ms total, 425 ?s avg, 137 ?s to 4.808 ms max  (0.13%)
  95% of Lock : 5.313 ms total, 231 ?s avg, 137 ?s to 388 ?s max
Rows sent     : 1 avg, 0 to 1 max  (0.06%)
Rows examined : 253.71k avg, 77.15k to 272.71k max  (0.41%)
Database      : 
Users         : 
	munin@localhost 127.0.0.1 : 100.00% (25) of query, 0.52% (85) of all users

Query abstract:
SET timestamp=N; SELECT COUNT(*) FROM delayed_jobs WHERE priority='S' AND run_at < now() > N;

Query sample:
SET timestamp=1306937072;
SELECT COUNT(*) FROM delayed_jobs WHERE priority='1100' and run_at < NOW() > 0;

______________________________________________________________________ 006 ___
Count         : 54  (0.33%)
Time          : 481.892005 s total, 8.923926 s avg, 5.063305 s to 17.940082 s max  (0.20%)
  95% of Time : 432.227356 s total, 8.475046 s avg, 5.063305 s to 12.847025 s max
Lock Time (s) : 72.247 ms total, 1.338 ms avg, 93 ?s to 30.86 ms max  (0.86%)
  95% of Lock : 30.674 ms total, 601 ?s avg, 93 ?s to 3.908 ms max
Rows sent     : 1 avg, 0 to 5 max  (0.15%)
Rows examined : 7.00k avg, 5 to 7.43k max  (0.02%)
Database      : 
Users         : 
	delayed_job@job14.posterous.com 172.27.0.211 : 96.30% (52) of query, 0.59% (96) of all users
	delayed_job@job15.posterous.com 172.27.0.212 : 1.85% (1) of query, 0.01% (1) of all users
	delayed_job@job11.posterous.com 172.27.0.201 : 1.85% (1) of query, 8.23% (1341) of all users

Query abstract:
SET timestamp=N; SELECT * FROM delayed_jobs WHERE ((run_at <= 'S' AND (locked_at IS NULL OR locked_at < 'S') OR (locked_by = 'S')) AND failed_at IS NULL AND (priority >= N) AND (priority <= N)) LIMIT N;

Query sample:
SET timestamp=1306936818;
SELECT * FROM `delayed_jobs` WHERE ((run_at <= '2011-06-01 07:00:13' AND (locked_at IS NULL OR locked_at < '2011-06-01 03:00:13') OR (locked_by = 'host:job14.posterous.com pid:31852')) AND failed_at IS NULL AND (priority >= 900) AND (priority <= 900))  LIMIT 5;

______________________________________________________________________ 007 ___
Count         : 21  (0.13%)
Time          : 599.623 ms total, 28.553 ms avg, 10.061 ms to 84.967 ms max  (0.00%)
  95% of Time : 455.697 ms total, 23.984 ms avg, 10.061 ms to 55.474 ms max
Lock Time (s) : 34.845 ms total, 1.659 ms avg, 501 ?s to 2.7 ms max  (0.42%)
  95% of Lock : 29.521 ms total, 1.554 ms avg, 501 ?s to 2.383 ms max
Rows sent     : 15 avg, 0 to 101 max  (0.82%)
Rows examined : 273 avg, 260 to 285 max  (0.00%)
Database      : 
Users         : 
	root@localhost  : 100.00% (21) of query, 0.14% (23) of all users

Query abstract:
SET timestamp=N; SELECT id FROM information_schema.processlist WHERE user='S' AND time > N;

Query sample:
SET timestamp=1306939318;
SELECT ID FROM INFORMATION_SCHEMA.PROCESSLIST where USER='delayed_job' and TIME > 30;

______________________________________________________________________ 008 ___
Count         : 1  (0.01%)
Time          : 47.642 ms total, 47.642 ms avg, 47.642 ms to 47.642 ms max  (0.00%)
Lock Time (s) : 2.515 ms total, 2.515 ms avg, 2.515 ms to 2.515 ms max  (0.03%)
Rows sent     : 107 avg, 107 to 107 max  (0.27%)
Rows examined : 280 avg, 280 to 280 max  (0.00%)
Database      : 
Users         : 
	root@localhost  : 100.00% (1) of query, 0.14% (23) of all users

Query abstract:
SET timestamp=N; SELECT id,command FROM information_schema.processlist WHERE user='S' AND time > N;

Query sample:
SET timestamp=1306939263;
SELECT ID,Command FROM INFORMATION_SCHEMA.PROCESSLIST where USER='delayed_job' and TIME > 30;