All pastes #2131427 Raw Edit

Unnamed

public text v1 · immutable
#2131427 ·published 2012-03-23 09:00 UTC
rendered paste body
+----------+-------+--------------------+-------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------+
| Id       | User  | Host               | db    | Command | Time | State                        | Info                                                                                                 |
+----------+-------+--------------------+-------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------+
| 13372791 | gifyo | 216.59.15.34:53612 | gifyo | Query   | 0    | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '180873'                                                          |
| 13372845 | gifyo | 216.59.15.34:53619 | gifyo | Query   | 0    | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '288828'                                                          |
| 13372905 | gifyo | 216.59.15.34:53630 | gifyo | Query   | 0    | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '61712'                                                           |
| 13372936 | gifyo | localhost          | gifyo | Query   | 15   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13372937 | gifyo | localhost          | gifyo | Sleep   | 15   |                              |                                                                                                      |
| 13372938 | gifyo | localhost          | gifyo | Query   | 0    | Sending data                 | UPDATE users u SET nr_pictures = (SELECT count(p.id) FROM pictures p WHERE p.user_id = u.id and p.ac |
| 13372939 | gifyo | localhost          | gifyo | Query   | 15   | Waiting for table level lock | REPLACE INTO stats SET
                added = 1332486000,
                nr_booths = (select count(id) from pictures |
| 13372942 | gifyo | localhost          | gifyo | Query   | 15   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13372943 | gifyo | localhost          | gifyo | Sleep   | 15   |                              |                                                                                                      |
| 13372948 | gifyo | 216.59.15.34:53635 | gifyo | Query   | 0    | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '48805'                                                           |
| 13372956 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '91442'                                                           |
| 13372957 | gifyo | localhost          | gifyo | Sleep   | 15   |                              |                                                                                                      |
| 13372962 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '186379'                                                          |
| 13372963 | gifyo | localhost          | gifyo | Sleep   | 15   |                              |                                                                                                      |
| 13372966 | gifyo | localhost          | gifyo | Query   | 15   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13372967 | gifyo | localhost          | gifyo | Sleep   | 15   |                              |                                                                                                      |
| 13372975 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13372976 | gifyo | localhost          | gifyo | Sleep   | 15   |                              |                                                                                                      |
| 13372980 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13372981 | gifyo | localhost          | gifyo | Sleep   | 15   |                              |                                                                                                      |
| 13372982 | gifyo | localhost          | gifyo | Query   | 15   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13372983 | gifyo | localhost          | gifyo | Sleep   | 15   |                              |                                                                                                      |
| 13372989 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '85983'                                                           |
| 13372990 | gifyo | localhost          | gifyo | Sleep   | 14   |                              |                                                                                                      |
| 13372991 | gifyo | localhost          | gifyo | Query   | 14   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13372992 | gifyo | localhost          | gifyo | Sleep   | 14   |                              |                                                                                                      |
| 13372995 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13372996 | gifyo | localhost          | gifyo | Sleep   | 14   |                              |                                                                                                      |
| 13372998 | gifyo | 216.59.15.34:53652 | gifyo | Query   | 10   | Waiting for table level lock | INSERT IGNORE INTO `pictures` SET `id` = NULL, `folder` = '44', `picture` = '39af9771c6507b6c7e2ff87 |
| 13372999 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT u.user, u.id, u.nr_pictures as total, u.id as id
                                FROM followers f
                                LEF |
| 13373000 | gifyo | localhost          | gifyo | Sleep   | 14   |                              |                                                                                                      |
| 13373008 | gifyo | localhost          | gifyo | Query   | 14   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
      |
| 13373009 | gifyo | localhost          | gifyo | Sleep   | 14   |                              |                                                                                                      |
| 13373010 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '86562'                                                           |
| 13373011 | gifyo | localhost          | gifyo | Sleep   | 13   |                              |                                                                                                      |
| 13373016 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '321377'                                                          |
| 13373017 | gifyo | localhost          | gifyo | Sleep   | 13   |                              |                                                                                                      |
| 13373022 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '98419'                                                           |
| 13373024 | gifyo | localhost          | gifyo | Sleep   | 13   |                              |                                                                                                      |
| 13373037 | gifyo | localhost          | gifyo | Query   | 13   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13373038 | gifyo | localhost          | gifyo | Sleep   | 13   |                              |                                                                                                      |
| 13373043 | gifyo | localhost          | gifyo | Query   | 13   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
      |
| 13373044 | gifyo | localhost          | gifyo | Sleep   | 13   |                              |                                                                                                      |
| 13373051 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT u.user, u.id, u.nr_pictures as total, u.id as id
                                FROM followers f
                                LEF |
| 13373052 | gifyo | localhost          | gifyo | Sleep   | 13   |                              |                                                                                                      |
| 13373053 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13373054 | gifyo | localhost          | gifyo | Sleep   | 12   |                              |                                                                                                      |
| 13373055 | gifyo | localhost          | gifyo | Query   | 12   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
      |
| 13373056 | gifyo | localhost          | gifyo | Sleep   | 12   |                              |                                                                                                      |
| 13373057 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '230996'                                                          |
| 13373058 | gifyo | localhost          | gifyo | Sleep   | 12   |                              |                                                                                                      |
| 13373059 | gifyo | localhost          | gifyo | Query   | 12   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
      |
| 13373060 | gifyo | localhost          | gifyo | Sleep   | 12   |                              |                                                                                                      |
| 13373066 | gifyo | localhost          | gifyo | Query   | 12   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
      |
| 13373067 | gifyo | localhost          | gifyo | Sleep   | 12   |                              |                                                                                                      |
| 13373068 | gifyo | localhost          | gifyo | Query   | 12   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
      |
| 13373069 | gifyo | localhost          | gifyo | Sleep   | 12   |                              |                                                                                                      |
| 13373082 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT u.user, u.id, u.nr_pictures as total, u.id as id
                                FROM followers f
                                LEF |
| 13373083 | gifyo | localhost          | gifyo | Sleep   | 11   |                              |                                                                                                      |
| 13373084 | gifyo | localhost          | gifyo | Query   | 11   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
      |
| 13373085 | gifyo | localhost          | gifyo | Sleep   | 11   |                              |                                                                                                      |
| 13373088 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '320224'                                                          |
| 13373089 | gifyo | localhost          | gifyo | Sleep   | 11   |                              |                                                                                                      |
| 13373093 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '28519'                                                           |
| 13373094 | gifyo | localhost          | gifyo | Sleep   | 11   |                              |                                                                                                      |
| 13373095 | gifyo | localhost          | gifyo | Query   | 11   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13373096 | gifyo | localhost          | gifyo | Sleep   | 11   |                              |                                                                                                      |
| 13373097 | gifyo | localhost          | gifyo | Query   | 11   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
      |
| 13373098 | gifyo | localhost          | gifyo | Sleep   | 11   |                              |                                                                                                      |
| 13373101 | gifyo | localhost          | gifyo | Query   | 11   | Waiting for table level lock | UPDATE pictures SET comments = comments + 1 WHERE id = '2054953'                                     |
| 13373102 | gifyo | localhost          | gifyo | Sleep   | 11   |                              |                                                                                                      |
| 13373103 | gifyo | localhost          | gifyo | Query   | 11   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
      |
| 13373104 | gifyo | localhost          | gifyo | Sleep   | 11   |                              |                                                                                                      |
| 13373109 | gifyo | localhost          | gifyo | Query   | 11   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
      |
| 13373110 | gifyo | localhost          | gifyo | Sleep   | 11   |                              |                                                                                                      |
| 13373111 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '124967'                                                          |
| 13373112 | gifyo | localhost          | gifyo | Sleep   | 11   |                              |                                                                                                      |
| 13373115 | gifyo | localhost          | gifyo | Query   | 11   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
      |
| 13373116 | gifyo | localhost          | gifyo | Sleep   | 11   |                              |                                                                                                      |
| 13373120 | gifyo | localhost          | gifyo | Query   | 10   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
      |
| 13373121 | gifyo | localhost          | gifyo | Sleep   | 10   |                              |                                                                                                      |
| 13373122 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13373123 | gifyo | localhost          | gifyo | Sleep   | 10   |                              |                                                                                                      |
| 13373124 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '267546'                                                          |
| 13373125 | gifyo | localhost          | gifyo | Sleep   | 10   |                              |                                                                                                      |
| 13373127 | gifyo | localhost          | gifyo | Query   | 10   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
      |
| 13373128 | gifyo | localhost          | gifyo | Sleep   | 10   |                              |                                                                                                      |
| 13373132 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '6569'                                                            |
| 13373133 | gifyo | localhost          | gifyo | Sleep   | 10   |                              |                                                                                                      |
| 13373134 | gifyo | localhost          | gifyo | Query   | 10   | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
      |
| 13373135 | gifyo | localhost          | gifyo | Sleep   | 10   |                              |                                                                                                      |
| 13373138 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13373139 | gifyo | localhost          | gifyo | Sleep   | 9    |                              |                                                                                                      |
| 13373140 | gifyo | localhost          | gifyo | Query   | 9    | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
      |
| 13373141 | gifyo | localhost          | gifyo | Sleep   | 9    |                              |                                                                                                      |
| 13373149 | gifyo | localhost          | gifyo | Query   | 9    | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
      |
| 13373150 | gifyo | localhost          | gifyo | Sleep   | 9    |                              |                                                                                                      |
| 13373151 | gifyo | localhost          | gifyo | Query   | 9    | Waiting for table level lock | UPDATE pictures SET comments = comments + 1 WHERE id = '2054954'                                     |
| 13373152 | gifyo | localhost          | gifyo | Sleep   | 9    |                              |                                                                                                      |
| 13373155 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13373156 | gifyo | localhost          | gifyo | Sleep   | 9    |                              |                                                                                                      |
| 13373164 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '98481'                                                           |
| 13373165 | gifyo | localhost          | gifyo | Sleep   | 9    |                              |                                                                                                      |
| 13373170 | gifyo | localhost          | gifyo | Query   | 8    | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
      |
| 13373171 | gifyo | localhost          | gifyo | Sleep   | 8    |                              |                                                                                                      |
| 13373172 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT * FROM `users` WHERE `id` = '224932'                                                          |
| 13373173 | gifyo | localhost          | gifyo | Sleep   | 8    |                              |                                                                                                      |
| 13373174 | gifyo | localhost          | gifyo | Query   | 0    | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13373175 | gifyo | localhost          | gifyo | Sleep   | 8    |                              |                                                                                                      |
| 13373176 | gifyo | localhost          | gifyo | Query   | 8    | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.added, u.user, p.blurb, count(c.id) as totalcomments FROM
      |
| 13373177 | gifyo | localhost          | gifyo | Sleep   | 8    |                              |                                                                                                      |
| 13373178 | gifyo | localhost          | gifyo | Query   | 8    | Waiting for table level lock | SELECT p.id, p.folder, p.picture, p.blurb, p.views, p.added, p.user_id, p.likes, p.private, p.report |
| 13373179 | gifyo | localhost          | gifyo | Sleep   | 8    |                              |                                                                                                      |
| 13373189 | gifyo | 216.59.15.34:53682 | gifyo | Sleep   | 4    |                              |                                                                                                      |
| 13373191 | root  | localhost          |       | Query   | 0    |                              | show processlist                                                                                     |
+----------+-------+--------------------+-------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------+