Process list a few minutes after "crash":

# mysql -u root -p -e 'show processlist;'
+-----+------+------------------+------+------------+------+----------------+------------------------------------------------------------------------------------------------------+
| Id  | User | Host             | db   | Command    | Time | State          | Info                                                                                                 |
+-----+------+------------------+------+------------+------+----------------+------------------------------------------------------------------------------------------------------+
|  40 | otrs | x.x.x.193:34667 | otrs | Query      | 1054 | Sending data   | SELECT id, name
        FROM standard_template WHERE valid_id IN (1) AND template_type = 'Create'    |
|  41 | otrs | x.x.x.194:58120 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  42 | otrs | x.x.x.193:35083 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('4yXxGJQDZMRYn2Zi6Hl5EvP |
|  46 | otrs | x.x.x.194:58224 | otrs | Query      | 1054 | updating       | DELETE FROM sessions WHERE session_id = 'RroLPpnyhoffOLTqRKge8ujkx6zrnl1P'                           |
|  48 | otrs | x.x.x.193:35222 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('BNxvLpmOasFUoQVmqYyAXt3 |
|  50 | otrs | x.x.x.194:58253 | otrs | Query      | 1054 | updating       | DELETE FROM sessions WHERE session_id = 'MEb7L0MCa57kuKUeFHs4STDEGpVX3xfF'                           |
|  51 | otrs | x.x.x.194:58280 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  52 | otrs | x.x.x.193:35249 | otrs | Query      | 1054 | Sending data   | SELECT article.id, article_flag.article_key, article_flag.article_value
            FROM article_fla |
|  54 | otrs | x.x.x.194:58369 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('85ZQCQlO5G8TItzHS7146Gw |
|  55 | otrs | x.x.x.193:35269 | otrs | Query      | 1054 | Sending data   | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
|  56 | otrs | x.x.x.194:58385 | otrs | Query      | 1054 | statistics     | SELECT sa.ticket_id, sa.a_from, sa.a_to, sa.a_cc, sa.a_subject,
            sa.a_reply_to, sa.a_mess |
|  57 | otrs | x.x.x.193:35295 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('48UaXSroOSz1ubD5uTSFqAD |
|  59 | otrs | x.x.x.194:58417 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('VjB45wuExbXdhoMrpRXy58Q |
|  60 | otrs | x.x.x.193:35399 | otrs | Query      | 1054 | Sending data   | SELECT id, name FROM article_type WHERE valid_id IN (1)                                              |
|  61 | otrs | x.x.x.194:58433 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('ctIPmqvZeRgg0uXXinkhZvy |
|  62 | otrs | x.x.x.193:35425 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  63 | otrs | x.x.x.194:58471 | otrs | Query      | 1054 | Sending data   | SELECT user_id, create_time, create_by, change_time, change_by
            FROM ticket_watcher
      |
|  64 | otrs | x.x.x.193:35453 | otrs | Query      | 1054 | Sending data   | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
|  65 | otrs | x.x.x.194:58505 | otrs | Query      | 1054 | Sending data   | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
|  66 | otrs | x.x.x.193:35533 | otrs | Query      | 1054 | statistics     | SELECT sa.ticket_id, sa.a_from, sa.a_to, sa.a_cc, sa.a_subject,
            sa.a_reply_to, sa.a_mess |
|  67 | otrs | x.x.x.193:35541 | otrs | Query      | 1054 | Sending data   | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
|  68 | otrs | x.x.x.194:58605 | otrs | Query      | 1054 | Sending data   | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
|  69 | otrs | x.x.x.193:35621 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('g1WxMKdGY7tKScvm6jFkOZ2 |
|  70 | otrs | x.x.x.194:58840 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('1U5AFNeWGUzE8MR3U8EULxf |
|  71 | otrs | x.x.x.193:35622 | otrs | Query      | 1054 | statistics     | SELECT sa.ticket_id, sa.a_from, sa.a_to, sa.a_cc, sa.a_subject,
            sa.a_reply_to, sa.a_mess |
|  72 | otrs | x.x.x.193:35752 | otrs | Query      | 1054 | Sending data   | SELECT id, name FROM article_type WHERE valid_id IN (1)                                              |
|  73 | otrs | x.x.x.194:59162 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  74 | otrs | x.x.x.194:59246 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('7HxmniuRIEpWizCqdHIw8S8 |
|  75 | otrs | x.x.x.193:35872 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('s4J0Ftj3vw0GPgYipdDhlXA |
|  76 | otrs | x.x.x.193:35873 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('8vXpYe8ODFWSF9vRSKKZGD2 |
|  77 | otrs | x.x.x.193:35874 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('H59AkjnF4eOrLNKcgNjxLwm |
|  78 | otrs | x.x.x.194:59277 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  79 | otrs | x.x.x.193:35926 | otrs | Query      | 1054 | query end      | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('ef0xpmmK4bnALbfUZJozDjH |
|  80 | otrs | x.x.x.194:59318 | otrs | Query      | 1054 | Sending data   | SELECT time_unit FROM time_accounting WHERE ticket_id = '29'                                         |
|  81 | otrs | x.x.x.193:35935 | otrs | Query      | 1054 | Sending data   | SELECT article_key, article_value
            FROM article_flag
            WHERE article_id = '74'
 |
|  82 | otrs | x.x.x.194:59471 | otrs | Query      | 1054 | updating       | DELETE FROM sessions WHERE session_id = 'b8poqUCiKHHtkw6OoIxPwnRvke1UKBVf'                           |
|  83 | otrs | x.x.x.194:59507 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  84 | otrs | x.x.x.193:36318 | otrs | Query      | 1054 | query end      | DELETE FROM sessions
                    WHERE session_id = 'p8zgUGzIIK5AkAAhxiWm22H3ytyjFuOD'
      |
|  85 | otrs | x.x.x.193:36319 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  86 | otrs | x.x.x.194:59608 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('NGnh62ueimcXD3y8l0uYukd |
|  87 | otrs | x.x.x.193:36455 | otrs | Query      | 1054 | statistics     | SELECT sa.ticket_id, sa.a_from, sa.a_to, sa.a_cc, sa.a_subject,
            sa.a_reply_to, sa.a_mess |
|  88 | otrs | x.x.x.194:59614 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('23JgYCl30lr7LPDVwJruMPE |
|  89 | otrs | x.x.x.193:36496 | otrs | Query      | 1054 | query end      | DELETE FROM sessions
                    WHERE session_id = 'WPycg7NUbohxJg9S3iHwXLDnqidM6MRu'
      |
|  90 | otrs | x.x.x.194:59841 | otrs | Query      | 1054 | Sending data   | SELECT target_object_id, target_key, type_id
            FROM link_relation
            WHERE source |
|  91 | otrs | x.x.x.193:36735 | otrs | Query      | 1054 | query end      | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('78q037jbh7XMAAVdywkCpRY |
|  92 | otrs | x.x.x.193:36736 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  93 | otrs | x.x.x.194:59951 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  94 | otrs | x.x.x.193:36901 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('jasbONd1Q4NzE5YtkRbdHjb |
|  95 | otrs | x.x.x.194:60020 | otrs | Query      | 1054 | Sending data   | SELECT id, name
        FROM standard_template WHERE valid_id IN (1) AND template_type = 'Create'    |
|  96 | otrs | x.x.x.193:36918 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  97 | otrs | x.x.x.194:60053 | otrs | Query      | 1054 | Sending data   | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  98 | otrs | x.x.x.193:36946 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  99 | otrs | x.x.x.194:60098 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('WEl0RzmhxPchbJTzT9oA8Nw |
| 100 | otrs | x.x.x.193:37101 | otrs | Query      | 1054 | Sending data   | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
| 101 | otrs | x.x.x.193:37215 | otrs | Query      | 1054 | Sending data   | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
| 102 | otrs | x.x.x.194:60392 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 103 | otrs | x.x.x.193:37227 | otrs | Query      | 1054 | Sending data   | SELECT user_id, create_time, create_by, change_time, change_by
            FROM ticket_watcher
      |
| 104 | otrs | x.x.x.194:60467 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 105 | otrs | x.x.x.193:37254 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('bErwvzvSCTcsHQIJ1KSK34s |
| 106 | otrs | x.x.x.193:37256 | otrs | Query      | 1054 | Sending data   | SELECT id, name FROM article_type WHERE valid_id IN (1)                                              |
| 107 | otrs | x.x.x.194:60507 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('yWvY3fMRSTSCGtOo4o0yp4x |
| 108 | otrs | x.x.x.194:60527 | otrs | Query      | 1054 | NULL           | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 109 | otrs | x.x.x.194:60541 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 110 | otrs | x.x.x.193:37269 | otrs | Query      | 1054 | statistics     | SELECT sa.ticket_id, sa.a_from, sa.a_to, sa.a_cc, sa.a_subject,
            sa.a_reply_to, sa.a_mess |
| 111 | otrs | x.x.x.193:37290 | otrs | Query      | 1054 | Sending data   | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id  WHERE 1=1 A |
| 112 | otrs | x.x.x.194:60976 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 113 | otrs | x.x.x.194:32796 | otrs | Query      | 1054 | Sending data   | SELECT article_key, article_value
            FROM article_flag
            WHERE article_id = '146' |
| 114 | otrs | x.x.x.193:37543 | otrs | Query      | 1054 | Sending data   | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
| 115 | otrs | x.x.x.194:33195 | otrs | Query      | 1054 | query end      | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('jcq2SvQurhRc2m0Az8hTS0D |
| 116 | otrs | x.x.x.193:37970 | otrs | Query      | 1054 | query end      | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('CYGjL6fvcSfxJuUrlU9YIBH |
| 117 | otrs | x.x.x.193:38284 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 118 | otrs | x.x.x.194:34049 | otrs | Query      | 1054 | statistics     | SELECT sa.ticket_id, sa.a_from, sa.a_to, sa.a_cc, sa.a_subject,
            sa.a_reply_to, sa.a_mess |
| 123 | otrs | x.x.x.194:34082 | otrs | Query      | 1054 | Sending data   | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
| 124 | otrs | x.x.x.194:34090 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 125 | otrs | x.x.x.194:34121 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 126 | otrs | x.x.x.193:38731 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('cmFDEih9y609HjWtRyRli22 |
| 127 | otrs | x.x.x.194:34164 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('caNFkBCwfseWWtYruKHpLBh |
| 128 | otrs | x.x.x.194:34184 | otrs | Query      | 1054 | Sending data   | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
| 129 | otrs | x.x.x.194:34232 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 130 | otrs | x.x.x.193:38983 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('GCiOJw97mcDoDb1ZUWsvYjK |
| 131 | otrs | x.x.x.193:39319 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('ElGk9OJ8soeWUuaHnDmYbra |
| 132 | otrs | x.x.x.193:39393 | otrs | Query      | 1054 | Sending data   | SELECT id, name FROM article_type WHERE valid_id IN (1)                                              |
| 133 | otrs | x.x.x.194:34741 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 134 | otrs | x.x.x.193:39631 | otrs | Query      | 1054 | Sending data   | SELECT article.id, article_flag.article_key, article_flag.article_value
            FROM article_fla |
| 135 | otrs | x.x.x.194:34879 | otrs | Query      | 1054 | Sending data   | SELECT id, name
        FROM standard_template WHERE valid_id IN (1) AND template_type = 'Create'    |
| 136 | otrs | x.x.x.194:34904 | otrs | Query      | 1054 | statistics     | SELECT sa.ticket_id, sa.a_from, sa.a_to, sa.a_cc, sa.a_subject,
            sa.a_reply_to, sa.a_mess |
| 137 | otrs | x.x.x.194:34916 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 138 | otrs | x.x.x.194:35156 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('fPyyVUsjjs6chUGW3TV5L4U |
| 139 | otrs | x.x.x.194:35334 | otrs | Query      | 1054 | Sending data   | SELECT user_id, create_time, create_by, change_time, change_by
            FROM ticket_watcher
      |
| 140 | otrs | x.x.x.193:40425 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('0MFnfxE6m5AYiJikamD0T0A |
| 141 | otrs | x.x.x.194:35589 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('LJ1xJZNFapeoi3sIaGOUU8h |
| 142 | otrs | x.x.x.193:40937 | otrs | Query      | 1054 | Sending data   | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
| 143 | otrs | x.x.x.194:35922 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('ymSIi663k3GWgV9VsAnw7xd |
| 144 | otrs | x.x.x.193:41027 | otrs | Query      | 1054 | Sending data   | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
| 145 | otrs | x.x.x.193:41092 | otrs | Query      | 1054 | Sending data   | SELECT id, name FROM article_type WHERE valid_id IN (1)                                              |
| 146 | otrs | x.x.x.193:41937 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 147 | otrs | x.x.x.194:37150 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('q68z3oTpMoaiyq9mr1MypcH |
| 148 | otrs | x.x.x.193:42310 | otrs | Query      | 1054 | update         | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('dRwuahGfWPoKQ8fGs1AoDNG |
| 149 | otrs | x.x.x.194:37555 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 150 | otrs | x.x.x.193:42825 | otrs | Query      | 1054 | Sorting result | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 159 | otrs | x.x.x.194:51548 | otrs | Query      | 1054 | NULL           | select count(*) from customer_user                                                                   |
| 161 | otrs | x.x.x.193:56256 | otrs | Query      |  744 | NULL           | SELECT process_host, process_name, process_id, process_create, process_change FROM process_id WHERE  |
| 163 | otrs | x.x.x.194:51683 | otrs | Query      |  493 | NULL           | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket',' |
| 164 | otrs | x.x.x.193:56329 | otrs | Query      |  444 | Opening tables | SELECT session_id, data_key, data_value
            FROM sessions
            WHERE data_key = 'User |
| 165 | root | localhost        | otrs | Field List |  339 | Opening tables |                                                                                                      |
| 176 | root | localhost        | otrs | Field List |  148 | Opening tables |                                                                                                      |
| 177 | otrs | x.x.x.193:56376 | otrs | Query      |  144 | Opening tables | SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
            FROM ticket st, queue sq
             |
| 178 | otrs | x.x.x.193:56377 | otrs | Query      |  144 | Opening tables | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st INNER JOIN queue sq ON sq.id = st.q |
| 179 | otrs | x.x.x.193:56378 | otrs | Query      |  144 | Opening tables | SELECT process_host, process_name, process_id, process_create, process_change FROM process_id WHERE  |
| 180 | root | localhost        | otrs | Field List |   85 | Opening tables |                                                                                                      |
| 182 | root | localhost        | NULL | Query      |    0 | NULL           | show processlist                                                                                     |
+-----+------+------------------+------+------------+------+----------------+------------------------------------------------------------------------------------------------------+

---

# mysql -u root -p -e 'show engine innodb status\G;'
// no response; interrupted with ctrl+c

---

# mysql -u root -p -e 'show engine innodb mutex;'
+--------+------------------------+---------------+
| Type   | Name                   | Status        |
+--------+------------------------+---------------+
| InnoDB | log0log.c:882          | os_waits=7    |
| InnoDB | log0log.c:878          | os_waits=1284 |
| InnoDB | buf0buf.c:1188         | os_waits=1    |
| InnoDB | buf0buf.c:1188         | os_waits=2    |
| InnoDB | buf0buf.c:1188         | os_waits=2    |
| InnoDB | buf0buf.c:1188         | os_waits=1    |
| InnoDB | buf0buf.c:1188         | os_waits=2    |
| InnoDB | buf0buf.c:1188         | os_waits=6    |
| InnoDB | fil0fil.c:1645         | os_waits=13   |
| InnoDB | srv0srv.c:1024         | os_waits=113  |
| InnoDB | combined buf0buf.c:937 | os_waits=2    |
| InnoDB | fil0fil.c:1303         | os_waits=9    |
| InnoDB | dict0dict.c:1879       | os_waits=132  |
| InnoDB | dict0dict.c:1879       | os_waits=37   |
| InnoDB | dict0dict.c:1879       | os_waits=97   |
| InnoDB | dict0dict.c:754        | os_waits=14   |
| InnoDB | dict0dict.c:754        | os_waits=21   |
| InnoDB | dict0dict.c:754        | os_waits=41   |
| InnoDB | log0log.c:940          | os_waits=54   |
| InnoDB | btr0sea.c:178          | os_waits=82   |
| InnoDB | combined buf0buf.c:938 | os_waits=99   |
+--------+------------------------+---------------+

---

Morning, next day (more cron & backup & maintenace tasks where fired at night):

# mysql -u root -p -e 'show processlist;'
+-----+------------------+------------------+-------+------------+-------+------------------------------+------------------------------------------------------------------------------------------------------+
| Id  | User             | Host             | db    | Command    | Time  | State                        | Info                                                                                                 |
+-----+------------------+------------------+-------+------------+-------+------------------------------+------------------------------------------------------------------------------------------------------+
|  40 | otrs             | x.x.x.193:34667 | otrs  | Query      | 53802 | Sending data                 | SELECT id, name
        FROM standard_template WHERE valid_id IN (1) AND template_type = 'Create'    |
|  41 | otrs             | x.x.x.194:58120 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  42 | otrs             | x.x.x.193:35083 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('4yXxGJQDZMRYn2Zi6Hl5EvP |
|  46 | otrs             | x.x.x.194:58224 | otrs  | Query      | 53802 | updating                     | DELETE FROM sessions WHERE session_id = 'RroLPpnyhoffOLTqRKge8ujkx6zrnl1P'                           |
|  48 | otrs             | x.x.x.193:35222 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('BNxvLpmOasFUoQVmqYyAXt3 |
|  50 | otrs             | x.x.x.194:58253 | otrs  | Query      | 53802 | updating                     | DELETE FROM sessions WHERE session_id = 'MEb7L0MCa57kuKUeFHs4STDEGpVX3xfF'                           |
|  51 | otrs             | x.x.x.194:58280 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  52 | otrs             | x.x.x.193:35249 | otrs  | Query      | 53802 | Sending data                 | SELECT article.id, article_flag.article_key, article_flag.article_value
            FROM article_fla |
|  54 | otrs             | x.x.x.194:58369 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('85ZQCQlO5G8TItzHS7146Gw |
|  55 | otrs             | x.x.x.193:35269 | otrs  | Query      | 53802 | Sending data                 | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
|  56 | otrs             | x.x.x.194:58385 | otrs  | Query      | 53802 | statistics                   | SELECT sa.ticket_id, sa.a_from, sa.a_to, sa.a_cc, sa.a_subject,
            sa.a_reply_to, sa.a_mess |
|  57 | otrs             | x.x.x.193:35295 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('48UaXSroOSz1ubD5uTSFqAD |
|  59 | otrs             | x.x.x.194:58417 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('VjB45wuExbXdhoMrpRXy58Q |
|  60 | otrs             | x.x.x.193:35399 | otrs  | Query      | 53802 | Sending data                 | SELECT id, name FROM article_type WHERE valid_id IN (1)                                              |
|  61 | otrs             | x.x.x.194:58433 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('ctIPmqvZeRgg0uXXinkhZvy |
|  62 | otrs             | x.x.x.193:35425 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  63 | otrs             | x.x.x.194:58471 | otrs  | Query      | 53802 | Sending data                 | SELECT user_id, create_time, create_by, change_time, change_by
            FROM ticket_watcher
      |
|  64 | otrs             | x.x.x.193:35453 | otrs  | Query      | 53802 | Sending data                 | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
|  65 | otrs             | x.x.x.194:58505 | otrs  | Query      | 53802 | Sending data                 | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
|  66 | otrs             | x.x.x.193:35533 | otrs  | Query      | 53802 | statistics                   | SELECT sa.ticket_id, sa.a_from, sa.a_to, sa.a_cc, sa.a_subject,
            sa.a_reply_to, sa.a_mess |
|  67 | otrs             | x.x.x.193:35541 | otrs  | Query      | 53802 | Sending data                 | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
|  68 | otrs             | x.x.x.194:58605 | otrs  | Query      | 53802 | Sending data                 | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
|  69 | otrs             | x.x.x.193:35621 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('g1WxMKdGY7tKScvm6jFkOZ2 |
|  70 | otrs             | x.x.x.194:58840 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('1U5AFNeWGUzE8MR3U8EULxf |
|  71 | otrs             | x.x.x.193:35622 | otrs  | Query      | 53802 | statistics                   | SELECT sa.ticket_id, sa.a_from, sa.a_to, sa.a_cc, sa.a_subject,
            sa.a_reply_to, sa.a_mess |
|  72 | otrs             | x.x.x.193:35752 | otrs  | Query      | 53802 | Sending data                 | SELECT id, name FROM article_type WHERE valid_id IN (1)                                              |
|  73 | otrs             | x.x.x.194:59162 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  74 | otrs             | x.x.x.194:59246 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('7HxmniuRIEpWizCqdHIw8S8 |
|  75 | otrs             | x.x.x.193:35872 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('s4J0Ftj3vw0GPgYipdDhlXA |
|  76 | otrs             | x.x.x.193:35873 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('8vXpYe8ODFWSF9vRSKKZGD2 |
|  77 | otrs             | x.x.x.193:35874 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('H59AkjnF4eOrLNKcgNjxLwm |
|  78 | otrs             | x.x.x.194:59277 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  79 | otrs             | x.x.x.193:35926 | otrs  | Query      | 53802 | query end                    | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('ef0xpmmK4bnALbfUZJozDjH |
|  80 | otrs             | x.x.x.194:59318 | otrs  | Query      | 53802 | Sending data                 | SELECT time_unit FROM time_accounting WHERE ticket_id = '29'                                         |
|  81 | otrs             | x.x.x.193:35935 | otrs  | Query      | 53802 | Sending data                 | SELECT article_key, article_value
            FROM article_flag
            WHERE article_id = '74'
 |
|  82 | otrs             | x.x.x.194:59471 | otrs  | Query      | 53802 | updating                     | DELETE FROM sessions WHERE session_id = 'b8poqUCiKHHtkw6OoIxPwnRvke1UKBVf'                           |
|  83 | otrs             | x.x.x.194:59507 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  84 | otrs             | x.x.x.193:36318 | otrs  | Query      | 53802 | query end                    | DELETE FROM sessions
                    WHERE session_id = 'p8zgUGzIIK5AkAAhxiWm22H3ytyjFuOD'
      |
|  85 | otrs             | x.x.x.193:36319 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  86 | otrs             | x.x.x.194:59608 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('NGnh62ueimcXD3y8l0uYukd |
|  87 | otrs             | x.x.x.193:36455 | otrs  | Query      | 53802 | statistics                   | SELECT sa.ticket_id, sa.a_from, sa.a_to, sa.a_cc, sa.a_subject,
            sa.a_reply_to, sa.a_mess |
|  88 | otrs             | x.x.x.194:59614 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('23JgYCl30lr7LPDVwJruMPE |
|  89 | otrs             | x.x.x.193:36496 | otrs  | Query      | 53802 | query end                    | DELETE FROM sessions
                    WHERE session_id = 'WPycg7NUbohxJg9S3iHwXLDnqidM6MRu'
      |
|  90 | otrs             | x.x.x.194:59841 | otrs  | Query      | 53802 | Sending data                 | SELECT target_object_id, target_key, type_id
            FROM link_relation
            WHERE source |
|  91 | otrs             | x.x.x.193:36735 | otrs  | Query      | 53802 | query end                    | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('78q037jbh7XMAAVdywkCpRY |
|  92 | otrs             | x.x.x.193:36736 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  93 | otrs             | x.x.x.194:59951 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  94 | otrs             | x.x.x.193:36901 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('jasbONd1Q4NzE5YtkRbdHjb |
|  95 | otrs             | x.x.x.194:60020 | otrs  | Query      | 53802 | Sending data                 | SELECT id, name
        FROM standard_template WHERE valid_id IN (1) AND template_type = 'Create'    |
|  96 | otrs             | x.x.x.193:36918 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  97 | otrs             | x.x.x.194:60053 | otrs  | Query      | 53802 | Sending data                 | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  98 | otrs             | x.x.x.193:36946 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
|  99 | otrs             | x.x.x.194:60098 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('WEl0RzmhxPchbJTzT9oA8Nw |
| 100 | otrs             | x.x.x.193:37101 | otrs  | Query      | 53802 | Sending data                 | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
| 101 | otrs             | x.x.x.193:37215 | otrs  | Query      | 53802 | Sending data                 | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
| 102 | otrs             | x.x.x.194:60392 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 103 | otrs             | x.x.x.193:37227 | otrs  | Query      | 53802 | Sending data                 | SELECT user_id, create_time, create_by, change_time, change_by
            FROM ticket_watcher
      |
| 104 | otrs             | x.x.x.194:60467 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 105 | otrs             | x.x.x.193:37254 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('bErwvzvSCTcsHQIJ1KSK34s |
| 106 | otrs             | x.x.x.193:37256 | otrs  | Query      | 53802 | Sending data                 | SELECT id, name FROM article_type WHERE valid_id IN (1)                                              |
| 107 | otrs             | x.x.x.194:60507 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('yWvY3fMRSTSCGtOo4o0yp4x |
| 108 | otrs             | x.x.x.194:60527 | otrs  | Query      | 53802 | NULL                         | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 109 | otrs             | x.x.x.194:60541 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 110 | otrs             | x.x.x.193:37269 | otrs  | Query      | 53802 | statistics                   | SELECT sa.ticket_id, sa.a_from, sa.a_to, sa.a_cc, sa.a_subject,
            sa.a_reply_to, sa.a_mess |
| 111 | otrs             | x.x.x.193:37290 | otrs  | Query      | 53802 | Sending data                 | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id  WHERE 1=1 A |
| 112 | otrs             | x.x.x.194:60976 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 113 | otrs             | x.x.x.194:32796 | otrs  | Query      | 53802 | Sending data                 | SELECT article_key, article_value
            FROM article_flag
            WHERE article_id = '146' |
| 114 | otrs             | x.x.x.193:37543 | otrs  | Query      | 53802 | Sending data                 | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
| 115 | otrs             | x.x.x.194:33195 | otrs  | Query      | 53802 | query end                    | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('jcq2SvQurhRc2m0Az8hTS0D |
| 116 | otrs             | x.x.x.193:37970 | otrs  | Query      | 53802 | query end                    | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('CYGjL6fvcSfxJuUrlU9YIBH |
| 117 | otrs             | x.x.x.193:38284 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 118 | otrs             | x.x.x.194:34049 | otrs  | Query      | 53802 | statistics                   | SELECT sa.ticket_id, sa.a_from, sa.a_to, sa.a_cc, sa.a_subject,
            sa.a_reply_to, sa.a_mess |
| 123 | otrs             | x.x.x.194:34082 | otrs  | Query      | 53802 | Sending data                 | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
| 124 | otrs             | x.x.x.194:34090 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 125 | otrs             | x.x.x.194:34121 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 126 | otrs             | x.x.x.193:38731 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('cmFDEih9y609HjWtRyRli22 |
| 127 | otrs             | x.x.x.194:34164 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('caNFkBCwfseWWtYruKHpLBh |
| 128 | otrs             | x.x.x.194:34184 | otrs  | Query      | 53802 | Sending data                 | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
| 129 | otrs             | x.x.x.194:34232 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 130 | otrs             | x.x.x.193:38983 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('GCiOJw97mcDoDb1ZUWsvYjK |
| 131 | otrs             | x.x.x.193:39319 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('ElGk9OJ8soeWUuaHnDmYbra |
| 132 | otrs             | x.x.x.193:39393 | otrs  | Query      | 53802 | Sending data                 | SELECT id, name FROM article_type WHERE valid_id IN (1)                                              |
| 133 | otrs             | x.x.x.194:34741 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 134 | otrs             | x.x.x.193:39631 | otrs  | Query      | 53802 | Sending data                 | SELECT article.id, article_flag.article_key, article_flag.article_value
            FROM article_fla |
| 135 | otrs             | x.x.x.194:34879 | otrs  | Query      | 53802 | Sending data                 | SELECT id, name
        FROM standard_template WHERE valid_id IN (1) AND template_type = 'Create'    |
| 136 | otrs             | x.x.x.194:34904 | otrs  | Query      | 53802 | statistics                   | SELECT sa.ticket_id, sa.a_from, sa.a_to, sa.a_cc, sa.a_subject,
            sa.a_reply_to, sa.a_mess |
| 137 | otrs             | x.x.x.194:34916 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 138 | otrs             | x.x.x.194:35156 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('fPyyVUsjjs6chUGW3TV5L4U |
| 139 | otrs             | x.x.x.194:35334 | otrs  | Query      | 53802 | Sending data                 | SELECT user_id, create_time, create_by, change_time, change_by
            FROM ticket_watcher
      |
| 140 | otrs             | x.x.x.193:40425 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('0MFnfxE6m5AYiJikamD0T0A |
| 141 | otrs             | x.x.x.194:35589 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('LJ1xJZNFapeoi3sIaGOUU8h |
| 142 | otrs             | x.x.x.193:40937 | otrs  | Query      | 53802 | Sending data                 | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
| 143 | otrs             | x.x.x.194:35922 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('ymSIi663k3GWgV9VsAnw7xd |
| 144 | otrs             | x.x.x.193:41027 | otrs  | Query      | 53802 | Sending data                 | SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN queue sq ON sq.id = st.queue_id INNER JOIN t |
| 145 | otrs             | x.x.x.193:41092 | otrs  | Query      | 53802 | Sending data                 | SELECT id, name FROM article_type WHERE valid_id IN (1)                                              |
| 146 | otrs             | x.x.x.193:41937 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 147 | otrs             | x.x.x.194:37150 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('q68z3oTpMoaiyq9mr1MypcH |
| 148 | otrs             | x.x.x.193:42310 | otrs  | Query      | 53802 | update                       | INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('dRwuahGfWPoKQ8fGs1AoDNG |
| 149 | otrs             | x.x.x.194:37555 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 150 | otrs             | x.x.x.193:42825 | otrs  | Query      | 53802 | Sorting result               | SELECT id, data_key, data_value, serialized
            FROM sessions
            WHERE session_id = |
| 159 | otrs             | x.x.x.194:51548 | otrs  | Query      | 53802 | NULL                         | select count(*) from customer_user                                                                   |
| 161 | otrs             | x.x.x.193:56256 | otrs  | Query      | 53492 | NULL                         | SELECT process_host, process_name, process_id, process_create, process_change FROM process_id WHERE  |
| 163 | otrs             | x.x.x.194:51683 | otrs  | Query      | 53241 | NULL                         | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket',' |
| 164 | otrs             | x.x.x.193:56329 | otrs  | Query      | 53192 | Opening tables               | SELECT session_id, data_key, data_value
            FROM sessions
            WHERE data_key = 'User |
| 165 | root             | localhost        | otrs  | Field List | 53087 | Opening tables               |                                                                                                      |
| 176 | root             | localhost        | otrs  | Field List | 52896 | Opening tables               |                                                                                                      |
| 177 | otrs             | x.x.x.193:56376 | otrs  | Query      | 52892 | Opening tables               | SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
            FROM ticket st, queue sq
             |
| 178 | otrs             | x.x.x.193:56377 | otrs  | Query      | 52892 | Opening tables               | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st INNER JOIN queue sq ON sq.id = st.q |
| 179 | otrs             | x.x.x.193:56378 | otrs  | Query      | 52892 | Opening tables               | SELECT process_host, process_name, process_id, process_create, process_change FROM process_id WHERE  |
| 180 | root             | localhost        | otrs  | Field List | 52833 | Opening tables               |                                                                                                      |
| 184 | root             | localhost        | NULL  | Killed     | 52711 | NULL                         | show engine innodb status                                                                            |
| 187 | root             | localhost        | NULL  | Killed     | 52536 | NULL                         | show engine innodb status                                                                            |
| 192 | root             | localhost        | otrs  | Field List | 52299 | Opening tables               |                                                                                                      |
| 193 | otrs             | x.x.x.193:56476 | otrs  | Query      | 52293 | Opening tables               | SELECT process_host, process_name, process_id, process_create, process_change FROM process_id WHERE  |
| 195 | root             | localhost        | otrs  | Field List | 52209 | Opening tables               |                                                                                                      |
| 197 | otrs             | x.x.x.194:51872 | otrs  | Query      | 51992 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket',' |
| 199 | otrs             | x.x.x.193:56571 | otrs  | Query      | 51692 | Opening tables               | SELECT process_host, process_name, process_id, process_create, process_change FROM process_id WHERE  |
| 200 | otrs             | x.x.x.193:56572 | otrs  | Query      | 51693 | Opening tables               | SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
            FROM ticket st, queue sq
             |
| 201 | otrs             | x.x.x.193:56573 | otrs  | Query      | 51692 | Opening tables               | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st INNER JOIN queue sq ON sq.id = st.q |
| 204 | otrs             | x.x.x.193:56671 | otrs  | Query      | 51092 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 206 | otrs             | x.x.x.193:56721 | otrs  | Query      | 50793 | Opening tables               | SELECT process_host, process_name, process_id, process_create, process_change FROM process_id WHERE  |
| 208 | otrs             | x.x.x.193:56768 | otrs  | Query      | 50492 | Opening tables               | SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
            FROM ticket st, queue sq
             |
| 209 | otrs             | x.x.x.193:56769 | otrs  | Query      | 50492 | Opening tables               | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st INNER JOIN queue sq ON sq.id = st.q |
| 210 | otrs             | x.x.x.193:56770 | otrs  | Query      | 50492 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 215 | otrs             | x.x.x.193:56870 | otrs  | Query      | 49892 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 218 | otrs             | x.x.x.193:56966 | otrs  | Query      | 49292 | Opening tables               | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st INNER JOIN queue sq ON sq.id = st.q |
| 219 | otrs             | x.x.x.193:56967 | otrs  | Query      | 49292 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 220 | otrs             | x.x.x.193:56968 | otrs  | Query      | 49292 | Opening tables               | SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
            FROM ticket st, queue sq
             |
| 223 | otrs             | x.x.x.193:57067 | otrs  | Query      | 48692 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 226 | otrs             | x.x.x.193:57163 | otrs  | Query      | 48092 | Opening tables               | SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
            FROM ticket st, queue sq
             |
| 227 | otrs             | x.x.x.193:57164 | otrs  | Query      | 48092 | Opening tables               | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st INNER JOIN queue sq ON sq.id = st.q |
| 228 | otrs             | x.x.x.193:57165 | otrs  | Query      | 48092 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 231 | otrs             | x.x.x.193:57264 | otrs  | Query      | 47492 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 233 | otrs             | x.x.x.193:57314 | otrs  | Query      | 47193 | Opening tables               | SELECT process_host, process_name, process_id, process_create, process_change FROM process_id WHERE  |
| 235 | otrs             | x.x.x.193:57361 | otrs  | Query      | 46892 | Opening tables               | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st INNER JOIN queue sq ON sq.id = st.q |
| 236 | otrs             | x.x.x.193:57362 | otrs  | Query      | 46892 | Opening tables               | SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
            FROM ticket st, queue sq
             |
| 237 | otrs             | x.x.x.193:57363 | otrs  | Query      | 46892 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 240 | otrs             | x.x.x.193:57462 | otrs  | Query      | 46292 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 242 | otrs             | x.x.x.193:57512 | otrs  | Query      | 45993 | Opening tables               | SELECT session_id, data_key, data_value
            FROM sessions
            WHERE data_key = 'User |
| 245 | otrs             | x.x.x.193:57560 | otrs  | Query      | 45692 | Opening tables               | SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
            FROM ticket st, queue sq
             |
| 244 | otrs             | x.x.x.193:57559 | otrs  | Query      | 45692 | Opening tables               | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st INNER JOIN queue sq ON sq.id = st.q |
| 246 | otrs             | x.x.x.193:57561 | otrs  | Query      | 45692 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 249 | otrs             | x.x.x.193:57660 | otrs  | Query      | 45093 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 252 | otrs             | x.x.x.193:57756 | otrs  | Query      | 44492 | Opening tables               | SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
            FROM ticket st, queue sq
             |
| 253 | otrs             | x.x.x.193:57757 | otrs  | Query      | 44492 | Opening tables               | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st INNER JOIN queue sq ON sq.id = st.q |
| 254 | otrs             | x.x.x.193:57758 | otrs  | Query      | 44492 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 257 | otrs             | x.x.x.193:57857 | otrs  | Query      | 43892 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 259 | otrs             | x.x.x.193:57907 | otrs  | Query      | 43593 | Opening tables               | SELECT process_host, process_name, process_id, process_create, process_change FROM process_id WHERE  |
| 261 | otrs             | x.x.x.193:57954 | otrs  | Query      | 43292 | Opening tables               | SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
            FROM ticket st, queue sq
             |
| 262 | otrs             | x.x.x.193:57955 | otrs  | Query      | 43292 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 263 | otrs             | x.x.x.193:57956 | otrs  | Query      | 43292 | Opening tables               | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st INNER JOIN queue sq ON sq.id = st.q |
| 266 | otrs             | x.x.x.193:58055 | otrs  | Query      | 42692 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 269 | otrs             | x.x.x.193:58151 | otrs  | Query      | 42092 | Opening tables               | SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
            FROM ticket st, queue sq
             |
| 270 | otrs             | x.x.x.193:58152 | otrs  | Query      | 42092 | Opening tables               | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st INNER JOIN queue sq ON sq.id = st.q |
| 271 | otrs             | x.x.x.193:58153 | otrs  | Query      | 42092 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 274 | otrs             | x.x.x.193:58252 | otrs  | Query      | 41492 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 277 | otrs             | x.x.x.193:58348 | otrs  | Query      | 40892 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 278 | otrs             | x.x.x.193:58349 | otrs  | Query      | 40892 | Opening tables               | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st INNER JOIN queue sq ON sq.id = st.q |
| 279 | otrs             | x.x.x.193:58350 | otrs  | Query      | 40892 | Opening tables               | SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
            FROM ticket st, queue sq
             |
| 282 | otrs             | x.x.x.193:58449 | otrs  | Query      | 40292 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 284 | otrs             | x.x.x.193:58499 | otrs  | Query      | 39993 | Opening tables               | SELECT process_host, process_name, process_id, process_create, process_change FROM process_id WHERE  |
| 286 | otrs             | x.x.x.193:58546 | otrs  | Query      | 39692 | Opening tables               | SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
            FROM ticket st, queue sq
             |
| 287 | otrs             | x.x.x.193:58547 | otrs  | Query      | 39692 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 288 | otrs             | x.x.x.193:58548 | otrs  | Query      | 39692 | Opening tables               | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st INNER JOIN queue sq ON sq.id = st.q |
| 291 | otrs             | x.x.x.193:58647 | otrs  | Query      | 39092 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 293 | otrs             | x.x.x.193:58697 | otrs  | Query      | 38793 | Opening tables               | SELECT session_id, data_key, data_value
            FROM sessions
            WHERE data_key = 'User |
| 295 | otrs             | x.x.x.193:58744 | otrs  | Query      | 38492 | Opening tables               | SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
            FROM ticket st, queue sq
             |
| 296 | otrs             | x.x.x.193:58745 | otrs  | Query      | 38492 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 297 | otrs             | x.x.x.193:58746 | otrs  | Query      | 38492 | Opening tables               | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st INNER JOIN queue sq ON sq.id = st.q |
| 300 | otrs             | x.x.x.193:58845 | otrs  | Query      | 37892 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 303 | otrs             | x.x.x.193:58941 | otrs  | Query      | 37292 | Opening tables               | SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
            FROM ticket st, queue sq
             |
| 304 | otrs             | x.x.x.193:58942 | otrs  | Query      | 37292 | Opening tables               | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st INNER JOIN queue sq ON sq.id = st.q |
| 305 | otrs             | x.x.x.193:58943 | otrs  | Query      | 37292 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 308 | otrs             | x.x.x.193:59042 | otrs  | Query      | 36692 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 310 | otrs             | x.x.x.193:59092 | otrs  | Query      | 36393 | Opening tables               | SELECT process_host, process_name, process_id, process_create, process_change FROM process_id WHERE  |
| 312 | otrs             | x.x.x.193:59139 | otrs  | Query      | 36092 | Opening tables               | SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
            FROM ticket st, queue sq
             |
| 313 | otrs             | x.x.x.193:59140 | otrs  | Query      | 36092 | Opening tables               | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st INNER JOIN queue sq ON sq.id = st.q |
| 314 | otrs             | x.x.x.193:59141 | otrs  | Query      | 36092 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 317 | otrs             | x.x.x.193:59240 | otrs  | Query      | 35492 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 320 | otrs             | x.x.x.193:59336 | otrs  | Query      | 34892 | Opening tables               | SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
            FROM ticket st, queue sq
             |
| 321 | otrs             | x.x.x.193:59337 | otrs  | Query      | 34892 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 322 | otrs             | x.x.x.193:59338 | otrs  | Query      | 34892 | Opening tables               | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st INNER JOIN queue sq ON sq.id = st.q |
| 325 | otrs             | x.x.x.193:59437 | otrs  | Query      | 34292 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 328 | otrs             | x.x.x.193:59533 | otrs  | Query      | 33692 | Opening tables               | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st INNER JOIN queue sq ON sq.id = st.q |
| 329 | otrs             | x.x.x.193:59534 | otrs  | Query      | 33692 | Opening tables               | SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
            FROM ticket st, queue sq
             |
| 330 | otrs             | x.x.x.193:59535 | otrs  | Query      | 33692 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 333 | otrs             | x.x.x.193:59634 | otrs  | Query      | 33092 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 335 | otrs             | x.x.x.193:59684 | otrs  | Query      | 32793 | Opening tables               | SELECT process_host, process_name, process_id, process_create, process_change FROM process_id WHERE  |
| 337 | otrs             | x.x.x.193:59731 | otrs  | Query      | 32492 | Opening tables               | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st INNER JOIN queue sq ON sq.id = st.q |
| 338 | otrs             | x.x.x.193:59732 | otrs  | Query      | 32492 | Opening tables               | SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
            FROM ticket st, queue sq
             |
| 339 | otrs             | x.x.x.193:59733 | otrs  | Query      | 32492 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 342 | otrs             | x.x.x.193:59832 | otrs  | Query      | 31892 | Opening tables               | SELECT id, name, field_order FROM dynamic_field WHERE valid_id IN (1) AND object_type IN ('Ticket')  |
| 344 | otrs             | x.x.x.193:59882 | otrs  | Query      | 31593 | Opening tables               | SELECT session_id, data_key, data_value
            FROM sessions
            WHERE data_key = 'User |
| 346 | otrs             | x.x.x.193:59929 | otrs  | Query      | 31292 | Opening tables               | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st INNER JOIN queue sq ON sq.id = st.q |
| 347 | otrs             | x.x.x.193:59930 | otrs  | Query      | 31290 | NULL                         | SELECT id, name FROM valid                                                                           |
| 348 | otrs             | x.x.x.193:59931 | otrs  | Query      | 31292 | Opening tables               | SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
            FROM ticket st, queue sq
             |
| 351 | otrs             | x.x.x.193:60029 | otrs  | Query      | 30690 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 354 | otrs             | x.x.x.193:60124 | otrs  | Query      | 30092 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 355 | otrs             | x.x.x.193:60125 | otrs  | Query      | 30091 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 356 | otrs             | x.x.x.193:60126 | otrs  | Query      | 30091 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 359 | otrs             | x.x.x.193:60225 | otrs  | Query      | 29490 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 361 | otrs             | x.x.x.193:60274 | otrs  | Query      | 29193 | Opening tables               | SELECT process_host, process_name, process_id, process_create, process_change FROM process_id WHERE  |
| 363 | otrs             | x.x.x.193:60321 | otrs  | Query      | 28890 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 364 | otrs             | x.x.x.193:60322 | otrs  | Query      | 28891 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 365 | otrs             | x.x.x.193:60323 | otrs  | Query      | 28892 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 368 | otrs             | x.x.x.193:60422 | otrs  | Query      | 28290 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 371 | otrs             | x.x.x.193:60517 | otrs  | Query      | 27690 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 372 | otrs             | x.x.x.193:60518 | otrs  | Query      | 27690 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 373 | otrs             | x.x.x.193:60519 | otrs  | Query      | 27691 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 374 | root             | localhost        | mysql | Sleep      | 27633 |                              | NULL                                                                                                 |
| 375 | root             | localhost        | mysql | Query      | 27633 | NULL                         | FLUSH LOGS                                                                                           |
| 378 | otrs             | x.x.x.193:60619 | otrs  | Query      | 27090 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 381 | otrs             | x.x.x.193:60714 | otrs  | Query      | 26491 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 382 | otrs             | x.x.x.193:60715 | otrs  | Query      | 26492 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 383 | otrs             | x.x.x.193:60716 | otrs  | Query      | 26491 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 386 | otrs             | x.x.x.193:60815 | otrs  | Query      | 25890 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 388 | otrs             | x.x.x.193:60864 | otrs  | Query      | 25593 | Opening tables               | SELECT process_host, process_name, process_id, process_create, process_change FROM process_id WHERE  |
| 391 | otrs             | x.x.x.193:60912 | otrs  | Query      | 25292 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 390 | otrs             | x.x.x.193:60911 | otrs  | Query      | 25290 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 392 | otrs             | x.x.x.193:60913 | otrs  | Query      | 25291 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 395 | otrs             | x.x.x.193:32779 | otrs  | Query      | 24690 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 397 | otrs             | x.x.x.193:32828 | otrs  | Query      | 24393 | Opening tables               | SELECT session_id, data_key, data_value
            FROM sessions
            WHERE data_key = 'User |
| 399 | otrs             | x.x.x.193:32875 | otrs  | Query      | 24091 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 400 | otrs             | x.x.x.193:32876 | otrs  | Query      | 24090 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 401 | otrs             | x.x.x.193:32877 | otrs  | Query      | 24091 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 404 | otrs             | x.x.x.193:32976 | otrs  | Query      | 23490 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 407 | otrs             | x.x.x.193:33071 | otrs  | Query      | 22890 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 408 | otrs             | x.x.x.193:33072 | otrs  | Query      | 22890 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 409 | otrs             | x.x.x.193:33073 | otrs  | Query      | 22891 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 412 | otrs             | x.x.x.193:33172 | otrs  | Query      | 22289 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 414 | otrs             | x.x.x.193:33221 | otrs  | Query      | 21992 | Opening tables               | SELECT process_host, process_name, process_id, process_create, process_change FROM process_id WHERE  |
| 415 | otrs             | x.x.x.193:33222 | otrs  | Query      | 21990 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 418 | otrs             | x.x.x.193:33272 | otrs  | Query      | 21690 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 417 | otrs             | x.x.x.193:33271 | otrs  | Query      | 21690 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 419 | otrs             | x.x.x.193:33273 | otrs  | Query      | 21691 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 422 | otrs             | x.x.x.193:33372 | otrs  | Query      | 21091 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 425 | otrs             | x.x.x.193:33467 | otrs  | Query      | 20491 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 426 | otrs             | x.x.x.193:33468 | otrs  | Query      | 20490 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 427 | otrs             | x.x.x.193:33469 | otrs  | Query      | 20492 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 430 | otrs             | x.x.x.193:33568 | otrs  | Query      | 19890 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 433 | otrs             | x.x.x.193:33663 | otrs  | Query      | 19291 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 434 | otrs             | x.x.x.193:33664 | otrs  | Query      | 19291 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 435 | otrs             | x.x.x.193:33665 | otrs  | Query      | 19292 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 438 | otrs             | x.x.x.193:33764 | otrs  | Query      | 18690 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 440 | otrs             | x.x.x.193:33813 | otrs  | Query      | 18393 | Opening tables               | SELECT process_host, process_name, process_id, process_create, process_change FROM process_id WHERE  |
| 442 | otrs             | x.x.x.193:33860 | otrs  | Query      | 18091 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 443 | otrs             | x.x.x.193:33861 | otrs  | Query      | 18091 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 444 | otrs             | x.x.x.193:33862 | otrs  | Query      | 18092 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 447 | otrs             | x.x.x.193:33961 | otrs  | Query      | 17490 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 449 | otrs             | x.x.x.193:34010 | otrs  | Query      | 17193 | Opening tables               | SELECT session_id, data_key, data_value
            FROM sessions
            WHERE data_key = 'User |
| 451 | otrs             | x.x.x.193:34057 | otrs  | Query      | 16891 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 452 | otrs             | x.x.x.193:34058 | otrs  | Query      | 16891 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 453 | otrs             | x.x.x.193:34059 | otrs  | Query      | 16891 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 454 | root             | localhost        | NULL  | Query      | 16833 | Waiting for query cache lock | FLUSH /*!40101 LOCAL */ TABLES                                                                       |
| 457 | otrs             | x.x.x.193:34158 | otrs  | Query      | 16290 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 460 | otrs             | x.x.x.193:34253 | otrs  | Query      | 15690 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 461 | otrs             | x.x.x.193:34254 | otrs  | Query      | 15692 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 462 | otrs             | x.x.x.193:34255 | otrs  | Query      | 15691 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 465 | otrs             | x.x.x.193:34354 | otrs  | Query      | 15090 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 467 | otrs             | x.x.x.193:34403 | otrs  | Query      | 14793 | Opening tables               | SELECT process_host, process_name, process_id, process_create, process_change FROM process_id WHERE  |
| 469 | otrs             | x.x.x.193:34450 | otrs  | Query      | 14492 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 470 | otrs             | x.x.x.193:34451 | otrs  | Query      | 14490 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 471 | otrs             | x.x.x.193:34452 | otrs  | Query      | 14491 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 474 | otrs             | x.x.x.193:34551 | otrs  | Query      | 13890 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 477 | otrs             | x.x.x.193:34646 | otrs  | Query      | 13291 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 478 | otrs             | x.x.x.193:34647 | otrs  | Query      | 13291 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 479 | otrs             | x.x.x.193:34648 | otrs  | Query      | 13291 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 482 | otrs             | x.x.x.193:34747 | otrs  | Query      | 12690 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 485 | otrs             | x.x.x.193:34842 | otrs  | Query      | 12091 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 486 | otrs             | x.x.x.193:34843 | otrs  | Query      | 12091 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 487 | otrs             | x.x.x.193:34844 | otrs  | Query      | 12092 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 490 | otrs             | x.x.x.193:34949 | otrs  | Query      | 11490 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 492 | otrs             | x.x.x.193:34998 | otrs  | Query      | 11192 | Opening tables               | SELECT process_host, process_name, process_id, process_create, process_change FROM process_id WHERE  |
| 494 | otrs             | x.x.x.193:35045 | otrs  | Query      | 10889 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 495 | otrs             | x.x.x.193:35046 | otrs  | Query      | 10890 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 496 | otrs             | x.x.x.193:35047 | otrs  | Query      | 10891 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 499 | otrs             | x.x.x.193:35146 | otrs  | Query      | 10291 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 501 | debian-sys-maint | localhost        | NULL  | Refresh    | 10231 | NULL                         | NULL                                                                                                 |
| 503 | otrs             | x.x.x.193:35195 | otrs  | Query      |  9993 | Opening tables               | SELECT session_id, data_key, data_value
            FROM sessions
            WHERE data_key = 'User |
| 505 | otrs             | x.x.x.193:35242 | otrs  | Query      |  9690 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 506 | otrs             | x.x.x.193:35243 | otrs  | Query      |  9691 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 507 | otrs             | x.x.x.193:35244 | otrs  | Query      |  9692 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 510 | otrs             | x.x.x.193:35343 | otrs  | Query      |  9090 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 513 | otrs             | x.x.x.193:35438 | otrs  | Query      |  8491 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 514 | otrs             | x.x.x.193:35439 | otrs  | Query      |  8491 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 515 | otrs             | x.x.x.193:35440 | otrs  | Query      |  8492 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 518 | otrs             | x.x.x.193:35539 | otrs  | Query      |  7890 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 520 | otrs             | x.x.x.193:35588 | otrs  | Query      |  7593 | Opening tables               | SELECT process_host, process_name, process_id, process_create, process_change FROM process_id WHERE  |
| 523 | otrs             | x.x.x.193:35636 | otrs  | Query      |  7291 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 522 | otrs             | x.x.x.193:35635 | otrs  | Query      |  7291 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 524 | otrs             | x.x.x.193:35637 | otrs  | Query      |  7292 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 527 | otrs             | x.x.x.193:35736 | otrs  | Query      |  6690 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 530 | otrs             | x.x.x.193:35831 | otrs  | Query      |  6091 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 531 | otrs             | x.x.x.193:35832 | otrs  | Query      |  6091 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 532 | otrs             | x.x.x.193:35833 | otrs  | Query      |  6091 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 535 | otrs             | x.x.x.193:35932 | otrs  | Query      |  5490 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 538 | otrs             | x.x.x.193:36027 | otrs  | Query      |  4891 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 539 | otrs             | x.x.x.193:36028 | otrs  | Query      |  4892 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 540 | otrs             | x.x.x.193:36029 | otrs  | Query      |  4891 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 543 | otrs             | x.x.x.193:36128 | otrs  | Query      |  4290 | Opening tables               | SELECT id, name FROM valid                                                                           |
| 589 | root             | localhost        | NULL  | Query      |     0 | NULL                         | show processlist                                                                                     |
+-----+------------------+------------------+-------+------------+-------+------------------------------+------------------------------------------------------------------------------------------------------+

---

# tail mysql-error.log
151117 16:16:46 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
151117 16:16:46 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
151117 16:16:46 [Note] Server socket created on IP: '0.0.0.0'.
151117 16:16:46 [Note] Event Scheduler: Loaded 0 events
151117 16:16:46 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.46-0+deb7u1-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)
151117 16:20:02 [Warning] IP address 'x.x.x.193' could not be resolved: Name or service not known
151117 16:20:02 [Warning] IP address 'x.x.x.193' could not be resolved: Name or service not known
151117 16:20:02 [Warning] IP address 'x.x.x.193' could not be resolved: Name or service not known
151117 16:25:48 [Warning] IP address 'x.x.x.194' could not be resolved: Name or service not known

---

# ps aux | grep /usr/sbin/mysqld | grep -v grep
mysql     3073  0.0  6.2 13968768 1027636 ?    Sl   Nov17   1:04 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/log/mysql/mysql-error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306

---

# cat /proc/3073/limits
Limit                     Soft Limit           Hard Limit           Units     
Max cpu time              unlimited            unlimited            seconds   
Max file size             unlimited            unlimited            bytes     
Max data size             unlimited            unlimited            bytes     
Max stack size            8388608              unlimited            bytes     
Max core file size        0                    unlimited            bytes     
Max resident set          unlimited            unlimited            bytes     
Max processes             128606               128606               processes
Max open files            2310                 2310                 files     
Max locked memory         65536                65536                bytes     
Max address space         unlimited            unlimited            bytes     
Max file locks            unlimited            unlimited            locks     
Max pending signals       128606               128606               signals   
Max msgqueue size         819200               819200               bytes     
Max nice priority         0                    0                    
Max realtime priority     0                    0                    
Max realtime timeout      unlimited            unlimited            us      

---

Last binary log file update was before "crash":

# mysqlbinlog mysql-bin.000416 | tail -n 50
Warning: mysqlbinlog: unknown variable 'loose-default-character-set=utf8'
BEGIN
/*!*/;
# at 8315436
#151117 16:44:51 server id 1  end_log_pos 8315464     Intvar
SET INSERT_ID=39945/*!*/;
# at 8315464
#151117 16:44:51 server id 1  end_log_pos 8315673     Query    thread_id=84    exec_time=0    error_code=0
SET TIMESTAMP=1447775091/*!*/;
INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('p8zgUGzIIK5AkAAhxiWm22H3ytyjFuOD','UserLastRequest','1447775091','0')
/*!*/;
# at 8315673
#151117 16:44:51 server id 1  end_log_pos 8315700     Xid = 55324
COMMIT/*!*/;
# at 8315700
#151117 16:44:52 server id 1  end_log_pos 8315768     Query    thread_id=91    exec_time=0    error_code=0
SET TIMESTAMP=1447775092/*!*/;
BEGIN
/*!*/;
# at 8315768
#151117 16:44:52 server id 1  end_log_pos 8315796     Intvar
SET INSERT_ID=39946/*!*/;
# at 8315796
#151117 16:44:52 server id 1  end_log_pos 8316005     Query    thread_id=91    exec_time=0    error_code=0
SET TIMESTAMP=1447775092/*!*/;
INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('78q037jbh7XMAAVdywkCpRYfZcCK2ZZr','UserLastRequest','1447775091','0')
/*!*/;
# at 8316005
#151117 16:44:52 server id 1  end_log_pos 8316032     Xid = 55335
COMMIT/*!*/;
# at 8316032
#151117 16:44:52 server id 1  end_log_pos 8316100     Query    thread_id=84    exec_time=0    error_code=0
SET TIMESTAMP=1447775092/*!*/;
BEGIN
/*!*/;
# at 8316100
#151117 16:44:52 server id 1  end_log_pos 8316356     Query    thread_id=84    exec_time=0    error_code=0
SET TIMESTAMP=1447775092/*!*/;
DELETE FROM sessions
                    WHERE session_id = 'p8zgUGzIIK5AkAAhxiWm22H3ytyjFuOD'
                        AND data_key = 'UserLastRequest'
                        AND id <= '39891'
/*!*/;
# at 8316356
#151117 16:44:52 server id 1  end_log_pos 8316383     Xid = 55334
COMMIT/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;

---

pid(3073) = mysqld

/proc/3073# cat stack
[<ffffffff810cab9e>] zone_page_state_add+0x14/0x23
[<ffffffff810713ed>] arch_local_irq_save+0x11/0x17
[<ffffffff810713ed>] arch_local_irq_save+0x11/0x17
[<ffffffff811091d1>] poll_schedule_timeout+0x43/0x5e
[<ffffffff8110a08d>] do_sys_poll+0x2b9/0x347
[<ffffffff81109283>] __pollwait+0x0/0xce
[<ffffffff81109351>] pollwake+0x0/0x52
[<ffffffff81109351>] pollwake+0x0/0x52
[<ffffffff810b9f5e>] get_pageblock_flags_group+0x3a/0x6e
[<ffffffff812c5302>] do_tcp_setsockopt.isra.26+0x5a0/0x5d7
[<ffffffff8102bb5c>] pvclock_clocksource_read+0x42/0xb2
[<ffffffff81040d9c>] select_task_rq_fair+0x3a0/0x667
[<ffffffff8102bb5c>] pvclock_clocksource_read+0x42/0xb2
[<ffffffff81027884>] native_x2apic_icr_write+0x12/0x16
[<ffffffff81027974>] __x2apic_send_IPI_mask+0x93/0xb7
[<ffffffff8103f741>] try_to_wake_up+0x187/0x197
[<ffffffff8106d84a>] wake_futex+0x5d/0x69
[<ffffffff8106d7de>] put_task_struct+0xd/0x1c
[<ffffffff8104c361>] _local_bh_enable_ip.isra.11+0x1e/0x88
[<ffffffff8106ff23>] sys_futex+0x120/0x151
[<ffffffff810fc80b>] fget_light+0x67/0x7b
[<ffffffff8110a1a6>] sys_poll+0x43/0xab
[<ffffffff813562b2>] system_call_fastpath+0x16/0x1b
[<ffffffffffffffff>] 0xffffffffffffffff

/proc/3073# cat status
Name:    mysqld
State:    S (sleeping)
Tgid:    3073
Pid:    3073
PPid:    2312
TracerPid:    0
Uid:    105    105    105    105
Gid:    109    109    109    109
FDSize:    512
Groups:    109
VmPeak:    13968772 kB
VmSize:    13968768 kB
VmLck:           0 kB
VmPin:           0 kB
VmHWM:     1146824 kB
VmRSS:     1027636 kB
VmData:    13918056 kB
VmStk:         136 kB
VmExe:       10732 kB
VmLib:        3776 kB
VmPTE:        2468 kB
VmSwap:           0 kB
Threads:    317
SigQ:    0/128606
SigPnd:    0000000000000000
ShdPnd:    0000000000000000
SigBlk:    0000000000087007
SigIgn:    0000000000001006
SigCgt:    00000001800066e9
CapInh:    0000000000000000
CapPrm:    0000000000000000
CapEff:    0000000000000000
CapBnd:    ffffffffffffffff
Cpus_allowed:    f
Cpus_allowed_list:    0-3
Mems_allowed:    00000000,00000001
Mems_allowed_list:    0
voluntary_ctxt_switches:    863
nonvoluntary_ctxt_switches:    54

/proc/3073/task# ll | wc -l
320

One of mysqld tasks:

/proc/3073/task/10082# cat stack
[<ffffffff8106d776>] futex_wait_queue_me+0xba/0xd5
[<ffffffff8106e356>] futex_wait+0x10c/0x236
[<ffffffff8106e5a7>] futex_wake+0xe9/0xfb
[<ffffffff8106f6ac>] do_futex+0xb5/0x80c
[<ffffffff8103665c>] should_resched+0x5/0x23
[<ffffffff81038139>] set_next_entity+0x32/0x55
[<ffffffff8103adc2>] pick_next_task_fair+0xde/0xf2
[<ffffffff8106ff23>] sys_futex+0x120/0x151
[<ffffffff81066a7d>] do_gettimeofday+0x10/0x30
[<ffffffff8103665c>] should_resched+0x5/0x23
[<ffffffff813562b2>] system_call_fastpath+0x16/0x1b
[<ffffffffffffffff>] 0xffffffffffffffff

/proc/3073/task/10082# cat status
Name:    mysqld
State:    S (sleeping)
Tgid:    3073
Pid:    10082
PPid:    2312
TracerPid:    0
Uid:    105    105    105    105
Gid:    109    109    109    109
FDSize:    512
Groups:    109
VmPeak:    13968772 kB
VmSize:    13968768 kB
VmLck:           0 kB
VmPin:           0 kB
VmHWM:     1146824 kB
VmRSS:     1027636 kB
VmData:    13918056 kB
VmStk:         136 kB
VmExe:       10732 kB
VmLib:        3776 kB
VmPTE:        2468 kB
VmSwap:           0 kB
Threads:    317
SigQ:    0/128606
SigPnd:    0000000000000000
ShdPnd:    0000000000000000
SigBlk:    0000000000087007
SigIgn:    0000000000001006
SigCgt:    00000001800066e9
CapInh:    0000000000000000
CapPrm:    0000000000000000
CapEff:    0000000000000000
CapBnd:    ffffffffffffffff
Cpus_allowed:    f
Cpus_allowed_list:    0-3
Mems_allowed:    00000000,00000001
Mems_allowed_list:    0
voluntary_ctxt_switches:    23
nonvoluntary_ctxt_switches:    9

Other mysqld task:

/proc/3073/task/17391# cat stack
[<ffffffff8106d776>] futex_wait_queue_me+0xba/0xd5
[<ffffffff8106e356>] futex_wait+0x10c/0x236
[<ffffffff8106e5a7>] futex_wake+0xe9/0xfb
[<ffffffff8106f6ac>] do_futex+0xb5/0x80c
[<ffffffff8103665c>] should_resched+0x5/0x23
[<ffffffff81038139>] set_next_entity+0x32/0x55
[<ffffffff8103adc2>] pick_next_task_fair+0xde/0xf2
[<ffffffff8106ff23>] sys_futex+0x120/0x151
[<ffffffff81066a7d>] do_gettimeofday+0x10/0x30
[<ffffffff8103665c>] should_resched+0x5/0x23
[<ffffffff813562b2>] system_call_fastpath+0x16/0x1b
[<ffffffffffffffff>] 0xffffffffffffffff

/proc/3073/task/17391# cat status
Name:    mysqld
State:    S (sleeping)
Tgid:    3073
Pid:    17391
PPid:    2312
TracerPid:    0
Uid:    105    105    105    105
Gid:    109    109    109    109
FDSize:    512
Groups:    109
VmPeak:    13968772 kB
VmSize:    13968768 kB
VmLck:           0 kB
VmPin:           0 kB
VmHWM:     1146824 kB
VmRSS:     1027636 kB
VmData:    13918056 kB
VmStk:         136 kB
VmExe:       10732 kB
VmLib:        3776 kB
VmPTE:        2468 kB
VmSwap:           0 kB
Threads:    317
SigQ:    0/128606
SigPnd:    0000000000000000
ShdPnd:    0000000000000000
SigBlk:    0000000000087007
SigIgn:    0000000000001006
SigCgt:    00000001800066e9
CapInh:    0000000000000000
CapPrm:    0000000000000000
CapEff:    0000000000000000
CapBnd:    ffffffffffffffff
Cpus_allowed:    f
Cpus_allowed_list:    0-3
Mems_allowed:    00000000,00000001
Mems_allowed_list:    0
voluntary_ctxt_switches:    12
nonvoluntary_ctxt_switches:    6

---

This still hangs:

# mysql -u root -p -e 'SHOW ENGINE INNODB STATUS;'

---

/var/log/mysql# mysqladmin debug

/var/log/mysql# tail -n 200 mysql-error.log

lock: 0x7f8bc1ead740:

lock: 0x7f8bc1eac3c0:

lock: 0x7f8bc1eaa610:

lock: 0x7f8bc1ea5b30:

lock: 0x7f8bc1ea10d0:

lock: 0x7f8bc1e9c090:

lock: 0x7f8bc1e8db50: read
read      : 0x7f8bc1e92c98 (111:2); 0x7f88780279b8 (128:2); 0x7f886c10d258 (136:2); 0x7f8bc2aceb18 (66:2); 0x7f8bc2ae3c38 (110:2); 0x7f886c129f68 (101:2); 0x7f886c36f158 (68:2); 0x7f8bc316e438 (71:2); 0x7f8878514818 (55:2); 0x7f887852e538 (142:2); 0x7f8bc3188708 (114:2); 0x7f8878759438 (123:2); 0x7f887878cc18 (87:2); 0x7f886cc1e4c8 (56:2); 0x7f886ce43a18 (144:2); 0x7f88787bec28 (118:2); 0x7f88787c7f68 (100:2); 0x7f886ce5aaf8 (64:2); 0x7f8bc37ffe98 (65:2); 0x7f886ce72bc8 (67:2);

lock: 0x7f8bc1e8a0b0:

lock: 0x7f8bc1e7d740:

lock: 0x7f8bc1e79ae0:

lock: 0x7f8bc1e6fa70: read
read      : 0x7f8bc1e6bea8 (135:2); 0x7f8bc37f86e8 (95:2); 0x7f8bc3818c28 (40:2);

lock: 0x7f8bc1e60420:

lock: 0x7f8bc1e5fc40:

lock: 0x7f8bc1e5b4f0:

lock: 0x7f8bc1e56dc0:

lock: 0x7f8bc1c1c040:

lock: 0x7f8bc1c0a2a0:

lock: 0x7f8bc1c204d0:

lock: 0x7f8bc1c1ffc0:

lock: 0x7f8bc1c03110:

lock: 0x7f8bc1bf7420:

lock: 0x7f8bc1bf6e10:

lock: 0x7f8bc1bf2840:

lock: 0x7f8bc1be2bd0:

lock: 0x7f8bc1bde520:

lock: 0x7f8bc1bda960:

lock: 0x7f8bc1bd6f20:

lock: 0x7f8bc1bd2d40:

lock: 0x7f8bc1bc2aa0: read
read      : 0x7f8bc1bcab18 (111:2); 0x7f887805acc8 (128:2); 0x7f886c131308 (101:2); 0x7f886c3764a8 (68:2); 0x7f887851bbd8 (55:2); 0x7f88785358f8 (142:2); 0x7f8bc318fa58 (114:2); 0x7f8878760788 (123:2); 0x7f886ce4add8 (144:2); 0x7f88787cf2b8 (100:2); 0x7f886ce61eb8 (64:2); 0x7f8bc38071e8 (65:2); 0x7f886ce79f88 (67:2);

lock: 0x7f8bc1bc2990:

lock: 0x7f8bc1bbf8d0:

lock: 0x7f8bc1bbad90:

lock: 0x7f8bc1bb04f0:

lock: 0x7f8bc1ba50a0:

lock: 0x7f8bc1ba49e0:

lock: 0x7f8bc1b9a8b0:

lock: 0x7f8bc1b96ee0:

lock: 0x7f8bc1b91210:

lock: 0x7f8bc1b8d1e0:

lock: 0x7f8bc1b87640:

lock: 0x7f8bc1b7ac60:

lock: 0x7f8bc1b7a190:

lock: 0x7f8bc1b596d0:

lock: 0x7f8bc1b5b550:

lock: 0x7f8bc1b530e0:

lock: 0x7f8bc1b48e30:

lock: 0x7f8bc1b445b0: read
read      : 0x7f8bc1b42118 (90:2);

lock: 0x7f8bc1b3b790:

lock: 0x7f8bc1b345f0:

lock: 0x7f8bc1b27b50:

lock: 0x7f8bc1b23e90:

lock: 0x7f8bc1b17e70:

lock: 0x7f8bc1b11b80:

lock: 0x7f8bc1b0a700:

lock: 0x7f8bc1af5380:

lock: 0x7f8bc1afa110:

lock: 0x7f8bc1aeecf0:

lock: 0x7f8bc1db8240:

lock: 0x7f8bc1da87c0:

lock: 0x7f8bc1da1e00:

lock: 0x7f8bc1d9a7b0:

lock: 0x7f8bc1d8baa0:

lock: 0x7f8bc1d88830:

lock: 0x7f8bc1d7bbe0:

lock: 0x7f8bc1d681e0:

lock: 0x7f8bc1d63510:

lock: 0x7f8bc1d532e0: read
read      : 0x7f8bc1d50748 (145:2); 0x7f886c11b268 (72:2); 0x7f88782ccf88 (106:2); 0x7f886ce3d338 (132:2); 0x7f88787b0728 (60:2);

lock: 0x7f8bc1d4eb80:

lock: 0x7f8bc1d4a300:

lock: 0x7f8bc1d462e0:

lock: 0x7f8bc1d427d0: read
read      : 0x7f8bc1d40728 (52:2); 0x7f886c364508 (113:2); 0x7f8bc2f45258 (81:2); 0x7f886cc0ad28 (134:2);


Key caches:
default
Buffer_size:       1048576
Block_size:           1024
Division_limit:        100
Age_limit:             300
blocks used:             1
not flushed:             0
w_requests:             20
writes:                  0
r_requests:           1263
reads:                   0


handler status:
read_key:       591732
read_next:      649228
read_rnd        579539
read_first:        403
write:          139448
delete           41124
update:             28

Table status:
Opened tables:        285
Open tables:          260
Open files:            51
Open streams:           0

Alarm status:
Active alarms:   0
Max used alarms: 0
Next alarm time: 0

Thread database.table_name          Locked/Waiting        Lock_type

52      otrs.article_flag           Locked - read         Low priority read lock
80      otrs.time_accounting        Locked - read         Low priority read lock
89      otrs.sessions               Locked - write        High priority write lock
90      otrs.link_relation          Locked - read         Low priority read lock
97      otrs.sessions               Locked - read         Low priority read lock
103     otrs.ticket_watcher         Locked - read         Low priority read lock
111     otrs.ticket                 Locked - read         Low priority read lock
111     otrs.queue                  Locked - read         Low priority read lock
135     otrs.standard_template      Locked - read         Low priority read lock
136     otrs.article                Locked - read         Low priority read lock
145     otrs.article_type           Locked - read         Low priority read lock

---

These hang too:

/var/log/mysql# mysql -u root -p -e 'SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS'
// ctrl+c

/var/log/mysql# mysql -u root -p -e 'SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS'
// ctrl+c

/var/log/mysql# mysql -u root -p -e 'SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX'
// ctrl+c

---

mysql> show status;
+------------------------------------------+-------------+
| Variable_name                            | Value       |
+------------------------------------------+-------------+
| Aborted_clients                          | 1           |
| Aborted_connects                         | 56          |
| Binlog_cache_disk_use                    | 0           |
| Binlog_cache_use                         | 7437        |
| Binlog_stmt_cache_disk_use               | 0           |
| Binlog_stmt_cache_use                    | 0           |
| Bytes_received                           | 137         |
| Bytes_sent                               | 181         |
| Com_admin_commands                       | 0           |
| Com_assign_to_keycache                   | 0           |
| Com_alter_db                             | 0           |
| Com_alter_db_upgrade                     | 0           |
| Com_alter_event                          | 0           |
| Com_alter_function                       | 0           |
| Com_alter_procedure                      | 0           |
| Com_alter_server                         | 0           |
| Com_alter_table                          | 0           |
| Com_alter_tablespace                     | 0           |
| Com_analyze                              | 0           |
| Com_begin                                | 0           |
| Com_binlog                               | 0           |
| Com_call_procedure                       | 0           |
| Com_change_db                            | 0           |
| Com_change_master                        | 0           |
| Com_check                                | 0           |
| Com_checksum                             | 0           |
| Com_commit                               | 0           |
| Com_create_db                            | 0           |
| Com_create_event                         | 0           |
| Com_create_function                      | 0           |
| Com_create_index                         | 0           |
| Com_create_procedure                     | 0           |
| Com_create_server                        | 0           |
| Com_create_table                         | 0           |
| Com_create_trigger                       | 0           |
| Com_create_udf                           | 0           |
| Com_create_user                          | 0           |
| Com_create_view                          | 0           |
| Com_dealloc_sql                          | 0           |
| Com_delete                               | 0           |
| Com_delete_multi                         | 0           |
| Com_do                                   | 0           |
| Com_drop_db                              | 0           |
| Com_drop_event                           | 0           |
| Com_drop_function                        | 0           |
| Com_drop_index                           | 0           |
| Com_drop_procedure                       | 0           |
| Com_drop_server                          | 0           |
| Com_drop_table                           | 0           |
| Com_drop_trigger                         | 0           |
| Com_drop_user                            | 0           |
| Com_drop_view                            | 0           |
| Com_empty_query                          | 0           |
| Com_execute_sql                          | 0           |
| Com_flush                                | 0           |
| Com_grant                                | 0           |
| Com_ha_close                             | 0           |
| Com_ha_open                              | 0           |
| Com_ha_read                              | 0           |
| Com_help                                 | 0           |
| Com_insert                               | 0           |
| Com_insert_select                        | 0           |
| Com_install_plugin                       | 0           |
| Com_kill                                 | 0           |
| Com_load                                 | 0           |
| Com_lock_tables                          | 0           |
| Com_optimize                             | 0           |
| Com_preload_keys                         | 0           |
| Com_prepare_sql                          | 0           |
| Com_purge                                | 0           |
| Com_purge_before_date                    | 0           |
| Com_release_savepoint                    | 0           |
| Com_rename_table                         | 0           |
| Com_rename_user                          | 0           |
| Com_repair                               | 0           |
| Com_replace                              | 0           |
| Com_replace_select                       | 0           |
| Com_reset                                | 0           |
| Com_resignal                             | 0           |
| Com_revoke                               | 0           |
| Com_revoke_all                           | 0           |
| Com_rollback                             | 0           |
| Com_rollback_to_savepoint                | 0           |
| Com_savepoint                            | 0           |
| Com_select                               | 1           |
| Com_set_option                           | 0           |
| Com_signal                               | 0           |
| Com_show_authors                         | 0           |
| Com_show_binlog_events                   | 0           |
| Com_show_binlogs                         | 0           |
| Com_show_charsets                        | 0           |
| Com_show_collations                      | 0           |
| Com_show_contributors                    | 0           |
| Com_show_create_db                       | 0           |
| Com_show_create_event                    | 0           |
| Com_show_create_func                     | 0           |
| Com_show_create_proc                     | 0           |
| Com_show_create_table                    | 0           |
| Com_show_create_trigger                  | 0           |
| Com_show_databases                       | 0           |
| Com_show_engine_logs                     | 0           |
| Com_show_engine_mutex                    | 0           |
| Com_show_engine_status                   | 0           |
| Com_show_events                          | 0           |
| Com_show_errors                          | 0           |
| Com_show_fields                          | 0           |
| Com_show_function_status                 | 0           |
| Com_show_grants                          | 0           |
| Com_show_keys                            | 0           |
| Com_show_master_status                   | 0           |
| Com_show_open_tables                     | 0           |
| Com_show_plugins                         | 0           |
| Com_show_privileges                      | 0           |
| Com_show_procedure_status                | 0           |
| Com_show_processlist                     | 0           |
| Com_show_profile                         | 0           |
| Com_show_profiles                        | 0           |
| Com_show_relaylog_events                 | 0           |
| Com_show_slave_hosts                     | 0           |
| Com_show_slave_status                    | 0           |
| Com_show_status                          | 1           |
| Com_show_storage_engines                 | 0           |
| Com_show_table_status                    | 0           |
| Com_show_tables                          | 0           |
| Com_show_triggers                        | 0           |
| Com_show_variables                       | 0           |
| Com_show_warnings                        | 0           |
| Com_slave_start                          | 0           |
| Com_slave_stop                           | 0           |
| Com_stmt_close                           | 0           |
| Com_stmt_execute                         | 0           |
| Com_stmt_fetch                           | 0           |
| Com_stmt_prepare                         | 0           |
| Com_stmt_reprepare                       | 0           |
| Com_stmt_reset                           | 0           |
| Com_stmt_send_long_data                  | 0           |
| Com_truncate                             | 0           |
| Com_uninstall_plugin                     | 0           |
| Com_unlock_tables                        | 0           |
| Com_update                               | 0           |
| Com_update_multi                         | 0           |
| Com_xa_commit                            | 0           |
| Com_xa_end                               | 0           |
| Com_xa_prepare                           | 0           |
| Com_xa_recover                           | 0           |
| Com_xa_rollback                          | 0           |
| Com_xa_start                             | 0           |
| Compression                              | OFF         |
| Connections                              | 648         |
| Created_tmp_disk_tables                  | 0           |
| Created_tmp_files                        | 6           |
| Created_tmp_tables                       | 0           |
| Delayed_errors                           | 0           |
| Delayed_insert_threads                   | 0           |
| Delayed_writes                           | 0           |
| Flush_commands                           | 1           |
| Handler_commit                           | 0           |
| Handler_delete                           | 0           |
| Handler_discover                         | 0           |
| Handler_prepare                          | 0           |
| Handler_read_first                       | 0           |
| Handler_read_key                         | 0           |
| Handler_read_last                        | 0           |
| Handler_read_next                        | 0           |
| Handler_read_prev                        | 0           |
| Handler_read_rnd                         | 0           |
| Handler_read_rnd_next                    | 0           |
| Handler_rollback                         | 0           |
| Handler_savepoint                        | 0           |
| Handler_savepoint_rollback               | 0           |
| Handler_update                           | 0           |
| Handler_write                            | 0           |
| Innodb_buffer_pool_pages_data            | 2196        |
| Innodb_buffer_pool_bytes_data            | 35979264    |
| Innodb_buffer_pool_pages_dirty           | 1380        |
| Innodb_buffer_pool_bytes_dirty           | 22609920    |
| Innodb_buffer_pool_pages_flushed         | 3365        |
| Innodb_buffer_pool_pages_free            | 784114      |
| Innodb_buffer_pool_pages_misc            | 114         |
| Innodb_buffer_pool_pages_total           | 786424      |
| Innodb_buffer_pool_read_ahead_rnd        | 0           |
| Innodb_buffer_pool_read_ahead            | 0           |
| Innodb_buffer_pool_read_ahead_evicted    | 0           |
| Innodb_buffer_pool_read_requests         | 3375182     |
| Innodb_buffer_pool_reads                 | 1109        |
| Innodb_buffer_pool_wait_free             | 0           |
| Innodb_buffer_pool_write_requests        | 778922      |
| Innodb_data_fsyncs                       | 14855       |
| Innodb_data_pending_fsyncs               | 0           |
| Innodb_data_pending_reads                | 0           |
| Innodb_data_pending_writes               | 0           |
| Innodb_data_read                         | 20353024    |
| Innodb_data_reads                        | 1210        |
| Innodb_data_writes                       | 17084       |
| Innodb_data_written                      | 161122304   |
| Innodb_dblwr_pages_written               | 3365        |
| Innodb_dblwr_writes                      | 1046        |
| Innodb_have_atomic_builtins              | ON          |
| Innodb_log_waits                         | 0           |
| Innodb_log_write_requests                | 109428      |
| Innodb_log_writes                        | 12336       |
| Innodb_os_log_fsyncs                     | 12391       |
| Innodb_os_log_pending_fsyncs             | 0           |
| Innodb_os_log_pending_writes             | 0           |
| Innodb_os_log_written                    | 50830336    |
| Innodb_page_size                         | 16384       |
| Innodb_pages_created                     | 1687        |
| Innodb_pages_read                        | 1108        |
| Innodb_pages_written                     | 3365        |
| Innodb_row_lock_current_waits            | 0           |
| Innodb_row_lock_time                     | 118         |
| Innodb_row_lock_time_avg                 | 5           |
| Innodb_row_lock_time_max                 | 16          |
| Innodb_row_lock_waits                    | 22          |
| Innodb_rows_deleted                      | 41123       |
| Innodb_rows_inserted                     | 73966       |
| Innodb_rows_read                         | 1266071     |
| Innodb_rows_updated                      | 3           |
| Innodb_truncated_status_writes           | 0           |
| Key_blocks_not_flushed                   | 0           |
| Key_blocks_unused                        | 837         |
| Key_blocks_used                          | 1           |
| Key_read_requests                        | 1263        |
| Key_reads                                | 0           |
| Key_write_requests                       | 20          |
| Key_writes                               | 0           |
| Last_query_cost                          | 0.000000    |
| Max_used_connections                     | 305         |
| Not_flushed_delayed_rows                 | 0           |
| Open_files                               | 51          |
| Open_streams                             | 0           |
| Open_table_definitions                   | 132         |
| Open_tables                              | 260         |
| Opened_files                             | 463         |
| Opened_table_definitions                 | 0           |
| Opened_tables                            | 0           |
| Performance_schema_cond_classes_lost     | 0           |
| Performance_schema_cond_instances_lost   | 0           |
| Performance_schema_file_classes_lost     | 0           |
| Performance_schema_file_handles_lost     | 0           |
| Performance_schema_file_instances_lost   | 0           |
| Performance_schema_locker_lost           | 0           |
| Performance_schema_mutex_classes_lost    | 0           |
| Performance_schema_mutex_instances_lost  | 0           |
| Performance_schema_rwlock_classes_lost   | 0           |
| Performance_schema_rwlock_instances_lost | 0           |
| Performance_schema_table_handles_lost    | 0           |
| Performance_schema_table_instances_lost  | 0           |
| Performance_schema_thread_classes_lost   | 0           |
| Performance_schema_thread_instances_lost | 0           |
| Prepared_stmt_count                      | 0           |
| Qcache_free_blocks                       | 12          |
| Qcache_free_memory                       | 13276368    |
| Qcache_hits                              | 28232       |
| Qcache_inserts                           | 4483        |
| Qcache_lowmem_prunes                     | 0           |
| Qcache_not_cached                        | 1739        |
| Qcache_queries_in_cache                  | 2194        |
| Qcache_total_blocks                      | 4445        |
| Queries                                  | 57923       |
| Questions                                | 2           |
| Rpl_status                               | AUTH_MASTER |
| Select_full_join                         | 0           |
| Select_full_range_join                   | 0           |
| Select_range                             | 0           |
| Select_range_check                       | 0           |
| Select_scan                              | 0           |
| Slave_heartbeat_period                   | 0.000       |
| Slave_open_temp_tables                   | 0           |
| Slave_received_heartbeats                | 0           |
| Slave_retried_transactions               | 0           |
| Slave_running                            | OFF         |
| Slow_launch_threads                      | 0           |
| Slow_queries                             | 0           |
| Sort_merge_passes                        | 0           |
| Sort_range                               | 0           |
| Sort_rows                                | 0           |
| Sort_scan                                | 0           |
| Ssl_accept_renegotiates                  | 0           |
| Ssl_accepts                              | 0           |
| Ssl_callback_cache_hits                  | 0           |
| Ssl_cipher                               |             |
| Ssl_cipher_list                          |             |
| Ssl_client_connects                      | 0           |
| Ssl_connect_renegotiates                 | 0           |
| Ssl_ctx_verify_depth                     | 0           |
| Ssl_ctx_verify_mode                      | 0           |
| Ssl_default_timeout                      | 0           |
| Ssl_finished_accepts                     | 0           |
| Ssl_finished_connects                    | 0           |
| Ssl_session_cache_hits                   | 0           |
| Ssl_session_cache_misses                 | 0           |
| Ssl_session_cache_mode                   | NONE        |
| Ssl_session_cache_overflows              | 0           |
| Ssl_session_cache_size                   | 0           |
| Ssl_session_cache_timeouts               | 0           |
| Ssl_sessions_reused                      | 0           |
| Ssl_used_session_cache_entries           | 0           |
| Ssl_verify_depth                         | 0           |
| Ssl_verify_mode                          | 0           |
| Ssl_version                              |             |
| Table_locks_immediate                    | 14797       |
| Table_locks_waited                       | 0           |
| Tc_log_max_pages_used                    | 0           |
| Tc_log_page_size                         | 0           |
| Tc_log_page_waits                        | 0           |
| Threads_cached                           | 0           |
| Threads_connected                        | 305         |
| Threads_created                          | 305         |
| Threads_running                          | 305         |
| Uptime                                   | 69296       |
| Uptime_since_flush_status                | 69296       |
+------------------------------------------+-------------+
312 rows in set (0.03 sec)


# service mysql stop
[....] Stopping MySQL database server: mysqld
// hangup for long time; no exit


After stop (during its hangup) in mysql-error.log:

151118 12:07:34 [Note] /usr/sbin/mysqld: Normal shutdown

151118 12:07:34 [Note] Event Scheduler: Purging the queue. 0 events
151118 12:07:36 [Warning] /usr/sbin/mysqld: Forcing close of thread 643  user: 'root'

151118 12:07:36 [Warning] /usr/sbin/mysqld: Forcing close of thread 640  user: 'root'

151118 12:07:36 [Warning] /usr/sbin/mysqld: Forcing close of thread 637  user: 'root'

151118 12:07:36 [Warning] /usr/sbin/mysqld: Forcing close of thread 635  user: 'root'

151118 12:07:36 [Warning] /usr/sbin/mysqld: Forcing close of thread 627  user: 'root'

151118 12:07:36 [Warning] /usr/sbin/mysqld: Forcing close of thread 543  user: 'otrs'
[...]
151118 12:07:36 [Warning] /usr/sbin/mysqld: Forcing close of thread 505  user: 'otrs'

151118 12:07:36 [Warning] /usr/sbin/mysqld: Forcing close of thread 503  user: 'otrs'

151118 12:07:36 [Warning] /usr/sbin/mysqld: Forcing close of thread 501  user: 'debian-sys-maint'

151118 12:07:36 [Warning] /usr/sbin/mysqld: Forcing close of thread 499  user: 'otrs'
[...]
151118 12:07:36 [Warning] /usr/sbin/mysqld: Forcing close of thread 42  user: 'otrs'

151118 12:07:36 [Warning] /usr/sbin/mysqld: Forcing close of thread 41  user: 'otrs'

151118 12:07:36 [Warning] /usr/sbin/mysqld: Forcing close of thread 40  user: 'otrs'

[...]

---

After waiting for "service mysql stop" to finish (without success) killed mysqld and mysqld_safe with -9 (simple kill didn't work):

# kill -9 <pid of mysqld> <pid of mysqld_safe>


---

# tail -n 120 /var/log/mysql/mysql-error.log
[...]

Killed
151118 12:14:59 mysqld_safe Number of processes running now: 0
151118 12:14:59 mysqld_safe mysqld restarted
151118 12:14:59 [Note] /usr/sbin/mysqld (mysqld 5.5.46-0+deb7u1-log) starting as process 16462 ...
151118 12:14:59 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
151118 12:14:59 [Note] Plugin 'FEDERATED' is disabled.
151118 12:14:59 InnoDB: The InnoDB memory heap is disabled
151118 12:14:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151118 12:14:59 InnoDB: Compressed tables use zlib 1.2.7
151118 12:14:59 InnoDB: Using Linux native AIO
151118 12:14:59 InnoDB: Initializing buffer pool, size = 12.0G
151118 12:15:00 InnoDB: Completed initialization of buffer pool
151118 12:15:00 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 198745218
151118 12:15:00  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 203987968
InnoDB: Doing recovery: scanned up to log sequence number 209230848
InnoDB: Doing recovery: scanned up to log sequence number 214473728
InnoDB: Doing recovery: scanned up to log sequence number 218083366
InnoDB: Transaction C1ACF was in the XA prepared state.
InnoDB: Transaction C1AD0 was in the XA prepared state.
InnoDB: Transaction C1AD2 was in the XA prepared state.
InnoDB: Transaction C1AD3 was in the XA prepared state.
InnoDB: Transaction C1AD4 was in the XA prepared state.
InnoDB: 5 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 0 row operations to undo
InnoDB: Trx id counter is C1C00
151118 12:15:01  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 8316032, file name /var/log/mysql/mysql-bin.000416
InnoDB: Starting in background the rollback of uncommitted transactions
151118 12:15:03  InnoDB: Rollback of non-prepared transactions completed
151118 12:15:03  InnoDB: Waiting for the background threads to start
151118 12:15:04 InnoDB: 5.5.46 started; log sequence number 218083366
151118 12:15:04 [Note] Recovering after a crash using /var/log/mysql/mysql-bin
151118 12:15:04 [Note] Starting crash recovery...
151118 12:15:04  InnoDB: Starting recovery for XA transactions...
151118 12:15:04  InnoDB: Transaction C1AD4 in prepared state after recovery
151118 12:15:04  InnoDB: Transaction contains changes to 2 rows
151118 12:15:04  InnoDB: Transaction C1AD3 in prepared state after recovery
151118 12:15:04  InnoDB: Transaction contains changes to 1 rows
151118 12:15:04  InnoDB: Transaction C1AD2 in prepared state after recovery
151118 12:15:04  InnoDB: Transaction contains changes to 1 rows
151118 12:15:04  InnoDB: Transaction C1AD0 in prepared state after recovery
151118 12:15:04  InnoDB: Transaction contains changes to 1 rows
151118 12:15:04  InnoDB: Transaction C1ACF in prepared state after recovery
151118 12:15:04  InnoDB: Transaction contains changes to 1 rows
151118 12:15:04  InnoDB: 5 transactions in prepared state after recovery
151118 12:15:04 [Note] Found 5 prepared transaction(s) in InnoDB
151118 12:15:04 [Note] Crash recovery finished.
151118 12:15:04 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
151118 12:15:04 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
151118 12:15:04 [Note] Server socket created on IP: '0.0.0.0'.
151118 12:15:04 [Note] Event Scheduler: Loaded 0 events
151118 12:15:04 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.46-0+deb7u1-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)
151118 12:15:32 [Note] /usr/sbin/mysqld: Normal shutdown

151118 12:15:32 [Note] Event Scheduler: Purging the queue. 0 events
151118 12:15:32  InnoDB: Starting shutdown...
151118 12:15:34  InnoDB: Shutdown completed; log sequence number 218527695
151118 12:15:34 [Note] /usr/sbin/mysqld: Shutdown complete

151118 12:15:34 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
151118 12:16:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
151118 12:16:50 [Note] /usr/sbin/mysqld (mysqld 5.5.46-0+deb7u1-log) starting as process 17296 ...
151118 12:16:50 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
151118 12:16:50 [Note] Plugin 'FEDERATED' is disabled.
151118 12:16:50 InnoDB: The InnoDB memory heap is disabled
151118 12:16:50 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151118 12:16:50 InnoDB: Compressed tables use zlib 1.2.7
151118 12:16:50 InnoDB: Using Linux native AIO
151118 12:16:50 InnoDB: Initializing buffer pool, size = 12.0G
151118 12:16:51 InnoDB: Completed initialization of buffer pool
151118 12:16:51 InnoDB: highest supported file format is Barracuda.
151118 12:16:52  InnoDB: Waiting for the background threads to start
151118 12:16:53 InnoDB: 5.5.46 started; log sequence number 218527695
151118 12:16:53 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
151118 12:16:53 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
151118 12:16:53 [Note] Server socket created on IP: '0.0.0.0'.
151118 12:16:53 [Note] Event Scheduler: Loaded 0 events
151118 12:16:53 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.46-0+deb7u1-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)

---

This was development system only so no need for further repairing.



