mysql> SHOW PROCESSLIST;
+----+------+-----------------+------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------------+------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
| 3 | root | localhost:60300 | test | Query | 2803 | executing | (
select count(*) from
`test`.`t9` as `t9` force index (idx55,idx48)
natural left outer join `t |
| 4 | root | localhost:60301 | test | Query | 1653 | Waiting for table metadata lock | (
select count(*) from
`test`.`t29` as `t29` force index (idx266,idx265)
natural left join `tes |
| 5 | root | localhost:60302 | test | Query | 3286 | Waiting for table metadata lock | delete t10 from (
select count(*) from
`test`.`t17` as `t17` force index (idx119,PRIMARY,idx119) |
| 6 | root | localhost:60303 | test | Query | 3287 | Sending data | (
select count(*) from
`test`.`t7` as `t7`
natural join `test`.`t25` as `t25` use index (PRIMA |
| 7 | root | localhost:60304 | test | Query | 3227 | Waiting for table metadata lock | create trigger `trg_t16_before_delete` before delete on `t16` for each row
begin
delete t20 from (
|
| 8 | root | localhost:60305 | test | Query | 2180 | Waiting for table metadata lock | delete from `test`.`t27` where `col258` <= 0 limit 1 |
| 9 | root | localhost:60306 | test | Query | 2297 | Waiting for table metadata lock | explain
select sql_no_cache all count(*) from
`test`.`t20` as `t20`
natural join `test`.`t2` |
| 10 | root | localhost:60307 | test | Query | 3210 | Waiting for table metadata lock | create trigger `trg_t25_after_update` after update on `t25` for each row
begin
delete t18 from (
se |
| 11 | root | localhost:60308 | test | Query | 3182 | Waiting for table metadata lock | update ignore `test`.`t27` set
`a27` = '',
`col258` = '17:18:58'
where `col258`&& 23661 limit 1 |
| 12 | root | localhost:60309 | test | Query | 3131 | Waiting for table metadata lock | delete t15 from (
select count(*) from
`test`.`t28` as `t28` use index (idx250,idx250)
right o |
| 13 | root | localhost:60310 | test | Query | 3286 | Waiting for table metadata lock | insert ignore into `test`.`t6` set
`col52` = -1.3764409700144E+18,
`col53` = '2011-04-17 04:48:22',
|
| 14 | root | localhost:60311 | test | Query | 3252 | Waiting for table metadata lock | update (
select count(*) from
`test`.`t18` as `t18`
natural right join `test`.`t19` as `t19`
|
| 15 | root | localhost:60312 | test | Query | 3159 | Waiting for table metadata lock | create trigger `trg_t27_before_delete` before delete on `t27` for each row
begin
delete t27 from (
|
| 16 | root | localhost:60313 | test | Query | 3286 | Waiting for table metadata lock | select all count(*) from
`test`.`t11` as `t11`
inner join `test`.`t17` as `t17`
on (t11.col9 |
| 17 | root | localhost:60314 | test | Query | 2297 | Waiting for table metadata lock | explain extended
select all sql_no_cache count(*) from
`test`.`t26` as `t26` force index (PRIMAR |
| 18 | root | localhost:60315 | test | Query | 2297 | Waiting for table metadata lock | select count(*) from
`test`.`t19` as `t19` ignore index (idx141,idx131,idx145,idx131)
natural l |
| 19 | root | localhost:60316 | test | Query | 3182 | Waiting for table metadata lock | insert ignore into `test`.`t21` set
`col219` = 0.3606,
`col222` = -3.9366862609486E+18,
`col224` = 1 |
| 20 | root | localhost:60317 | test | Query | 3214 | Waiting for table metadata lock | delete t10 from (
select count(*) from
`test`.`t7` as `t7` force index (idx31)
natural right o |
| 21 | root | localhost:60318 | test | Query | 3280 | Waiting for table metadata lock | explain extended
select sql_no_cache distinctrow col184 from
`test`.`t27` as `t27`
right out |
| 22 | root | localhost:60319 | test | Query | 3159 | Waiting for table metadata lock | create trigger `trg_t10_before_delete` before delete on `t10` for each row
begin
delete t29 from (
|
| 23 | root | localhost:60320 | test | Query | 3210 | Waiting for table metadata lock | create trigger `trg_t21_before_insert` before insert on `t21` for each row
begin
delete t16 from (
|
| 24 | root | localhost:60321 | test | Query | 1855 | Waiting for table metadata lock | select count(*) from
`test`.`t19` as `t19`
right join `test`.`t12` as `t12`
on ( (case (( (( |
| 25 | root | localhost:60322 | test | Query | 3232 | Waiting for table metadata lock | create trigger `trg_t6_before_insert` before insert on `t6` for each row
begin
delete t22 from (
se |
| 26 | root | localhost:60323 | test | Query | 3210 | Waiting for table metadata lock | create trigger `trg_t28_before_update` before update on `t28` for each row
begin
delete t17 from (
|
| 27 | root | localhost:60324 | test | Query | 3236 | Waiting for table metadata lock | explain
select col283,col119 from
`test`.`t22` as `t22` ignore index (PRIMARY,idx188,idx189,idx |
| 28 | root | localhost:60325 | test | Query | 3131 | Waiting for table metadata lock | update ignore `test`.`t16` set
`a16` = '',
`col173` = -1075813,
`col174` = from_unixtime(unix_timest |
| 29 | root | localhost:60326 | test | Query | 3278 | Sending data | select count(*) from
`test`.`t23` as `t23` force index (PRIMARY,idx192)
natural right join `tes |
| 30 | root | localhost:60327 | test | Query | 2297 | Waiting for table metadata lock | explain partitions
select sql_cache all col215 from
`test`.`t6` as `t6`
natural left outer j |
| 31 | root | localhost:60328 | test | Query | 3156 | Waiting for table metadata lock | update ignore `test`.`t25` set
`col252` = 0,
`col253` = 2071150030,
`a25` = geomfromtext("point(9023 |
| 32 | root | localhost:60329 | test | Query | 3184 | Waiting for table metadata lock | create trigger `trg_t17_after_update` after update on `t17` for each row
begin
delete t25 from (
se |
| 33 | root | localhost:60330 | test | Query | 3210 | Waiting for table metadata lock | explain
select distinctrow sql_no_cache col179 from
`test`.`t27` as `t27` ignore index (idx238, |
| 34 | root | localhost:60331 | test | Query | 3182 | Waiting for table metadata lock | create trigger `trg_t27_before_update` before update on `t27` for each row
begin
delete t29 from (
|
| 35 | root | localhost:60332 | test | Query | 2297 | Waiting for table metadata lock | select
`t8`.`col60` as col60
from
`test`.`t17` as `t17` ignore index (idx119,idx119)
inner jo |
| 36 | root | localhost:60333 | test | Query | 3224 | Waiting for table metadata lock | create trigger `trg_t26_before_insert` before insert on `t26` for each row
begin
delete t14 from (
|
| 37 | root | localhost:60334 | test | Query | 2245 | Waiting for table metadata lock | insert ignore into `test`.`t27` set
`a27` = 'nalyiwqifiitsccp',
`col258` = 3721 |
| 38 | root | localhost:60335 | test | Query | 3227 | Waiting for table metadata lock | delete from `test`.`t6` where `col54` >= null limit 1 |
| 39 | root | localhost:60336 | test | Query | 3129 | Waiting for table metadata lock | update ignore `test`.`t6` set
`col52` = 8634042,
`col53` = '2010-10-22',
`a6` = -8.3404022104877E+18 |
| 40 | root | localhost:60337 | test | Query | 3286 | Waiting for table metadata lock | delete t28 from (
select col264,a12 from
`test`.`t26` as `t26`
right outer join `test`.`t4` |
| 41 | root | localhost:60338 | test | Query | 2297 | Waiting for table metadata lock | explain extended
select
`t19`.`col202` as col202 ,
(( count(distinct (`t19`.`col201`))) in (( g |
| 42 | root | localhost:60339 | test | Query | 3281 | Waiting for table metadata lock | select sql_cache count(*) from
`test`.`t4` as `t4` ignore index (idx19)
natural left join `test |
| 45 | root | localhost:48500 | NULL | Query | 0 | NULL | SHOW PROCESSLIST |
+----+------+-----------------+------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
41 rows in set (0.00 sec)
mysql> SHOW ENGINE INNODB STATUS\G
*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
=====================================
110315 8:57:54 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 12 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 217 srv_active, 0 srv_shutdown, 3383 srv_idle
srv_master_thread log flush and writes: 3683
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 28141, signal count 23794
Mutex spin waits 479147, rounds 786026, OS waits 9781
RW-shared spins 17917, rounds 536832, OS waits 17546
RW-excl spins 428, rounds 24294, OS waits 749
Spin rounds per wait: 1.64 mutex, 29.96 RW-shared, 56.76 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 13FF
Purge done for trx's n:o < 1394 undo n:o < 0
History list length 160
Total number of lock structs in row lock hash table 7
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started, process no 2062, OS thread id 139821332014848
MySQL thread id 45, query id 6944 localhost 127.0.0.1 root
SHOW ENGINE INNODB STATUS
---TRANSACTION 0, not started, process no 2062, OS thread id 139821332547328
MySQL thread id 42, query id 6649 localhost 127.0.0.1 root Waiting for table metadata lock
select sql_cache count(*) from
`test`.`t4` as `t4` ignore index (idx19)
natural left join `test`.`t12` as `t12` ignore index (idx97,PRIMARY,idx90)
right join `test`.`t6` as `t6`
on (t4.col25 && t6.col52 )
natural left join `test`.`t23` as `t23` ignore index (PRIMARY)
left join `test`.`t20` as `t20`
on (t4.col26 || t20.col214 )
left join `test`.`t11` as `t11` ignore index (idx80,idx72)
on ( insert(( ((t4.col28) not in ((t4.col29),(t4.col33),(t4.col27),(t4.col27),(t4.col29)))),( least((t4.col33),(t4.col30),(t4.col26))),( encode((t4.col26),(t4.col28))),( @@global.log
---TRANSACTION 13CA, not started, process no 2062, OS thread id 139821332813568
MySQL thread id 41, query id 6919 localhost 127.0.0.1 root Waiting for table metadata lock
explain extended
select
`t19`.`col202` as col202 ,
(( count(distinct (`t19`.`col201`))) in (( greatest(((
select count(*) from
`test`.`t9` as `t9` ignore index (idx55,idx48)
left outer join `test`.`t26` as `t26`
on (t9.col80 & @var7 )
left outer join `test`.`t10` as `t10` force index (PRIMARY,PRIMARY,idx64)
on (@var4 is not false )
group by
t9.col66
limit 1
)),(`t19`.`col201`),(`t19`.`col201`),(`t19`.`col202`))),( count((`t19`.`col201`))),( (case ((`t19`.`col202`)) when ((`t19`.`col201`)) then ((`t19`.`col201`))when ((`t19`.`col202`)) then ((`t19`.`col201`)) e
---TRANSACTION 1390, not started, process no 2062, OS thread id 139821333079808
MySQL thread id 40, query id 6513 localhost 127.0.0.1 root Waiting for table metadata lock
delete t28 from (
select col264,a12 from
`test`.`t26` as `t26`
right outer join `test`.`t4` as `t4`
on ( '1' )
natural join `test`.`t11` as `t11` ignore index (idx80,idx75)
natural left join `test`.`t21` as `t21` use index (idx173,idx173,PRIMARY)
natural left join `test`.`t27` as `t27`
natural left outer join `test`.`t12` as `t12` force index (idx97,idx97)
natural left outer join `test`.`t28` as `t28`
right outer join `test`.`t15` as `t15`
on (@var3 << t15.col168 )
cross join `test`.`t29` as `t29` force index (idx262,idx272,idx265)
on (@var6 i
---TRANSACTION 13BA, not started, process no 2062, OS thread id 139821337073408
mysql tables in use 1, locked 1
MySQL thread id 25, query id 6748 localhost 127.0.0.1 root Waiting for table metadata lock
create trigger `trg_t6_before_insert` before insert on `t6` for each row
begin
delete t22 from (
select count(*) from
`test`.`t7` as `t7` force index (idx31,PRIMARY)
left outer join `test`.`t21` as `t21`
on (@var7 sounds like @var3 )
limit 1
) `x`,
t22 as t22
where t22.a22>x.a7
;
update (
select count(*) from
`test`.`t7` as `t7` force index (idx31,PRIMARY)
left outer join `test`.`t21` as `t21`
on (@var0 < t21.col223 )
limit 1
) `x`,
`test`.`t10` as `t10` set `t10`.`col81`=`x`.`a7`
;
select count(*) from
`test`.`t7` as `t7` force index (idx31,PRIM
---TRANSACTION 13E9, not started, process no 2062, OS thread id 139821335475968
MySQL thread id 31, query id 6826 localhost 127.0.0.1 root Waiting for table metadata lock
update ignore `test`.`t25` set
`col252` = 0,
`col253` = 2071150030,
`a25` = geomfromtext("point(90237 67715)")
where `a25`>= 2249025804 limit 1
---TRANSACTION 13DF, not started, process no 2062, OS thread id 139821334144768
mysql tables in use 1, locked 1
MySQL thread id 36, query id 6765 localhost 127.0.0.1 root Waiting for table metadata lock
create trigger `trg_t26_before_insert` before insert on `t26` for each row
begin
delete t14 from (
select
`t5`.`col37` as col37
from
`test`.`t3` as `t3`
natural left outer join `test`.`t2` as `t2`
right join `test`.`t5` as `t5`
on (@var4 = @var6 )
inner join `test`.`t7` as `t7` force index (PRIMARY,PRIMARY)
on ( updatexml((t3.col21),(t3.col23),(t3.col20)) and t3.col21 )
left outer join `test`.`t27` as `t27` force index (PRIMARY)
on (t3.col23 * t27.a27 )
where
t3.col21 <> t2.col9 xor not
row(t5.col50 ,t3.a3 )!= row( t3.col23 , t3.col23 )
group by
t5.a5,
t2
---TRANSACTION 13D2, not started, process no 2062, OS thread id 139821335209728
MySQL thread id 32, query id 6811 localhost 127.0.0.1 root Waiting for table metadata lock
create trigger `trg_t17_after_update` after update on `t17` for each row
begin
delete t25 from (
select
group_concat(distinct (`t15`.`col170`) order by ((
select count(*) from
`test`.`t15` as `t15`
left join `test`.`t1` as `t1` ignore index (idx1)
on ( '1' )
left join `test`.`t12` as `t12` force index (PRIMARY,idx90)
on (t15.col171 = @var5 )
natural left outer join `test`.`t9` as `t9`
inner join `test`.`t21` as `t21`
on (@var5 % t21.col221 )
natural left join `test`.`t29` as `t29` force index (idx260,idx272,idx265)
right outer join `test`.`t22` as `t22
---TRANSACTION 1341, not started, process no 2062, OS thread id 139821334943488
MySQL thread id 33, query id 6790 localhost 127.0.0.1 root Waiting for table metadata lock
explain
select distinctrow sql_no_cache col179 from
`test`.`t27` as `t27` ignore index (idx238,PRIMARY,idx240,idx247)
straight_join `test`.`t19` as `t19` force index (idx132,idx143)
on (t27.col258 is not unknown )
natural right join `test`.`t4` as `t4` use index (PRIMARY)
cross join `test`.`t16` as `t16`
on (t27.a27 < t16.col181 )
straight_join `test`.`t21` as `t21`
on (@var2 is not false )
inner join `test`.`t3` as `t3` use index (idx13,idx15,idx15)
on ( '1' )
left outer join `test`.`t7` as `t7` ignore index (idx31)
on ( char_length((t27.a27)) >> t27.a2
---TRANSACTION 135D, not started, process no 2062, OS thread id 139821336540928
MySQL thread id 27, query id 6735 localhost 127.0.0.1 root Waiting for table metadata lock
explain
select col283,col119 from
`test`.`t22` as `t22` ignore index (PRIMARY,idx188,idx189,idx181)
left join `test`.`t6` as `t6` force index (PRIMARY)
on (@var5 = t6.col54 )
natural left outer join `test`.`t29` as `t29` force index (PRIMARY,idx272,PRIMARY)
natural join `test`.`t24` as `t24` use index (idx195,idx209)
inner join `test`.`t12` as `t12`
on ( '1' )
left join `test`.`t13` as `t13`
on (t22.a22 <=> t13.col140 )
inner join `test`.`t26` as `t26` force index (PRIMARY)
on (@var1 is unknown )
where
t24.col244 & '2011-10-07 21:33:54' and not
t13.col
---TRANSACTION 13CC, not started, process no 2062, OS thread id 139821333612288
MySQL thread id 38, query id 6757 localhost 127.0.0.1 root Waiting for table metadata lock
delete from `test`.`t6` where `col54` >= null limit 1
---TRANSACTION 13FA, not started, process no 2062, OS thread id 139821333878528
MySQL thread id 37, query id 6925 localhost 127.0.0.1 root Waiting for table metadata lock
insert ignore into `test`.`t27` set
`a27` = 'nalyiwqifiitsccp',
`col258` = 3721
---TRANSACTION 1366, not started, process no 2062, OS thread id 139821334411008
MySQL thread id 35, query id 6877 localhost 127.0.0.1 root Waiting for table metadata lock
select
`t8`.`col60` as col60
from
`test`.`t17` as `t17` ignore index (idx119,idx119)
inner join `test`.`t6` as `t6` force index (idx24,idx28,idx28)
on ( convert_tz(( greatest((t17.col186),(t17.a17),(t17.col185),(t17.a17),(t17.a17))),( greatest((t17.a17),(t17.col185),(t17.col186),(t17.col186))),( export_set((t17.col185),(t17.a17),(t17.col185),(t17.col186)))) && (( bit_length((t6.col55))) not in (( ((t6.col54) not in ((t6.col55),(t6.a6),(t6.col52),(t6.col55)))),( now()),( subdate((t6.col54),interval (t6.col55) hour)),( (case when (t6.col53) then (t6.col52) else (t6.col55) end)))) )
---TRANSACTION 13D7, not started, process no 2062, OS thread id 139821334677248
MySQL thread id 34, query id 6813 localhost 127.0.0.1 root Waiting for table metadata lock
create trigger `trg_t27_before_update` before update on `t27` for each row
begin
delete t29 from (
select count(*) from
`test`.`t4` as `t4` force index (PRIMARY,idx19)
straight_join `test`.`t22` as `t22` use index (idx185,idx180)
on (t4.col26 is not unknown )
limit 1
) `x`,
t29 as t29
where t29.col282>x.col30
;
update (
select count(*) from
`test`.`t4` as `t4` force index (PRIMARY,idx19)
straight_join `test`.`t22` as `t22` use index (idx185,idx180)
on ( uncompress(( acos((t4.col26)))) > @@global.server_id )
limit 1
) `x`,
`test`.`t3` as `t3` set `t3`.`
---TRANSACTION 13E2, not started, process no 2062, OS thread id 139821336274688
MySQL thread id 28, query id 6830 localhost 127.0.0.1 root Waiting for table metadata lock
update ignore `test`.`t16` set
`a16` = '',
`col173` = -1075813,
`col174` = from_unixtime(unix_timestamp()),
`col175` = "îÊðÙÉ5 j¸ÊÀ!1Z",
`col176` = "Á¤ãX7ÁÍM‹¦ætß3ä",
`col177` = '2011-09-11 03:56:03',
`col178` = '2011-07-21',
`col179` = 'mumdimdc',
`col180` = null,
`col181` = geomfromtext("point(-1931 -35765)"),
`col182` = null,
`col183` = -5246711,
`col184` = -41
where `col184`<=> "ep" limit 1
---TRANSACTION 0, not started, process no 2062, OS thread id 139821335742208
MySQL thread id 30, query id 6920 localhost 127.0.0.1 root Waiting for table metadata lock
explain partitions
select sql_cache all col215 from
`test`.`t6` as `t6`
natural left outer join `test`.`t25` as `t25`
left outer join `test`.`t12` as `t12`
on (@var0 & t12.col113 )
left join `test`.`t5` as `t5`
on (t6.col53 is not null )
natural left outer join `test`.`t11` as `t11`
cross join `test`.`t14` as `t14`
on ( @@global.myisam_data_pointer_size + t6.col55 )
right outer join `test`.`t27` as `t27` ignore index (idx241)
on ( (case ((t6.col52)) when ((t6.a6)) then ((t6.col54))when ((t6.a6)) then ((t6.col52)) else ((t6.col52)) end) <= timestamp((t
---TRANSACTION 13F1, not started, process no 2062, OS thread id 139821333346048
MySQL thread id 39, query id 6833 localhost 127.0.0.1 root Waiting for table metadata lock
update ignore `test`.`t6` set
`col52` = 8634042,
`col53` = '2010-10-22',
`a6` = -8.3404022104877E+18,
`col55` = 255,
`col54` = 74
where `col54`< null limit 1
---TRANSACTION 13F5, not started, process no 2062, OS thread id 139821337339648
MySQL thread id 24, query id 6930 localhost 127.0.0.1 root Waiting for table metadata lock
select count(*) from
`test`.`t19` as `t19`
right join `test`.`t12` as `t12`
on ( (case (( ((t19.col199) not in ((t19.col199),(t19.col205),(t19.col202))))) when (( @@global.net_write_timeout)) then (( period_diff((t19.col200),(t19.col203))))when (( position((t19.col201) in (t19.col199)))) then (( @@global.slave_compressed_protocol)) else (( greatest((t19.col201),(t19.col203),(t19.col199),(t19.col199)))) end) | @var9 )
natural join `test`.`t29` as `t29` ignore index (idx272,idx260,idx265)
natural right join `test`.`t17` as `t17` use index (idx112,idx114,idx120,idx119)
righ
---TRANSACTION 1378, not started, process no 2062, OS thread id 139821338937088
MySQL thread id 18, query id 6917 localhost 127.0.0.1 root Waiting for table metadata lock
select count(*) from
`test`.`t19` as `t19` ignore index (idx141,idx131,idx145,idx131)
natural left outer join `test`.`t25` as `t25`
left join `test`.`t27` as `t27`
on (t19.col199 < t27.a27 )
natural join `test`.`t29` as `t29` force index (idx260,idx266,PRIMARY)
left outer join `test`.`t21` as `t21`
on (t19.col202 | @var5 )
limit 1
union all
select
`t25`.`a25` as a25 ,
`t19`.`col199` as col199
from
`test`.`t19` as `t19` ignore index (idx141,idx131,idx145,idx131)
natural left outer join `test`.`t25` as `t25`
left join `test`.`t27` as `t27`
o
---TRANSACTION 13E6, not started, process no 2062, OS thread id 139821336807168
mysql tables in use 1, locked 1
MySQL thread id 26, query id 6801 localhost 127.0.0.1 root Waiting for table metadata lock
create trigger `trg_t28_before_update` before update on `t28` for each row
begin
delete t17 from (
select count(*) from
`test`.`t15` as `t15`
inner join `test`.`t23` as `t23`
on ( convert(( release_lock((t15.col169))),binary) xor (case (( ((t23.a23) in ((t23.col234),(t23.a23),(t23.col235),(t23.col234))))) when (( @@global.bulk_insert_buffer_size)) then (( maketime((t23.col234),(t23.col234),(t23.col235))))when (( elt((t23.col234),(t23.col234),(t23.col235),(t23.col235),(t23.col235)))) then (( period_diff((t23.a23),(t23.col234)))) else (( greatest((t23.col235),(t23.col235),(t23.col235),
---TRANSACTION 0, not started, process no 2062, OS thread id 139821338138368
MySQL thread id 21, query id 6657 localhost 127.0.0.1 root Waiting for table metadata lock
explain extended
select sql_no_cache distinctrow col184 from
`test`.`t27` as `t27`
right outer join `test`.`t5` as `t5`
on ( '1' )
cross join `test`.`t23` as `t23`
on ( week((t27.col258),6) | t27.a27 )
right join `test`.`t6` as `t6` force index (idx24)
on ( greatest(( char((t27.a27) using eucjpms)),( ((t27.col258) in ((t27.a27),(t27.a27),(t27.a27),(t27.a27),(t27.col258)))),( mid((t27.a27),(t27.a27),(t27.a27))),( char((t27.col258) using latin5)),( @@global.character_set_system)) or elt((t6.col52),(t6.col54),(t6.a6),(t6.a6),(t6.a6),(t6.col53)) )
natural join `test`.
---TRANSACTION 13DA, not started, process no 2062, OS thread id 139821337605888
mysql tables in use 1, locked 1
MySQL thread id 23, query id 6776 localhost 127.0.0.1 root Waiting for table metadata lock
create trigger `trg_t21_before_insert` before insert on `t21` for each row
begin
delete t16 from (
select count(*) from
`test`.`t16` as `t16`
left join `test`.`t28` as `t28` use index (PRIMARY,idx255,PRIMARY)
on (t16.a16 is not false )
cross join `test`.`t26` as `t26`
on (t16.col176 is true )
limit 1
) `x`,
t16 as t16
where t16.a16>x.col267
;
update (
select count(*) from
`test`.`t16` as `t16`
left join `test`.`t28` as `t28` use index (PRIMARY,idx255,PRIMARY)
on (t16.a16 not regexp @var1 )
cross join `test`.`t26` as `t26`
on (@var0 is not true )
---TRANSACTION 13E7, not started, process no 2062, OS thread id 139821337872128
MySQL thread id 22, query id 6823 localhost 127.0.0.1 root Waiting for table metadata lock
create trigger `trg_t10_before_delete` before delete on `t10` for each row
begin
delete t29 from (
select count(*) from
`test`.`t18` as `t18` ignore index (PRIMARY)
natural left outer join `test`.`t1` as `t1` ignore index (PRIMARY,idx1)
right outer join `test`.`t28` as `t28`
on (t18.col197 | @var7 )
left outer join `test`.`t25` as `t25` ignore index (idx212)
on (t18.col188 is true )
limit 1
) `x`,
t29 as t29
where t29.col295>x.col196
;
update (
select count(*) from
`test`.`t18` as `t18` ignore index (PRIMARY)
natural left outer join `test`.`t1` as `t1` ig
---TRANSACTION 1345, not started, process no 2062, OS thread id 139821339203328
MySQL thread id 17, query id 6918 localhost 127.0.0.1 root Waiting for table metadata lock
explain extended
select all sql_no_cache count(*) from
`test`.`t26` as `t26` force index (PRIMARY,idx229,idx233,idx225)
straight_join `test`.`t2` as `t2`
on (@var7 is true )
left outer join `test`.`t29` as `t29`
on (@var3 is not unknown )
group by
t26.col256 desc,
(( interval((`t2`.`col12`),(`t29`.`col286`),(`t26`.`col255`),(`t29`.`col281`),(`t2`.`col14`),(`t2`.`col10`))) in (( substring((`t29`.`col284`),(`t29`.`col281`),(`t29`.`col283`))),( greatest((`t26`.`col254`),(`t29`.`col286`),(`t26`.`a26`),(`t29`.`col288`),(`t2`.`col10`))),( interval((`t29`.`col289`),(`t2`.`col1
---TRANSACTION 13ED, not started, process no 2062, OS thread id 139821340800768
MySQL thread id 11, query id 6819 localhost 127.0.0.1 root Waiting for table metadata lock
update ignore `test`.`t27` set
`a27` = '',
`col258` = '17:18:58'
where `col258`&& 23661 limit 1
---TRANSACTION 13CE, not started, process no 2062, OS thread id 139821340002048
MySQL thread id 14, query id 6674 localhost 127.0.0.1 root Waiting for table metadata lock
update (
select count(*) from
`test`.`t18` as `t18`
natural right join `test`.`t19` as `t19`
left outer join `test`.`t23` as `t23`
on (t18.col187 is not false )
cross join `test`.`t14` as `t14`
on ( '1' )
straight_join `test`.`t5` as `t5`
on ( export_set((t18.col191),(t18.col192),(t18.col193),(t18.col191)) >> ((t5.col50) not in ((t5.col39),(t5.col42),(t5.col35),(t5.col37))) )
where
t5.col41 <= t18.col187 and not
row(t18.col190 ,t18.col195 ,t5.col43 )>= row( t5.col50 , t19.col203 , t18.col191 )xor
t18.col195 sounds like t19.col200
group by
t5.col48,
t18.
---TRANSACTION 137C, not started, process no 2062, OS thread id 139821341333248
MySQL thread id 9, query id 6894 localhost 127.0.0.1 root Waiting for table metadata lock
explain
select sql_no_cache all count(*) from
`test`.`t20` as `t20`
natural join `test`.`t2` as `t2` ignore index (idx7,PRIMARY)
natural left join `test`.`t25` as `t25` force index (PRIMARY)
left join `test`.`t4` as `t4`
on ( '1' )
having `col207` & `col207` and
`col207` || `col207`
for update
---TRANSACTION 0, not started, process no 2062, OS thread id 139821339469568
MySQL thread id 16, query id 6482 localhost 127.0.0.1 root Waiting for table metadata lock
select all count(*) from
`test`.`t11` as `t11`
inner join `test`.`t17` as `t17`
on (t11.col91 is not true )
right outer join `test`.`t10` as `t10` ignore index (idx56,idx63,idx64,idx64)
on ( repeat(( ((t11.col107) not in ((t11.col96),(t11.col92),(t11.col99),(t11.col98),(t11.a11)))),( interval((t11.col103),(t11.col96),(t11.col94),(t11.col99),(t11.col108))) mod 10) <> @var7 )
natural right join `test`.`t5` as `t5`
natural join `test`.`t25` as `t25` use index (PRIMARY)
right outer join `test`.`t13` as `t13`
on ( ((t11.col105) in ((t11.col95),(t11.col106),(t11.col93
---TRANSACTION 13FC, not started, process no 2062, OS thread id 139821341599488
MySQL thread id 8, query id 6928 localhost 127.0.0.1 root Waiting for table metadata lock
delete from `test`.`t27` where `col258` <= 0 limit 1
---TRANSACTION 13D1, not started, process no 2062, OS thread id 139821341865728
mysql tables in use 1, locked 1
MySQL thread id 7, query id 6756 localhost 127.0.0.1 root Waiting for table metadata lock
create trigger `trg_t16_before_delete` before delete on `t16` for each row
begin
delete t20 from (
select col39,col35 from
`test`.`t26` as `t26`
right join `test`.`t10` as `t10`
on ( elt(( @@global.tmpdir),( interval((t26.col255),(t26.a26),(t26.a26),(t26.col256),(t26.col257),(t26.col255))),( ((t26.a26) - (t26.a26))),( least((t26.col254),(t26.col256),(t26.col257),(t26.a26))),( ((t26.col255) not between (t26.a26) and (t26.col257))),( get_format(datetime,'internal'))) - least((t10.a10),(t10.col87),(t10.col89),(t10.col89),(t10.col87)) )
left outer join `test`.`t5` as `t5`
on (t26
---TRANSACTION 1387, not started, process no 2062, OS thread id 139821340268288
MySQL thread id 13, query id 6504 localhost 127.0.0.1 root Waiting for table metadata lock
insert ignore into `test`.`t6` set
`col52` = -1.3764409700144E+18,
`col53` = '2011-04-17 04:48:22',
`a6` = 0,
`col55` = 14038542,
`col54` = '2011-10-25 15:35:45'
---TRANSACTION 13EE, not started, process no 2062, OS thread id 139821340534528
MySQL thread id 12, query id 6827 localhost 127.0.0.1 root Waiting for table metadata lock
delete t15 from (
select count(*) from
`test`.`t28` as `t28` use index (idx250,idx250)
right outer join `test`.`t18` as `t18`
on (t28.a28 & @var6 )
natural left join `test`.`t19` as `t19`
right join `test`.`t26` as `t26` use index (idx220,PRIMARY,idx229)
on ( datediff((t28.col264),(t28.col263)) < elt((t26.col256),(t26.col257),(t26.a26),(t26.a26)) )
left join `test`.`t2` as `t2` use index (idx8,idx8)
on ( '1' )
inner join `test`.`t9` as `t9`
on ( '1' )
right outer join `test`.`t4` as `t4`
on ( coalesce((t28.col263),(t28.col270),(t28.col263),(t28.col266
---TRANSACTION 13F0, not started, process no 2062, OS thread id 139821339735808
MySQL thread id 15, query id 6825 localhost 127.0.0.1 root Waiting for table metadata lock
create trigger `trg_t27_before_delete` before delete on `t27` for each row
begin
delete t27 from (
select count(*) from
`test`.`t7` as `t7`
right outer join `test`.`t11` as `t11`
on (@var2 is unknown )
natural left outer join `test`.`t9` as `t9`
left join `test`.`t20` as `t20`
on (@var9 is not unknown )
where
t9.col74 < null and not
t11.col110 in( select '1' ) or
t11.col108 >( select '1' )
limit 1
) `x`,
t27 as t27
where t27.col258>x.a9
;
update (
select count(*) from
`test`.`t7` as `t7`
right outer join `test`.`t11` as `t11`
on (~t7.col58 )
---TRANSACTION 13DE, not started, process no 2062, OS thread id 139821338670848
MySQL thread id 19, query id 6814 localhost 127.0.0.1 root Waiting for table metadata lock
insert ignore into `test`.`t21` set
`col219` = 0.3606,
`col222` = -3.9366862609486E+18,
`col224` = 1,
`col225` = "…»QõT¢eŽ½O¾w’",
`col226` = 669377,
`col223` = '',
`col218` = -1268352046,
`a21` = '2010-04-17 15:10:24',
`col221` = 3114,
`col220` = 3062870
---TRANSACTION 13CF, not started, process no 2062, OS thread id 139821338404608
MySQL thread id 20, query id 6767 localhost 127.0.0.1 root Waiting for table metadata lock
delete t10 from (
select count(*) from
`test`.`t7` as `t7` force index (idx31)
natural right outer join `test`.`t12` as `t12`
left join `test`.`t2` as `t2`
on (@var2 not rlike @var4 )
left outer join `test`.`t11` as `t11` use index (PRIMARY,idx77,idx73)
on ( get_format(time,'eur') | @var5 )
cross join `test`.`t17` as `t17`
on (t7.a7 * @var5 )
inner join `test`.`t13` as `t13`
on ( '1' )
group by
t12.col118
limit 1
) `x`,
t10 as t10
where t10.col90>x.col102
---TRANSACTION 13E1, not started, process no 2062, OS thread id 139821341067008
MySQL thread id 10, query id 6793 localhost 127.0.0.1 root Waiting for table metadata lock
create trigger `trg_t25_after_update` after update on `t25` for each row
begin
delete t18 from (
select count(*) from
`test`.`t11` as `t11` ignore index (idx76,idx66,idx79)
right join `test`.`t28` as `t28` ignore index (idx255,idx255)
on ( '1' )
limit 1
) `x`,
t18 as t18
where t18.col189>x.col268
;
update (
select count(*) from
`test`.`t11` as `t11` ignore index (idx76,idx66,idx79)
right join `test`.`t28` as `t28` ignore index (idx255,idx255)
on (@var2 is true )
limit 1
) `x`,
`test`.`t9` as `t9` set `t9`.`col72`=`x`.`col268`
;
select count(*) from
---TRANSACTION 1360, not started, process no 2062, OS thread id 139821342664448
MySQL thread id 4, query id 6931 localhost 127.0.0.1 root Waiting for table metadata lock
(
select count(*) from
`test`.`t29` as `t29` force index (idx266,idx265)
natural left join `test`.`t13` as `t13`
natural left join `test`.`t26` as `t26`
natural right join `test`.`t14` as `t14`
left join `test`.`t4` as `t4` force index (idx19)
on ( concat_ws((t29.col289),(t29.col279),(t29.col285)) <> date_add((t4.col29),interval (t4.col24) month) )
right outer join `test`.`t22` as `t22`
on (t29.col289 / @var8 )
group by
t29.a29
limit 1
lock in share mode) union all (
select count(*) from
`test`.`t29` as `t29` force index (idx266,idx265)
natu
---TRANSACTION 133D, not started, process no 2062, OS thread id 139821342398208
MySQL thread id 5, query id 6512 localhost 127.0.0.1 root Waiting for table metadata lock
delete t10 from (
select count(*) from
`test`.`t17` as `t17` force index (idx119,PRIMARY,idx119)
cross join `test`.`t7` as `t7` force index (PRIMARY)
on ( '1' )
natural left outer join `test`.`t26` as `t26`
natural left outer join `test`.`t3` as `t3` force index (idx15,idx15,PRIMARY)
straight_join `test`.`t27` as `t27` ignore index (idx247)
on ( insert(( cast((t17.a17) as unsigned)),( interval((t17.col186),(t17.col185),(t17.col185))),( ((t17.col185) in ((t17.col186),(t17.col186),(t17.a17),(t17.col185),(t17.a17)))),( current_timestamp())) | t17.col186 )
straight_jo
---TRANSACTION 13F3, ACTIVE 2311 sec, process no 2062, OS thread id 139821336008448 fetching rows
mysql tables in use 14, locked 0
MySQL thread id 29, query id 6667 localhost 127.0.0.1 root Sending data
select count(*) from
`test`.`t23` as `t23` force index (PRIMARY,idx192)
natural right join `test`.`t3` as `t3` ignore index (idx13,idx15)
left outer join `test`.`t10` as `t10` ignore index (idx56)
on ( '1' )
left outer join `test`.`t18` as `t18`
on (@var7 is not false )
natural right join `test`.`t7` as `t7` force index (PRIMARY)
right outer join `test`.`t1` as `t1`
on (t23.col234 is not null )
inner join `test`.`t21` as `t21` force index (PRIMARY,PRIMARY,PRIMARY,idx174)
on ( '1' )
limit 1
union all
select col235 from
`test`.`t23` as `t2
Trx read view will not see trx with id >= 13F4, sees < 1360
---TRANSACTION 13F2, ACTIVE 2817 sec, process no 2062, OS thread id 139821342930688
mysql tables in use 12, locked 12
13 lock struct(s), heap size 3112, 123 row lock(s)
MySQL thread id 3, query id 6872 localhost 127.0.0.1 root executing
(
select count(*) from
`test`.`t9` as `t9` force index (idx55,idx48)
natural left outer join `test`.`t27` as `t27` ignore index (idx241,idx242,idx239,idx246)
inner join `test`.`t17` as `t17`
on (t9.col78 is not null )
right join `test`.`t22` as `t22`
on ( '1' )
right join `test`.`t2` as `t2`
on ( '1' )
right join `test`.`t8` as `t8` use index (PRIMARY,idx37,idx37)
on ( '1' )
where
t9.col73 collate latin1_bin <= '2010-08-17 10:02:17' or
t9.col70 > all( select '1' ) and
row(t9.col67 ,t9.col75 )< row(( select '1' ) ,( select '1' ) )
group by
t9.col78 d
---TRANSACTION 1382, ACTIVE 3301 sec, process no 2062, OS thread id 139821342131968 fetching rows
mysql tables in use 14, locked 0
MySQL thread id 6, query id 6337 localhost 127.0.0.1 root Sending data
(
select count(*) from
`test`.`t7` as `t7`
natural join `test`.`t25` as `t25` use index (PRIMARY)
natural left join `test`.`t5` as `t5`
cross join `test`.`t16` as `t16`
on (@var0 is not unknown )
natural join `test`.`t18` as `t18` force index (idx128)
natural left join `test`.`t29` as `t29` force index (idx267)
left join `test`.`t1` as `t1`
on (@var6 = t1.col3 )
limit 1
) union all (
select count(*) from
`test`.`t7` as `t7`
natural join `test`.`t25` as `t25` use index (PRIMARY)
natural left join `test`.`t5` as `t5`
cross join `t
Trx read view will not see trx with id >= 1383, sees < 1326
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
82 OS file reads, 5004 OS file writes, 3553 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 0 merges
merged operations:
insert 0, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 4425293, used cells 411, node heap has 2 buffer(s)
7007.17 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 6031995
Log flushed up to 6031995
Pages flushed up to 6031995
Last checkpoint at 6031995
0 pending log writes, 0 pending chkp writes
1754 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 2217738240; in additional pool allocated 0
Dictionary memory allocated 397022
Buffer pool size 131071
Free buffers 130276
Database pages 793
Old database pages 274
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 0, created 2700, written 1174
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s
LRU len: 793, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
3 read views open inside InnoDB
Main thread process no. 2062, id 139817780160256, state: sleeping
Number of rows inserted 583, updated 21, deleted 7, read 50782777
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 17691.69 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
1 row in set (0.25 sec)
mysql> SHOW FULL PROCESSLIST\G
*************************** 1. row ***************************
Id: 3
User: root
Host: localhost:60300
db: test
Command: Query
Time: 2837
State: executing
Info: (
select count(*) from
`test`.`t9` as `t9` force index (idx55,idx48)
natural left outer join `test`.`t27` as `t27` ignore index (idx241,idx242,idx239,idx246)
inner join `test`.`t17` as `t17`
on (t9.col78 is not null )
right join `test`.`t22` as `t22`
on ( '1' )
right join `test`.`t2` as `t2`
on ( '1' )
right join `test`.`t8` as `t8` use index (PRIMARY,idx37,idx37)
on ( '1' )
where
t9.col73 collate latin1_bin <= '2010-08-17 10:02:17' or
t9.col70 > all( select '1' ) and
row(t9.col67 ,t9.col75 )< row(( select '1' ) ,( select '1' ) )
group by
t9.col78 desc,
t9.col66
having `col78` | `col78`
limit 1
lock in share mode) union all (
select count(*) from
`test`.`t9` as `t9` force index (idx55,idx48)
natural left outer join `test`.`t27` as `t27` ignore index (idx241,idx242,idx239,idx246)
inner join `test`.`t17` as `t17`
on ( '1' )
right join `test`.`t22` as `t22`
on (@var7 + @var5 )
right join `test`.`t2` as `t2`
on ( des_decrypt((t9.col67),(t9.col66)) sounds like greatest((t2.col14),(t2.col16),(t2.col8),(t2.col8),(t2.col18)) )
right join `test`.`t8` as `t8` use index (PRIMARY,idx37,idx37)
on (t9.col80 is not false )
where
t9.col73 collate latin1_bin <= '2010-08-17 10:02:17' or
t9.col70 > all( select '1' ) and
row(t9.col67 ,t9.col75 )< row(( select '1' ) ,( select '1' ) )
group by
t9.col78 desc,
t9.col66
having `col78` | `col78`
limit 1
lock in share mode) order by 1
*************************** 2. row ***************************
Id: 4
User: root
Host: localhost:60301
db: test
Command: Query
Time: 1687
State: Waiting for table metadata lock
Info: (
select count(*) from
`test`.`t29` as `t29` force index (idx266,idx265)
natural left join `test`.`t13` as `t13`
natural left join `test`.`t26` as `t26`
natural right join `test`.`t14` as `t14`
left join `test`.`t4` as `t4` force index (idx19)
on ( concat_ws((t29.col289),(t29.col279),(t29.col285)) <> date_add((t4.col29),interval (t4.col24) month) )
right outer join `test`.`t22` as `t22`
on (t29.col289 / @var8 )
group by
t29.a29
limit 1
lock in share mode) union all (
select count(*) from
`test`.`t29` as `t29` force index (idx266,idx265)
natural left join `test`.`t13` as `t13`
natural left join `test`.`t26` as `t26`
natural right join `test`.`t14` as `t14`
left join `test`.`t4` as `t4` force index (idx19)
on (@var1 rlike @var2 )
right outer join `test`.`t22` as `t22`
on (@var4 rlike @var1 )
group by
t29.a29
limit 1
lock in share mode) order by 1
*************************** 3. row ***************************
Id: 5
User: root
Host: localhost:60302
db: test
Command: Query
Time: 3320
State: Waiting for table metadata lock
Info: delete t10 from (
select count(*) from
`test`.`t17` as `t17` force index (idx119,PRIMARY,idx119)
cross join `test`.`t7` as `t7` force index (PRIMARY)
on ( '1' )
natural left outer join `test`.`t26` as `t26`
natural left outer join `test`.`t3` as `t3` force index (idx15,idx15,PRIMARY)
straight_join `test`.`t27` as `t27` ignore index (idx247)
on ( insert(( cast((t17.a17) as unsigned)),( interval((t17.col186),(t17.col185),(t17.col185))),( ((t17.col185) in ((t17.col186),(t17.col186),(t17.a17),(t17.col185),(t17.a17)))),( current_timestamp())) | t17.col186 )
straight_join `test`.`t8` as `t8`
on (t17.col185 regexp @var9 )
left join `test`.`t10` as `t10` force index (PRIMARY)
on (@var0 is not unknown )
group by
t10.col90
limit 1
) `x`,
t10 as t10
where t10.col86>x.a17
*************************** 4. row ***************************
Id: 6
User: root
Host: localhost:60303
db: test
Command: Query
Time: 3321
State: Sending data
Info: (
select count(*) from
`test`.`t7` as `t7`
natural join `test`.`t25` as `t25` use index (PRIMARY)
natural left join `test`.`t5` as `t5`
cross join `test`.`t16` as `t16`
on (@var0 is not unknown )
natural join `test`.`t18` as `t18` force index (idx128)
natural left join `test`.`t29` as `t29` force index (idx267)
left join `test`.`t1` as `t1`
on (@var6 = t1.col3 )
limit 1
) union all (
select count(*) from
`test`.`t7` as `t7`
natural join `test`.`t25` as `t25` use index (PRIMARY)
natural left join `test`.`t5` as `t5`
cross join `test`.`t16` as `t16`
on ( export_set(( des_encrypt((t7.a7))),( ((t7.a7) < (t7.col58))),( ((t7.a7) in ((t7.col58),(t7.col56),(t7.col56),(t7.col56),(t7.col57))))) | des_encrypt((t16.col179)) )
natural join `test`.`t18` as `t18` force index (idx128)
natural left join `test`.`t29` as `t29` force index (idx267)
left join `test`.`t1` as `t1`
on ( ((t7.a7) not in ((t7.col58),(t7.a7),(t7.col57),(t7.col56),(t7.col57))) = @var0 )
limit 1
) order by 1
*************************** 5. row ***************************
Id: 7
User: root
Host: localhost:60304
db: test
Command: Query
Time: 3261
State: Waiting for table metadata lock
Info: create trigger `trg_t16_before_delete` before delete on `t16` for each row
begin
delete t20 from (
select col39,col35 from
`test`.`t26` as `t26`
right join `test`.`t10` as `t10`
on ( elt(( @@global.tmpdir),( interval((t26.col255),(t26.a26),(t26.a26),(t26.col256),(t26.col257),(t26.col255))),( ((t26.a26) - (t26.a26))),( least((t26.col254),(t26.col256),(t26.col257),(t26.a26))),( ((t26.col255) not between (t26.a26) and (t26.col257))),( get_format(datetime,'internal'))) - least((t10.a10),(t10.col87),(t10.col89),(t10.col89),(t10.col87)) )
left outer join `test`.`t5` as `t5`
on (t26.col257 and t5.col42 )
straight_join `test`.`t13` as `t13`
on (t26.col256 is not null )
where
t5.col41 not like 'l' or
t13.col140 & t10.col84 and not
t5.col46 = t10.col82
limit 1
) `x`,
t20 as t20
where t20.col214>x.col35
;
update (
select count(*) from
`test`.`t26` as `t26`
right join `test`.`t10` as `t10`
on (@var3 not rlike t10.a10 )
left outer join `test`.`t5` as `t5`
on (@var4 is unknown )
straight_join `test`.`t13` as `t13`
on ( '1' )
where
t5.col41 not like 'l' or
t13.col140 & t10.col84 and not
t5.col46 = t10.col82
limit 1
) `x`,
`test`.`t5` as `t5` set `t5`.`col47`=`x`.`col39`
;
select col39,col35 from
`test`.`t26` as `t26`
right join `test`.`t10` as `t10`
on (t26.a26 is not unknown )
left outer join `test`.`t5` as `t5`
on (t26.col256 is true )
straight_join `test`.`t13` as `t13`
on (@var4 <= t13.a13 )
where
t5.col41 not like 'l' or
t13.col140 & t10.col84 and not
t5.col46 = t10.col82
limit 1
into @`var0`,@`var1` ;
end
*************************** 6. row ***************************
Id: 8
User: root
Host: localhost:60305
db: test
Command: Query
Time: 2214
State: Waiting for table metadata lock
Info: delete from `test`.`t27` where `col258` <= 0 limit 1
*************************** 7. row ***************************
Id: 9
User: root
Host: localhost:60306
db: test
Command: Query
Time: 2331
State: Waiting for table metadata lock
Info: explain
select sql_no_cache all count(*) from
`test`.`t20` as `t20`
natural join `test`.`t2` as `t2` ignore index (idx7,PRIMARY)
natural left join `test`.`t25` as `t25` force index (PRIMARY)
left join `test`.`t4` as `t4`
on ( '1' )
having `col207` & `col207` and
`col207` || `col207`
for update
*************************** 8. row ***************************
Id: 10
User: root
Host: localhost:60307
db: test
Command: Query
Time: 3244
State: Waiting for table metadata lock
Info: create trigger `trg_t25_after_update` after update on `t25` for each row
begin
delete t18 from (
select count(*) from
`test`.`t11` as `t11` ignore index (idx76,idx66,idx79)
right join `test`.`t28` as `t28` ignore index (idx255,idx255)
on ( '1' )
limit 1
) `x`,
t18 as t18
where t18.col189>x.col268
;
update (
select count(*) from
`test`.`t11` as `t11` ignore index (idx76,idx66,idx79)
right join `test`.`t28` as `t28` ignore index (idx255,idx255)
on (@var2 is true )
limit 1
) `x`,
`test`.`t9` as `t9` set `t9`.`col72`=`x`.`col268`
;
select count(*) from
`test`.`t11` as `t11` ignore index (idx76,idx66,idx79)
right join `test`.`t28` as `t28` ignore index (idx255,idx255)
on ( ((t11.col102) not in ((t11.col110),(t11.col98),(t11.col94),(t11.col99))) || ((t28.col260) not in ((t28.col259),(t28.col272),(t28.col274))) )
limit 1
into @`var0` ;
end
*************************** 9. row ***************************
Id: 11
User: root
Host: localhost:60308
db: test
Command: Query
Time: 3216
State: Waiting for table metadata lock
Info: update ignore `test`.`t27` set
`a27` = '',
`col258` = '17:18:58'
where `col258`&& 23661 limit 1
*************************** 10. row ***************************
Id: 12
User: root
Host: localhost:60309
db: test
Command: Query
Time: 3165
State: Waiting for table metadata lock
Info: delete t15 from (
select count(*) from
`test`.`t28` as `t28` use index (idx250,idx250)
right outer join `test`.`t18` as `t18`
on (t28.a28 & @var6 )
natural left join `test`.`t19` as `t19`
right join `test`.`t26` as `t26` use index (idx220,PRIMARY,idx229)
on ( datediff((t28.col264),(t28.col263)) < elt((t26.col256),(t26.col257),(t26.a26),(t26.a26)) )
left join `test`.`t2` as `t2` use index (idx8,idx8)
on ( '1' )
inner join `test`.`t9` as `t9`
on ( '1' )
right outer join `test`.`t4` as `t4`
on ( coalesce((t28.col263),(t28.col270),(t28.col263),(t28.col266)) && null )
group by
t18.col192,
t28.col266
limit 1
) `x`,
t15 as t15
where t15.col170>x.col30
*************************** 11. row ***************************
Id: 13
User: root
Host: localhost:60310
db: test
Command: Query
Time: 3320
State: Waiting for table metadata lock
Info: insert ignore into `test`.`t6` set
`col52` = -1.3764409700144E+18,
`col53` = '2011-04-17 04:48:22',
`a6` = 0,
`col55` = 14038542,
`col54` = '2011-10-25 15:35:45'
*************************** 12. row ***************************
Id: 14
User: root
Host: localhost:60311
db: test
Command: Query
Time: 3286
State: Waiting for table metadata lock
Info: update (
select count(*) from
`test`.`t18` as `t18`
natural right join `test`.`t19` as `t19`
left outer join `test`.`t23` as `t23`
on (t18.col187 is not false )
cross join `test`.`t14` as `t14`
on ( '1' )
straight_join `test`.`t5` as `t5`
on ( export_set((t18.col191),(t18.col192),(t18.col193),(t18.col191)) >> ((t5.col50) not in ((t5.col39),(t5.col42),(t5.col35),(t5.col37))) )
where
t5.col41 <= t18.col187 and not
row(t18.col190 ,t18.col195 ,t5.col43 )>= row( t5.col50 , t19.col203 , t18.col191 )xor
t18.col195 sounds like t19.col200
group by
t5.col48,
t18.col195
limit 1
) `x`,
`test`.`t21` as `t21` set `t21`.`col220`=`x`.`col194`
*************************** 13. row ***************************
Id: 15
User: root
Host: localhost:60312
db: test
Command: Query
Time: 3193
State: Waiting for table metadata lock
Info: create trigger `trg_t27_before_delete` before delete on `t27` for each row
begin
delete t27 from (
select count(*) from
`test`.`t7` as `t7`
right outer join `test`.`t11` as `t11`
on (@var2 is unknown )
natural left outer join `test`.`t9` as `t9`
left join `test`.`t20` as `t20`
on (@var9 is not unknown )
where
t9.col74 < null and not
t11.col110 in( select '1' ) or
t11.col108 >( select '1' )
limit 1
) `x`,
t27 as t27
where t27.col258>x.a9
;
update (
select count(*) from
`test`.`t7` as `t7`
right outer join `test`.`t11` as `t11`
on (~t7.col58 )
natural left outer join `test`.`t9` as `t9`
left join `test`.`t20` as `t20`
on (t7.col57 not between t7.col56 and t20.col213 )
where
t9.col74 < null and not
t11.col110 in( select '1' ) or
t11.col108 >( select '1' )
limit 1
) `x`,
`test`.`t1` as `t1` set `t1`.`a1`=`x`.`a9`
;
select count(*) from
`test`.`t7` as `t7`
right outer join `test`.`t11` as `t11`
on (t7.col57 between @var9 and t11.col106 )
natural left outer join `test`.`t9` as `t9`
left join `test`.`t20` as `t20`
on (@var7 is true )
where
t9.col74 < null and not
t11.col110 in( select '1' ) or
t11.col108 >( select '1' )
limit 1
into @`var0` ;
end
*************************** 14. row ***************************
Id: 16
User: root
Host: localhost:60313
db: test
Command: Query
Time: 3320
State: Waiting for table metadata lock
Info: select all count(*) from
`test`.`t11` as `t11`
inner join `test`.`t17` as `t17`
on (t11.col91 is not true )
right outer join `test`.`t10` as `t10` ignore index (idx56,idx63,idx64,idx64)
on ( repeat(( ((t11.col107) not in ((t11.col96),(t11.col92),(t11.col99),(t11.col98),(t11.a11)))),( interval((t11.col103),(t11.col96),(t11.col94),(t11.col99),(t11.col108))) mod 10) <> @var7 )
natural right join `test`.`t5` as `t5`
natural join `test`.`t25` as `t25` use index (PRIMARY)
right outer join `test`.`t13` as `t13`
on ( ((t11.col105) in ((t11.col95),(t11.col106),(t11.col93),(t11.col101))) | @var3 )
straight_join `test`.`t22` as `t22`
on (t11.col110 is not false )
natural right join `test`.`t12` as `t12` use index (idx86)
right join `test`.`t27` as `t27` use index (idx238)
on ( (case ((t11.a11)) when ((t11.col108)) then ((t11.col102)) else ((t11.col100)) end) like greatest(( ((t27.col258) not in ((t27.col258),(t27.a27),(t27.a27),(t27.a27),(t27.col258)))),( ((t27.a27) in ((t27.a27),(t27.a27),(t27.col258)))),( @@global.flush_time),( (case ((t27.col258)) when ((t27.a27)) then ((t27.a27)) end)),( nullif((t27.col258),(t27.col258)))) )
right join `test`.`t6` as `t6` force index (PRIMARY,PRIMARY,idx28,idx24)
on (t11.col108 << t6.col54 )
where
t10.col85 collate latin1_bin < t11.col103 and not
row(t11.col96 ,t10.col83 )<> row( t11.col104 , t10.col81 )
limit 1
for update
*************************** 15. row ***************************
Id: 17
User: root
Host: localhost:60314
db: test
Command: Query
Time: 2331
State: Waiting for table metadata lock
Info: explain extended
select all sql_no_cache count(*) from
`test`.`t26` as `t26` force index (PRIMARY,idx229,idx233,idx225)
straight_join `test`.`t2` as `t2`
on (@var7 is true )
left outer join `test`.`t29` as `t29`
on (@var3 is not unknown )
group by
t26.col256 desc,
(( interval((`t2`.`col12`),(`t29`.`col286`),(`t26`.`col255`),(`t29`.`col281`),(`t2`.`col14`),(`t2`.`col10`))) in (( substring((`t29`.`col284`),(`t29`.`col281`),(`t29`.`col283`))),( greatest((`t26`.`col254`),(`t29`.`col286`),(`t26`.`a26`),(`t29`.`col288`),(`t2`.`col10`))),( interval((`t29`.`col289`),(`t2`.`col11`),((
select count(*) from
`test`.`t7` as `t7` use index (PRIMARY,PRIMARY)
left join `test`.`t12` as `t12` use index (idx97,idx90)
on (t7.col56 is not null )
right outer join `test`.`t22` as `t22` ignore index (idx189,idx176,idx185)
on ( (case ((t7.col58)) when ((t7.col58)) then ((t7.col57))when ((t7.col56)) then ((t7.a7)) else ((t7.a7)) end) = last_insert_id(( @@global.timed_mutexes)) )
left join `test`.`t6` as `t6` use index (PRIMARY)
on ( '1' )
left join `test`.`t14` as `t14`
on ( '1' )
where
t7.col56 ^ t7.col56
limit 1
)),((
select count(*) from
`test`.`t7` as `t7` use index (PRIMARY,PRIMARY)
left join `test`.`t12` as `t12` use index (idx97,idx90)
on ( '1' )
right outer join `test`.`t22` as `t22` ignore index (idx189,idx176,idx185)
on ( elt((t7.a7),(t7.col58),(t7.col58),(t7.a7)) xor @@global.slave_compressed_protocol )
left join `test`.`t6` as `t6` use index (PRIMARY)
on ( ((t7.col58) sounds like (t7.col58)) > convert((t6.col52) using cp1251) )
left join `test`.`t14` as `t14`
on (~t7.col56 )
where
t7.col56 ^ t7.col56
limit 1
)),(`t26`.`col254`),((
select count(*) from
`test`.`t7` as `t7` use index (PRIMARY,PRIMARY)
left join `test`.`t12` as `t12` use index (idx97,idx90)
on (@var4 - t12.a12 )
right outer join `test`.`t22` as `t22` ignore index (idx189,idx176,idx185)
on (!t7.a7 )
left join `test`.`t6` as `t6` use index (PRIMARY)
on ( '1' )
left join `test`.`t14` as `t14`
on ( (case ((t7.a7)) when ((t7.col57)) then ((t7.col57))when ((t7.col56)) then ((t7.col57)) else ((t7.col58)) end) << elt(( substring((t14.col151),(t14.col154),(t14.col149))),( ((t14.col152) in ((t14.col154),(t14.col149),(t14.col150),(t14.col154),(t14.col151)))),( ((t14.col155) in ((t14.col153),(t14.col153),(t14.col153),(t14.col153),(t14.col152)))),( @@global.time_format)) )
where
t7.col56 ^ t7.col56
limit 1
)))),( ((`t26`.`a26`) % (`t29`.`col291`)))))
order by
(case ((`t2`.`col8`)) when ((`t2`.`a2`)) then ((`t29`.`col293`))when ((`t2`.`col18`)) then ((`t26`.`col257`)) else ((`t2`.`col18`)) end) ,
t26.a26
*************************** 16. row ***************************
Id: 18
User: root
Host: localhost:60315
db: test
Command: Query
Time: 2331
State: Waiting for table metadata lock
Info: select count(*) from
`test`.`t19` as `t19` ignore index (idx141,idx131,idx145,idx131)
natural left outer join `test`.`t25` as `t25`
left join `test`.`t27` as `t27`
on (t19.col199 < t27.a27 )
natural join `test`.`t29` as `t29` force index (idx260,idx266,PRIMARY)
left outer join `test`.`t21` as `t21`
on (t19.col202 | @var5 )
limit 1
union all
select
`t25`.`a25` as a25 ,
`t19`.`col199` as col199
from
`test`.`t19` as `t19` ignore index (idx141,idx131,idx145,idx131)
natural left outer join `test`.`t25` as `t25`
left join `test`.`t27` as `t27`
on (@var2 << @var2 )
natural join `test`.`t29` as `t29` force index (idx260,idx266,PRIMARY)
left outer join `test`.`t21` as `t21`
on ( coalesce((t19.col203),(t19.col203),(t19.a19)) / convert((t21.col221) using hp8) )
limit 1
*************************** 17. row ***************************
Id: 19
User: root
Host: localhost:60316
db: test
Command: Query
Time: 3216
State: Waiting for table metadata lock
Info: insert ignore into `test`.`t21` set
`col219` = 0.3606,
`col222` = -3.9366862609486E+18,
`col224` = 1,
`col225` = "…»QõT¢eŽ½O¾w’",
`col226` = 669377,
`col223` = '',
`col218` = -1268352046,
`a21` = '2010-04-17 15:10:24',
`col221` = 3114,
`col220` = 3062870
*************************** 18. row ***************************
Id: 20
User: root
Host: localhost:60317
db: test
Command: Query
Time: 3248
State: Waiting for table metadata lock
Info: delete t10 from (
select count(*) from
`test`.`t7` as `t7` force index (idx31)
natural right outer join `test`.`t12` as `t12`
left join `test`.`t2` as `t2`
on (@var2 not rlike @var4 )
left outer join `test`.`t11` as `t11` use index (PRIMARY,idx77,idx73)
on ( get_format(time,'eur') | @var5 )
cross join `test`.`t17` as `t17`
on (t7.a7 * @var5 )
inner join `test`.`t13` as `t13`
on ( '1' )
group by
t12.col118
limit 1
) `x`,
t10 as t10
where t10.col90>x.col102
*************************** 19. row ***************************
Id: 21
User: root
Host: localhost:60318
db: test
Command: Query
Time: 3314
State: Waiting for table metadata lock
Info: explain extended
select sql_no_cache distinctrow col184 from
`test`.`t27` as `t27`
right outer join `test`.`t5` as `t5`
on ( '1' )
cross join `test`.`t23` as `t23`
on ( week((t27.col258),6) | t27.a27 )
right join `test`.`t6` as `t6` force index (idx24)
on ( greatest(( char((t27.a27) using eucjpms)),( ((t27.col258) in ((t27.a27),(t27.a27),(t27.a27),(t27.a27),(t27.col258)))),( mid((t27.a27),(t27.a27),(t27.a27))),( char((t27.col258) using latin5)),( @@global.character_set_system)) or elt((t6.col52),(t6.col54),(t6.a6),(t6.a6),(t6.a6),(t6.col53)) )
natural join `test`.`t7` as `t7`
left join `test`.`t16` as `t16`
on ( ceiling((t27.a27)) not rlike @var8 )
inner join `test`.`t26` as `t26`
on ( greatest((t27.col258),(t27.a27)) <> (( ((t26.col257) not in ((t26.col256),(t26.a26),(t26.col254),(t26.col256),(t26.col255)))) not in (( @@global.server_id),( export_set((t26.col255),(t26.col257),(t26.a26),(t26.col256),(t26.col254))))) )
natural right join `test`.`t20` as `t20` use index (idx155,idx155,idx155)
straight_join `test`.`t24` as `t24`
on (t27.a27 is null )
natural left join `test`.`t4` as `t4` force index (PRIMARY)
right join `test`.`t22` as `t22` ignore index (idx189,idx184,idx184)
on (t27.col258 is not true )
group by
t5.col47
order by
t20.col213 desc,
t4.col29
*************************** 20. row ***************************
Id: 22
User: root
Host: localhost:60319
db: test
Command: Query
Time: 3193
State: Waiting for table metadata lock
Info: create trigger `trg_t10_before_delete` before delete on `t10` for each row
begin
delete t29 from (
select count(*) from
`test`.`t18` as `t18` ignore index (PRIMARY)
natural left outer join `test`.`t1` as `t1` ignore index (PRIMARY,idx1)
right outer join `test`.`t28` as `t28`
on (t18.col197 | @var7 )
left outer join `test`.`t25` as `t25` ignore index (idx212)
on (t18.col188 is true )
limit 1
) `x`,
t29 as t29
where t29.col295>x.col196
;
update (
select count(*) from
`test`.`t18` as `t18` ignore index (PRIMARY)
natural left outer join `test`.`t1` as `t1` ignore index (PRIMARY,idx1)
right outer join `test`.`t28` as `t28`
on ( str_to_date((t18.col189),(t18.col198)) * weekofyear(( least((t28.col268),(t28.col267),(t28.col269),(t28.col273),(t28.col263)))) )
left outer join `test`.`t25` as `t25` ignore index (idx212)
on (t18.col190 >> t25.col253 )
limit 1
) `x`,
`test`.`t28` as `t28` set `t28`.`col259`=`x`.`col196`
;
select
`t18`.`col196` as col196
from
`test`.`t18` as `t18` ignore index (PRIMARY)
natural left outer join `test`.`t1` as `t1` ignore index (PRIMARY,idx1)
right outer join `test`.`t28` as `t28`
on (!t18.col196 )
left outer join `test`.`t25` as `t25` ignore index (idx212)
on (@var0 is not false )
limit 1
into @`var0` ;
end
*************************** 21. row ***************************
Id: 23
User: root
Host: localhost:60320
db: test
Command: Query
Time: 3244
State: Waiting for table metadata lock
Info: create trigger `trg_t21_before_insert` before insert on `t21` for each row
begin
delete t16 from (
select count(*) from
`test`.`t16` as `t16`
left join `test`.`t28` as `t28` use index (PRIMARY,idx255,PRIMARY)
on (t16.a16 is not false )
cross join `test`.`t26` as `t26`
on (t16.col176 is true )
limit 1
) `x`,
t16 as t16
where t16.a16>x.col267
;
update (
select count(*) from
`test`.`t16` as `t16`
left join `test`.`t28` as `t28` use index (PRIMARY,idx255,PRIMARY)
on (t16.a16 not regexp @var1 )
cross join `test`.`t26` as `t26`
on (@var0 is not true )
limit 1
) `x`,
`test`.`t9` as `t9` set `t9`.`col77`=`x`.`col267`
;
select count(*) from
`test`.`t16` as `t16`
left join `test`.`t28` as `t28` use index (PRIMARY,idx255,PRIMARY)
on ( substring(( ((t16.col182) in ((t16.col174),(t16.col177),(t16.col181),(t16.col182),(t16.col180)))) from ( timestamp((t16.col176),(t16.col182))) for ( @@global.max_tmp_tables)) - t16.a16 )
cross join `test`.`t26` as `t26`
on ( @@global.system_time_zone <=> convert(( collation((t26.col254))) using gb2312) )
limit 1
into @`var0` ;
end
*************************** 22. row ***************************
Id: 24
User: root
Host: localhost:60321
db: test
Command: Query
Time: 1889
State: Waiting for table metadata lock
Info: select count(*) from
`test`.`t19` as `t19`
right join `test`.`t12` as `t12`
on ( (case (( ((t19.col199) not in ((t19.col199),(t19.col205),(t19.col202))))) when (( @@global.net_write_timeout)) then (( period_diff((t19.col200),(t19.col203))))when (( position((t19.col201) in (t19.col199)))) then (( @@global.slave_compressed_protocol)) else (( greatest((t19.col201),(t19.col203),(t19.col199),(t19.col199)))) end) | @var9 )
natural join `test`.`t29` as `t29` ignore index (idx272,idx260,idx265)
natural right join `test`.`t17` as `t17` use index (idx112,idx114,idx120,idx119)
right join `test`.`t6` as `t6` use index (idx24,idx25)
on ( '1' )
limit 1
union all
select
interval((`t19`.`col199`),(`t19`.`col199`),(`t19`.`col199`),(`t19`.`col199`),(`t19`.`col199`),((
select count(*) from
`test`.`t19` as `t19`
right join `test`.`t12` as `t12`
on ( '1' )
natural join `test`.`t29` as `t29` ignore index (idx272,idx260,idx265)
natural right join `test`.`t17` as `t17` use index (idx112,idx114,idx120,idx119)
right join `test`.`t6` as `t6` use index (idx24,idx25)
on (t19.col199 is null )
limit 1
))) as col199
from
`test`.`t19` as `t19`
right join `test`.`t12` as `t12`
on ( coalesce(( unhex((t19.col202))),( @@global.myisam_stats_method),( elt((t19.a19),(t19.col200),(t19.col199),(t19.col204))),( log((t19.col204),(t19.col202))),( yearweek((t19.col199),(t19.col199)))) | ((t12.col127) or (t12.a12)) )
natural join `test`.`t29` as `t29` ignore index (idx272,idx260,idx265)
natural right join `test`.`t17` as `t17` use index (idx112,idx114,idx120,idx119)
right join `test`.`t6` as `t6` use index (idx24,idx25)
on (~t19.col200 )
limit 1
*************************** 23. row ***************************
Id: 25
User: root
Host: localhost:60322
db: test
Command: Query
Time: 3266
State: Waiting for table metadata lock
Info: create trigger `trg_t6_before_insert` before insert on `t6` for each row
begin
delete t22 from (
select count(*) from
`test`.`t7` as `t7` force index (idx31,PRIMARY)
left outer join `test`.`t21` as `t21`
on (@var7 sounds like @var3 )
limit 1
) `x`,
t22 as t22
where t22.a22>x.a7
;
update (
select count(*) from
`test`.`t7` as `t7` force index (idx31,PRIMARY)
left outer join `test`.`t21` as `t21`
on (@var0 < t21.col223 )
limit 1
) `x`,
`test`.`t10` as `t10` set `t10`.`col81`=`x`.`a7`
;
select count(*) from
`test`.`t7` as `t7` force index (idx31,PRIMARY)
left outer join `test`.`t21` as `t21`
on ( updatexml(( ((t7.col58) div (t7.col57))),( (case ((t7.col56)) when ((t7.col57)) then ((t7.a7))when ((t7.col56)) then ((t7.col58)) else ((t7.col56)) end)),( ((t7.col56) not in ((t7.a7))))) regexp insert((t21.col223),(t21.col224),(t21.col222),(t21.col222)) )
limit 1
into @`var0` ;
end
*************************** 24. row ***************************
Id: 26
User: root
Host: localhost:60323
db: test
Command: Query
Time: 3244
State: Waiting for table metadata lock
Info: create trigger `trg_t28_before_update` before update on `t28` for each row
begin
delete t17 from (
select count(*) from
`test`.`t15` as `t15`
inner join `test`.`t23` as `t23`
on ( convert(( release_lock((t15.col169))),binary) xor (case (( ((t23.a23) in ((t23.col234),(t23.a23),(t23.col235),(t23.col234))))) when (( @@global.bulk_insert_buffer_size)) then (( maketime((t23.col234),(t23.col234),(t23.col235))))when (( elt((t23.col234),(t23.col234),(t23.col235),(t23.col235),(t23.col235)))) then (( period_diff((t23.a23),(t23.col234)))) else (( greatest((t23.col235),(t23.col235),(t23.col235),(t23.col235),(t23.a23)))) end) )
where
t15.col168 ^ t15.col160 xor
row(t23.col235 ,t15.col164 collate utf8_esperanto_ci )< row( t15.col160 , t15.col170 collate latin1_german2_ci )
limit 1
) `x`,
t17 as t17
where t17.a17>x.col169
;
update (
select count(*) from
`test`.`t15` as `t15`
inner join `test`.`t23` as `t23`
on ( (( char((t15.col168) using eucjpms)) in (( date_sub((t15.col159),interval (t15.a15) month)),( coalesce((t15.col168),(t15.col171),(t15.col158),(t15.col168))),( greatest((t15.col168),(t15.col171),(t15.col162),(t15.a15),(t15.col167))),( @@global.local_infile),( elt((t15.col161),(t15.col161),(t15.col159),(t15.a15),(t15.col160),(t15.col163))))) != (case (( (case ((t23.a23)) when ((t23.a23)) then ((t23.col235)) else ((t23.a23)) end))) when (( ((t23.a23) in ((t23.a23),(t23.col234),(t23.col235),(t23.a23),(t23.col235))))) then (( convert((t23.a23) using cp1257))) end) )
where
t15.col168 ^ t15.col160 xor
row(t23.col235 ,t15.col164 collate utf8_esperanto_ci )< row( t15.col160 , t15.col170 collate latin1_german2_ci )
limit 1
) `x`,
`test`.`t24` as `t24` set `t24`.`col244`=`x`.`col169`
;
select count(*) from
`test`.`t15` as `t15`
inner join `test`.`t23` as `t23`
on ( power(( ((t15.col158) between (t15.col172) and (t15.col168))),( addtime((t15.col159),(t15.col165)))) = @var7 )
where
t15.col168 ^ t15.col160 xor
row(t23.col235 ,t15.col164 collate utf8_esperanto_ci )< row( t15.col160 , t15.col170 collate latin1_german2_ci )
limit 1
into @`var0` ;
end
*************************** 25. row ***************************
Id: 27
User: root
Host: localhost:60324
db: test
Command: Query
Time: 3270
State: Waiting for table metadata lock
Info: explain
select col283,col119 from
`test`.`t22` as `t22` ignore index (PRIMARY,idx188,idx189,idx181)
left join `test`.`t6` as `t6` force index (PRIMARY)
on (@var5 = t6.col54 )
natural left outer join `test`.`t29` as `t29` force index (PRIMARY,idx272,PRIMARY)
natural join `test`.`t24` as `t24` use index (idx195,idx209)
inner join `test`.`t12` as `t12`
on ( '1' )
left join `test`.`t13` as `t13`
on (t22.a22 <=> t13.col140 )
inner join `test`.`t26` as `t26` force index (PRIMARY)
on (@var1 is unknown )
where
t24.col244 & '2011-10-07 21:33:54' and not
t13.col140 | t24.col241
*************************** 26. row ***************************
Id: 28
User: root
Host: localhost:60325
db: test
Command: Query
Time: 3165
State: Waiting for table metadata lock
Info: update ignore `test`.`t16` set
`a16` = '',
`col173` = -1075813,
`col174` = from_unixtime(unix_timestamp()),
`col175` = "îÊðÙÉ5 j¸ÊÀ!1Z",
`col176` = "Á¤ãX7ÁÍM‹¦ætß3ä",
`col177` = '2011-09-11 03:56:03',
`col178` = '2011-07-21',
`col179` = 'mumdimdc',
`col180` = null,
`col181` = geomfromtext("point(-1931 -35765)"),
`col182` = null,
`col183` = -5246711,
`col184` = -41
where `col184`<=> "ep" limit 1
*************************** 27. row ***************************
Id: 29
User: root
Host: localhost:60326
db: test
Command: Query
Time: 3312
State: Sending data
Info: select count(*) from
`test`.`t23` as `t23` force index (PRIMARY,idx192)
natural right join `test`.`t3` as `t3` ignore index (idx13,idx15)
left outer join `test`.`t10` as `t10` ignore index (idx56)
on ( '1' )
left outer join `test`.`t18` as `t18`
on (@var7 is not false )
natural right join `test`.`t7` as `t7` force index (PRIMARY)
right outer join `test`.`t1` as `t1`
on (t23.col234 is not null )
inner join `test`.`t21` as `t21` force index (PRIMARY,PRIMARY,PRIMARY,idx174)
on ( '1' )
limit 1
union all
select col235 from
`test`.`t23` as `t23` force index (PRIMARY,idx192)
natural right join `test`.`t3` as `t3` ignore index (idx13,idx15)
left outer join `test`.`t10` as `t10` ignore index (idx56)
on ( '1' )
left outer join `test`.`t18` as `t18`
on (@var7 regexp @var3 )
natural right join `test`.`t7` as `t7` force index (PRIMARY)
right outer join `test`.`t1` as `t1`
on (@var4 is true )
inner join `test`.`t21` as `t21` force index (PRIMARY,PRIMARY,PRIMARY,idx174)
on ( '1' )
limit 1
*************************** 28. row ***************************
Id: 30
User: root
Host: localhost:60327
db: test
Command: Query
Time: 2331
State: Waiting for table metadata lock
Info: explain partitions
select sql_cache all col215 from
`test`.`t6` as `t6`
natural left outer join `test`.`t25` as `t25`
left outer join `test`.`t12` as `t12`
on (@var0 & t12.col113 )
left join `test`.`t5` as `t5`
on (t6.col53 is not null )
natural left outer join `test`.`t11` as `t11`
cross join `test`.`t14` as `t14`
on ( @@global.myisam_data_pointer_size + t6.col55 )
right outer join `test`.`t27` as `t27` ignore index (idx241)
on ( (case ((t6.col52)) when ((t6.a6)) then ((t6.col54))when ((t6.a6)) then ((t6.col52)) else ((t6.col52)) end) <= timestamp((t27.a27)) )
left outer join `test`.`t20` as `t20`
on ( coalesce(( least((t6.col52),(t6.col53),(t6.col52),(t6.col52),(t6.col54))),( get_format(datetime,'eur')),( coalesce((t6.col52),(t6.col53),(t6.a6),(t6.col52),(t6.a6)))) rlike @var3 )
left join `test`.`t18` as `t18`
on (@var5 < t18.col191 )
left join `test`.`t3` as `t3` ignore index (idx13)
on ( ((t6.a6) not in ((t6.col55),(t6.col52),(t6.col53),(t6.col52))) not rlike t6.col54 )
*************************** 29. row ***************************
Id: 31
User: root
Host: localhost:60328
db: test
Command: Query
Time: 3190
State: Waiting for table metadata lock
Info: update ignore `test`.`t25` set
`col252` = 0,
`col253` = 2071150030,
`a25` = geomfromtext("point(90237 67715)")
where `a25`>= 2249025804 limit 1
*************************** 30. row ***************************
Id: 32
User: root
Host: localhost:60329
db: test
Command: Query
Time: 3218
State: Waiting for table metadata lock
Info: create trigger `trg_t17_after_update` after update on `t17` for each row
begin
delete t25 from (
select
group_concat(distinct (`t15`.`col170`) order by ((
select count(*) from
`test`.`t15` as `t15`
left join `test`.`t1` as `t1` ignore index (idx1)
on ( '1' )
left join `test`.`t12` as `t12` force index (PRIMARY,idx90)
on (t15.col171 = @var5 )
natural left outer join `test`.`t9` as `t9`
inner join `test`.`t21` as `t21`
on (@var5 % t21.col221 )
natural left join `test`.`t29` as `t29` force index (idx260,idx272,idx265)
right outer join `test`.`t22` as `t22`
on ( '1' )
natural left join `test`.`t7` as `t7`
right join `test`.`t5` as `t5`
on (t15.col170 is true )
right outer join `test`.`t16` as `t16`
on (t15.col163 is not true )
where
t15.col169 < timestamp(now())
limit 1
)) desc) as col170 ,
`t15`.`col169` as col169
from
`test`.`t15` as `t15`
left join `test`.`t1` as `t1` ignore index (idx1)
on (t15.col172 <> @var9 )
left join `test`.`t12` as `t12` force index (PRIMARY,idx90)
on ( ((t15.col161) between (t15.col170) and (t15.col160)) + t15.col162 )
natural left outer join `test`.`t9` as `t9`
inner join `test`.`t21` as `t21`
on ( (( ((t15.col172) not in ((t15.col171),(t15.col165),(t15.col162),(t15.a15),(t15.col161)))) not in (( @@global.tx_isolation),( addtime((t15.col167),(t15.col159))),( timediff((t15.col159),(t15.col169))),( coalesce((t15.a15),(t15.col172),(t15.col161),(t15.col162))),( ((t15.col158) in ((t15.col158),(t15.col167),(t15.col161),(t15.col167),(t15.col159)))))) << monthname((t21.col226)) )
natural left join `test`.`t29` as `t29` force index (idx260,idx272,idx265)
right outer join `test`.`t22` as `t22`
on (@var9 is true )
natural left join `test`.`t7` as `t7`
right join `test`.`t5` as `t5`
on ( maketime((t15.col159),(t15.col165),(t15.col158)) % t15.col164 )
right outer join `test`.`t16` as `t16`
on ( '1' )
where
t15.col169 < timestamp(now())
limit 1
) `x`,
t25 as t25
where t25.a25>x.col170
;
update (
select count(*) from
`test`.`t15` as `t15`
left join `test`.`t1` as `t1` ignore index (idx1)
on (t15.col166 is false )
left join `test`.`t12` as `t12` force index (PRIMARY,idx90)
on (t15.col167 >> @var8 )
natural left outer join `test`.`t9` as `t9`
inner join `test`.`t21` as `t21`
on (@var9 is false )
natural left join `test`.`t29` as `t29` force index (idx260,idx272,idx265)
right outer join `test`.`t22` as `t22`
on (@var2 && t22.col230 )
natural left join `test`.`t7` as `t7`
right join `test`.`t5` as `t5`
on (t15.col160 regexp t5.col47 )
right outer join `test`.`t16` as `t16`
on (@var7 between t15.col162 and t16.col173 )
where
t15.col169 < timestamp(now())
limit 1
) `x`,
`test`.`t3` as `t3` set `t3`.`col19`=`x`.`col169`
;
select count(*) from
`test`.`t15` as `t15`
left join `test`.`t1` as `t1` ignore index (idx1)
on ( greatest(( ((t15.col158) in ((t15.col168),(t15.col158),(t15.col169),(t15.col162),(t15.col167)))),( mid((t15.col167),(t15.a15),(t15.col164))),( ((t15.col166) between (t15.col162) and (t15.col159)))) or t15.col172 )
left join `test`.`t12` as `t12` force index (PRIMARY,idx90)
on ( '1' )
natural left outer join `test`.`t9` as `t9`
inner join `test`.`t21` as `t21`
on ( '1' )
natural left join `test`.`t29` as `t29` force index (idx260,idx272,idx265)
right outer join `test`.`t22` as `t22`
on ( ((t15.col162) ^ (t15.col170)) - @var3 )
natural left join `test`.`t7` as `t7`
right join `test`.`t5` as `t5`
on (@var4 like t5.col43 )
right outer join `test`.`t16` as `t16`
on (t15.col159 is not unknown )
where
t15.col169 < timestamp(now())
limit 1
into @`var0`,@`var1` ;
end
*************************** 31. row ***************************
Id: 33
User: root
Host: localhost:60330
db: test
Command: Query
Time: 3244
State: Waiting for table metadata lock
Info: explain
select distinctrow sql_no_cache col179 from
`test`.`t27` as `t27` ignore index (idx238,PRIMARY,idx240,idx247)
straight_join `test`.`t19` as `t19` force index (idx132,idx143)
on (t27.col258 is not unknown )
natural right join `test`.`t4` as `t4` use index (PRIMARY)
cross join `test`.`t16` as `t16`
on (t27.a27 < t16.col181 )
straight_join `test`.`t21` as `t21`
on (@var2 is not false )
inner join `test`.`t3` as `t3` use index (idx13,idx15,idx15)
on ( '1' )
left outer join `test`.`t7` as `t7` ignore index (idx31)
on ( char_length((t27.a27)) >> t27.a27 )
right join `test`.`t14` as `t14`
on ( '1' )
right join `test`.`t8` as `t8` force index (idx39,idx39)
on (@var4 >> @var9 )
order by
t27.col258 desc,
t8.a8
limit 259
*************************** 32. row ***************************
Id: 34
User: root
Host: localhost:60331
db: test
Command: Query
Time: 3216
State: Waiting for table metadata lock
Info: create trigger `trg_t27_before_update` before update on `t27` for each row
begin
delete t29 from (
select count(*) from
`test`.`t4` as `t4` force index (PRIMARY,idx19)
straight_join `test`.`t22` as `t22` use index (idx185,idx180)
on (t4.col26 is not unknown )
limit 1
) `x`,
t29 as t29
where t29.col282>x.col30
;
update (
select count(*) from
`test`.`t4` as `t4` force index (PRIMARY,idx19)
straight_join `test`.`t22` as `t22` use index (idx185,idx180)
on ( uncompress(( acos((t4.col26)))) > @@global.server_id )
limit 1
) `x`,
`test`.`t3` as `t3` set `t3`.`a3`=`x`.`col230`
;
select count(*) from
`test`.`t4` as `t4` force index (PRIMARY,idx19)
straight_join `test`.`t22` as `t22` use index (idx185,idx180)
on (~t4.col25 )
limit 1
into @`var0`,@`var1` ;
end
*************************** 33. row ***************************
Id: 35
User: root
Host: localhost:60332
db: test
Command: Query
Time: 2331
State: Waiting for table metadata lock
Info: select
`t8`.`col60` as col60
from
`test`.`t17` as `t17` ignore index (idx119,idx119)
inner join `test`.`t6` as `t6` force index (idx24,idx28,idx28)
on ( convert_tz(( greatest((t17.col186),(t17.a17),(t17.col185),(t17.a17),(t17.a17))),( greatest((t17.a17),(t17.col185),(t17.col186),(t17.col186))),( export_set((t17.col185),(t17.a17),(t17.col185),(t17.col186)))) && (( bit_length((t6.col55))) not in (( ((t6.col54) not in ((t6.col55),(t6.a6),(t6.col52),(t6.col55)))),( now()),( subdate((t6.col54),interval (t6.col55) hour)),( (case when (t6.col53) then (t6.col52) else (t6.col55) end)))) )
natural left join `test`.`t13` as `t13`
natural join `test`.`t8` as `t8`
natural left join `test`.`t3` as `t3` force index (idx13)
left join `test`.`t22` as `t22` ignore index (idx189,idx189)
on (@var1 = @var4 )
limit 1
union
select count(*) from
`test`.`t17` as `t17` ignore index (idx119,idx119)
inner join `test`.`t6` as `t6` force index (idx24,idx28,idx28)
on ( '1' )
natural left join `test`.`t13` as `t13`
natural join `test`.`t8` as `t8`
natural left join `test`.`t3` as `t3` force index (idx13)
left join `test`.`t22` as `t22` ignore index (idx189,idx189)
on ( ((t17.col185) between (t17.a17) and (t17.col185)) + t17.col186 )
limit 1
*************************** 34. row ***************************
Id: 36
User: root
Host: localhost:60333
db: test
Command: Query
Time: 3258
State: Waiting for table metadata lock
Info: create trigger `trg_t26_before_insert` before insert on `t26` for each row
begin
delete t14 from (
select
`t5`.`col37` as col37
from
`test`.`t3` as `t3`
natural left outer join `test`.`t2` as `t2`
right join `test`.`t5` as `t5`
on (@var4 = @var6 )
inner join `test`.`t7` as `t7` force index (PRIMARY,PRIMARY)
on ( updatexml((t3.col21),(t3.col23),(t3.col20)) and t3.col21 )
left outer join `test`.`t27` as `t27` force index (PRIMARY)
on (t3.col23 * t27.a27 )
where
t3.col21 <> t2.col9 xor not
row(t5.col50 ,t3.a3 )!= row( t3.col23 , t3.col23 )
group by
t5.a5,
t2.col7
limit 1
) `x`,
t14 as t14
where t14.col152>x.col37
;
update (
select col37 from
`test`.`t3` as `t3`
natural left outer join `test`.`t2` as `t2`
right join `test`.`t5` as `t5`
on (@var8 is not null )
inner join `test`.`t7` as `t7` force index (PRIMARY,PRIMARY)
on ( '1' )
left outer join `test`.`t27` as `t27` force index (PRIMARY)
on ( substring((t3.col19) from (t3.col23) for (t3.col22)) ^ interval((t27.a27),(t27.a27),(t27.a27),(t27.a27),(t27.col258),(t27.col258)) )
where
t3.col21 <> t2.col9 xor not
row(t5.col50 ,t3.a3 )!= row( t3.col23 , t3.col23 )
group by
t5.a5,
t2.col7
limit 1
) `x`,
`test`.`t28` as `t28` set `t28`.`col266`=`x`.`col37`
;
select count(*) from
`test`.`t3` as `t3`
natural left outer join `test`.`t2` as `t2`
right join `test`.`t5` as `t5`
on (t3.col22 is null )
inner join `test`.`t7` as `t7` force index (PRIMARY,PRIMARY)
on ( concat_ws((t3.col19),(t3.col22),(t3.col21)) <= @var4 )
left outer join `test`.`t27` as `t27` force index (PRIMARY)
on (@var7 << t27.a27 )
where
t3.col21 <> t2.col9 xor not
row(t5.col50 ,t3.a3 )!= row( t3.col23 , t3.col23 )
group by
t5.a5,
t2.col7
limit 1
into @`var0` ;
end
*************************** 35. row ***************************
Id: 37
User: root
Host: localhost:60334
db: test
Command: Query
Time: 2279
State: Waiting for table metadata lock
Info: insert ignore into `test`.`t27` set
`a27` = 'nalyiwqifiitsccp',
`col258` = 3721
*************************** 36. row ***************************
Id: 38
User: root
Host: localhost:60335
db: test
Command: Query
Time: 3261
State: Waiting for table metadata lock
Info: delete from `test`.`t6` where `col54` >= null limit 1
*************************** 37. row ***************************
Id: 39
User: root
Host: localhost:60336
db: test
Command: Query
Time: 3163
State: Waiting for table metadata lock
Info: update ignore `test`.`t6` set
`col52` = 8634042,
`col53` = '2010-10-22',
`a6` = -8.3404022104877E+18,
`col55` = 255,
`col54` = 74
where `col54`< null limit 1
*************************** 38. row ***************************
Id: 40
User: root
Host: localhost:60337
db: test
Command: Query
Time: 3320
State: Waiting for table metadata lock
Info: delete t28 from (
select col264,a12 from
`test`.`t26` as `t26`
right outer join `test`.`t4` as `t4`
on ( '1' )
natural join `test`.`t11` as `t11` ignore index (idx80,idx75)
natural left join `test`.`t21` as `t21` use index (idx173,idx173,PRIMARY)
natural left join `test`.`t27` as `t27`
natural left outer join `test`.`t12` as `t12` force index (idx97,idx97)
natural left outer join `test`.`t28` as `t28`
right outer join `test`.`t15` as `t15`
on (@var3 << t15.col168 )
cross join `test`.`t29` as `t29` force index (idx262,idx272,idx265)
on (@var6 is not false )
where
row(t26.col255 ,t4.col28 collate latin1_danish_ci ,t12.col116 )!= row( t11.col106 collate latin1_german1_ci , t26.col254 , t11.col91 )or not
t26.col254 <> -2522
limit 1
) `x`,
t28 as t28
where t28.col270>x.a12
*************************** 39. row ***************************
Id: 41
User: root
Host: localhost:60338
db: test
Command: Query
Time: 2331
State: Waiting for table metadata lock
Info: explain extended
select
`t19`.`col202` as col202 ,
(( count(distinct (`t19`.`col201`))) in (( greatest(((
select count(*) from
`test`.`t9` as `t9` ignore index (idx55,idx48)
left outer join `test`.`t26` as `t26`
on (t9.col80 & @var7 )
left outer join `test`.`t10` as `t10` force index (PRIMARY,PRIMARY,idx64)
on (@var4 is not false )
group by
t9.col66
limit 1
)),(`t19`.`col201`),(`t19`.`col201`),(`t19`.`col202`))),( count((`t19`.`col201`))),( (case ((`t19`.`col202`)) when ((`t19`.`col201`)) then ((`t19`.`col201`))when ((`t19`.`col202`)) then ((`t19`.`col201`)) else ((`t19`.`col202`)) end)),( count(distinct (`t19`.`col202`))),( ((`t19`.`col202`) in ((`t19`.`col201`),(`t19`.`col202`),((
select count(*) from
`test`.`t9` as `t9` ignore index (idx55,idx48)
left outer join `test`.`t26` as `t26`
on (@var0 is not null )
left outer join `test`.`t10` as `t10` force index (PRIMARY,PRIMARY,idx64)
on (@var5 % @var6 )
group by
t9.col66
limit 1
)),(`t19`.`col201`),(`t19`.`col201`)))))) as col201
from
`test`.`t19` as `t19` use index (idx143,idx143)
straight_join `test`.`t17` as `t17` ignore index (idx120)
on (t19.col203 xor t17.col186 )
where
t17.a17 >= t19.col203 or not
t19.col204 collate latin1_bin < '2011-08-24 09:07:58' and not
row(t17.col185 ,t19.col201 collate latin1_spanish_ci ,t19.col202 collate utf8_turkish_ci )= row( t19.col204 collate latin1_german2_ci , t17.col186 , t17.col186 )
order by
insert((`t19`.`col204`),(`t19`.`col204`),(`t19`.`col200`),(`t19`.`col200`)) desc,
elt((`t19`.`col202`),(`t19`.`col204`),(`t19`.`col203`),(`t17`.`col186`),(`t17`.`col185`),(`t19`.`a19`))
*************************** 40. row ***************************
Id: 42
User: root
Host: localhost:60339
db: test
Command: Query
Time: 3315
State: Waiting for table metadata lock
Info: select sql_cache count(*) from
`test`.`t4` as `t4` ignore index (idx19)
natural left join `test`.`t12` as `t12` ignore index (idx97,PRIMARY,idx90)
right join `test`.`t6` as `t6`
on (t4.col25 && t6.col52 )
natural left join `test`.`t23` as `t23` ignore index (PRIMARY)
left join `test`.`t20` as `t20`
on (t4.col26 || t20.col214 )
left join `test`.`t11` as `t11` ignore index (idx80,idx72)
on ( insert(( ((t4.col28) not in ((t4.col29),(t4.col33),(t4.col27),(t4.col27),(t4.col29)))),( least((t4.col33),(t4.col30),(t4.col26))),( encode((t4.col26),(t4.col28))),( @@global.log_bin_trust_function_creators)) regexp @var7 )
natural right join `test`.`t9` as `t9`
inner join `test`.`t5` as `t5`
on ( '1' )
right join `test`.`t21` as `t21` force index (idx173,idx173,idx174)
on ( coalesce((t4.col26),(t4.col24),(t4.col27),(t4.col25),(t4.col24)) sounds like @@global.hostname )
cross join `test`.`t18` as `t18` use index (idx126,idx128,idx128,idx125)
on (@var4 is not true )
straight_join `test`.`t28` as `t28`
on (t4.col27 like t28.col259 )
order by
t9.col64,
t28.col271 desc
limit 1
*************************** 41. row ***************************
Id: 45
User: root
Host: localhost:48500
db: NULL
Command: Query
Time: 0
State: NULL
Info: SHOW FULL PROCESSLIST
41 rows in set (0.01 sec)
mysql> SHOW GLOBAL VARIABLES;
+---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| autocommit | ON |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | /mysql2/mysql-5.6.2-m5-linux-x86_64-debug-max/ |
| big_tables | OFF |
| bind_address | |
| binlog_cache_size | 32768 |
| binlog_checksum | NONE |
| binlog_direct_non_transactional_updates | OFF |
| binlog_format | STATEMENT |
| binlog_row_image | FULL |
| binlog_rows_query_log_events | OFF |
| binlog_stmt_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /mysql2/mysql-5.6.2-m5-linux-x86_64-debug-max/share/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| completion_type | NO_CHAIN |
| concurrent_insert | AUTO |
| connect_timeout | 10 |
| datadir | |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| debug | |
| default_storage_engine | InnoDB |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| div_precision_increment | 4 |
| event_scheduler | OFF |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| foreign_key_checks | ON |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| general_log | OFF |
| general_log_file | /mysql2/mysql-5.6.2-m5-linux-x86_64-debug-max/data/mac.log |
| group_concat_max_len | 1024 |
| have_compress | YES |
| have_crypt | YES |
| have_dynamic_loading | YES |
| have_geometry | YES |
| have_openssl | DISABLED |
| have_profiling | YES |
| have_query_cache | YES |
| have_rtree_keys | YES |
| have_ssl | DISABLED |
| have_symlink | YES |
| hostname | mac.home |
| ignore_builtin_innodb | OFF |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_adaptive_flushing | ON |
| innodb_adaptive_hash_index | ON |
| innodb_additional_mem_pool_size | 8388608 |
| innodb_analyze_is_persistent | OFF |
| innodb_autoextend_increment | 8 |
| innodb_autoinc_lock_mode | 1 |
| innodb_buffer_pool_instances | 1 |
| innodb_buffer_pool_size | 2147483648 |
| innodb_change_buffer_max_size | 25 |
| innodb_change_buffering | all |
| innodb_change_buffering_debug | 0 |
| innodb_checksums | ON |
| innodb_commit_concurrency | 0 |
| innodb_concurrency_tickets | 500 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_disable_monitor_counter | |
| innodb_doublewrite | ON |
| innodb_enable_monitor_counter | |
| innodb_fast_shutdown | 1 |
| innodb_file_format | Antelope |
| innodb_file_format_check | ON |
| innodb_file_format_max | Antelope |
| innodb_file_per_table | ON |
| innodb_flush_log_at_trx_commit | 0 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_io_capacity | 200 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_buffer_size | 8388608 |
| innodb_log_file_size | 134217728 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_max_dirty_pages_pct | 75 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_old_blocks_pct | 37 |
| innodb_old_blocks_time | 0 |
| innodb_open_files | 300 |
| innodb_page_hash_locks | 16 |
| innodb_print_all_deadlocks | OFF |
| innodb_purge_batch_size | 20 |
| innodb_purge_threads | 0 |
| innodb_read_ahead_threshold | 56 |
| innodb_read_io_threads | 4 |
| innodb_replication_delay | 0 |
| innodb_reset_all_monitor_counter | |
| innodb_reset_monitor_counter | |
| innodb_rollback_on_timeout | OFF |
| innodb_spin_wait_delay | 6 |
| innodb_stats_method | nulls_equal |
| innodb_stats_on_metadata | ON |
| innodb_stats_persistent_sample_pages | 20 |
| innodb_stats_sample_pages | 8 |
| innodb_stats_transient_sample_pages | 8 |
| innodb_strict_mode | OFF |
| innodb_support_xa | ON |
| innodb_sync_spin_loops | 30 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 0 |
| innodb_thread_sleep_delay | 10000 |
| innodb_use_native_aio | ON |
| innodb_use_sys_malloc | ON |
| innodb_version | 1.2.2 |
| innodb_write_io_threads | 4 |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| keep_files_on_create | OFF |
| key_buffer_size | 1073741824 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| large_files_support | ON |
| large_page_size | 0 |
| large_pages | OFF |
| lc_messages | en_US |
| lc_messages_dir | /mysql2/mysql-5.6.2-m5-linux-x86_64-debug-max/share/ |
| lc_time_names | en_US |
| license | GPL |
| local_infile | ON |
| lock_wait_timeout | 31536000 |
| locked_in_memory | OFF |
| log_bin | OFF |
| log_bin_basename | |
| log_bin_index | |
| log_bin_trust_function_creators | OFF |
| log_error | /mysql2/mysql-5.6.2-m5-linux-x86_64-debug-max/data/error.log |
| log_output | FILE |
| log_queries_not_using_indexes | OFF |
| log_slave_updates | OFF |
| log_warnings | 1 |
| long_query_time | 10.000000 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| master_info_repository | FILE |
| master_verify_checksum | OFF |
| max_allowed_packet | 1048576 |
| max_binlog_cache_size | 18446744073709547520 |
| max_binlog_size | 1073741824 |
| max_binlog_stmt_cache_size | 18446744073709547520 |
| max_connect_errors | 10 |
| max_connections | 151 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 18446744073709551615 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 18446744073709551615 |
| max_sort_length | 1024 |
| max_sp_recursion_depth | 0 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 18446744073709551615 |
| min_examined_row_limit | 0 |
| multi_range_count | 256 |
| myisam_data_pointer_size | 6 |
| myisam_max_sort_file_size | 9223372036853727232 |
| myisam_mmap_size | 18446744073709551615 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 8388608 |
| myisam_stats_method | nulls_unequal |
| myisam_use_mmap | OFF |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old | OFF |
| old_alter_table | OFF |
| old_passwords | OFF |
| open_files_limit | 1024 |
| optimizer_join_cache_level | 4 |
| optimizer_prune_level | 1 |
| optimizer_search_depth | 62 |
| optimizer_switch | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,materialization=on,semijoin=on,loosescan=on,firstmatch=on |
| performance_schema | OFF |
| performance_schema_events_waits_history_long_size | 10000 |
| performance_schema_events_waits_history_size | 10 |
| performance_schema_max_cond_classes | 80 |
| performance_schema_max_cond_instances | 1000 |
| performance_schema_max_file_classes | 50 |
| performance_schema_max_file_handles | 32768 |
| performance_schema_max_file_instances | 10000 |
| performance_schema_max_mutex_classes | 200 |
| performance_schema_max_mutex_instances | 1000000 |
| performance_schema_max_rwlock_classes | 30 |
| performance_schema_max_rwlock_instances | 1000000 |
| performance_schema_max_table_handles | 10000 |
| performance_schema_max_table_instances | 1000 |
| performance_schema_max_thread_classes | 50 |
| performance_schema_max_thread_instances | 1000 |
| performance_schema_setup_actors_size | 100 |
| performance_schema_setup_objects_size | 100 |
| pid_file | /mysql2/mysql-5.6.2-m5-linux-x86_64-debug-max/pid-5620.pid |
| plugin_dir | /mysql2/mysql-5.6.2-m5-linux-x86_64-debug-max/lib/plugin |
| port | 5620 |
| preload_buffer_size | 32768 |
| profiling | OFF |
| profiling_history_size | 15 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 0 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 4096 |
| read_buffer_size | 131072 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log | |
| relay_log_basename | |
| relay_log_index | |
| relay_log_info_file | relay-log.info |
| relay_log_info_repository | FILE |
| relay_log_purge | ON |
| relay_log_recovery | OFF |
| relay_log_space_limit | 0 |
| report_host | |
| report_password | |
| report_port | 3306 |
| report_user | |
| secure_auth | OFF |
| secure_file_priv | |
| server_id | 0 |
| server_uuid | 7cb10594-4e7d-11e0-b2ae-002332a0387f |
| skip_external_locking | ON |
| skip_name_resolve | OFF |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_compressed_protocol | OFF |
| slave_exec_mode | STRICT |
| slave_load_tmpdir | /tmp |
| slave_net_timeout | 3600 |
| slave_skip_errors | OFF |
| slave_sql_verify_checksum | ON |
| slave_transaction_retries | 10 |
| slave_type_conversions | |
| slow_launch_time | 2 |
| slow_query_log | OFF |
| slow_query_log_file | /mysql2/mysql-5.6.2-m5-linux-x86_64-debug-max/data/mac-slow.log |
| socket | /mysql2/mysql-5.6.2-m5-linux-x86_64-debug-max/socket-5620.sock |
| sort_buffer_size | 2097152 |
| sql_auto_is_null | OFF |
| sql_big_selects | ON |
| sql_buffer_result | OFF |
| sql_log_bin | ON |
| sql_log_off | OFF |
| sql_mode | |
| sql_notes | ON |
| sql_quote_show_create | ON |
| sql_safe_updates | OFF |
| sql_select_limit | 18446744073709551615 |
| sql_slave_skip_counter | 0 |
| sql_warnings | OFF |
| ssl_ca | |
| ssl_capath | |
| ssl_cert | |
| ssl_cipher | |
| ssl_key | |
| storage_engine | InnoDB |
| sync_binlog | 0 |
| sync_frm | OFF |
| sync_master_info | 0 |
| sync_relay_log | 0 |
| sync_relay_log_info | 0 |
| system_time_zone | EST |
| table_definition_cache | 400 |
| table_open_cache | 400 |
| thread_cache_size | 8 |
| thread_concurrency | 10 |
| thread_handling | one-thread-per-connection |
| thread_stack | 262144 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| timed_mutexes | OFF |
| tmp_table_size | 16777216 |
| tmpdir | /tmp |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| unique_checks | ON |
| updatable_views_with_limit | YES |
| version | 5.6.2-m5-debug |
| version_comment | Source distribution |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
| wait_timeout | 28800 |
+---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
324 rows in set (0.01 sec)
mysql> SHOW GLOBAL STATUS;
+------------------------------------------+---------------------+
| Variable_name | Value |
+------------------------------------------+---------------------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Binlog_stmt_cache_disk_use | 0 |
| Binlog_stmt_cache_use | 0 |
| Bytes_received | 1485684 |
| Bytes_sent | 2013295 |
| 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 | 320 |
| Com_alter_tablespace | 0 |
| Com_analyze | 0 |
| Com_begin | 21 |
| Com_binlog | 0 |
| Com_call_procedure | 0 |
| Com_change_db | 1 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 20 |
| Com_create_db | 0 |
| Com_create_event | 0 |
| Com_create_function | 0 |
| Com_create_index | 214 |
| Com_create_procedure | 0 |
| Com_create_server | 0 |
| Com_create_table | 29 |
| Com_create_trigger | 15 |
| Com_create_udf | 0 |
| Com_create_user | 0 |
| Com_create_view | 13 |
| Com_dealloc_sql | 0 |
| Com_delete | 29 |
| Com_delete_multi | 28 |
| 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 | 29 |
| Com_drop_trigger | 16 |
| 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 | 2126 |
| 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 | 1666 |
| Com_set_option | 2231 |
| Com_signal | 0 |
| Com_show_authors | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 1 |
| 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 | 13 |
| Com_show_create_trigger | 0 |
| Com_show_databases | 1 |
| Com_show_engine_logs | 0 |
| Com_show_engine_mutex | 0 |
| Com_show_engine_status | 3 |
| Com_show_events | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 33 |
| Com_show_function_code | 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_code | 0 |
| Com_show_procedure_status | 0 |
| Com_show_processlist | 8 |
| 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 | 1 |
| Com_show_table_status | 0 |
| Com_show_tables | 1 |
| Com_show_triggers | 0 |
| Com_show_variables | 41 |
| 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 | 20 |
| Com_update_multi | 30 |
| 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 | 46 |
| Created_tmp_disk_tables | 1280 |
| Created_tmp_files | 78 |
| Created_tmp_tables | 1634 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 2893 |
| Handler_delete | 22 |
| Handler_discover | 0 |
| Handler_mrr_init | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 2597071 |
| Handler_read_key | 4689319 |
| Handler_read_last | 0 |
| Handler_read_next | 11025766 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 36945587 |
| Handler_read_rnd_next | 43027133 |
| Handler_rollback | 271 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 36972938 |
| Handler_write | 89379281 |
| Innodb_buffer_pool_pages_data | 793 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 2348 |
| Innodb_buffer_pool_pages_free | 130276 |
| Innodb_buffer_pool_pages_latched | 2 |
| Innodb_buffer_pool_pages_misc | 2 |
| Innodb_buffer_pool_pages_total | 131071 |
| Innodb_buffer_pool_read_ahead | 0 |
| Innodb_buffer_pool_read_ahead_evicted | 0 |
| Innodb_buffer_pool_read_requests | 94321529 |
| Innodb_buffer_pool_reads | 0 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 85405 |
| Innodb_data_fsyncs | 3553 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 0 |
| Innodb_data_reads | 82 |
| Innodb_data_writes | 5004 |
| Innodb_data_written | 42556928 |
| Innodb_dblwr_pages_written | 1001 |
| Innodb_dblwr_writes | 17 |
| Innodb_have_atomic_builtins | ON |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 13300 |
| Innodb_log_writes | 1734 |
| Innodb_os_log_fsyncs | 1753 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 6911488 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 2700 |
| Innodb_pages_read | 0 |
| Innodb_pages_written | 1174 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 1746337 |
| Innodb_row_lock_time_avg | 36382 |
| Innodb_row_lock_time_max | 51900 |
| Innodb_row_lock_waits | 48 |
| Innodb_rows_deleted | 7 |
| Innodb_rows_inserted | 583 |
| Innodb_rows_read | 51935189 |
| Innodb_rows_updated | 21 |
| Innodb_num_open_files | 32 |
| Innodb_truncated_status_writes | 0 |
| Key_blocks_not_flushed | 1 |
| Key_blocks_unused | 857367 |
| Key_blocks_used | 8 |
| Key_read_requests | 37152079 |
| Key_reads | 0 |
| Key_write_requests | 434 |
| Key_writes | 0 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 42 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 18 |
| Open_streams | 0 |
| Open_table_definitions | 74 |
| Open_tables | 393 |
| Opened_files | 7179 |
| Opened_table_definitions | 1326 |
| Opened_tables | 4098 |
| 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 | 0 |
| Qcache_free_memory | 0 |
| Qcache_hits | 0 |
| Qcache_inserts | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 0 |
| Queries | 6947 |
| Questions | 6946 |
| Select_full_join | 561 |
| Select_full_range_join | 0 |
| Select_range | 0 |
| Select_range_check | 0 |
| Select_scan | 1621 |
| Slave_heartbeat_period | 0.000 |
| Slave_last_heartbeat | 1970-01-01 10:00:00 |
| Slave_open_temp_tables | 0 |
| Slave_received_heartbeats | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 54 |
| Sort_merge_passes | 2 |
| Sort_range | 0 |
| Sort_rows | 29521 |
| Sort_scan | 209 |
| 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 | 16768 |
| Table_locks_waited | 0 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 1 |
| Threads_connected | 41 |
| Threads_created | 42 |
| Threads_running | 41 |
| Uptime | 3786 |
| Uptime_since_flush_status | 3786 |
+------------------------------------------+---------------------+
314 rows in set (0.03 sec)
mysql> select 1
-> ;
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)