Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from events_waits_current;
- +-----------+----------+--------------+-----------------------------------------+----------------------------+------------------+------------------+-----------------+-------+---------------+----------------------------+------------------------+-------------+-----------------------+------------------+--------------------+---------------+-----------------+-------+
- | THREAD_ID | EVENT_ID | END_EVENT_ID | EVENT_NAME | SOURCE | TIMER_START | TIMER_END | TIMER_WAIT | SPINS | OBJECT_SCHEMA | OBJECT_NAME | INDEX_NAME | OBJECT_TYPE | OBJECT_INSTANCE_BEGIN | NESTING_EVENT_ID | NESTING_EVENT_TYPE | OPERATION | NUMBER_OF_BYTES | FLAGS |
- +-----------+----------+--------------+-----------------------------------------+----------------------------+------------------+------------------+-----------------+-------+---------------+----------------------------+------------------------+-------------+-----------------------+------------------+--------------------+---------------+-----------------+-------+
- | 18 | 854 | 854 | wait/io/file/innodb/innodb_log_file | fil0fil.cc:962 | 8928270538324000 | 8928273993679000 | 3455355000 | NULL | NULL | /var/lib/mysql/ib_logfile1 | NULL | FILE | 140109870504192 | NULL | NULL | sync | NULL | NULL |
- | 28 | 3251 | NULL | idle | mysqld.cc:1196 | 8925598505000000 | 8928600898000000 | 3002393000000 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | idle | NULL | NULL |
- | 3343 | 1 | 1 | wait/io/socket/sql/client_connection | viosocket.c:479 | 8898565764180000 | 8898565765346000 | 1166000 | NULL | NULL | :0 | NULL | SOCKET | 140109833055808 | NULL | NULL | opt | NULL | NULL |
- | 4579 | 1 | 1 | wait/io/socket/sql/client_connection | viosocket.c:479 | 8902852305251500 | 8902852306396500 | 1145000 | NULL | NULL | :0 | NULL | SOCKET | 140109833057408 | NULL | NULL | opt | NULL | NULL |
- | 5108 | 1 | 1 | wait/io/socket/sql/client_connection | viosocket.c:479 | 8897213252068000 | 8897213253212000 | 1144000 | NULL | NULL | :0 | NULL | SOCKET | 140109833055488 | NULL | NULL | opt | NULL | NULL |
- | 5109 | 684435 | NULL | idle | mysqld.cc:1196 | 8928599461000000 | 8928600941000000 | 1480000000 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | idle | NULL | NULL |
- | 5111 | 728715 | 728715 | wait/lock/table/sql/handler | handler.cc:5858 | 8928814860302000 | 8928814861492000 | 1190000 | NULL | a2billing | cc_card | PRIMARY | TABLE | 139911042823904 | 728714 | STAGE | read external | NULL | NULL |
- | 5113 | 720546 | NULL | idle | mysqld.cc:1196 | 8928600668000000 | 8928600953000000 | 285000000 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | idle | NULL | NULL |
- | 5114 | 1 | 1 | wait/io/socket/sql/client_connection | viosocket.c:479 | 8900164039879000 | 8900164041146500 | 1267500 | NULL | NULL | :0 | NULL | SOCKET | 140109833056448 | NULL | NULL | opt | NULL | NULL |
- | 5115 | 666006 | NULL | idle | mysqld.cc:1196 | 8928599772000000 | 8928600960000000 | 1188000000 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | idle | NULL | NULL |
- | 5116 | 1 | 1 | wait/io/socket/sql/client_connection | viosocket.c:479 | 8901328343324000 | 8901328344644000 | 1320000 | NULL | NULL | :0 | NULL | SOCKET | 140109833056768 | NULL | NULL | opt | NULL | NULL |
- | 5117 | 715356 | NULL | idle | mysqld.cc:1196 | 8928599444000000 | 8928600967000000 | 1523000000 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | idle | NULL | NULL |
- | 5118 | 1 | 1 | wait/io/socket/sql/client_connection | viosocket.c:479 | 8902573977462000 | 8902573978626000 | 1164000 | NULL | NULL | :0 | NULL | SOCKET | 140109833057088 | NULL | NULL | opt | NULL | NULL |
- | 5119 | 729574 | 729574 | wait/io/table/sql/handler | handler.cc:2625 | 8928814759614000 | 8928814831972000 | 72358000 | NULL | a2billing | cc_card | cons_cc_card_useralias | TABLE | 139915069346688 | 729573 | STAGE | fetch | NULL | NULL |
- | 5122 | 705994 | NULL | idle | mysqld.cc:1196 | 8928600094000000 | 8928600979000000 | 885000000 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | idle | NULL | NULL |
- | 5124 | 1 | 1 | wait/io/socket/sql/client_connection | viosocket.c:479 | 8924251038950000 | 8924251039866000 | 916000 | NULL | NULL | :0 | NULL | SOCKET | 140109833057728 | NULL | NULL | opt | NULL | NULL |
- | 5125 | 716510 | NULL | idle | mysqld.cc:1196 | 8928600744000000 | 8928600986000000 | 242000000 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | idle | NULL | NULL |
- | 5196 | 12 | NULL | idle | mysqld.cc:1196 | 8803484508000000 | 8928600992000000 | 125116484000000 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | idle | NULL | NULL |
- | 5198 | 12 | NULL | idle | mysqld.cc:1196 | 8808982196000000 | 8928600995000000 | 119618799000000 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | idle | NULL | NULL |
- | 5200 | 12 | NULL | idle | mysqld.cc:1196 | 8811283736000000 | 8928600999000000 | 117317263000000 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | idle | NULL | NULL |
- | 5202 | 12 | NULL | idle | mysqld.cc:1196 | 8822946006000000 | 8928601002000000 | 105654996000000 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | idle | NULL | NULL |
- | 5230 | 2 | NULL | wait/synch/cond/threadpool/worker_cond | threadpool_generic.cc:1276 | 8890794382004000 | 8928814956236000 | 38020574232000 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | timed_wait | NULL | NULL |
- | 5232 | 2 | NULL | wait/synch/cond/threadpool/worker_cond | threadpool_generic.cc:1276 | 8892145884278000 | 8928814961266000 | 36669076988000 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | timed_wait | NULL | NULL |
- | 5234 | 2 | NULL | wait/synch/cond/threadpool/worker_cond | threadpool_generic.cc:1276 | 8893523841796500 | 8928814964522000 | 35291122725500 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | timed_wait | NULL | NULL |
- | 5236 | 2 | NULL | wait/synch/cond/threadpool/worker_cond | threadpool_generic.cc:1276 | 8894682457991000 | 8928814967870000 | 34132509879000 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | timed_wait | NULL | NULL |
- | 5238 | 2 | NULL | wait/synch/cond/threadpool/worker_cond | threadpool_generic.cc:1276 | 8894949818616500 | 8928814971204000 | 33865152587500 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | timed_wait | NULL | NULL |
- | 5240 | 1 | NULL | wait/synch/cond/threadpool/worker_cond | threadpool_generic.cc:1276 | 8894949688574000 | 8928814974522000 | 33865285948000 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | timed_wait | NULL | NULL |
- | 5241 | 2 | NULL | wait/synch/cond/threadpool/worker_cond | threadpool_generic.cc:1276 | 8896171033826500 | 8928814977962000 | 32643944135500 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | timed_wait | NULL | NULL |
- | 5244 | 1 | NULL | wait/synch/cond/threadpool/worker_cond | threadpool_generic.cc:1276 | 8897213400366500 | 8928814981346000 | 31601580979500 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | timed_wait | NULL | NULL |
- | 5246 | 1 | NULL | wait/synch/cond/threadpool/worker_cond | threadpool_generic.cc:1276 | 8898565905752000 | 8928814984804000 | 30249079052000 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | timed_wait | NULL | NULL |
- | 5248 | 1 | NULL | wait/synch/cond/threadpool/worker_cond | threadpool_generic.cc:1276 | 8898977681822000 | 8928814988382000 | 29837306560000 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | timed_wait | NULL | NULL |
- | 5250 | 1 | NULL | wait/synch/cond/threadpool/worker_cond | threadpool_generic.cc:1276 | 8900164201491500 | 8928814991676000 | 28650790184500 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | timed_wait | NULL | NULL |
- | 5252 | 1 | NULL | wait/synch/cond/threadpool/worker_cond | threadpool_generic.cc:1276 | 8901328487261500 | 8928814994794000 | 27486507532500 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | timed_wait | NULL | NULL |
- | 5255 | 1 | NULL | wait/synch/cond/threadpool/worker_cond | threadpool_generic.cc:1276 | 8902852440259000 | 8928814998350000 | 25962558091000 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | timed_wait | NULL | NULL |
- | 5256 | 1083 | 1083 | wait/synch/mutex/sql/THD::LOCK_thd_data | sql_class.h:3958 | 8928814755976000 | 8928814756190000 | 214000 | NULL | NULL | NULL | NULL | NULL | 0 | 1082 | STAGE | lock | NULL | NULL |
- | 4231 | 1 | 1 | wait/io/socket/sql/client_connection | viosocket.c:479 | 8898977556128000 | 8898977557114000 | 986000 | NULL | NULL | :0 | NULL | SOCKET | 140109833056128 | NULL | NULL | opt | NULL | NULL |
- +-----------+----------+--------------+-----------------------------------------+----------------------------+------------------+------------------+-----------------+-------+---------------+----------------------------+------------------------+-------------+-----------------------+--
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
