Skip to content

Instantly share code, notes, and snippets.

@x8k2
Created September 16, 2011 18:37
Show Gist options
  • Select an option

  • Save x8k2/1222767 to your computer and use it in GitHub Desktop.

Select an option

Save x8k2/1222767 to your computer and use it in GitHub Desktop.
When Load QPS Slow Se/In/Up/De% QCacheHit KCacheHit BpsIn BpsOut
Now 49.51 3.88 0 0/ 0/ 0/ 0 0.00% 100.00% 170.88 25.42k
Total 0.00 13.99 229 24/ 0/23/ 0 0.00% 100.00% 468.90 4.51k
Cmd ID State User Host DB Time Query
Query 48 Sending data root localhost userdump 18:03 select id from users where dumper = 0 limit 1 for update
Query 47 Sending data root localhost userdump 16:40 select id from users where dumper = 0 limit 1 for update
Query 44 Sending data root localhost userdump 14:27 select id from users where dumper = 0 limit 1 for update
Query 77 Sending data root localhost userdump 09:42 select id from users where dumper = 0 limit 1 for update
Query 65 Sending data root localhost userdump 09:37 select id from users where dumper = 0 limit 1 for update
Query 74 Sending data root localhost userdump 09:35 select id from users where dumper = 0 limit 1 for update
Query 83 Sending data root localhost userdump 09:17 select id from users where dumper = 0 limit 1 for update
Query 55 Sending data root localhost userdump 09:04 select id from users where dumper = 0 limit 1 for update
Query 38 Sending data root localhost userdump 08:45 select id from users where dumper = 0 limit 1 for update
Query 45 Sending data root localhost userdump 08:30 select id from users where dumper = 0 limit 1 for update
Query 35 Sending data root localhost userdump 07:57 select id from users where dumper = 0 limit 1 for update
Query 71 Sending data root localhost userdump 07:47 select id from users where dumper = 0 limit 1 for update
Query 78 Sending data root localhost userdump 07:33 select id from users where dumper = 0 limit 1 for update
Query 61 Sending data root localhost userdump 07:12 select id from users where dumper = 0 limit 1 for update
Query 56 Sending data root localhost userdump 06:27 select id from users where dumper = 0 limit 1 for update
Query 40 Sending data root localhost userdump 06:07 select id from users where dumper = 0 limit 1 for update
Query 63 Sending data root localhost userdump 06:01 select id from users where dumper = 0 limit 1 for update
Query 75 Sending data root localhost userdump 05:46 select id from users where dumper = 0 limit 1 for update
Query 53 Sending data root localhost userdump 05:38 select id from users where dumper = 0 limit 1 for update
Query 66 Sending data root localhost userdump 05:28 select id from users where dumper = 0 limit 1 for update
Query 70 Sending data root localhost userdump 05:02 select id from users where dumper = 0 limit 1 for update
Query 34 Sending data root localhost userdump 04:56 select id from users where dumper = 0 limit 1 for update
Query 80 Sending data root localhost userdump 04:53 select id from users where dumper = 0 limit 1 for update
Query 68 Sending data root localhost userdump 04:46 select id from users where dumper = 0 limit 1 for update
Query 51 Sending data root localhost userdump 04:31 select id from users where dumper = 0 limit 1 for update
Query 79 Sending data root localhost userdump 04:14 select id from users where dumper = 0 limit 1 for update
Query 39 Sending data root localhost userdump 03:22 select id from users where dumper = 0 limit 1 for update
Query 46 Sending data root localhost userdump 03:07 select id from users where dumper = 0 limit 1 for update
Query 76 Sending data root localhost userdump 02:59 select id from users where dumper = 0 limit 1 for update
Query 41 Sending data root localhost userdump 02:49 select id from users where dumper = 0 limit 1 for update
Query 62 Sending data root localhost userdump 02:23 select id from users where dumper = 0 limit 1 for update
Query 67 Sending data root localhost userdump 02:16 select id from users where dumper = 0 limit 1 for update
Query 37 Sending data root localhost userdump 02:09 select id from users where dumper = 0 limit 1 for update
Query 64 Sending data root localhost userdump 01:55 select id from users where dumper = 0 limit 1 for update
Query 43 Sending data root localhost userdump 01:48 select id from users where dumper = 0 limit 1 for update
Query 81 Sending data root localhost userdump 01:40 select id from users where dumper = 0 limit 1 for update
Query 72 Sending data root localhost userdump 01:37 select id from users where dumper = 0 limit 1 for update
Query 73 Sending data root localhost userdump 01:31 select id from users where dumper = 0 limit 1 for update
Query 49 Sending data root localhost userdump 01:22 select id from users where dumper = 0 limit 1 for update
Query 59 Sending data root localhost userdump 01:14 select id from users where dumper = 0 limit 1 for update
Query 57 Sending data root localhost userdump 01:09 select id from users where dumper = 0 limit 1 for update
Query 36 Sending data root localhost userdump 01:00 select id from users where dumper = 0 limit 1 for update
Query 82 Sending data root localhost userdump 00:55 select id from users where dumper = 0 limit 1 for update
Query 50 Sending data root localhost userdump 00:44 select id from users where dumper = 0 limit 1 for update
Query 58 Sending data root localhost userdump 00:34 select id from users where dumper = 0 limit 1 for update
Query 54 Sending data root localhost userdump 00:27 select id from users where dumper = 0 limit 1 for update
Query 60 Sending data root localhost userdump 00:20 select id from users where dumper = 0 limit 1 for update
Query 69 Sending data root localhost userdump 00:12 select id from users where dumper = 0 limit 1 for update
Query 52 Sending data root localhost userdump 00:04 select id from users where dumper = 0 limit 1 for update
Query 42 Updating root localhost userdump 00:01 update users set dumper = 8 where id = 8319
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment