mysql> show processlist; +------+---------+-----------+------+----------------+------+--------------------+-----------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+---------+-----------+------+----------------+------+--------------------+-----------------------------------------------+ | 1839 | root | | test | Sleep | 6 | | NULL | | 1841 | DELAYED | localhost | test | Delayed insert | 68 | Waiting for INSERT | | | 1957 | root | | test | Query | 0 | NULL | show processlist | | 1989 | root | | test | Query | 68 | Locked | select * from t1 where id not in(-23,82,-47) | | 1990 | root | | test | Query | 68 | Locked | select * from t1 where id not in(-126,74,25) | | 1991 | root | | test | Query | 68 | Locked | select * from t1 where id not in(-79,12,120) | | 1992 | root | | test | Query | 68 | Locked | select * from t1 where id not in(-83,8,84) | | 1993 | root | | test | Query | 68 | Locked | select * from t1 where id not in(-86,-74,82) | | 1994 | root | | test | Query | 68 | Locked | select * from t1 where id not in(-114,-1,-73) | | 1995 | root | | test | Query | 68 | Locked | select * from t1 where id not in(-120,8,-32) | | 1996 | root | | test | Query | 68 | Locked | select * from t1 where id not in(26,67,-24) | | 1997 | root | | test | Query | 67 | Locked | select * from t1 where id not in(-26,97,46) | | 1998 | root | | test | Query | 67 | Locked | select * from t1 where id not in(9,122,57) | | 1999 | root | | test | Query | 68 | Locked | select * from t1 where id not in(-53,-94,-95) | | 2001 | root | | test | Query | 67 | Locked | select * from t1 where id not in(39,86,16) | | 2002 | root | | test | Query | 1 | Locked | select * from t1 where id not in(-7,-9,112) | | 2003 | root | | test | Query | 1 | Locked | select * from t1 where id not in(82,-128,112) | +------+---------+-----------+------+----------------+------+--------------------+-----------------------------------------------+ 17 rows in set (0.00 sec) mysql> lock table t4 write; Query OK, 0 rows affected (0.41 sec) mysql> lock table t4 write; Query OK, 0 rows affected (0.16 sec) mysql> lock table t4 write; Query OK, 0 rows affected (0.14 sec) mysql> lock table t4 write; Query OK, 0 rows affected (0.08 sec) mysql> show processlist; +------+---------+-----------+------+----------------+------+--------------------+------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+---------+-----------+------+----------------+------+--------------------+------------------------------------------------+ | 1839 | root | | test | Sleep | 1 | | NULL | | 1841 | DELAYED | localhost | test | Delayed insert | 19 | Waiting for INSERT | | | 1957 | root | | test | Query | 0 | NULL | show processlist | | 2004 | root | | test | Query | 16 | Locked | select * from t4 where id in(-45,-74,49) | | 2005 | root | | test | Query | 15 | Locked | select * from t4 where id in(73,88,19) | | 2006 | root | | test | Query | 15 | Locked | select * from t4 where id in(27,52,78) | | 2007 | root | | test | Query | 15 | Locked | select * from t4 where id in(-127,-98,-48) | | 2009 | root | | test | Query | 15 | Locked | select * from t4 where id in(109,-128,63) | | 2008 | root | | test | Query | 15 | Locked | select * from t4 where id in(-125,-8,-85) | | 2010 | root | | test | Query | 15 | Locked | select * from t4 where id in(-60,-70,-80) | | 2011 | root | | test | Query | 15 | Locked | select * from t4 where id in(-108,-96,43) | | 2012 | root | | test | Query | 15 | Locked | select * from t4 where id in(30,94,18) | | 2013 | root | | test | Query | 15 | Locked | select * from t4 where id in(-113,-8,-18) | | 2014 | root | | test | Query | 15 | NULL | select * from t4 where id in(70,52,-41) | | 2015 | root | | test | Query | 5 | freeing items | select * from t1 where id not in(-68,-128,-55) | +------+---------+-----------+------+----------------+------+--------------------+------------------------------------------------+ 15 rows in set (0.02 sec) mysql> show processlist; +------+---------+-----------+------+----------------+------+--------------------+--------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+---------+-----------+------+----------------+------+--------------------+--------------------------------------------+ | 1839 | root | | test | Query | 3 | freeing items | SHOW /*!50010 GLOBAL*/ STATUS | | 1841 | DELAYED | localhost | test | Delayed insert | 76 | Waiting for INSERT | | | 1957 | root | | test | Query | 0 | NULL | show processlist | | 2004 | root | | test | Query | 73 | Locked | select * from t4 where id in(-45,-74,49) | | 2005 | root | | test | Query | 72 | Locked | select * from t4 where id in(73,88,19) | | 2006 | root | | test | Query | 72 | Locked | select * from t4 where id in(27,52,78) | | 2007 | root | | test | Query | 72 | Locked | select * from t4 where id in(-127,-98,-48) | | 2009 | root | | test | Query | 72 | Locked | select * from t4 where id in(109,-128,63) | | 2008 | root | | test | Query | 72 | Locked | select * from t4 where id in(-125,-8,-85) | | 2010 | root | | test | Query | 72 | Locked | select * from t4 where id in(-60,-70,-80) | | 2011 | root | | test | Query | 72 | Locked | select * from t4 where id in(-108,-96,43) | | 2012 | root | | test | Query | 72 | Locked | select * from t4 where id in(30,94,18) | | 2013 | root | | test | Query | 72 | Locked | select * from t4 where id in(-113,-8,-18) | | 2014 | root | | test | Query | 72 | Locked | select * from t4 where id in(70,52,-41) | | 2015 | root | | test | Query | 47 | Locked | select * from t4 where id in(-18,47,-68) | | 2016 | root | | test | Query | 22 | Locked | select * from t4 where id in(28,-17,-59) | | 2017 | root | | test | Query | 2 | freeing items | select * from t2 where id in(-91,-42,-68) | +------+---------+-----------+------+----------------+------+--------------------+--------------------------------------------+ 17 rows in set (0.03 sec) mysql> show processlist; +------+---------+-----------+------+----------------+------+--------------------+--------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+---------+-----------+------+----------------+------+--------------------+--------------------------------------------+ | 1839 | root | | test | Sleep | 5 | | NULL | | 1841 | DELAYED | localhost | test | Delayed insert | 123 | Waiting for INSERT | | | 1957 | root | | test | Query | 0 | NULL | show processlist | | 2004 | root | | test | Query | 120 | Locked | select * from t4 where id in(-45,-74,49) | | 2005 | root | | test | Query | 119 | Locked | select * from t4 where id in(73,88,19) | | 2006 | root | | test | Query | 119 | Locked | select * from t4 where id in(27,52,78) | | 2007 | root | | test | Query | 119 | Locked | select * from t4 where id in(-127,-98,-48) | | 2009 | root | | test | Query | 119 | Locked | select * from t4 where id in(109,-128,63) | | 2008 | root | | test | Query | 119 | Locked | select * from t4 where id in(-125,-8,-85) | | 2010 | root | | test | Query | 119 | Locked | select * from t4 where id in(-60,-70,-80) | | 2011 | root | | test | Query | 119 | Locked | select * from t4 where id in(-108,-96,43) | | 2012 | root | | test | Query | 119 | Locked | select * from t4 where id in(30,94,18) | | 2013 | root | | test | Query | 119 | Locked | select * from t4 where id in(-113,-8,-18) | | 2014 | root | | test | Query | 119 | NULL | select * from t4 where id in(70,52,-41) | | 2015 | root | | test | Query | 94 | Locked | select * from t4 where id in(-18,47,-68) | | 2016 | root | | test | Query | 69 | Locked | select * from t4 where id in(28,-17,-59) | | 2017 | root | | test | Query | 39 | Locked | select * from t4 where id in(-26,-33,22) | +------+---------+-----------+------+----------------+------+--------------------+--------------------------------------------+ 17 rows in set (0.02 sec) mysql> show processlist; +------+---------+-----------+------+----------------+------+--------------------+--------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+---------+-----------+------+----------------+------+--------------------+--------------------------------------------+ | 1839 | root | | test | Query | 2 | freeing items | SHOW /*!50010 GLOBAL*/ STATUS | | 1841 | DELAYED | localhost | test | Delayed insert | 186 | Waiting for INSERT | | | 1957 | root | | test | Query | 0 | NULL | show processlist | | 2004 | root | | test | Query | 183 | Locked | select * from t4 where id in(-45,-74,49) | | 2005 | root | | test | Query | 182 | Locked | select * from t4 where id in(73,88,19) | | 2006 | root | | test | Query | 182 | Locked | select * from t4 where id in(27,52,78) | | 2007 | root | | test | Query | 182 | Locked | select * from t4 where id in(-127,-98,-48) | | 2009 | root | | test | Query | 182 | Locked | select * from t4 where id in(109,-128,63) | | 2008 | root | | test | Query | 182 | Locked | select * from t4 where id in(-125,-8,-85) | | 2010 | root | | test | Query | 182 | Locked | select * from t4 where id in(-60,-70,-80) | | 2011 | root | | test | Query | 182 | Locked | select * from t4 where id in(-108,-96,43) | | 2012 | root | | test | Query | 182 | Locked | select * from t4 where id in(30,94,18) | | 2013 | root | | test | Query | 182 | Locked | select * from t4 where id in(-113,-8,-18) | | 2014 | root | | test | Query | 182 | Locked | select * from t4 where id in(70,52,-41) | | 2015 | root | | test | Query | 157 | Locked | select * from t4 where id in(-18,47,-68) | | 2016 | root | | test | Query | 132 | Locked | select * from t4 where id in(28,-17,-59) | | 2017 | root | | test | Query | 102 | Locked | select * from t4 where id in(-26,-33,22) | +------+---------+-----------+------+----------------+------+--------------------+--------------------------------------------+ 17 rows in set (0.05 sec) mysql> mysql> show processlist; +------+------+------+------+---------+------+--------+--------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+------+------+------+---------+------+--------+--------------------------------------------+ | 1839 | root | | test | Query | 0 | NULL | SHOW /*!50010 GLOBAL*/ STATUS | | 1957 | root | | test | Query | 0 | NULL | show processlist | | 2004 | root | | test | Query | 1373 | Locked | select * from t4 where id in(-45,-74,49) | | 2005 | root | | test | Query | 1372 | Locked | select * from t4 where id in(73,88,19) | | 2006 | root | | test | Query | 1372 | Locked | select * from t4 where id in(27,52,78) | | 2007 | root | | test | Query | 1372 | Locked | select * from t4 where id in(-127,-98,-48) | | 2009 | root | | test | Query | 1372 | Locked | select * from t4 where id in(109,-128,63) | | 2008 | root | | test | Query | 1372 | Locked | select * from t4 where id in(-125,-8,-85) | | 2010 | root | | test | Query | 1372 | Locked | select * from t4 where id in(-60,-70,-80) | | 2011 | root | | test | Query | 1372 | Locked | select * from t4 where id in(-108,-96,43) | | 2012 | root | | test | Query | 1372 | Locked | select * from t4 where id in(30,94,18) | | 2013 | root | | test | Query | 1372 | Locked | select * from t4 where id in(-113,-8,-18) | | 2014 | root | | test | Query | 1372 | NULL | select * from t4 where id in(70,52,-41) | <-------- NOTE | 2015 | root | | test | Query | 1347 | Locked | select * from t4 where id in(-18,47,-68) | | 2016 | root | | test | Query | 1322 | Locked | select * from t4 where id in(28,-17,-59) | | 2017 | root | | test | Query | 1292 | Locked | select * from t4 where id in(-26,-33,22) | +------+------+------+------+---------+------+--------+--------------------------------------------+ 16 rows in set (12.66 sec) mysql> show processlist; +------+------+------+------+---------+------+----------------+--------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+------+------+------+---------+------+----------------+--------------------------------------------+ | 1839 | root | | test | Query | 4 | Opening tables | SHOW /*!50010 GLOBAL*/ STATUS | | 1957 | root | | test | Query | 0 | NULL | show processlist | | 2004 | root | | test | Query | 1577 | Locked | select * from t4 where id in(-45,-74,49) | | 2005 | root | | test | Query | 1576 | Locked | select * from t4 where id in(73,88,19) | | 2006 | root | | test | Query | 1576 | Locked | select * from t4 where id in(27,52,78) | | 2007 | root | | test | Query | 1576 | Locked | select * from t4 where id in(-127,-98,-48) | | 2009 | root | | test | Query | 1576 | Locked | select * from t4 where id in(109,-128,63) | | 2008 | root | | test | Query | 1576 | Locked | select * from t4 where id in(-125,-8,-85) | | 2010 | root | | test | Query | 1576 | Locked | select * from t4 where id in(-60,-70,-80) | | 2011 | root | | test | Query | 1576 | Locked | select * from t4 where id in(-108,-96,43) | | 2012 | root | | test | Query | 1576 | Locked | select * from t4 where id in(30,94,18) | | 2013 | root | | test | Query | 1576 | Locked | select * from t4 where id in(-113,-8,-18) | | 2014 | root | | test | Query | 1576 | Locked | select * from t4 where id in(70,52,-41) |<-------- NOTE | 2015 | root | | test | Query | 1551 | Locked | select * from t4 where id in(-18,47,-68) | | 2016 | root | | test | Query | 1526 | Locked | select * from t4 where id in(28,-17,-59) | | 2017 | root | | test | Query | 1496 | Locked | select * from t4 where id in(-26,-33,22) | | 2018 | ODBC | | NULL | Debug | 89 | NULL | NULL | +------+------+------+------+---------+------+----------------+--------------------------------------------+ 17 rows in set (0.03 sec) mysql> show processlist; +------+------+------+------+---------+------+----------------+--------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+------+------+------+---------+------+----------------+--------------------------------------------+ | 1839 | root | | test | Query | 45 | Opening tables | SHOW /*!50010 GLOBAL*/ STATUS | | 1957 | root | | test | Query | 0 | NULL | show processlist | | 2004 | root | | test | Query | 1618 | Locked | select * from t4 where id in(-45,-74,49) | | 2005 | root | | test | Query | 1617 | Locked | select * from t4 where id in(73,88,19) | | 2006 | root | | test | Query | 1617 | Locked | select * from t4 where id in(27,52,78) | | 2007 | root | | test | Query | 1617 | Locked | select * from t4 where id in(-127,-98,-48) | | 2009 | root | | test | Query | 1617 | Locked | select * from t4 where id in(109,-128,63) | | 2008 | root | | test | Query | 1617 | Locked | select * from t4 where id in(-125,-8,-85) | | 2010 | root | | test | Query | 1617 | Locked | select * from t4 where id in(-60,-70,-80) | | 2011 | root | | test | Query | 1617 | Locked | select * from t4 where id in(-108,-96,43) | | 2012 | root | | test | Query | 1617 | Locked | select * from t4 where id in(30,94,18) | | 2013 | root | | test | Query | 1617 | Locked | select * from t4 where id in(-113,-8,-18) | | 2014 | root | | test | Query | 1617 | NULL | select * from t4 where id in(70,52,-41) |<-------- NOTE | 2015 | root | | test | Query | 1592 | Locked | select * from t4 where id in(-18,47,-68) | | 2016 | root | | test | Query | 1567 | Locked | select * from t4 where id in(28,-17,-59) | | 2017 | root | | test | Query | 1537 | Locked | select * from t4 where id in(-26,-33,22) | | 2018 | ODBC | | NULL | Debug | 130 | NULL | NULL | +------+------+------+------+---------+------+----------------+--------------------------------------------+ 17 rows in set (0.02 sec) mysql> show processlist; +------+------+------+------+---------+------+-----------+--------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+------+------+------+---------+------+-----------+--------------------------------------------+ | 1839 | root | | test | Query | 96 | preparing | SHOW /*!50010 GLOBAL*/ STATUS | | 1957 | root | | test | Query | 0 | NULL | show processlist | | 2004 | root | | test | Query | 1938 | Locked | select * from t4 where id in(-45,-74,49) | | 2005 | root | | test | Query | 1937 | Locked | select * from t4 where id in(73,88,19) | | 2006 | root | | test | Query | 1937 | Locked | select * from t4 where id in(27,52,78) | | 2007 | root | | test | Query | 1937 | Locked | select * from t4 where id in(-127,-98,-48) | | 2009 | root | | test | Query | 1937 | Locked | select * from t4 where id in(109,-128,63) | | 2008 | root | | test | Query | 1937 | Locked | select * from t4 where id in(-125,-8,-85) | | 2010 | root | | test | Query | 1937 | Locked | select * from t4 where id in(-60,-70,-80) | | 2011 | root | | test | Query | 1937 | Locked | select * from t4 where id in(-108,-96,43) | | 2012 | root | | test | Query | 1937 | Locked | select * from t4 where id in(30,94,18) | | 2013 | root | | test | Query | 1937 | Locked | select * from t4 where id in(-113,-8,-18) | | 2014 | root | | test | Query | 1937 | NULL | select * from t4 where id in(70,52,-41) |<-------- NOTE | 2015 | root | | test | Query | 1912 | Locked | select * from t4 where id in(-18,47,-68) | | 2016 | root | | test | Query | 1887 | Locked | select * from t4 where id in(28,-17,-59) | | 2017 | root | | test | Query | 1857 | Locked | select * from t4 where id in(-26,-33,22) | | 2018 | ODBC | | NULL | Debug | 450 | NULL | NULL | +------+------+------+------+---------+------+-----------+--------------------------------------------+ 17 rows in set (0.02 sec) i|1|drop table if exists t1| i|1|drop table if exists t2| i|1|drop table if exists t3| i|1|drop table if exists t4| i|1|drop table if exists t5| i|1|create table t1(id int, key(id))engine=myisam| i|1|create table t2 like t1| i|1|create table t3 like t1| i|1|create table t4 like t1| i|1|create table t5 like t1| n|1|set global thread_cache_size=abs(?)|tinyint n|1|select * from t1 where id not in(?,?,?)|tinyint,tinyint,tinyint n|1|select * from t2 where id in(?,?,?)|tinyint,tinyint,tinyint n|1|select * from t3 where id in(?,?,?)|tinyint,tinyint,tinyint n|1|select * from t4 where id in(?,?,?)|tinyint,tinyint,tinyint n|1|select * from t5 where id in(?,?,?)|tinyint,tinyint,tinyint n|1|delete from t1 where id in(?,?,?)|tinyint,tinyint,tinyint n|1|delete from t2 where id in(?,?,?)|tinyint,tinyint,tinyint n|1|delete from t3 where id in(?,?,?)|tinyint,tinyint,tinyint n|1|delete from t4 where id in(?,?,?)|tinyint,tinyint,tinyint n|1|delete from t5 where id in(?,?,?)|tinyint,tinyint,tinyint n|1|insert delayed into t1 values (?),(?)|tinyint,tinyint n|1|insert into t2 values (?),(?)|tinyint,tinyint n|1|insert into t3 values (?),(?)|tinyint,tinyint n|1|insert into t4 values (?),(?)|tinyint,tinyint n|1|insert into t5 values (?),(?)|tinyint,tinyint n|1|lock table t1 write| n|1|reconnect| 1380 __tmainCRTStartup pthread_cond_wait Below Normal 0 5612 _threadstart handle_shutdown Normal 0 1076 _threadstart pthread_cond_timedwait Normal 0 1620 _threadstart NtWaitForSingleObject Normal 0 2236 _threadstart dispatch_command Normal 0 6844 _threadstart pthread_cond_wait Highest 0 4468 _threadstart pthread_cond_wait Highest 0 8696 _threadstart vio_read Normal 0 7184 _threadstart pthread_cond_wait Highest 0 7924 _threadstart pthread_cond_wait Normal 0 6220 _threadstart pthread_cond_wait Highest 0 360 _threadstart pthread_cond_timedwait Normal 0 2032 _threadstart pthread_cond_wait Highest 0 5996 _threadstart pthread_cond_wait Highest 0 4244 _threadstart pthread_cond_wait Highest 0 1384 _threadstart pthread_cond_wait Highest 0 5112 _threadstart pthread_cond_wait Highest 0 6180 _threadstart pthread_cond_wait Highest 0 6188 _threadstart pthread_cond_wait Highest 0 6324 _threadstart pthread_cond_wait Highest 0 > 4940 _threadstart _sanity Highest 0 <-------- NOTE 8572 _threadstart pthread_cond_wait Highest 0 C:\svn_gypsy\win32\debug>gypsy --queryfile=c:/dev/thread_cache/small.txt --host=127.0.0.1:3306 --threads=15 --shuffle-queries=0 --duration=3600 --skip-init=0 [INFO] 23:43:33 [0234] 8648 - 32-bit version of Gypsy [INFO] 23:43:33 [0244] 8648 - using 1 hosts [INFO] 23:43:33 [0276] 8648 - client library version: 5.0.38 [ALWAYS] 23:43:33 [0294] 8648 - server 00: '5.0.36-debug', host: '127.0.0.1 via TCP/IP', protocol: 10, charset: latin1 [INFO] 23:43:33 [0341] 8648 - read 28 valid queries from query file [INFO] 23:43:33 [0397] 8648 - spawning data generation thread [INFO] 23:43:33 [0411] 8648 - generate_char_data=0, generate_int_data=0, generate_float_data=0, generate_blob_data=0 [INFO] 23:43:33 [0440] 8648 - now running for 3600 seconds. [INFO] 23:43:33 [0446] 8648 - running initialization queries [INFO] 23:43:33 [2040] 7192 - thread 0 connecting to host 0 [INFO] 23:43:33 [2051] 7192 - thread 0 has 1 alive hosts connected [INFO] 23:43:34 [0489] 8648 - spawning database stats thread [ALWAYS] 23:43:34 [0505] 8648 - spawning 15 new thread(s) [INFO] 23:43:34 [0739] 8404 - show status will be in files like 'report__host_' [INFO] 23:43:34 [2040] 8388 - thread 0 connecting to host 0 [INFO] 23:43:34 [2051] 8388 - thread 0 has 1 alive hosts connected [INFO] 23:43:34 [2040] 3820 - thread 1 connecting to host 0 [INFO] 23:43:34 [2051] 3820 - thread 1 has 1 alive hosts connected [INFO] 23:43:34 [2040] 2764 - thread 2 connecting to host 0 [INFO] 23:43:34 [2051] 2764 - thread 2 has 1 alive hosts connected [INFO] 23:43:35 [2040] 2344 - thread 3 connecting to host 0 [INFO] 23:43:35 [2040] 6896 - thread 4 connecting to host 0 [INFO] 23:43:35 [2051] 2344 - thread 3 has 1 alive hosts connected [INFO] 23:43:35 [2051] 6896 - thread 4 has 1 alive hosts connected [INFO] 23:43:35 [2040] 3480 - thread 5 connecting to host 0 [INFO] 23:43:35 [2051] 3480 - thread 5 has 1 alive hosts connected [INFO] 23:43:36 [2040] 9048 - thread 6 connecting to host 0 [INFO] 23:43:36 [2051] 9048 - thread 6 has 1 alive hosts connected [INFO] 23:43:36 [2040] 2300 - thread 7 connecting to host 0 [INFO] 23:43:36 [2051] 2300 - thread 7 has 1 alive hosts connected [INFO] 23:43:36 [2040] 5872 - thread 8 connecting to host 0 [INFO] 23:43:36 [2051] 5872 - thread 8 has 1 alive hosts connected [INFO] 23:43:37 [2040] 3832 - thread 9 connecting to host 0 [INFO] 23:43:37 [2040] 8360 - thread 10 connecting to host 0 [INFO] 23:43:37 [2051] 8360 - thread 10 has 1 alive hosts connected [INFO] 23:43:37 [2040] 3324 - thread 11 connecting to host 0 [INFO] 23:43:37 [2051] 3324 - thread 11 has 1 alive hosts connected [INFO] 23:43:37 [2051] 3832 - thread 9 has 1 alive hosts connected [INFO] 23:43:38 [2040] 3596 - thread 12 connecting to host 0 [INFO] 23:43:38 [2051] 3596 - thread 12 has 1 alive hosts connected [INFO] 23:43:38 [2040] 8668 - thread 13 connecting to host 0 [INFO] 23:43:38 [2051] 8668 - thread 13 has 1 alive hosts connected [INFO] 23:43:38 [2040] 5668 - thread 14 connecting to host 0 [INFO] 23:43:38 [2051] 5668 - thread 14 has 1 alive hosts connected [INFO] 23:43:38 [0531] 8648 - completed spawning new database worker threads [INFO] 23:43:38 [0570] 8648 - 15 threads running, 0000418 successful queries. 0000000 failed queries (0.000000 QPS). [INFO] 23:43:49 [0570] 8648 - 15 threads running, 0001391 successful queries. 0000000 failed queries (81.083333 QPS). [INFO] 23:44:00 [0570] 8648 - 15 threads running, 0001807 successful queries. 0000000 failed queries (34.666667 QPS). [INFO] 23:44:11 [0570] 8648 - 15 threads running, 0001807 successful queries. 0000000 failed queries (0.000000 QPS). [INFO] 23:44:22 [0570] 8648 - 15 threads running, 0002437 successful queries. 0000000 failed queries (52.500000 QPS). [INFO] 23:44:33 [0570] 8648 - 15 threads running, 0002510 successful queries. 0000000 failed queries (6.083333 QPS). [INFO] 23:44:44 [0570] 8648 - 15 threads running, 0002510 successful queries. 0000000 failed queries (0.000000 QPS). [INFO] 23:44:55 [0570] 8648 - 15 threads running, 0002510 successful queries. 0000000 failed queries (0.000000 QPS). [INFO] 23:45:06 [0570] 8648 - 15 threads running, 0002510 successful queries. 0000000 failed queries (0.000000 QPS). [ERROR] 23:45:15 [2530] 5872 - query failed (2013) - Lost connection to MySQL server during query: select * from t1 where id not i [...] [INFO] 23:45:17 [0570] 8648 - 14 threads running, 0002510 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:45:28 [0570] 8648 - 14 threads running, 0002510 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:45:39 [0570] 8648 - 14 threads running, 0002514 successful queries. 0000001 failed queries (0.416667 QPS). [INFO] 23:45:50 [0570] 8648 - 14 threads running, 0002760 successful queries. 0000001 failed queries (20.583333 QPS). [INFO] 23:46:01 [0570] 8648 - 14 threads running, 0002784 successful queries. 0000001 failed queries (2.083333 QPS). [INFO] 23:46:12 [0570] 8648 - 14 threads running, 0002786 successful queries. 0000001 failed queries (0.250000 QPS). [INFO] 23:46:23 [0570] 8648 - 14 threads running, 0002787 successful queries. 0000001 failed queries (0.166667 QPS). [INFO] 23:46:34 [0570] 8648 - 14 threads running, 0002789 successful queries. 0000001 failed queries (0.250000 QPS). [INFO] 23:46:45 [0570] 8648 - 14 threads running, 0002790 successful queries. 0000001 failed queries (0.166667 QPS). [INFO] 23:46:56 [0570] 8648 - 14 threads running, 0002792 successful queries. 0000001 failed queries (0.250000 QPS). [INFO] 23:47:07 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.250000 QPS). [INFO] 23:47:18 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:47:29 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:47:40 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:47:51 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:48:02 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:48:13 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:48:24 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:48:35 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:48:46 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:48:57 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:49:08 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:49:19 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:49:30 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:49:41 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:49:52 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:50:03 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:50:14 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:50:25 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:50:36 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:50:47 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:50:58 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:51:09 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:51:20 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). [INFO] 23:51:31 [0570] 8648 - 14 threads running, 0002794 successful queries. 0000001 failed queries (0.083333 QPS). ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x00237ba4, _RTL_CRITICAL_SECTION * mutex=0x06786294) Line 48 C mysqld-debug.exe!wait_for_lock(st_lock_list * wait=0x067862ac, st_thr_lock_data * data=0x040ea220, char in_wait_list=0x00) Line 415 + 0x3a bytes C mysqld-debug.exe!thr_lock(st_thr_lock_data * data=0x040ea220, st_thr_lock_owner * owner=0x04bebfb4, thr_lock_type lock_type=TL_READ) Line 679 + 0x28 bytes C mysqld-debug.exe!thr_multi_lock(st_thr_lock_data * * data=0x0a029d14, unsigned int count=0x00000001, st_thr_lock_owner * owner=0x04bebfb4) Line 929 + 0x18 bytes C mysqld-debug.exe!mysql_lock_tables(THD * thd=0x04beafa0, st_table * * tables=0x023bd7e0, unsigned int count=0x00000001, unsigned int flags=0x00000004, int * need_reopen=0x0574e5c4) Line 172 + 0x26 bytes C++ mysqld-debug.exe!lock_tables(THD * thd=0x04beafa0, st_table_list * tables=0x023bd178, unsigned int count=0x00000001, int * need_reopen=0x0574e5c4) Line 2610 + 0x1d bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x04beafa0, st_table_list * tables=0x023bd178) Line 2463 + 0x15 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x04beafa0) Line 2594 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x04beafa0, char * inBuf=0x023bd050, unsigned int length=0x00000028) Line 5909 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x04beafa0, char * packet=0x040cc011, unsigned int packet_length=0x00000029) Line 1786 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x04beafa0) Line 1568 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x066f5128) Line 1194 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x07e33028) Line 62 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x06a78db0) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes <-------- NOTE <-------- > mysqld-debug.exe!_sanity(const char * filename=0x008e52f8, unsigned int lineno=0x0000010e) Line 488 + 0x10 bytes C mysqld-debug.exe!_myfree(char * ptr=0x0414afb8, const char * filename=0x008e52f8, unsigned int lineno=0x0000010e, int myflags=0x00000000) Line 264 + 0xd bytes C mysqld-debug.exe!mysql_unlock_tables(THD * thd=0x04e8afc0, st_mysql_lock * sql_lock=0x0414afb8) Line 270 + 0x15 bytes C++ mysqld-debug.exe!mysql_lock_tables(THD * thd=0x04e8afc0, st_table * * tables=0x06843168, unsigned int count=0x00000001, unsigned int flags=0x00000004, int * need_reopen=0x054ce5c4) Line 200 + 0xd bytes C++ mysqld-debug.exe!lock_tables(THD * thd=0x04e8afc0, st_table_list * tables=0x02392138, unsigned int count=0x00000001, int * need_reopen=0x054ce5c4) Line 2610 + 0x1d bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x04e8afc0, st_table_list * tables=0x02392138) Line 2463 + 0x15 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x04e8afc0) Line 2594 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x04e8afc0, char * inBuf=0x02392018, unsigned int length=0x00000027) Line 5909 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x04e8afc0, char * packet=0x04063991, unsigned int packet_length=0x00000028) Line 1786 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x04e8afc0) Line 1568 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x0a0287b0) Line 1194 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x078abfe0) Line 62 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x04b55d98) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes [Frames below may be incorrect and/or missing, no symbols loaded for kernel32.dll] ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x0022affc, _RTL_CRITICAL_SECTION * mutex=0x06786294) Line 48 C mysqld-debug.exe!wait_for_lock(st_lock_list * wait=0x067862ac, st_thr_lock_data * data=0x06830220, char in_wait_list=0x00) Line 415 + 0x3a bytes C mysqld-debug.exe!thr_lock(st_thr_lock_data * data=0x06830220, st_thr_lock_owner * owner=0x07634f44, thr_lock_type lock_type=TL_READ) Line 679 + 0x28 bytes C mysqld-debug.exe!thr_multi_lock(st_thr_lock_data * * data=0x040c3efc, unsigned int count=0x00000001, st_thr_lock_owner * owner=0x07634f44) Line 929 + 0x18 bytes C mysqld-debug.exe!mysql_lock_tables(THD * thd=0x07633f30, st_table * * tables=0x023786a8, unsigned int count=0x00000001, unsigned int flags=0x00000004, int * need_reopen=0x04fce5c4) Line 172 + 0x26 bytes C++ mysqld-debug.exe!lock_tables(THD * thd=0x07633f30, st_table_list * tables=0x02378040, unsigned int count=0x00000001, int * need_reopen=0x04fce5c4) Line 2610 + 0x1d bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x07633f30, st_table_list * tables=0x02378040) Line 2463 + 0x15 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x07633f30) Line 2594 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x07633f30, char * inBuf=0x02377f18, unsigned int length=0x00000028) Line 5909 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x07633f30, char * packet=0x04096041, unsigned int packet_length=0x00000029) Line 1786 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x07633f30) Line 1568 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x04d59a28) Line 1194 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x04deefe0) Line 62 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x06ccbbc8) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x00233e84, _RTL_CRITICAL_SECTION * mutex=0x06786294) Line 48 C mysqld-debug.exe!wait_for_lock(st_lock_list * wait=0x067862ac, st_thr_lock_data * data=0x04b8f220, char in_wait_list=0x00) Line 415 + 0x3a bytes C mysqld-debug.exe!thr_lock(st_thr_lock_data * data=0x04b8f220, st_thr_lock_owner * owner=0x09d13a84, thr_lock_type lock_type=TL_READ) Line 679 + 0x28 bytes C mysqld-debug.exe!thr_multi_lock(st_thr_lock_data * * data=0x07f1cb7c, unsigned int count=0x00000001, st_thr_lock_owner * owner=0x09d13a84) Line 929 + 0x18 bytes C mysqld-debug.exe!mysql_lock_tables(THD * thd=0x09d12a70, st_table * * tables=0x02375ae8, unsigned int count=0x00000001, unsigned int flags=0x00000004, int * need_reopen=0x0494e5c4) Line 172 + 0x26 bytes C++ mysqld-debug.exe!lock_tables(THD * thd=0x09d12a70, st_table_list * tables=0x02375580, unsigned int count=0x00000001, int * need_reopen=0x0494e5c4) Line 2610 + 0x1d bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x09d12a70, st_table_list * tables=0x02375580) Line 2463 + 0x15 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x09d12a70) Line 2594 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x09d12a70, char * inBuf=0x02375460, unsigned int length=0x00000026) Line 5909 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x09d12a70, char * packet=0x02370d21, unsigned int packet_length=0x00000027) Line 1786 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x09d12a70) Line 1568 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x09d79390) Line 1194 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x084f8fe0) Line 62 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x07ccc028) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x00233a7c, _RTL_CRITICAL_SECTION * mutex=0x06786294) Line 48 C mysqld-debug.exe!wait_for_lock(st_lock_list * wait=0x067862ac, st_thr_lock_data * data=0x0406d740, char in_wait_list=0x00) Line 415 + 0x3a bytes C mysqld-debug.exe!thr_lock(st_thr_lock_data * data=0x0406d740, st_thr_lock_owner * owner=0x0a0297c4, thr_lock_type lock_type=TL_READ) Line 679 + 0x28 bytes C mysqld-debug.exe!thr_multi_lock(st_thr_lock_data * * data=0x066f66a4, unsigned int count=0x00000001, st_thr_lock_owner * owner=0x0a0297c4) Line 929 + 0x18 bytes C mysqld-debug.exe!mysql_lock_tables(THD * thd=0x0a0287b0, st_table * * tables=0x041034f0, unsigned int count=0x00000001, unsigned int flags=0x00000004, int * need_reopen=0x0480e5c4) Line 172 + 0x26 bytes C++ mysqld-debug.exe!lock_tables(THD * thd=0x0a0287b0, st_table_list * tables=0x04102e88, unsigned int count=0x00000001, int * need_reopen=0x0480e5c4) Line 2610 + 0x1d bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x0a0287b0, st_table_list * tables=0x04102e88) Line 2463 + 0x15 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x0a0287b0) Line 2594 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x0a0287b0, char * inBuf=0x04102d60, unsigned int length=0x00000028) Line 5909 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x0a0287b0, char * packet=0x0411ffa9, unsigned int packet_length=0x00000029) Line 1786 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x0a0287b0) Line 1568 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x04beafa0) Line 1194 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x0a0a3fe0) Line 62 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x06c484a8) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x00235d64, _RTL_CRITICAL_SECTION * mutex=0x06786294) Line 48 C mysqld-debug.exe!wait_for_lock(st_lock_list * wait=0x067862ac, st_thr_lock_data * data=0x06b03220, char in_wait_list=0x00) Line 415 + 0x3a bytes C mysqld-debug.exe!thr_lock(st_thr_lock_data * data=0x06b03220, st_thr_lock_owner * owner=0x06bd0fcc, thr_lock_type lock_type=TL_READ) Line 679 + 0x28 bytes C mysqld-debug.exe!thr_multi_lock(st_thr_lock_data * * data=0x023a7fc4, unsigned int count=0x00000001, st_thr_lock_owner * owner=0x06bd0fcc) Line 929 + 0x18 bytes C mysqld-debug.exe!mysql_lock_tables(THD * thd=0x06bcffb8, st_table * * tables=0x023b67a8, unsigned int count=0x00000001, unsigned int flags=0x00000004, int * need_reopen=0x05c4e5c4) Line 172 + 0x26 bytes C++ mysqld-debug.exe!lock_tables(THD * thd=0x06bcffb8, st_table_list * tables=0x023b60c0, unsigned int count=0x00000001, int * need_reopen=0x05c4e5c4) Line 2610 + 0x1d bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x06bcffb8, st_table_list * tables=0x023b60c0) Line 2463 + 0x15 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x06bcffb8) Line 2594 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x06bcffb8, char * inBuf=0x023b5f98, unsigned int length=0x0000002a) Line 5909 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x06bcffb8, char * packet=0x0419a871, unsigned int packet_length=0x0000002b) Line 1786 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x06bcffb8) Line 1568 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x04cb8ac8) Line 1194 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x06b58fe0) Line 62 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x09d33360) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x002393ec, _RTL_CRITICAL_SECTION * mutex=0x06786294) Line 48 C mysqld-debug.exe!wait_for_lock(st_lock_list * wait=0x067862ac, st_thr_lock_data * data=0x07fe9220, char in_wait_list=0x00) Line 415 + 0x3a bytes C mysqld-debug.exe!thr_lock(st_thr_lock_data * data=0x07fe9220, st_thr_lock_owner * owner=0x04b554ec, thr_lock_type lock_type=TL_READ) Line 679 + 0x28 bytes C mysqld-debug.exe!thr_multi_lock(st_thr_lock_data * * data=0x07f8ffdc, unsigned int count=0x00000001, st_thr_lock_owner * owner=0x04b554ec) Line 929 + 0x18 bytes C mysqld-debug.exe!mysql_lock_tables(THD * thd=0x04b544d8, st_table * * tables=0x023af800, unsigned int count=0x00000001, unsigned int flags=0x00000004, int * need_reopen=0x05b0e5c4) Line 172 + 0x26 bytes C++ mysqld-debug.exe!lock_tables(THD * thd=0x04b544d8, st_table_list * tables=0x023af218, unsigned int count=0x00000001, int * need_reopen=0x05b0e5c4) Line 2610 + 0x1d bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x04b544d8, st_table_list * tables=0x023af218) Line 2463 + 0x15 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x04b544d8) Line 2594 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x04b544d8, char * inBuf=0x023af0f0, unsigned int length=0x00000029) Line 5909 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x04b544d8, char * packet=0x02397fd1, unsigned int packet_length=0x0000002a) Line 1786 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x04b544d8) Line 1568 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x06beaea0) Line 1194 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x0797b028) Line 62 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x09c64db0) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x002356bc, _RTL_CRITICAL_SECTION * mutex=0x06786294) Line 48 C mysqld-debug.exe!wait_for_lock(st_lock_list * wait=0x067862ac, st_thr_lock_data * data=0x08107220, char in_wait_list=0x00) Line 415 + 0x3a bytes C mysqld-debug.exe!thr_lock(st_thr_lock_data * data=0x08107220, st_thr_lock_owner * owner=0x077363f4, thr_lock_type lock_type=TL_READ) Line 679 + 0x28 bytes C mysqld-debug.exe!thr_multi_lock(st_thr_lock_data * * data=0x081cdfdc, unsigned int count=0x00000001, st_thr_lock_owner * owner=0x077363f4) Line 929 + 0x18 bytes C mysqld-debug.exe!mysql_lock_tables(THD * thd=0x077353e0, st_table * * tables=0x09ca1be8, unsigned int count=0x00000001, unsigned int flags=0x00000004, int * need_reopen=0x0524e5c4) Line 172 + 0x26 bytes C++ mysqld-debug.exe!lock_tables(THD * thd=0x077353e0, st_table_list * tables=0x09ca1500, unsigned int count=0x00000001, int * need_reopen=0x0524e5c4) Line 2610 + 0x1d bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x077353e0, st_table_list * tables=0x09ca1500) Line 2463 + 0x15 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x077353e0) Line 2594 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x077353e0, char * inBuf=0x09ca13d8, unsigned int length=0x00000029) Line 5909 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x077353e0, char * packet=0x0231ee49, unsigned int packet_length=0x0000002a) Line 1786 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x077353e0) Line 1568 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x0a0287b0) Line 1194 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x06ceefe0) Line 62 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x023774a0) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x002333b4, _RTL_CRITICAL_SECTION * mutex=0x06786294) Line 48 C mysqld-debug.exe!wait_for_lock(st_lock_list * wait=0x067862ac, st_thr_lock_data * data=0x069e2220, char in_wait_list=0x00) Line 415 + 0x3a bytes C mysqld-debug.exe!thr_lock(st_thr_lock_data * data=0x069e2220, st_thr_lock_owner * owner=0x0844fc0c, thr_lock_type lock_type=TL_READ) Line 679 + 0x28 bytes C mysqld-debug.exe!thr_multi_lock(st_thr_lock_data * * data=0x023d921c, unsigned int count=0x00000001, st_thr_lock_owner * owner=0x0844fc0c) Line 929 + 0x18 bytes C mysqld-debug.exe!mysql_lock_tables(THD * thd=0x0844ebf8, st_table * * tables=0x023ce818, unsigned int count=0x00000001, unsigned int flags=0x00000004, int * need_reopen=0x0444e5c4) Line 172 + 0x26 bytes C++ mysqld-debug.exe!lock_tables(THD * thd=0x0844ebf8, st_table_list * tables=0x023ce1b0, unsigned int count=0x00000001, int * need_reopen=0x0444e5c4) Line 2610 + 0x1d bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x0844ebf8, st_table_list * tables=0x023ce1b0) Line 2463 + 0x15 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x0844ebf8) Line 2594 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x0844ebf8, char * inBuf=0x023ce088, unsigned int length=0x00000029) Line 5909 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x0844ebf8, char * packet=0x023ca019, unsigned int packet_length=0x0000002a) Line 1786 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x0844ebf8) Line 1568 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x077353e0) Line 1194 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x084b13a0) Line 62 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x06ab8ec8) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x00241c1c, _RTL_CRITICAL_SECTION * mutex=0x06786294) Line 48 C mysqld-debug.exe!wait_for_lock(st_lock_list * wait=0x067862ac, st_thr_lock_data * data=0x06d06220, char in_wait_list=0x00) Line 415 + 0x3a bytes C mysqld-debug.exe!thr_lock(st_thr_lock_data * data=0x06d06220, st_thr_lock_owner * owner=0x07f7e2f4, thr_lock_type lock_type=TL_READ) Line 679 + 0x28 bytes C mysqld-debug.exe!thr_multi_lock(st_thr_lock_data * * data=0x069e2b1c, unsigned int count=0x00000001, st_thr_lock_owner * owner=0x07f7e2f4) Line 929 + 0x18 bytes C mysqld-debug.exe!mysql_lock_tables(THD * thd=0x07f7d2e0, st_table * * tables=0x0232f898, unsigned int count=0x00000001, unsigned int flags=0x00000004, int * need_reopen=0x03fae5c4) Line 172 + 0x26 bytes C++ mysqld-debug.exe!lock_tables(THD * thd=0x07f7d2e0, st_table_list * tables=0x0232f1b0, unsigned int count=0x00000001, int * need_reopen=0x03fae5c4) Line 2610 + 0x1d bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x07f7d2e0, st_table_list * tables=0x0232f1b0) Line 2463 + 0x15 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x07f7d2e0) Line 2594 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x07f7d2e0, char * inBuf=0x0232f088, unsigned int length=0x00000029) Line 5909 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x07f7d2e0, char * packet=0x04041829, unsigned int packet_length=0x0000002a) Line 1786 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x07f7d2e0) Line 1568 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x09d79390) Line 1194 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x09fa0fe0) Line 62 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x07742dd8) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_timedwait(pthread_cond_t * cond=0x068debd4, _RTL_CRITICAL_SECTION * mutex=0x068debbc, timespec * abstime=0x04a8ff2c) Line 83 + 0x11 bytes C mysqld-debug.exe!handle_delayed_insert(void * arg=0x068dd6b0) Line 1939 + 0x1c bytes C++ mysqld-debug.exe!pthread_start(void * param=0x04adefe0) Line 62 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x07a8a028) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x00238f04, _RTL_CRITICAL_SECTION * mutex=0x06786294) Line 48 C mysqld-debug.exe!wait_for_lock(st_lock_list * wait=0x067862ac, st_thr_lock_data * data=0x06af5220, char in_wait_list=0x00) Line 415 + 0x3a bytes C mysqld-debug.exe!thr_lock(st_thr_lock_data * data=0x06af5220, st_thr_lock_owner * owner=0x09d7a3a4, thr_lock_type lock_type=TL_READ) Line 679 + 0x28 bytes C mysqld-debug.exe!thr_multi_lock(st_thr_lock_data * * data=0x07d44e24, unsigned int count=0x00000001, st_thr_lock_owner * owner=0x09d7a3a4) Line 929 + 0x18 bytes C mysqld-debug.exe!mysql_lock_tables(THD * thd=0x09d79390, st_table * * tables=0x023ad818, unsigned int count=0x00000001, unsigned int flags=0x00000004, int * need_reopen=0x0560e5c4) Line 172 + 0x26 bytes C++ mysqld-debug.exe!lock_tables(THD * thd=0x09d79390, st_table_list * tables=0x023ad1b0, unsigned int count=0x00000001, int * need_reopen=0x0560e5c4) Line 2610 + 0x1d bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x09d79390, st_table_list * tables=0x023ad1b0) Line 2463 + 0x15 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x09d79390) Line 2594 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x09d79390, char * inBuf=0x023ad088, unsigned int length=0x00000028) Line 5909 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x09d79390, char * packet=0x04171c21, unsigned int packet_length=0x00000029) Line 1786 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x09d79390) Line 1568 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x04d59a28) Line 1194 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x0a04dd10) Line 62 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x0a1d7db0) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x0023d7d4, _RTL_CRITICAL_SECTION * mutex=0x06786294) Line 48 C mysqld-debug.exe!wait_for_lock(st_lock_list * wait=0x067862ac, st_thr_lock_data * data=0x0681f220, char in_wait_list=0x00) Line 415 + 0x3a bytes C mysqld-debug.exe!thr_lock(st_thr_lock_data * data=0x0681f220, st_thr_lock_owner * owner=0x040810a4, thr_lock_type lock_type=TL_READ) Line 679 + 0x28 bytes C mysqld-debug.exe!thr_multi_lock(st_thr_lock_data * * data=0x06c44fd4, unsigned int count=0x00000001, st_thr_lock_owner * owner=0x040810a4) Line 929 + 0x18 bytes C mysqld-debug.exe!mysql_lock_tables(THD * thd=0x04080090, st_table * * tables=0x04d09238, unsigned int count=0x00000001, unsigned int flags=0x00000004, int * need_reopen=0x03e6e5c4) Line 172 + 0x26 bytes C++ mysqld-debug.exe!lock_tables(THD * thd=0x04080090, st_table_list * tables=0x04d08cd0, unsigned int count=0x00000001, int * need_reopen=0x03e6e5c4) Line 2610 + 0x1d bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x04080090, st_table_list * tables=0x04d08cd0) Line 2463 + 0x15 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x04080090) Line 2594 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x04080090, char * inBuf=0x04d08bb0, unsigned int length=0x00000026) Line 5909 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x04080090, char * packet=0x0234f719, unsigned int packet_length=0x00000027) Line 1786 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x04080090) Line 1568 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x04add950) Line 1194 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x04c2ef58) Line 62 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x04b2ea90) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x00239934, _RTL_CRITICAL_SECTION * mutex=0x06786294) Line 48 C mysqld-debug.exe!wait_for_lock(st_lock_list * wait=0x067862ac, st_thr_lock_data * data=0x07dba220, char in_wait_list=0x00) Line 415 + 0x3a bytes C mysqld-debug.exe!thr_lock(st_thr_lock_data * data=0x07dba220, st_thr_lock_owner * owner=0x07f44c7c, thr_lock_type lock_type=TL_READ) Line 679 + 0x28 bytes C mysqld-debug.exe!thr_multi_lock(st_thr_lock_data * * data=0x069d1b74, unsigned int count=0x00000001, st_thr_lock_owner * owner=0x07f44c7c) Line 929 + 0x18 bytes C mysqld-debug.exe!mysql_lock_tables(THD * thd=0x07f43c68, st_table * * tables=0x040255f8, unsigned int count=0x00000001, unsigned int flags=0x00000004, int * need_reopen=0x046ce5c4) Line 172 + 0x26 bytes C++ mysqld-debug.exe!lock_tables(THD * thd=0x07f43c68, st_table_list * tables=0x04025090, unsigned int count=0x00000001, int * need_reopen=0x046ce5c4) Line 2610 + 0x1d bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x07f43c68, st_table_list * tables=0x04025090) Line 2463 + 0x15 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x07f43c68) Line 2594 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x07f43c68, char * inBuf=0x04024f70, unsigned int length=0x00000026) Line 5909 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x07f43c68, char * packet=0x0232b019, unsigned int packet_length=0x00000027) Line 1786 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x07f43c68) Line 1568 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x04b544d8) Line 1194 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x06bf2fe0) Line 62 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x076cec48) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes ntdll.dll!NtWaitForSingleObject() + 0x15 bytes [Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll] kernel32.dll!WaitForSingleObject() + 0x12 bytes > mysqld-debug.exe!pthread_cond_wait(pthread_cond_t * cond=0x0023131c, _RTL_CRITICAL_SECTION * mutex=0x06786294) Line 48 C mysqld-debug.exe!wait_for_lock(st_lock_list * wait=0x067862ac, st_thr_lock_data * data=0x067096d8, char in_wait_list=0x00) Line 415 + 0x3a bytes C mysqld-debug.exe!thr_lock(st_thr_lock_data * data=0x067096d8, st_thr_lock_owner * owner=0x04d5aa3c, thr_lock_type lock_type=TL_READ) Line 679 + 0x28 bytes C mysqld-debug.exe!thr_multi_lock(st_thr_lock_data * * data=0x09f2403c, unsigned int count=0x00000001, st_thr_lock_owner * owner=0x04d5aa3c) Line 929 + 0x18 bytes C mysqld-debug.exe!mysql_lock_tables(THD * thd=0x04d59a28, st_table * * tables=0x0408b8d0, unsigned int count=0x00000001, unsigned int flags=0x00000004, int * need_reopen=0x0458e5c4) Line 172 + 0x26 bytes C++ mysqld-debug.exe!lock_tables(THD * thd=0x04d59a28, st_table_list * tables=0x0408b1e8, unsigned int count=0x00000001, int * need_reopen=0x0458e5c4) Line 2610 + 0x1d bytes C++ mysqld-debug.exe!open_and_lock_tables(THD * thd=0x04d59a28, st_table_list * tables=0x0408b1e8) Line 2463 + 0x15 bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x04d59a28) Line 2594 + 0xd bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x04d59a28, char * inBuf=0x0408b0c0, unsigned int length=0x00000029) Line 5909 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x04d59a28, char * packet=0x02381021, unsigned int packet_length=0x0000002a) Line 1786 + 0x1d bytes C++ mysqld-debug.exe!do_command(THD * thd=0x04d59a28) Line 1568 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x04add950) Line 1194 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x07cff810) Line 62 + 0x7 bytes C mysqld-debug.exe!_callthreadstart() Line 293 + 0xf bytes C mysqld-debug.exe!_threadstart(void * ptd=0x0762bd10) Line 277 C kernel32.dll!FlsSetValue() + 0x136 bytes looping in open_and_lock_tables(): for ( ; ; ) { if (open_tables(thd, &tables, &counter, 0)) DBUG_RETURN(-1); if (!lock_tables(thd, tables, counter, &need_reopen)) break; if (!need_reopen) DBUG_RETURN(-1); close_tables_for_reopen(thd, &tables); } - thd 0x04e8afc0 {net={...} warn_root={...} protocol=0x04e8bb54 ...} THD * - Statement {main_mem_root={...} main_lex={...} id=0 ...} Statement + ilink {prev=0x07633f38 next=0x07f7d2e0 } ilink + Query_arena {free_list=0x023926d0 mem_root=0x04e8afe0 is_backup_arena=0 ...} Query_arena + main_mem_root {free=0x06938d78 used=0x068e5030 pre_alloc=0x02392008 ...} st_mem_root + main_lex {yylineno=1 yytoklen=2 yylval=0x054ceff8 ...} st_lex id 0 unsigned long set_query_id 1 int + name {str=0x00000000 length=2779096485 } st_lex_string + lex 0x04e8b000 {yylineno=1 yytoklen=2 yylval=0x054ceff8 ...} st_lex * + query 0x02392018 "select * from t4 where id in(70,52,-41)" char * query_length 39 unsigned long + cursor 0x00000000 {result=??? } Server_side_cursor * - Open_tables_state {open_tables=0x00000000 temporary_tables=0x00000000 handler_tables=0x00000000 ...} Open_tables_state + open_tables 0x00000000 {s=??? file=??? next=??? ...} st_table * + temporary_tables 0x00000000 {s=??? file=??? next=??? ...} st_table * + handler_tables 0x00000000 {s=??? file=??? next=??? ...} st_table * + derived_tables 0x00000000 {s=??? file=??? next=??? ...} st_table * + lock 0x00000000 {table=??? table_count=??? lock_count=??? ...} st_mysql_lock * + locked_tables 0x00000000 {table=??? table_count=??? lock_count=??? ...} st_mysql_lock * prelocked_mode NON_PRELOCKED prelocked_mode_type version 1 unsigned long current_tablenr 1 unsigned int + DEFAULT_WHERE 0x009094e4 "field list" const char * const + net {vio=0x04c30168 buff=0x04063990 "select * from t4 where id in(70,52,-41)" buff_end=0x04067990 "¥¥¥¥¥¥¥h4zýýýý««««««««þ" ...} st_net + warn_root {free=0x00000000 used=0x00000000 pre_alloc=0x00000000 ...} st_mem_root + protocol 0x04e8bb54 Protocol * + protocol_simple {...} Protocol_simple + protocol_prep {bit_fields=2779096485 } Protocol_prep + user_vars {key_offset=0 key_length=0 records=0 ...} st_hash + packet {Ptr=0x040a7040 "-128testt3t3idid ?" str_length=5 Alloced_length=16384 ...} String + convert_buffer {Ptr=0x09f70040 "idst¥¥¥¥h4zýýýý««««««««" str_length=2 Alloced_length=8 ...} String + remote {sin_family=-23131 sin_port=42405 sin_addr={...} ...} sockaddr_in + rand {seed1=151552661 seed2=631019695 max_value=1073741823 ...} rand_struct + variables {myisam_max_extra_sort_file_size=2147483648 myisam_max_sort_file_size=2147483647 max_heap_table_size=16777216 ...} system_variables + status_var {bytes_received=271 bytes_sent=1266 com_other=0 ...} system_status_var + lock_info {thread=0x0000b230 thread_id=118 n_cursors=0 } st_thr_lock_info + main_lock_id {info=0x04e8bfc8 } st_thr_lock_owner + lock_id 0x04e8bfd4 {info=0x04e8bfc8 } st_thr_lock_owner * + LOCK_delete {DebugInfo=0x00236b80 LockCount=-1 RecursionCount=0 ...} _RTL_CRITICAL_SECTION - stmt_map {st_hash={...} names_hash={...} transient_cursor_list={...} ...} Statement_map + st_hash {key_offset=0 key_length=0 records=0 ...} st_hash + names_hash {key_offset=0 key_length=0 records=0 ...} st_hash + transient_cursor_list {...} I_List + last_found_statement 0x00000000 {main_mem_root={...} main_lex={...} id=??? ...} Statement * + thread_stack 0x054cff58 "À¯èpÿLãÄa" char * + db 0x04d24040 "test" char * + catalog 0x00909514 "std" char * + main_security_ctx {host=0x00000000 user=0x0a3d4fe0 "root" priv_user=0x009094ef "" ...} Security_context + security_ctx 0x04e8c07c {host=0x00000000 user=0x0a3d4fe0 "root" priv_user=0x009094ef "" ...} Security_context * peer_port 54379 unsigned short + proc_info 0x00000000 const char * client_capabilities 238223 unsigned long max_client_packet_length 1073741824 unsigned long + handler_tables_hash {key_offset=0 key_length=0 records=0 ...} st_hash + ull 0x00000000 {key=??? key_length=??? count=??? ...} User_level_lock * dbug_sentry 4276998655 unsigned int + mysys_var 0x00240820 {thr_errno=120 suspend={...} mutex={...} ...} st_my_thread_var * command COM_QUERY enum_server_command server_id 0 unsigned long file_id 0 unsigned long + where 0x009094e4 "field list" const char * start_time 1173044750 __int64 time_after_lock 1173045781 __int64 user_time 0 __int64 connect_time -6510615555426900571 __int64 thr_create_time 1173044750 __int64 update_lock_default TL_WRITE thr_lock_type + di 0xa5a5a5a5 {locks_in_memory=??? thd={...} table=??? ...} delayed_insert * in_sub_stmt 0 unsigned int + ha_data 0x04e8c174 void * [14] + transaction {savepoints=0x00000000 all={...} stmt={...} ...} THD::st_transactions + dupp_field 0x07bc8d40 {ptr=??? null_ptr=??? table=??? ...} Field * + active_vio 0x04c30168 {sd=46416 hPipe=0x00000000 localhost=0 ...} st_vio * + change_list {...} I_List + stmt_arena 0x04e8afcc {net={...} warn_root={...} protocol=0x04e8bb54 ...} Query_arena * next_insert_id 0 unsigned __int64 prev_insert_id 11936128518282651045 unsigned __int64 last_insert_id 0 unsigned __int64 current_insert_id 0 unsigned __int64 limit_found_rows 1 unsigned __int64 options 2156153344 unsigned __int64 row_count_func -1 __int64 cuted_fields 0 unsigned long sent_row_count 0 unsigned long examined_row_count 0 unsigned long used_tables 1 unsigned __int64 + user_connect 0x00000000 {user=??? host=??? len=??? ...} user_conn * + db_charset 0x00a1f988 _my_charset_latin1 {number=8 primary_number=0 binary_number=0 ...} charset_info_st * + warn_list {...} List + warn_count 0x04e8c36c unsigned int [3] total_warn_count 0 unsigned int query_id 40699 unsigned __int64 warn_id 40699 unsigned __int64 thread_id 2014 unsigned long col_access 0 unsigned long statement_id_counter 0 unsigned long rand_saved_seed1 2779096485 unsigned long rand_saved_seed2 2779096485 unsigned long row_count 1 unsigned long dbug_thread_id 118 long real_id 0x0000b230 void * tmp_table 0 unsigned int global_read_lock 0 unsigned int server_status 2 unsigned int open_options 0 unsigned int system_thread 0 unsigned int db_length 4 unsigned int select_number 1 unsigned int session_tx_isolation ISO_REPEATABLE_READ enum_tx_isolation count_cuted_fields CHECK_FIELD_IGNORE enum_check_fields + user_var_events {buffer=0x00000000 elements=0 max_element=0 ...} st_dynamic_array + user_var_events_alloc 0xa5a5a5a5 {free=??? used=??? pre_alloc=??? ...} st_mem_root * killed NOT_KILLED volatile THD::killed_state + scramble 0x04e8c3f0 "U?zi}\504Qz58Z:Tx!6." char [21] slave_thread 0 int one_shot_set 0 int locked 0 int some_tables_deleted 0 int last_cuted_field -1515870811 int no_errors 0 int password 0 int is_fatal_error 0 int query_start_used 0 int rand_used 0 int time_zone_used 0 int last_insert_id_used 0 int last_insert_id_used_bin_log 0 int insert_id_used 0 int clear_next_insert_id 0 int substitute_null_with_insert_id 0 int in_lock_tables 0 int query_error 0 int bootstrap 0 int cleanup_done 0 int tmp_table_used 0 int charset_is_system_charset 0 int charset_is_collation_connection 1 int charset_is_character_set_filesystem 1 int enable_slow_log 1 int no_trans_update -1515870811 int abort_on_warning 0 int got_warning -1515870811 int no_warnings_for_error 0 int derived_tables_processing 0 int tablespace_op 0 char + spcont 0x00000000 {callers_arena=??? sp=??? m_root_parsing_ctx=??? ...} sp_rcontext * + sp_proc_cache 0x00000000 {version=??? m_hashtable={...} } sp_cache * + sp_func_cache 0x00000000 {version=??? m_hashtable={...} } sp_cache * + current_linfo 0x00000000 {log_file_name=0x00000000 index_file_offset=??? index_file_start_offset=??? ...} st_log_info * + slave_net 0x00000000 {vio=??? buff=??? buff_end=??? ...} st_net * + sys_var_tmp {my_bool_value='¥' long_value=-1515870811 ulong_value=2779096485 } THD:: + binlog_evt_union {do_union=0 unioned_events=-1515870811 unioned_events_trans=-1515870811 ...} THD:: counter 1 unsigned int need_reopen 1 int - tables 0x02392138 {next_local=0x00000000 next_global=0x00000000 prev_global=0x04e8b008 ...} st_table_list * + next_local 0x00000000 {next_local=??? next_global=??? prev_global=??? ...} st_table_list * + next_global 0x00000000 {next_local=??? next_global=??? prev_global=??? ...} st_table_list * + prev_global 0x04e8b008 st_table_list * * + db 0x02392300 "test" char * + alias 0x02392130 "t4" char * + table_name 0x02392110 "t4" char * + schema_table_name 0x00000000 char * + option 0x00000000 char * + on_expr 0x00000000 {rsize=??? str_value={...} name=??? ...} Item * + prep_on_expr 0x00000000 {rsize=??? str_value={...} name=??? ...} Item * + cond_equal 0x00000000 {max_members=??? upper_levels=??? current_level={...} } COND_EQUAL * + natural_join 0x00000000 {next_local=??? next_global=??? prev_global=??? ...} st_table_list * is_natural_join 0 int + join_using_fields 0x00000000 List * + join_columns 0x00000000 List * is_join_columns_complete 0 int + next_name_resolution_table 0x00000000 {next_local=??? next_global=??? prev_global=??? ...} st_table_list * + use_index 0x00000000 List * + ignore_index 0x00000000 List * + table 0x00000000 {s=??? file=??? next=??? ...} st_table * + derived_result 0x00000000 {tmp_table_param={...} table=??? } select_union * + correspondent_table 0x00000000 {next_local=??? next_global=??? prev_global=??? ...} st_table_list * + derived 0x00000000 {result_table_list={...} union_result=??? table=??? ...} st_select_lex_unit * + schema_table 0x00000000 {table_name=??? fields_info=??? create_table=??? ...} st_schema_table * + schema_select_lex 0x00000000 {context={...} db=??? where=??? ...} st_select_lex * schema_table_reformed 0 int + schema_table_param 0x00000000 {copy_funcs={...} save_copy_funcs={...} copy_field=??? ...} TMP_TABLE_PARAM * + select_lex 0x04e8b2e0 {context={...} db=0x00000000 where=0x023925f8 ...} st_select_lex * + view 0x00000000 {yylineno=??? yytoklen=??? yylval=??? ...} st_lex * + field_translation 0x00000000 {item=??? name=??? } Field_translator * + field_translation_end 0x00000000 {item=??? name=??? } Field_translator * + merge_underlying_list 0x00000000 {next_local=??? next_global=??? prev_global=??? ...} st_table_list * + view_tables 0x00000000 List * + belong_to_view 0x00000000 {next_local=??? next_global=??? prev_global=??? ...} st_table_list * + referencing_view 0x00000000 {next_local=??? next_global=??? prev_global=??? ...} st_table_list * + security_ctx 0x00000000 {host=??? user=??? priv_user=??? ...} Security_context * + view_sctx 0x00000000 {host=??? user=??? priv_user=??? ...} Security_context * allowed_show 0 int + next_leaf 0x00000000 {next_local=??? next_global=??? prev_global=??? ...} st_table_list * + where 0x00000000 {rsize=??? str_value={...} name=??? ...} Item * + check_option 0x00000000 {rsize=??? str_value={...} name=??? ...} Item * + query {str=0x00000000 length=0 } st_lex_string + md5 {str=0x00000000 length=0 } st_lex_string + source {str=0x00000000 length=0 } st_lex_string + view_db {str=0x00000000 length=0 } st_lex_string + view_name {str=0x00000000 length=0 } st_lex_string + timestamp {str=0x00000000 length=0 } st_lex_string + definer {user={...} host={...} password={...} } st_lex_user file_version 0 unsigned __int64 updatable_view 0 unsigned __int64 revision 0 unsigned __int64 algorithm 0 unsigned __int64 view_suid 0 unsigned __int64 with_check 0 unsigned __int64 effective_with_check 0 unsigned char effective_algorithm 0 unsigned char + grant {grant_table=0x00000000 version=0 privilege=1 ...} st_grant_info engine_data 0 unsigned __int64 callback_func 0x00000000 char (THD *, char *, unsigned int, unsigned __int64 *)* lock_type TL_READ thr_lock_type outer_join 0 unsigned int shared 0 unsigned int db_length 4 unsigned int table_name_length 2 unsigned long updatable 1 int straight 0 int updating 0 int force_index 0 int ignore_leaves 0 int dep_tables 0 unsigned __int64 on_expr_dep_tables 0 unsigned __int64 + nested_join 0x00000000 {join_list={...} used_tables=??? not_null_tables=??? ...} st_nested_join * + embedding 0x00000000 {next_local=??? next_global=??? prev_global=??? ...} st_table_list * + join_list 0x04e8b3c8 List * cacheable_table 1 int table_in_first_from_clause 0 int skip_temporary 0 int contain_auto_increment 0 int multitable_view 0 int compact_view_format 0 int where_processed 0 int required_type FRMTYPE_ERROR frm_type_enum + timestamp_buffer 0x023922e4 "" char [20] prelocking_placeholder 0 int schema_table_state NOT_PROCESSED enum_schema_table_state + _db_func_ 0x04e8c07c "" const char * _db_level_ 0 unsigned int + _db_framep_ 0x054cf754 char * * + _db_file_ 0x005664ed "ƒÄ‰Eìë4j" const char * Version: '5.0.36-debug' socket: '' port: 3306 yes Status information: Current dir: c:\build\mysql-5.0.36-win-src\data\ Running threads: 17 Stack size: 196608 Current locks: lock: 0x6786288: write read_wait write : 0x84b3278 (91:10); read_wait : 0x6af5220 (101:1); 0x6b03220 (114:1); 0x681f220 (92:1); 0x4b8f220 (116:1); 0x7fe9220 (113:1); 0x67096d8 (87:1); 0x8107220 (110:1); 0x69e2220 (107:1); 0x7dba220 (88:1); 0x6d06220 (106:1); 0x6830220 (117:1); 0x40ea220 (119:1); 0x406d740 (115:1); lock: 0x80fcdf8: DB Table Version Thread L.thread Open Lock test t4 1 2006 92 1 Low priority read lock test t4 1 2013 106 1 Low priority read lock test t4 1 1957 91 1 High priority write lock test t4 1 2011 107 1 Low priority read lock test t4 1 2015 117 1 Low priority read lock test t4 1 2008 87 1 Low priority read lock test t1 1 0 0 1 Not in use test t4 1 2007 114 1 Low priority read lock test t4 1 2009 113 1 Low priority read lock test t4 1 2010 110 1 Low priority read lock test t4 1 2004 101 1 Low priority read lock test t4 1 2012 88 1 Low priority read lock test t4 1 2017 115 1 Low priority read lock test t4 1 2016 119 1 Low priority read lock test t4 1 2005 116 1 Low priority read lock test t4 1 2014 118 1 Low priority read lock Current refresh version: 1 Key caches: default Buffer_size: 8388572 Block_size: 1024 Division_limit: 100 Age_limit: 300 blocks used: 7173 not flushed: 2 w_requests: 527816 writes: 175338 r_requests: 1636340 reads: 38847 handler status: read_key: 46821 read_next: 375783 read_rnd 0 read_first: 1179 write: 69488 delete 16907 update: 0 Table status: Opened tables: 590 Open tables: 15 Open files: 16 Open streams: 0 Alarm status: Active alarms: 0 Max used alarms: 0 Next alarm time: 0 Thread database.table_name Locked/Waiting Lock_type 1957 test.t4 Locked - write High priority write lock 2004 test.t4 Waiting - read Low priority read lock Warning: Not freed memory segments: 635 Warning: Memory that was not free'ed (59114681 bytes): 447480 bytes at 0x00c572490, allocated at line 197 in '.\my_alloc.c' 447480 bytes at 0x00c505040, allocated at line 197 in '.\my_alloc.c' 447480 bytes at 0x00c4864c0, allocated at line 197 in '.\my_alloc.c' 439344 bytes at 0x00c41b038, allocated at line 197 in '.\my_alloc.c' 439344 bytes at 0x00c3afbb0, allocated at line 197 in '.\my_alloc.c' 439344 bytes at 0x00c344728, allocated at line 197 in '.\my_alloc.c' 439344 bytes at 0x00c2d92a0, allocated at line 197 in '.\my_alloc.c' 431208 bytes at 0x00c26fde0, allocated at line 197 in '.\my_alloc.c' 431208 bytes at 0x00c206920, allocated at line 197 in '.\my_alloc.c' 431208 bytes at 0x00c19d460, allocated at line 197 in '.\my_alloc.c' 431208 bytes at 0x00c133fa0, allocated at line 197 in '.\my_alloc.c' 423072 bytes at 0x00c0ccaa8, allocated at line 197 in '.\my_alloc.c' 423072 bytes at 0x00c0655b0, allocated at line 197 in '.\my_alloc.c' 423072 bytes at 0x00bffe0b8, allocated at line 197 in '.\my_alloc.c' 423072 bytes at 0x00bf96bc0, allocated at line 197 in '.\my_alloc.c' 414936 bytes at 0x00bf31690, allocated at line 197 in '.\my_alloc.c' 414936 bytes at 0x00becc160, allocated at line 197 in '.\my_alloc.c' 414936 bytes at 0x00be66c30, allocated at line 197 in '.\my_alloc.c' 414936 bytes at 0x00be01700, allocated at line 197 in '.\my_alloc.c' 406800 bytes at 0x00bd9e198, allocated at line 197 in '.\my_alloc.c' 406800 bytes at 0x00bd3ac30, allocated at line 197 in '.\my_alloc.c' 406800 bytes at 0x00bcd76c8, allocated at line 197 in '.\my_alloc.c' 406800 bytes at 0x00bc74160, allocated at line 197 in '.\my_alloc.c' 398664 bytes at 0x00bc12bc0, allocated at line 197 in '.\my_alloc.c' 398664 bytes at 0x00bbb1620, allocated at line 197 in '.\my_alloc.c' 398664 bytes at 0x00bb50080, allocated at line 197 in '.\my_alloc.c' 398664 bytes at 0x00ba90040, allocated at line 197 in '.\my_alloc.c' 390528 bytes at 0x00ba13738, allocated at line 197 in '.\my_alloc.c' 390528 bytes at 0x00b9b4160, allocated at line 197 in '.\my_alloc.c' 390528 bytes at 0x00b954b88, allocated at line 197 in '.\my_alloc.c' 390528 bytes at 0x00b8f55b0, allocated at line 197 in '.\my_alloc.c' 382392 bytes at 0x00b897fa0, allocated at line 197 in '.\my_alloc.c' 382392 bytes at 0x00b83a990, allocated at line 197 in '.\my_alloc.c' 382392 bytes at 0x00b7dd380, allocated at line 197 in '.\my_alloc.c' 382392 bytes at 0x00b77fd70, allocated at line 197 in '.\my_alloc.c' 374256 bytes at 0x00b724728, allocated at line 197 in '.\my_alloc.c' 374256 bytes at 0x00b6c90e0, allocated at line 197 in '.\my_alloc.c' 374256 bytes at 0x00b66da98, allocated at line 197 in '.\my_alloc.c' 374256 bytes at 0x00b612450, allocated at line 197 in '.\my_alloc.c' 366120 bytes at 0x00b5b8dd0, allocated at line 197 in '.\my_alloc.c' 366120 bytes at 0x00b55f750, allocated at line 197 in '.\my_alloc.c' 366120 bytes at 0x00b5060d0, allocated at line 197 in '.\my_alloc.c' 366120 bytes at 0x00b4aca50, allocated at line 197 in '.\my_alloc.c' 357984 bytes at 0x00b455398, allocated at line 197 in '.\my_alloc.c' 357984 bytes at 0x00b3fdce0, allocated at line 197 in '.\my_alloc.c' 357984 bytes at 0x00b3a6628, allocated at line 197 in '.\my_alloc.c' 357984 bytes at 0x00b34ef70, allocated at line 197 in '.\my_alloc.c' 349848 bytes at 0x00b2f9880, allocated at line 197 in '.\my_alloc.c' 349848 bytes at 0x00b2a4190, allocated at line 197 in '.\my_alloc.c' 349848 bytes at 0x00b24eaa0, allocated at line 197 in '.\my_alloc.c' 349848 bytes at 0x00b1f93b0, allocated at line 197 in '.\my_alloc.c' 341712 bytes at 0x00b1a5c88, allocated at line 197 in '.\my_alloc.c' 341712 bytes at 0x00b152560, allocated at line 197 in '.\my_alloc.c' 341712 bytes at 0x00b0fee38, allocated at line 197 in '.\my_alloc.c' 341712 bytes at 0x00b0ab710, allocated at line 197 in '.\my_alloc.c' 333576 bytes at 0x00b059fb0, allocated at line 197 in '.\my_alloc.c' 333576 bytes at 0x00b008850, allocated at line 197 in '.\my_alloc.c' 333576 bytes at 0x00afb70f0, allocated at line 197 in '.\my_alloc.c' 333576 bytes at 0x00af65990, allocated at line 197 in '.\my_alloc.c' 325440 bytes at 0x00af161f8, allocated at line 197 in '.\my_alloc.c' 325440 bytes at 0x00aec6a60, allocated at line 197 in '.\my_alloc.c' 325440 bytes at 0x00ae772c8, allocated at line 197 in '.\my_alloc.c' 325440 bytes at 0x00ae27b30, allocated at line 197 in '.\my_alloc.c' 317304 bytes at 0x00adda360, allocated at line 197 in '.\my_alloc.c' 317304 bytes at 0x00ad8cb90, allocated at line 197 in '.\my_alloc.c' 317304 bytes at 0x00ad3f3c0, allocated at line 197 in '.\my_alloc.c' 317304 bytes at 0x00acf1bf0, allocated at line 197 in '.\my_alloc.c' 309168 bytes at 0x00aca63e8, allocated at line 197 in '.\my_alloc.c' 309168 bytes at 0x00ac5abe0, allocated at line 197 in '.\my_alloc.c' 309168 bytes at 0x00ac0f3d8, allocated at line 197 in '.\my_alloc.c' 309168 bytes at 0x00abc3bd0, allocated at line 197 in '.\my_alloc.c' 301032 bytes at 0x00ab7a390, allocated at line 197 in '.\my_alloc.c' 301032 bytes at 0x00ab30b50, allocated at line 197 in '.\my_alloc.c' 301032 bytes at 0x00aae7310, allocated at line 197 in '.\my_alloc.c' 301032 bytes at 0x00aa9dad0, allocated at line 197 in '.\my_alloc.c' 292896 bytes at 0x00aa56258, allocated at line 197 in '.\my_alloc.c' 292896 bytes at 0x00aa0e9e0, allocated at line 197 in '.\my_alloc.c' 292896 bytes at 0x00a9c7168, allocated at line 197 in '.\my_alloc.c' 292896 bytes at 0x00a97f8f0, allocated at line 197 in '.\my_alloc.c' 284760 bytes at 0x00a93a040, allocated at line 197 in '.\my_alloc.c' 284760 bytes at 0x00a8a08e8, allocated at line 197 in '.\my_alloc.c' 284760 bytes at 0x00a85b038, allocated at line 197 in '.\my_alloc.c' 284760 bytes at 0x00a815788, allocated at line 197 in '.\my_alloc.c' 276624 bytes at 0x00a79a010, allocated at line 197 in '.\my_alloc.c' 276624 bytes at 0x00a71d0a0, allocated at line 197 in '.\my_alloc.c' 276624 bytes at 0x00a679040, allocated at line 197 in '.\my_alloc.c' 276624 bytes at 0x00a5e3010, allocated at line 197 in '.\my_alloc.c' 268488 bytes at 0x00a5979c0, allocated at line 197 in '.\my_alloc.c' 268488 bytes at 0x00a5560a0, allocated at line 197 in '.\my_alloc.c' 268488 bytes at 0x00a4d9158, allocated at line 197 in '.\my_alloc.c' 268488 bytes at 0x00a30c1f8, allocated at line 197 in '.\my_alloc.c' 260352 bytes at 0x00a204040, allocated at line 197 in '.\my_alloc.c' 260352 bytes at 0x00a173040, allocated at line 197 in '.\my_alloc.c' 260352 bytes at 0x00a0e67f8, allocated at line 197 in '.\my_alloc.c' 260352 bytes at 0x00a075040, allocated at line 197 in '.\my_alloc.c' 252216 bytes at 0x009fb33d0, allocated at line 197 in '.\my_alloc.c' 252216 bytes at 0x009f75a40, allocated at line 197 in '.\my_alloc.c' 252216 bytes at 0x009e76428, allocated at line 197 in '.\my_alloc.c' 252216 bytes at 0x009e07040, allocated at line 197 in '.\my_alloc.c' 244080 bytes at 0x009d335c8, allocated at line 197 in '.\my_alloc.c' 244080 bytes at 0x009ca6118, allocated at line 197 in '.\my_alloc.c' 244080 bytes at 0x0085b0a68, allocated at line 197 in '.\my_alloc.c' 244080 bytes at 0x0085750a0, allocated at line 197 in '.\my_alloc.c' 235944 bytes at 0x0084b3b60, allocated at line 197 in '.\my_alloc.c' 235944 bytes at 0x008450148, allocated at line 197 in '.\my_alloc.c' 235944 bytes at 0x00839a050, allocated at line 197 in '.\my_alloc.c' 235944 bytes at 0x008311950, allocated at line 197 in '.\my_alloc.c' 227808 bytes at 0x0082a6040, allocated at line 197 in '.\my_alloc.c' 227808 bytes at 0x0081cf040, allocated at line 197 in '.\my_alloc.c' 227808 bytes at 0x00807e230, allocated at line 197 in '.\my_alloc.c' 227808 bytes at 0x0080467f8, allocated at line 197 in '.\my_alloc.c' 219672 bytes at 0x007ec5040, allocated at line 197 in '.\my_alloc.c' 219672 bytes at 0x007e62040, allocated at line 197 in '.\my_alloc.c' 219672 bytes at 0x007e2b040, allocated at line 197 in '.\my_alloc.c' 219672 bytes at 0x007d0c968, allocated at line 197 in '.\my_alloc.c' 211536 bytes at 0x007ccc298, allocated at line 197 in '.\my_alloc.c' 4112 bytes at 0x003ffbf88, allocated at line 129 in '.\my_alloc.c' 8208 bytes at 0x007bc4ae8, allocated at line 129 in '.\my_alloc.c' 5 bytes at 0x00788bfe0, allocated at line 1048 in '.\sql_parse.cpp' 16392 bytes at 0x009c5f2e8, allocated at line 51 in '.\sql_string.cpp' 10 bytes at 0x00408b040, allocated at line 842 in '.\sql_parse.cpp' 16391 bytes at 0x0066abdc8, allocated at line 126 in '.\net_serv.cpp' 196 bytes at 0x004158f10, allocated at line 143 in '.\vio.c' 128 bytes at 0x004c30040, allocated at line 253 in '.\sql_class.cpp' 1040 bytes at 0x006cc3bd8, allocated at line 64 in '.\my_alloc.c' 42 bytes at 0x009c53f70, allocated at line 589 in '.\time.cpp' 33 bytes at 0x004b60f80, allocated at line 589 in '.\time.cpp' 33 bytes at 0x004b4efa0, allocated at line 589 in '.\time.cpp' 128 bytes at 0x007b34040, allocated at line 1720 in '.\sql_class.cpp' 128 bytes at 0x004eb3f58, allocated at line 1717 in '.\sql_class.cpp' 5368 bytes at 0x00a2bf0a8, allocated at line 471 in 'c:\build\mysql-5.0.36-win-src\sql\sql_list.h' 211536 bytes at 0x007c3f0a8, allocated at line 197 in '.\my_alloc.c' 211536 bytes at 0x007c08010, allocated at line 197 in '.\my_alloc.c' 211536 bytes at 0x007b91040, allocated at line 197 in '.\my_alloc.c' 203400 bytes at 0x007b341a8, allocated at line 197 in '.\my_alloc.c' 203400 bytes at 0x007afabd0, allocated at line 197 in '.\my_alloc.c' 203400 bytes at 0x007a65040, allocated at line 197 in '.\my_alloc.c' 203400 bytes at 0x007a31310, allocated at line 197 in '.\my_alloc.c' 195264 bytes at 0x007a017f8, allocated at line 197 in '.\my_alloc.c' 195264 bytes at 0x0079d1ce0, allocated at line 197 in '.\my_alloc.c' 195264 bytes at 0x00796c028, allocated at line 197 in '.\my_alloc.c' 195264 bytes at 0x007936760, allocated at line 197 in '.\my_alloc.c' 187128 bytes at 0x0078f8f78, allocated at line 197 in '.\my_alloc.c' 187128 bytes at 0x0078c1b08, allocated at line 197 in '.\my_alloc.c' 187128 bytes at 0x007893fb8, allocated at line 197 in '.\my_alloc.c' 187128 bytes at 0x0078400b8, allocated at line 197 in '.\my_alloc.c' 178992 bytes at 0x00780a2d8, allocated at line 197 in '.\my_alloc.c' 178992 bytes at 0x0077de750, allocated at line 197 in '.\my_alloc.c' 178992 bytes at 0x0077b2bc8, allocated at line 197 in '.\my_alloc.c' 178992 bytes at 0x007787040, allocated at line 197 in '.\my_alloc.c' 170856 bytes at 0x0076ff010, allocated at line 197 in '.\my_alloc.c' 170856 bytes at 0x007694040, allocated at line 197 in '.\my_alloc.c' 170856 bytes at 0x0076461f8, allocated at line 197 in '.\my_alloc.c' 170856 bytes at 0x006e46040, allocated at line 197 in '.\my_alloc.c' 162720 bytes at 0x006dfa040, allocated at line 197 in '.\my_alloc.c' 162720 bytes at 0x006da5040, allocated at line 197 in '.\my_alloc.c' 162720 bytes at 0x006d5bb70, allocated at line 197 in '.\my_alloc.c' 162720 bytes at 0x006d0b010, allocated at line 197 in '.\my_alloc.c' 154584 bytes at 0x006cd4030, allocated at line 197 in '.\my_alloc.c' 154584 bytes at 0x006be8ea0, allocated at line 197 in '.\my_alloc.c' 154584 bytes at 0x006b94808, allocated at line 197 in '.\my_alloc.c' 154584 bytes at 0x006b63f88, allocated at line 197 in '.\my_alloc.c' 146448 bytes at 0x006b2f040, allocated at line 197 in '.\my_alloc.c' 146448 bytes at 0x006b09040, allocated at line 197 in '.\my_alloc.c' 146448 bytes at 0x006ab9130, allocated at line 197 in '.\my_alloc.c' 146448 bytes at 0x006a79018, allocated at line 197 in '.\my_alloc.c' 138312 bytes at 0x006a3f0a0, allocated at line 197 in '.\my_alloc.c' 138312 bytes at 0x006a15ce0, allocated at line 197 in '.\my_alloc.c' 138312 bytes at 0x0069f4040, allocated at line 197 in '.\my_alloc.c' 138312 bytes at 0x0069a6040, allocated at line 197 in '.\my_alloc.c' 130176 bytes at 0x006938d78, allocated at line 197 in '.\my_alloc.c' 130176 bytes at 0x0068e5030, allocated at line 197 in '.\my_alloc.c' 130176 bytes at 0x0068bdb88, allocated at line 197 in '.\my_alloc.c' 130176 bytes at 0x00689deb0, allocated at line 197 in '.\my_alloc.c' 122040 bytes at 0x0067a41d8, allocated at line 197 in '.\my_alloc.c' 122040 bytes at 0x0067864c8, allocated at line 197 in '.\my_alloc.c' 122040 bytes at 0x004e8c510, allocated at line 197 in '.\my_alloc.c' 122040 bytes at 0x004e65ba8, allocated at line 197 in '.\my_alloc.c' 113904 bytes at 0x006833040, allocated at line 197 in '.\my_alloc.c' 113904 bytes at 0x0067d77d8, allocated at line 197 in '.\my_alloc.c' 113904 bytes at 0x004dcf040, allocated at line 197 in '.\my_alloc.c' 113904 bytes at 0x006690080, allocated at line 197 in '.\my_alloc.c' 105768 bytes at 0x00673d8c0, allocated at line 197 in '.\my_alloc.c' 105768 bytes at 0x006709fc0, allocated at line 197 in '.\my_alloc.c' 105768 bytes at 0x0066aff90, allocated at line 197 in '.\my_alloc.c' 105768 bytes at 0x004ce0900, allocated at line 197 in '.\my_alloc.c' 97632 bytes at 0x004d37468, allocated at line 197 in '.\my_alloc.c' 97632 bytes at 0x004e04040, allocated at line 197 in '.\my_alloc.c' 97632 bytes at 0x004e4b040, allocated at line 197 in '.\my_alloc.c' 97632 bytes at 0x004e23f50, allocated at line 197 in '.\my_alloc.c' 89496 bytes at 0x004d91040, allocated at line 197 in '.\my_alloc.c' 89496 bytes at 0x004d0ae30, allocated at line 197 in '.\my_alloc.c' 89496 bytes at 0x004ccab10, allocated at line 197 in '.\my_alloc.c' 89496 bytes at 0x004cb4d20, allocated at line 197 in '.\my_alloc.c' 81360 bytes at 0x004ca0ef8, allocated at line 197 in '.\my_alloc.c' 81360 bytes at 0x004c79040, allocated at line 197 in '.\my_alloc.c' 81360 bytes at 0x004c30288, allocated at line 197 in '.\my_alloc.c' 81360 bytes at 0x004c15e10, allocated at line 197 in '.\my_alloc.c' 73224 bytes at 0x004c01040, allocated at line 197 in '.\my_alloc.c' 73224 bytes at 0x004bec4f0, allocated at line 197 in '.\my_alloc.c' 73224 bytes at 0x004bd5be0, allocated at line 197 in '.\my_alloc.c' 73224 bytes at 0x004bc3d80, allocated at line 197 in '.\my_alloc.c' 65088 bytes at 0x004bb3ee8, allocated at line 197 in '.\my_alloc.c' 65088 bytes at 0x0041b4a20, allocated at line 197 in '.\my_alloc.c' 65088 bytes at 0x0041a4b88, allocated at line 197 in '.\my_alloc.c' 65088 bytes at 0x004b96040, allocated at line 197 in '.\my_alloc.c' 56952 bytes at 0x004af0040, allocated at line 197 in '.\my_alloc.c' 56952 bytes at 0x004adeea0, allocated at line 197 in '.\my_alloc.c' 56952 bytes at 0x0041d5fb8, allocated at line 197 in '.\my_alloc.c' 56952 bytes at 0x00414b040, allocated at line 197 in '.\my_alloc.c' 48816 bytes at 0x00402fd88, allocated at line 197 in '.\my_alloc.c' 48816 bytes at 0x004009b68, allocated at line 197 in '.\my_alloc.c' 48816 bytes at 0x003ff0080, allocated at line 197 in '.\my_alloc.c' 48816 bytes at 0x00235b040, allocated at line 197 in '.\my_alloc.c' 40680 bytes at 0x00a37b698, allocated at line 197 in '.\my_alloc.c' 40680 bytes at 0x00a371758, allocated at line 197 in '.\my_alloc.c' 40680 bytes at 0x00a367818, allocated at line 197 in '.\my_alloc.c' 40680 bytes at 0x004b57040, allocated at line 197 in '.\my_alloc.c' 32544 bytes at 0x004b47028, allocated at line 197 in '.\my_alloc.c' 32544 bytes at 0x004b17d98, allocated at line 197 in '.\my_alloc.c' 32544 bytes at 0x004b04cd8, allocated at line 197 in '.\my_alloc.c' 28 bytes at 0x0066f6690, allocated at line 689 in '.\lock.cpp' 32544 bytes at 0x0041ce040, allocated at line 197 in '.\my_alloc.c' 24408 bytes at 0x0041859b8, allocated at line 197 in '.\my_alloc.c' 8 bytes at 0x004b6b720, allocated at line 51 in '.\sql_string.cpp' 24408 bytes at 0x004145008, allocated at line 197 in '.\my_alloc.c' 16384 bytes at 0x00415bcc8, allocated at line 206 in 'c:\build\mysql-5.0.36-win-src\sql\sql_string.h' 4112 bytes at 0x004b45df0, allocated at line 129 in '.\my_alloc.c' 8208 bytes at 0x004102d50, allocated at line 129 in '.\my_alloc.c' 5 bytes at 0x009e63fb8, allocated at line 1203 in '.\sql_db.cpp' 5 bytes at 0x006a3f040, allocated at line 1048 in '.\sql_parse.cpp' 10 bytes at 0x00681fb08, allocated at line 842 in '.\sql_parse.cpp' 16391 bytes at 0x00411ffa8, allocated at line 126 in '.\net_serv.cpp' 196 bytes at 0x006df9f20, allocated at line 143 in '.\vio.c' 128 bytes at 0x0023d7f38, allocated at line 253 in '.\sql_class.cpp' 42 bytes at 0x004009ae0, allocated at line 589 in '.\time.cpp' 33 bytes at 0x00a3effb8, allocated at line 589 in '.\time.cpp' 33 bytes at 0x0083e3fb8, allocated at line 589 in '.\time.cpp' 24408 bytes at 0x004111e30, allocated at line 197 in '.\my_alloc.c' 28 bytes at 0x00a029d00, allocated at line 689 in '.\lock.cpp' 128 bytes at 0x00a27cf68, allocated at line 1720 in '.\sql_class.cpp' 24408 bytes at 0x004105040, allocated at line 197 in '.\my_alloc.c' 128 bytes at 0x0076c27a0, allocated at line 1717 in '.\sql_class.cpp' 8 bytes at 0x00813cfb8, allocated at line 51 in '.\sql_string.cpp' 16272 bytes at 0x0040da040, allocated at line 197 in '.\my_alloc.c' 16384 bytes at 0x0040fecf8, allocated at line 206 in 'c:\build\mysql-5.0.36-win-src\sql\sql_string.h' 4112 bytes at 0x007892f50, allocated at line 129 in '.\my_alloc.c' 8208 bytes at 0x0023bd040, allocated at line 129 in '.\my_alloc.c' 5 bytes at 0x00a6c5428, allocated at line 1203 in '.\sql_db.cpp' 5 bytes at 0x00a074fd8, allocated at line 1048 in '.\sql_parse.cpp' 10 bytes at 0x007fa6fc0, allocated at line 842 in '.\sql_parse.cpp' 5368 bytes at 0x00a0287b0, allocated at line 471 in 'c:\build\mysql-5.0.36-win-src\sql\sql_list.h' 16272 bytes at 0x00406fee0, allocated at line 197 in '.\my_alloc.c' 28 bytes at 0x0040c3ee8, allocated at line 689 in '.\lock.cpp' 16272 bytes at 0x00402bda0, allocated at line 197 in '.\my_alloc.c' 16391 bytes at 0x0040cc010, allocated at line 126 in '.\net_serv.cpp' 16272 bytes at 0x0040bff00, allocated at line 197 in '.\my_alloc.c' 8136 bytes at 0x00239f040, allocated at line 197 in '.\my_alloc.c' 8 bytes at 0x0079d1c80, allocated at line 51 in '.\sql_string.cpp' 196 bytes at 0x002347e08, allocated at line 143 in '.\vio.c' 8136 bytes at 0x0040c7fb8, allocated at line 197 in '.\my_alloc.c' 8136 bytes at 0x004175c80, allocated at line 197 in '.\my_alloc.c' 16384 bytes at 0x0040c3f60, allocated at line 206 in 'c:\build\mysql-5.0.36-win-src\sql\sql_string.h' 4112 bytes at 0x002379f70, allocated at line 129 in '.\my_alloc.c' 8208 bytes at 0x002377f08, allocated at line 129 in '.\my_alloc.c' 5 bytes at 0x007dcf930, allocated at line 1203 in '.\sql_db.cpp' 5 bytes at 0x007b90fe0, allocated at line 1048 in '.\sql_parse.cpp' 10 bytes at 0x007c3f040, allocated at line 842 in '.\sql_parse.cpp' 128 bytes at 0x004056d98, allocated at line 253 in '.\sql_class.cpp' 42 bytes at 0x009b9be80, allocated at line 589 in '.\time.cpp' 33 bytes at 0x004e03fb8, allocated at line 589 in '.\time.cpp' 33 bytes at 0x00a407fb8, allocated at line 589 in '.\time.cpp' 128 bytes at 0x009f75968, allocated at line 1720 in '.\sql_class.cpp' 128 bytes at 0x0040f1de0, allocated at line 1717 in '.\sql_class.cpp' 5368 bytes at 0x004beafa0, allocated at line 471 in 'c:\build\mysql-5.0.36-win-src\sql\sql_list.h' 16391 bytes at 0x004096040, allocated at line 126 in '.\net_serv.cpp' 196 bytes at 0x004ecd040, allocated at line 143 in '.\vio.c' 128 bytes at 0x009bb6bf0, allocated at line 253 in '.\sql_class.cpp' 42 bytes at 0x00777cfb8, allocated at line 589 in '.\time.cpp' 33 bytes at 0x00408efb8, allocated at line 589 in '.\time.cpp' 33 bytes at 0x007fe9b08, allocated at line 589 in '.\time.cpp' 128 bytes at 0x00231e950, allocated at line 1720 in '.\sql_class.cpp' 128 bytes at 0x004d0ad58, allocated at line 1717 in '.\sql_class.cpp' 5368 bytes at 0x007633f30, allocated at line 471 in 'c:\build\mysql-5.0.36-win-src\sql\sql_list.h' 8136 bytes at 0x00a070dc8, allocated at line 197 in '.\my_alloc.c' 8 bytes at 0x009f70040, allocated at line 51 in '.\sql_string.cpp' 16384 bytes at 0x0040a7040, allocated at line 206 in 'c:\build\mysql-5.0.36-win-src\sql\sql_string.h' 4112 bytes at 0x0076ccec8, allocated at line 129 in '.\my_alloc.c' 8208 bytes at 0x002392008, allocated at line 129 in '.\my_alloc.c' 5 bytes at 0x004d24040, allocated at line 1203 in '.\sql_db.cpp' 5 bytes at 0x00a3d4fe0, allocated at line 1048 in '.\sql_parse.cpp' 10 bytes at 0x004d8cb08, allocated at line 842 in '.\sql_parse.cpp' 16391 bytes at 0x004063990, allocated at line 126 in '.\net_serv.cpp' 196 bytes at 0x004c30168, allocated at line 143 in '.\vio.c' 128 bytes at 0x00687df68, allocated at line 253 in '.\sql_class.cpp' 42 bytes at 0x009e763a0, allocated at line 589 in '.\time.cpp' 33 bytes at 0x006d5baf0, allocated at line 589 in '.\time.cpp' 33 bytes at 0x0023c8b38, allocated at line 589 in '.\time.cpp' 128 bytes at 0x004d65f50, allocated at line 1720 in '.\sql_class.cpp' 128 bytes at 0x004d6ed28, allocated at line 1717 in '.\sql_class.cpp' 5368 bytes at 0x004e8afc0, allocated at line 471 in 'c:\build\mysql-5.0.36-win-src\sql\sql_list.h' 28 bytes at 0x0069e2b08, allocated at line 689 in '.\lock.cpp' 8 bytes at 0x007fb8fe0, allocated at line 51 in '.\sql_string.cpp' 16384 bytes at 0x004083000, allocated at line 206 in 'c:\build\mysql-5.0.36-win-src\sql\sql_string.h' 4112 bytes at 0x004008a78, allocated at line 129 in '.\my_alloc.c' 8208 bytes at 0x00232f078, allocated at line 129 in '.\my_alloc.c' 5 bytes at 0x006c80b08, allocated at line 1203 in '.\sql_db.cpp' 5 bytes at 0x00a4b2040, allocated at line 1048 in '.\sql_parse.cpp' 10 bytes at 0x00a2b1b08, allocated at line 842 in '.\sql_parse.cpp' 16391 bytes at 0x004041828, allocated at line 126 in '.\net_serv.cpp' 196 bytes at 0x004dbbbc0, allocated at line 143 in '.\vio.c' 128 bytes at 0x009ca6040, allocated at line 253 in '.\sql_class.cpp' 42 bytes at 0x007c9bfb8, allocated at line 589 in '.\time.cpp' 33 bytes at 0x00676cd58, allocated at line 589 in '.\time.cpp' 33 bytes at 0x00a39cfc0, allocated at line 589 in '.\time.cpp' 128 bytes at 0x004195f68, allocated at line 1720 in '.\sql_class.cpp' 128 bytes at 0x00689ddd8, allocated at line 1717 in '.\sql_class.cpp' 5368 bytes at 0x007f7d2e0, allocated at line 471 in 'c:\build\mysql-5.0.36-win-src\sql\sql_list.h' 28 bytes at 0x0069d1b60, allocated at line 689 in '.\lock.cpp' 8 bytes at 0x00a30c198, allocated at line 51 in '.\sql_string.cpp' 16384 bytes at 0x00404cfa8, allocated at line 206 in 'c:\build\mysql-5.0.36-win-src\sql\sql_string.h' 4112 bytes at 0x009c5a720, allocated at line 129 in '.\my_alloc.c' 8208 bytes at 0x004024f60, allocated at line 129 in '.\my_alloc.c' 5 bytes at 0x004d37408, allocated at line 1203 in '.\sql_db.cpp' 5 bytes at 0x009c06aa0, allocated at line 1048 in '.\sql_parse.cpp' 10 bytes at 0x004095fd8, allocated at line 842 in '.\sql_parse.cpp' 16391 bytes at 0x00232b018, allocated at line 126 in '.\net_serv.cpp' 196 bytes at 0x007b8b188, allocated at line 143 in '.\vio.c' 128 bytes at 0x00238ef68, allocated at line 253 in '.\sql_class.cpp' 42 bytes at 0x0079366d8, allocated at line 589 in '.\time.cpp' 33 bytes at 0x007874238, allocated at line 589 in '.\time.cpp' 33 bytes at 0x0078f8ef8, allocated at line 589 in '.\time.cpp' 128 bytes at 0x006dd1f68, allocated at line 1720 in '.\sql_class.cpp' 128 bytes at 0x004dcef68, allocated at line 1717 in '.\sql_class.cpp' 5368 bytes at 0x007f43c68, allocated at line 471 in 'c:\build\mysql-5.0.36-win-src\sql\sql_list.h' 28 bytes at 0x0023d9208, allocated at line 689 in '.\lock.cpp' 8 bytes at 0x00a71d040, allocated at line 51 in '.\sql_string.cpp' 16384 bytes at 0x004020f08, allocated at line 206 in 'c:\build\mysql-5.0.36-win-src\sql\sql_string.h' 4112 bytes at 0x0066f8900, allocated at line 129 in '.\my_alloc.c' 8208 bytes at 0x0023ce078, allocated at line 129 in '.\my_alloc.c' 5 bytes at 0x0069f3fe0, allocated at line 1203 in '.\sql_db.cpp' 5 bytes at 0x009cffb30, allocated at line 1048 in '.\sql_parse.cpp' 10 bytes at 0x008530038, allocated at line 842 in '.\sql_parse.cpp' 16391 bytes at 0x0023ca018, allocated at line 126 in '.\net_serv.cpp' 196 bytes at 0x00236bf20, allocated at line 143 in '.\vio.c' 128 bytes at 0x009eeb040, allocated at line 253 in '.\sql_class.cpp' 42 bytes at 0x004e4afb8, allocated at line 589 in '.\time.cpp' 33 bytes at 0x004c78fc0, allocated at line 589 in '.\time.cpp' 33 bytes at 0x004d76af0, allocated at line 589 in '.\time.cpp' 128 bytes at 0x007bc6b70, allocated at line 1720 in '.\sql_class.cpp' 128 bytes at 0x00a47df68, allocated at line 1717 in '.\sql_class.cpp' 5368 bytes at 0x00844ebf8, allocated at line 471 in 'c:\build\mysql-5.0.36-win-src\sql\sql_list.h' 28 bytes at 0x0081cdfc8, allocated at line 689 in '.\lock.cpp' 8 bytes at 0x009d14e20, allocated at line 51 in '.\sql_string.cpp' 16384 bytes at 0x007d08910, allocated at line 206 in 'c:\build\mysql-5.0.36-win-src\sql\sql_string.h' 4112 bytes at 0x009c52e30, allocated at line 129 in '.\my_alloc.c' 8208 bytes at 0x009ca13c8, allocated at line 129 in '.\my_alloc.c' 5 bytes at 0x008415040, allocated at line 1203 in '.\sql_db.cpp' 5 bytes at 0x00788bf80, allocated at line 1048 in '.\sql_parse.cpp' 10 bytes at 0x007d91fd8, allocated at line 842 in '.\sql_parse.cpp' 16391 bytes at 0x00231ee48, allocated at line 126 in '.\net_serv.cpp' 196 bytes at 0x002326d60, allocated at line 143 in '.\vio.c' 128 bytes at 0x00a47dd40, allocated at line 253 in '.\sql_class.cpp' 42 bytes at 0x004c00fb8, allocated at line 589 in '.\time.cpp' 33 bytes at 0x009c67fc0, allocated at line 589 in '.\time.cpp' 33 bytes at 0x006c25fc0, allocated at line 589 in '.\time.cpp' 128 bytes at 0x004d5cf68, allocated at line 1720 in '.\sql_class.cpp' 128 bytes at 0x007e075f0, allocated at line 1717 in '.\sql_class.cpp' 5368 bytes at 0x0077353e0, allocated at line 471 in 'c:\build\mysql-5.0.36-win-src\sql\sql_list.h' 28 bytes at 0x009f24028, allocated at line 689 in '.\lock.cpp' 28 bytes at 0x007f8ffc8, allocated at line 689 in '.\lock.cpp' 8 bytes at 0x00a26c040, allocated at line 51 in '.\sql_string.cpp' 8 bytes at 0x008404040, allocated at line 51 in '.\sql_string.cpp' 16384 bytes at 0x0040eaf90, allocated at line 206 in 'c:\build\mysql-5.0.36-win-src\sql\sql_string.h' 16384 bytes at 0x004018fa0, allocated at line 206 in 'c:\build\mysql-5.0.36-win-src\sql\sql_string.h' 4112 bytes at 0x006b62f20, allocated at line 129 in '.\my_alloc.c' 8208 bytes at 0x00408b0b0, allocated at line 129 in '.\my_alloc.c' 5 bytes at 0x007e61fe0, allocated at line 1203 in '.\sql_db.cpp' 5 bytes at 0x007b8dfe0, allocated at line 1048 in '.\sql_parse.cpp' 10 bytes at 0x00a815720, allocated at line 842 in '.\sql_parse.cpp' 4112 bytes at 0x002341648, allocated at line 129 in '.\my_alloc.c' 8208 bytes at 0x0023af0e0, allocated at line 129 in '.\my_alloc.c' 5 bytes at 0x006882920, allocated at line 1203 in '.\sql_db.cpp' 5 bytes at 0x004b77fe0, allocated at line 1048 in '.\sql_parse.cpp' 10 bytes at 0x008259fd8, allocated at line 842 in '.\sql_parse.cpp' 16391 bytes at 0x002397fd0, allocated at line 126 in '.\net_serv.cpp' 196 bytes at 0x009c63cb0, allocated at line 143 in '.\vio.c' 128 bytes at 0x004adc9b0, allocated at line 253 in '.\sql_class.cpp' 42 bytes at 0x00a203fb8, allocated at line 589 in '.\time.cpp' 33 bytes at 0x004d07a40, allocated at line 589 in '.\time.cpp' 33 bytes at 0x007a64fc0, allocated at line 589 in '.\time.cpp' 128 bytes at 0x004d6df50, allocated at line 1720 in '.\sql_class.cpp' 128 bytes at 0x007abef88, allocated at line 1717 in '.\sql_class.cpp' 5368 bytes at 0x004b544d8, allocated at line 471 in 'c:\build\mysql-5.0.36-win-src\sql\sql_list.h' 16391 bytes at 0x002381020, allocated at line 126 in '.\net_serv.cpp' 196 bytes at 0x009b84d30, allocated at line 143 in '.\vio.c' 128 bytes at 0x0041848f0, allocated at line 253 in '.\sql_class.cpp' 42 bytes at 0x0040e6f78, allocated at line 589 in '.\time.cpp' 33 bytes at 0x0069ecfc0, allocated at line 589 in '.\time.cpp' 33 bytes at 0x004b7de80, allocated at line 589 in '.\time.cpp' 128 bytes at 0x0076def68, allocated at line 1720 in '.\sql_class.cpp' 128 bytes at 0x006832f68, allocated at line 1717 in '.\sql_class.cpp' 5368 bytes at 0x004d59a28, allocated at line 471 in 'c:\build\mysql-5.0.36-win-src\sql\sql_list.h' 28 bytes at 0x007f1cb68, allocated at line 689 in '.\lock.cpp' 28 bytes at 0x006c44fc0, allocated at line 689 in '.\lock.cpp' 28 bytes at 0x0023a7fb0, allocated at line 689 in '.\lock.cpp' 8 bytes at 0x00a38b438, allocated at line 51 in '.\sql_string.cpp' 8 bytes at 0x009e06fe0, allocated at line 51 in '.\sql_string.cpp' 8 bytes at 0x0023c62f0, allocated at line 51 in '.\sql_string.cpp' 16384 bytes at 0x0023337d0, allocated at line 206 in 'c:\build\mysql-5.0.36-win-src\sql\sql_string.h' 4112 bytes at 0x00812cfa8, allocated at line 129 in '.\my_alloc.c' 8208 bytes at 0x0023b5f88, allocated at line 129 in '.\my_alloc.c' 5 bytes at 0x009c5f288, allocated at line 1203 in '.\sql_db.cpp' 5 bytes at 0x00680cfe0, allocated at line 1048 in '.\sql_parse.cpp' 10 bytes at 0x00696efd8, allocated at line 842 in '.\sql_parse.cpp' 16391 bytes at 0x00419a870, allocated at line 126 in '.\net_serv.cpp' 196 bytes at 0x008311830, allocated at line 143 in '.\vio.c' 128 bytes at 0x006cc8f68, allocated at line 253 in '.\sql_class.cpp' 42 bytes at 0x00a172fb8, allocated at line 589 in '.\time.cpp' 33 bytes at 0x0041a4b08, allocated at line 589 in '.\time.cpp' 33 bytes at 0x0040b1fc0, allocated at line 589 in '.\time.cpp' 128 bytes at 0x007be6cd8, allocated at line 1720 in '.\sql_class.cpp' 128 bytes at 0x00a454f68, allocated at line 1717 in '.\sql_class.cpp' 5368 bytes at 0x006bcffb8, allocated at line 471 in 'c:\build\mysql-5.0.36-win-src\sql\sql_list.h' 16384 bytes at 0x00416dbc8, allocated at line 206 in 'c:\build\mysql-5.0.36-win-src\sql\sql_string.h' 4112 bytes at 0x007645190, allocated at line 129 in '.\my_alloc.c' 8208 bytes at 0x004d08ba0, allocated at line 129 in '.\my_alloc.c' 5 bytes at 0x0080e3f98, allocated at line 1203 in '.\sql_db.cpp' 5 bytes at 0x006c6ce70, allocated at line 1048 in '.\sql_parse.cpp' 10 bytes at 0x007b34140, allocated at line 842 in '.\sql_parse.cpp' 16391 bytes at 0x00234f718, allocated at line 126 in '.\net_serv.cpp' 196 bytes at 0x00673d7a0, allocated at line 143 in '.\vio.c' 128 bytes at 0x00a939f68, allocated at line 253 in '.\sql_class.cpp' 42 bytes at 0x0069cd460, allocated at line 589 in '.\time.cpp' 33 bytes at 0x002368570, allocated at line 589 in '.\time.cpp' 33 bytes at 0x00698afc0, allocated at line 589 in '.\time.cpp' 128 bytes at 0x004049720, allocated at line 1720 in '.\sql_class.cpp' 128 bytes at 0x0066ddb08, allocated at line 1717 in '.\sql_class.cpp' 5368 bytes at 0x004080090, allocated at line 471 in 'c:\build\mysql-5.0.36-win-src\sql\sql_list.h' 16384 bytes at 0x002326fc0, allocated at line 206 in 'c:\build\mysql-5.0.36-win-src\sql\sql_string.h' 4112 bytes at 0x00a257bf8, allocated at line 129 in '.\my_alloc.c' 8208 bytes at 0x002375450, allocated at line 129 in '.\my_alloc.c' 5 bytes at 0x00a6dd040, allocated at line 1203 in '.\sql_db.cpp' 5 bytes at 0x00405ffe0, allocated at line 1048 in '.\sql_parse.cpp' 10 bytes at 0x009d22610, allocated at line 842 in '.\sql_parse.cpp' 16391 bytes at 0x002370d20, allocated at line 126 in '.\net_serv.cpp' 196 bytes at 0x00849cf20, allocated at line 143 in '.\vio.c' 128 bytes at 0x008404f68, allocated at line 253 in '.\sql_class.cpp' 42 bytes at 0x00a060fb8, allocated at line 589 in '.\time.cpp' 33 bytes at 0x007eb0fc0, allocated at line 589 in '.\time.cpp' 33 bytes at 0x00a159040, allocated at line 589 in '.\time.cpp' 128 bytes at 0x007e2af68, allocated at line 1720 in '.\sql_class.cpp' 128 bytes at 0x008046720, allocated at line 1717 in '.\sql_class.cpp' 5368 bytes at 0x009d12a70, allocated at line 471 in 'c:\build\mysql-5.0.36-win-src\sql\sql_list.h' 28 bytes at 0x007d44e10, allocated at line 689 in '.\lock.cpp' 8 bytes at 0x00a773040, allocated at line 51 in '.\sql_string.cpp' 16384 bytes at 0x00237cfc8, allocated at line 206 in 'c:\build\mysql-5.0.36-win-src\sql\sql_string.h' 4112 bytes at 0x00762ce58, allocated at line 129 in '.\my_alloc.c' 8208 bytes at 0x0023ad078, allocated at line 129 in '.\my_alloc.c' 5 bytes at 0x006d3fac8, allocated at line 1203 in '.\sql_db.cpp' 5 bytes at 0x00a41b040, allocated at line 1048 in '.\sql_parse.cpp' 10 bytes at 0x009c829c0, allocated at line 842 in '.\sql_parse.cpp' 16391 bytes at 0x004171c20, allocated at line 126 in '.\net_serv.cpp' 196 bytes at 0x009be2f20, allocated at line 143 in '.\vio.c' 128 bytes at 0x00a0d0f68, allocated at line 253 in '.\sql_class.cpp' 42 bytes at 0x004b95fb8, allocated at line 589 in '.\time.cpp' 33 bytes at 0x007f51fc0, allocated at line 589 in '.\time.cpp' 33 bytes at 0x004d29e38, allocated at line 589 in '.\time.cpp' 128 bytes at 0x004d90f68, allocated at line 1720 in '.\sql_class.cpp' 128 bytes at 0x00686cf68, allocated at line 1717 in '.\sql_class.cpp' 5368 bytes at 0x009d79390, allocated at line 471 in 'c:\build\mysql-5.0.36-win-src\sql\sql_list.h' 28 bytes at 0x0023c0cb8, allocated at line 689 in '.\lock.cpp' 48 bytes at 0x002375280, allocated at line 51 in '.\sql_string.cpp' 16384 bytes at 0x00412ee90, allocated at line 206 in 'c:\build\mysql-5.0.36-win-src\sql\sql_string.h' 4112 bytes at 0x007af9b68, allocated at line 129 in '.\my_alloc.c' 8208 bytes at 0x00a0e4790, allocated at line 129 in '.\my_alloc.c' 5 bytes at 0x00a556040, allocated at line 1203 in '.\sql_db.cpp' 5 bytes at 0x006cc3b78, allocated at line 1048 in '.\sql_parse.cpp' 10 bytes at 0x008397fd8, allocated at line 842 in '.\sql_parse.cpp' 16391 bytes at 0x004140fa8, allocated at line 126 in '.\net_serv.cpp' 196 bytes at 0x007ec4f20, allocated at line 143 in '.\vio.c' 128 bytes at 0x007f5b040, allocated at line 253 in '.\sql_class.cpp' 42 bytes at 0x007786fb8, allocated at line 589 in '.\time.cpp' 33 bytes at 0x009d13fc0, allocated at line 589 in '.\time.cpp' 33 bytes at 0x008107b08, allocated at line 589 in '.\time.cpp' 128 bytes at 0x007f92f68, allocated at line 1720 in '.\sql_class.cpp' 128 bytes at 0x009c53e98, allocated at line 1717 in '.\sql_class.cpp' 5368 bytes at 0x006937828, allocated at line 471 in 'c:\build\mysql-5.0.36-win-src\sql\sql_list.h' 24 bytes at 0x0068e4fc0, allocated at line 691 in '.\mi_open.c' 2672 bytes at 0x0084b3098, allocated at line 50 in '.\mulalloc.c' 14 bytes at 0x006c264c8, allocated at line 152 in '.\my_open.c' 3 bytes at 0x004b81d48, allocated at line 134 in '.\table.cpp' 968 bytes at 0x009f28bf0, allocated at line 197 in '.\my_alloc.c' 1672 bytes at 0x00412a890, allocated at line 1414 in '.\sql_base.cpp' 24 bytes at 0x002323d08, allocated at line 691 in '.\mi_open.c' 2672 bytes at 0x006af5040, allocated at line 50 in '.\mulalloc.c' 14 bytes at 0x006be8e38, allocated at line 152 in '.\my_open.c' 3 bytes at 0x00a017fc0, allocated at line 134 in '.\table.cpp' 968 bytes at 0x007f20bf0, allocated at line 197 in '.\my_alloc.c' 1672 bytes at 0x008412040, allocated at line 1414 in '.\sql_base.cpp' 24 bytes at 0x007736fc8, allocated at line 691 in '.\mi_open.c' 2672 bytes at 0x006b03040, allocated at line 50 in '.\mulalloc.c' 14 bytes at 0x009cf5d38, allocated at line 152 in '.\my_open.c' 3 bytes at 0x00796bfc8, allocated at line 134 in '.\table.cpp' 968 bytes at 0x0081a8bf0, allocated at line 197 in '.\my_alloc.c' 1672 bytes at 0x006803040, allocated at line 1414 in '.\sql_base.cpp' 24 bytes at 0x007df2d60, allocated at line 691 in '.\mi_open.c' 2672 bytes at 0x00681f040, allocated at line 50 in '.\mulalloc.c' 14 bytes at 0x007f04fc8, allocated at line 152 in '.\my_open.c' 3 bytes at 0x00690b720, allocated at line 134 in '.\table.cpp' 968 bytes at 0x006d8abf0, allocated at line 197 in '.\my_alloc.c' 1672 bytes at 0x00a4d8a78, allocated at line 1414 in '.\sql_base.cpp' 24 bytes at 0x004026fc8, allocated at line 691 in '.\mi_open.c' 2672 bytes at 0x004b8f040, allocated at line 50 in '.\mulalloc.c' 14 bytes at 0x006cd3fc8, allocated at line 152 in '.\my_open.c' 3 bytes at 0x007b31fc8, allocated at line 134 in '.\table.cpp' 968 bytes at 0x00775cbf0, allocated at line 197 in '.\my_alloc.c' 1672 bytes at 0x004b6b040, allocated at line 1414 in '.\sql_base.cpp' 24 bytes at 0x006bd1508, allocated at line 691 in '.\mi_open.c' 2672 bytes at 0x007fe9040, allocated at line 50 in '.\mulalloc.c' 14 bytes at 0x009b5dfc8, allocated at line 152 in '.\my_open.c' 3 bytes at 0x002312b80, allocated at line 134 in '.\table.cpp' 968 bytes at 0x006737bf0, allocated at line 197 in '.\my_alloc.c' 1672 bytes at 0x002367e90, allocated at line 1414 in '.\sql_base.cpp' 24 bytes at 0x006d06b08, allocated at line 691 in '.\mi_open.c' 2672 bytes at 0x0067094f8, allocated at line 50 in '.\mulalloc.c' 14 bytes at 0x006c9efd8, allocated at line 152 in '.\my_open.c' 3 bytes at 0x009f43040, allocated at line 134 in '.\table.cpp' 968 bytes at 0x00826cbf0, allocated at line 197 in '.\my_alloc.c' 1672 bytes at 0x006a72040, allocated at line 1414 in '.\sql_base.cpp' 24 bytes at 0x008172720, allocated at line 691 in '.\mi_open.c' 2672 bytes at 0x008107040, allocated at line 50 in '.\mulalloc.c' 14 bytes at 0x0069a5fd8, allocated at line 152 in '.\my_open.c' 3 bytes at 0x0066fdb08, allocated at line 134 in '.\table.cpp' 968 bytes at 0x007c07bf0, allocated at line 197 in '.\my_alloc.c' 1672 bytes at 0x00690b040, allocated at line 1414 in '.\sql_base.cpp' 24 bytes at 0x00407cce8, allocated at line 691 in '.\mi_open.c' 2672 bytes at 0x0069e2040, allocated at line 50 in '.\mulalloc.c' 14 bytes at 0x007840050, allocated at line 152 in '.\my_open.c' 3 bytes at 0x0082a5fe0, allocated at line 134 in '.\table.cpp' 968 bytes at 0x0076febf0, allocated at line 197 in '.\my_alloc.c' 1672 bytes at 0x008172040, allocated at line 1414 in '.\sql_base.cpp' 24 bytes at 0x006b08fd0, allocated at line 691 in '.\mi_open.c' 2672 bytes at 0x007dba040, allocated at line 50 in '.\mulalloc.c' 14 bytes at 0x00a2eafd8, allocated at line 152 in '.\my_open.c' 3 bytes at 0x007875fe0, allocated at line 134 in '.\table.cpp' 968 bytes at 0x00a5e2bf0, allocated at line 197 in '.\my_alloc.c' 1672 bytes at 0x00a815040, allocated at line 1414 in '.\sql_base.cpp' 24 bytes at 0x009e4dfd0, allocated at line 691 in '.\mi_open.c' 2672 bytes at 0x006d06040, allocated at line 50 in '.\mulalloc.c' 14 bytes at 0x006da4fd8, allocated at line 152 in '.\my_open.c' 3 bytes at 0x006b2efe0, allocated at line 134 in '.\table.cpp' 968 bytes at 0x0080fdbf0, allocated at line 197 in '.\my_alloc.c' 1672 bytes at 0x006c9e8f8, allocated at line 1414 in '.\sql_base.cpp' 24 bytes at 0x008515fd0, allocated at line 691 in '.\mi_open.c' 2672 bytes at 0x007f8f500, allocated at line 50 in '.\mulalloc.c' 14 bytes at 0x00836f040, allocated at line 152 in '.\my_open.c' 3 bytes at 0x008575040, allocated at line 134 in '.\table.cpp' 968 bytes at 0x004c6abf0, allocated at line 197 in '.\my_alloc.c' 1672 bytes at 0x00405f900, allocated at line 1414 in '.\sql_base.cpp' 40 bytes at 0x007ae8fc0, allocated at line 51 in '.\sql_string.cpp' 16384 bytes at 0x00417b040, allocated at line 206 in 'c:\build\mysql-5.0.36-win-src\sql\sql_string.h' 24 bytes at 0x009db9fd0, allocated at line 691 in '.\mi_open.c' 2672 bytes at 0x006830040, allocated at line 50 in '.\mulalloc.c' 14 bytes at 0x004c4ffd8, allocated at line 152 in '.\my_open.c' 3 bytes at 0x0040eab08, allocated at line 134 in '.\table.cpp' 968 bytes at 0x00a799bf0, allocated at line 197 in '.\my_alloc.c' 1672 bytes at 0x006c2a920, allocated at line 1414 in '.\sql_base.cpp' 24 bytes at 0x004b36fd0, allocated at line 691 in '.\mi_open.c' 2672 bytes at 0x0040ea040, allocated at line 50 in '.\mulalloc.c' 14 bytes at 0x007693fd8, allocated at line 152 in '.\my_open.c' 3 bytes at 0x00821e040, allocated at line 134 in '.\table.cpp' 968 bytes at 0x006d0abf0, allocated at line 197 in '.\my_alloc.c' 1672 bytes at 0x007dcd040, allocated at line 1414 in '.\sql_base.cpp' 24 bytes at 0x009dccfd0, allocated at line 691 in '.\mi_open.c' 2672 bytes at 0x00406d560, allocated at line 50 in '.\mulalloc.c' 14 bytes at 0x00a645fd8, allocated at line 152 in '.\my_open.c' 3 bytes at 0x004dab860, allocated at line 134 in '.\table.cpp' 968 bytes at 0x009c41040, allocated at line 197 in '.\my_alloc.c' 1672 bytes at 0x00801b950, allocated at line 1414 in '.\sql_base.cpp' 1072 bytes at 0x006786040, allocated at line 50 in '.\mulalloc.c' 47 bytes at 0x007d88fb8, allocated at line 152 in '.\my_open.c' 4112 bytes at 0x008542fc0, allocated at line 129 in '.\my_alloc.c' 8208 bytes at 0x00a2c0828, allocated at line 129 in '.\my_alloc.c' 5 bytes at 0x006bc9fe0, allocated at line 1203 in '.\sql_db.cpp' 5 bytes at 0x009b88040, allocated at line 1048 in '.\sql_parse.cpp' 10 bytes at 0x009d8dfd8, allocated at line 842 in '.\sql_parse.cpp' 16391 bytes at 0x006bdabf0, allocated at line 126 in '.\net_serv.cpp' 196 bytes at 0x004e65a88, allocated at line 143 in '.\vio.c' 128 bytes at 0x008292478, allocated at line 253 in '.\sql_class.cpp' 42 bytes at 0x00a678fb8, allocated at line 589 in '.\time.cpp' 33 bytes at 0x0040281d8, allocated at line 589 in '.\time.cpp' 33 bytes at 0x00a4c6d40, allocated at line 589 in '.\time.cpp' 128 bytes at 0x006b94730, allocated at line 1720 in '.\sql_class.cpp' 128 bytes at 0x0079c9f68, allocated at line 1717 in '.\sql_class.cpp' 5368 bytes at 0x004add950, allocated at line 471 in 'c:\build\mysql-5.0.36-win-src\sql\sql_list.h' 1920 bytes at 0x00417a868, allocated at line 127 in '.\array.c' 32712 bytes at 0x002312e18, allocated at line 197 in '.\my_alloc.c' 208 bytes at 0x002312cf0, allocated at line 1630 in '.\tztime.cpp' 160 bytes at 0x002312bf8, allocated at line 1624 in '.\tztime.cpp' 800 bytes at 0x0022ed440, allocated at line 501 in '.\sql_parse.cpp' 8136 bytes at 0x0023106c0, allocated at line 197 in '.\my_alloc.c' 8136 bytes at 0x00230e6a0, allocated at line 197 in '.\my_alloc.c' 344 bytes at 0x0022ed290, allocated at line 56 in '.\ft_stopwords.c' 1042792 bytes at 0x0038b0058, allocated at line 365 in '.\mf_keycache.c' 7345152 bytes at 0x0031a0058, allocated at line 358 in '.\mf_keycache.c' 256 bytes at 0x0022ed138, allocated at line 406 in '.\ha_federated.cpp' 256 bytes at 0x0022ecfe0, allocated at line 201 in '.\ha_archive.cpp' 256 bytes at 0x0022ece88, allocated at line 207 in '.\ha_berkeley.cpp' 16 bytes at 0x0022f1b38, allocated at line 174 in '.\my_error.c' 176 bytes at 0x0022f1a30, allocated at line 389 in '.\handler.cpp' 800 bytes at 0x00228fca0, allocated at line 2130 in '.\sql_class.cpp' 1024 bytes at 0x0022f15d8, allocated at line 212 in '.\repl_failsafe.cpp' 1024 bytes at 0x0022f1180, allocated at line 81 in 'c:\build\mysql-5.0.36-win-src\sql\hash_filo.h' 256 bytes at 0x00228f708, allocated at line 115 in '.\sql_db.cpp' 152 bytes at 0x00228f618, allocated at line 70 in '.\my_bitmap.c' 1 bytes at 0x00228f5b8, allocated at line 2771 in '.\mysqld.cpp' 1 bytes at 0x00228f558, allocated at line 2765 in '.\mysqld.cpp' 1408 bytes at 0x0022e6d08, allocated at line 3049 in '.\set_var.cpp' 128 bytes at 0x0022e6c30, allocated at line 3122 in '.\item_func.cpp' 16 bytes at 0x0022e6bc8, allocated at line 174 in '.\my_error.c' 16 bytes at 0x0022e6b60, allocated at line 174 in '.\my_error.c' 27267 bytes at 0x0022e0080, allocated at line 127 in '.\derror.cpp' 16000 bytes at 0x002286608, allocated at line 124 in '.\my_file.c' 42 bytes at 0x002286580, allocated at line 589 in '.\time.cpp' 33 bytes at 0x002286500, allocated at line 589 in '.\time.cpp' 33 bytes at 0x002286480, allocated at line 589 in '.\time.cpp' 36 bytes at 0x002286400, allocated at line 7416 in '.\mysqld.cpp' 36 bytes at 0x002286380, allocated at line 50 in '.\mf_tempdir.c' 4 bytes at 0x002286040, allocated at line 31 in '.\mf_tempdir.c' 456 bytes at 0x002286160, allocated at line 197 in '.\my_alloc.c' 128 bytes at 0x002285f00, allocated at line 113 in '.\mf_keycaches.c' 8 bytes at 0x002285ea0, allocated at line 963 in 'c:\build\mysql-5.0.36-win-src\sql\set_var.h' 24 bytes at 0x002285e30, allocated at line 471 in 'c:\build\mysql-5.0.36-win-src\sql\sql_list.h' 1232 bytes at 0x002285908, allocated at line 3612 in '.\set_var.cpp' Maximum memory usage: 59207991 bytes (57821k) in mysql_lock_tables, this block not executed: if (lock_external(thd, tables, count)) { } so, goes from thd->proc_info="System lock"; to thd->proc_info="Table lock"; rc == 1, so not entered block if (rc > 1) /* a timeout or a deadlock */ { my_error(rc, MYF(0)); my_free((gptr) sql_lock,MYF(0)); sql_lock= 0; break; } this is run: else if (rc == 1) /* aborted */ { thd->some_tables_deleted=1; // Try again sql_lock->lock_count= 0; // Locks are already freed } thd->proc_info=0; //NULL in processlist enter into this block: if (flags & MYSQL_LOCK_NOTIFY_IF_NEED_REOPEN) { *need_reopen= TRUE; break; } mysql_lock_tables() returning NULL thd->lex->requires_prelocking() returning FALSE if (!lock_tables(thd, tables, counter, &need_reopen)) need_reopen == 1 counter == 1 mysql> show global variables; +---------------------------------+-------------------------------------------------------------+ | Variable_name | Value | +---------------------------------+-------------------------------------------------------------+ | auto_increment_increment | 1 | | auto_increment_offset | 1 | | automatic_sp_privileges | ON | | back_log | 50 | | basedir | c:\build\mysql-5.0.36-win-src\ | | bdb_cache_size | 8388572 | | bdb_home | c:\build\mysql-5.0.36-win-src\data\ | | bdb_log_buffer_size | 32768 | | bdb_logdir | | | bdb_max_lock | 10000 | | bdb_shared_data | OFF | | bdb_tmpdir | C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\ | | binlog_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 | c:\build\mysql-5.0.36-win-src\share\charsets\ | | collation_connection | latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | | completion_type | 0 | | concurrent_insert | 1 | | connect_timeout | 5 | | datadir | c:\build\mysql-5.0.36-win-src\data\ | | date_format | %Y-%m-%d | | datetime_format | %Y-%m-%d %H:%i:%s | | default_week_format | 0 | | delay_key_write | ON | | delayed_insert_limit | 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | div_precision_increment | 4 | | engine_condition_pushdown | OFF | | expire_logs_days | 0 | | flush | OFF | | flush_time | 1800 | | ft_boolean_syntax | + -><()~*:""&| | | ft_max_word_len | 84 | | ft_min_word_len | 4 | | ft_query_expansion_limit | 20 | | ft_stopword_file | (built-in) | | group_concat_max_len | 1024 | | have_archive | YES | | have_bdb | YES | | have_blackhole_engine | YES | | have_compress | YES | | have_crypt | NO | | have_csv | NO | | have_dynamic_loading | YES | | have_example_engine | YES | | have_federated_engine | YES | | have_geometry | YES | | have_innodb | DISABLED | | have_isam | NO | | have_merge_engine | YES | | have_ndbcluster | NO | | have_openssl | DISABLED | | have_query_cache | YES | | have_raid | NO | | have_rtree_keys | YES | | have_symlink | YES | | init_connect | | | init_file | | | init_slave | | | innodb_additional_mem_pool_size | 1048576 | | innodb_autoextend_increment | 8 | | innodb_buffer_pool_awe_mem_mb | 0 | | innodb_buffer_pool_size | 8388608 | | innodb_checksums | ON | | innodb_commit_concurrency | 0 | | innodb_concurrency_tickets | 500 | | innodb_data_file_path | | | innodb_data_home_dir | | | innodb_doublewrite | ON | | innodb_fast_shutdown | 1 | | innodb_file_io_threads | 4 | | innodb_file_per_table | OFF | | innodb_flush_log_at_trx_commit | 1 | | innodb_flush_method | | | innodb_force_recovery | 0 | | innodb_lock_wait_timeout | 50 | | innodb_locks_unsafe_for_binlog | OFF | | innodb_log_arch_dir | | | innodb_log_archive | OFF | | innodb_log_buffer_size | 1048576 | | innodb_log_file_size | 5242880 | | innodb_log_files_in_group | 2 | | innodb_log_group_home_dir | | | innodb_max_dirty_pages_pct | 90 | | innodb_max_purge_lag | 0 | | innodb_mirrored_log_groups | 1 | | innodb_open_files | 300 | | innodb_rollback_on_timeout | OFF | | innodb_support_xa | ON | | innodb_sync_spin_loops | 20 | | innodb_table_locks | ON | | innodb_thread_concurrency | 8 | | innodb_thread_sleep_delay | 10000 | | interactive_timeout | 28800 | | join_buffer_size | 131072 | | key_buffer_size | 8388572 | | key_cache_age_threshold | 300 | | key_cache_block_size | 1024 | | key_cache_division_limit | 100 | | language | c:\build\mysql-5.0.36-win-src\share\english\ | | large_files_support | ON | | large_page_size | 0 | | large_pages | OFF | | lc_time_names | en_US | | license | GPL | | local_infile | ON | | log | OFF | | log_bin | OFF | | log_bin_trust_function_creators | OFF | | log_error | | | log_queries_not_using_indexes | OFF | | log_slave_updates | OFF | | log_slow_queries | OFF | | log_warnings | 1 | | long_query_time | 10 | | low_priority_updates | OFF | | lower_case_file_system | ON | | lower_case_table_names | 1 | | max_allowed_packet | 1048576 | | max_binlog_cache_size | 4294967295 | | max_binlog_size | 1073741824 | | max_connect_errors | 10 | | max_connections | 900 | | max_delayed_threads | 20 | | max_error_count | 64 | | max_heap_table_size | 16777216 | | max_insert_delayed_threads | 20 | | max_join_size | 4294967295 | | max_length_for_sort_data | 1024 | | max_prepared_stmt_count | 16382 | | max_relay_log_size | 0 | | max_seeks_for_key | 4294967295 | | max_sort_length | 1024 | | max_sp_recursion_depth | 0 | | max_tmp_tables | 32 | | max_user_connections | 0 | | max_write_lock_count | 4294967295 | | multi_range_count | 256 | | myisam_data_pointer_size | 6 | | myisam_max_sort_file_size | 2147483647 | | myisam_recover_options | OFF | | myisam_repair_threads | 1 | | myisam_sort_buffer_size | 8388608 | | myisam_stats_method | nulls_unequal | | net_buffer_length | 16384 | | net_read_timeout | 30 | | net_retry_count | 10 | | net_write_timeout | 60 | | new | OFF | | old_passwords | OFF | | open_files_limit | 500 | | optimizer_prune_level | 1 | | optimizer_search_depth | 62 | | pid_file | c:\build\mysql-5.0.36-win-src\data\xp64.pid | | port | 3306 | | preload_buffer_size | 32768 | | 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 | 2048 | | read_buffer_size | 131072 | | read_only | OFF | | read_rnd_buffer_size | 262144 | | relay_log_purge | ON | | relay_log_space_limit | 0 | | rpl_recovery_rank | 0 | | secure_auth | OFF | | shared_memory | OFF | | shared_memory_base_name | MYSQL | | server_id | 0 | | skip_external_locking | ON | | skip_networking | OFF | | skip_show_database | OFF | | slave_compressed_protocol | OFF | | slave_load_tmpdir | C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\ | | slave_net_timeout | 3600 | | slave_skip_errors | OFF | | slave_transaction_retries | 10 | | slow_launch_time | 2 | | sort_buffer_size | 2097116 | | sql_big_selects | ON | | sql_mode | | | sql_notes | ON | | sql_warnings | OFF | | ssl_ca | | | ssl_capath | | | ssl_cert | | | ssl_cipher | | | ssl_key | | | storage_engine | MyISAM | | sync_binlog | 0 | | sync_frm | ON | | system_time_zone | South Africa Standard Time | | table_cache | 512 | | table_lock_wait_timeout | 50 | | table_type | MyISAM | | thread_cache_size | 22 | | thread_stack | 196608 | | time_format | %H:%i:%s | | time_zone | SYSTEM | | timed_mutexes | OFF | | tmp_table_size | 33554432 | | tmpdir | C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\ | | transaction_alloc_block_size | 8192 | | transaction_prealloc_size | 4096 | | tx_isolation | REPEATABLE-READ | | updatable_views_with_limit | YES | | version | 5.0.36-debug | | version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (February 15, 2007) | | version_comment | yes | | version_compile_machine | ia32 | | version_compile_os | Win32 | | wait_timeout | 28800 | +---------------------------------+-------------------------------------------------------------+ 228 rows in set (2.83 sec)