Running "call pinsdel2()" in 100 threads for 10 minutes. Below is master and slave informations. No disconnections, but cpu was pegged at 100% for the entire test. the slave struggles to read events from the overloaded master (which happens to be on the same overloaded server). master: ------------------ F:\tmp\mysql-5.1.23-rc-winx64\bin>mysqld-release --console --skip-grant-tables --log-warn=2 --skip-grant-tables --log-bin --server-id=1 --port=3306 --innodb_buffer_pool_size=100M --innodb_flush_log_at_trx_commit=0 080725 16:10:55 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=xp64-bin' to avoid this problem. 080725 16:11:04 InnoDB: Started; log sequence number 0 40328118 080725 16:11:04 [Note] mysqld-release: ready for connections. Version: '5.1.23-rc-community-log' socket: '' port: 3306 MySQL Community Server (GPL) mysql> show processlist; +-----+------+-----------+------+-------------+------+-------------------------------+--------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+------+-----------+------+-------------+------+-------------------------------+--------------------------------------------------------------------+ | 1 | root | localhost | NULL | Binlog Dump | 456 | Sending binlog event to slave | NULL | | 5 | root | localhost | test | Query | 13 | preparing | /* don't kill */ SHOW /*!50010 GLOBAL*/ STATUS | | 6 | root | localhost | test | Query | 2 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',28069) | | 7 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',3704) | | 8 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',24355) | | 9 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',1789) | | 10 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',22881) | | 11 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',27563) | | 12 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',24674) | | 13 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',8385) | | 14 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',25345) | | 15 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',28402) | | 16 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',34767) | | 17 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',32704) | | 18 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',35232) | | 19 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',41530) | | 20 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',34281) | | 21 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',41738) | | 22 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',38932) | | 23 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',32275) | | 24 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',42925) | | 25 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',39560) | | 26 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',38453) | | 27 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',35497) | | 28 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',32607) | | 29 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',40861) | | 30 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',38141) | | 31 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',34178) | | 32 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',37502) | | 33 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',40210) | | 34 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',40548) | | 35 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',35447) | | 36 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',33832) | | 37 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',40020) | | 38 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',38468) | | 39 | root | localhost | test | Query | 0 | end | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',35363) | | 40 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',35427) | | 41 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',28646) | | 42 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',33008) | | 43 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',40365) | | 44 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',41745) | | 45 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',41401) | | 46 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',38048) | | 47 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',30699) | | 48 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',34005) | | 49 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',37347) | | 50 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',36608) | | 51 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',42336) | | 52 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',37763) | | 53 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',41046) | | 54 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',37469) | | 55 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',35827) | | 56 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',31777) | | 57 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',35323) | | 58 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',39383) | | 59 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',37499) | | 60 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',32615) | | 61 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',34330) | | 62 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',38615) | | 63 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',36717) | | 64 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',41378) | | 65 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',40951) | | 66 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',38403) | | 67 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',42652) | | 68 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',42349) | | 69 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',39988) | | 70 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',37081) | | 71 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',32357) | | 72 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',41087) | | 73 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',39367) | | 74 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',35468) | | 75 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',38503) | | 76 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',36486) | | 77 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',34143) | | 78 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',29909) | | 79 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',35955) | | 80 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',41528) | | 81 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',41478) | | 82 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',38344) | | 83 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',42044) | | 84 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',38744) | | 85 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',37877) | | 86 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',42577) | | 87 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',28550) | | 88 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',43092) | | 89 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',41478) | | 90 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',36529) | | 91 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',41747) | | 92 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',31855) | | 93 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',39358) | | 94 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',37362) | | 95 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',32218) | | 96 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',39605) | | 97 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',34435) | | 98 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',39655) | | 99 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',34719) | | 100 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',40908) | | 101 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',30664) | | 102 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',40993) | | 103 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',35153) | | 104 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',32780) | | 105 | root | localhost | test | Query | 0 | updating | DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',42128) | | 106 | root | localhost | test | Query | 0 | NULL | show processlist | +-----+------+-----------+------+-------------+------+-------------------------------+--------------------------------------------------------------------+ 103 rows in set (9.08 sec) mysql> show innodb status\G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 080725 16:22:09 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 15 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 109, signal count 80 Mutex spin waits 0, rounds 0, OS waits 0 RW-shared spins 178, OS waits 61; RW-excl spins 100, OS waits 48 ------------ TRANSACTIONS ------------ Trx id counter 0 3960425 Purge done for trx's n:o < 0 3268813 undo n:o < 0 0 History list length 169 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, OS thread id 18604 MySQL thread id 107, query id 2938670 localhost 127.0.0.1 root show innodb status ---TRANSACTION 0 3960364, not started, OS thread id 11696 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 103, query id 2938491 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',23665) ---TRANSACTION 0 3960405, not started, OS thread id 13896 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 97, query id 2938614 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',22947) ---TRANSACTION 0 3960381, not started, OS thread id 40064 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 81, query id 2938539 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',27506) ---TRANSACTION 0 3960347, not started, OS thread id 10380 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 105, query id 2938440 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',30642) ---TRANSACTION 0 3960329, not started, OS thread id 40084 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 104, query id 2938386 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',21772) ---TRANSACTION 0 3960416, not started, OS thread id 11852 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 102, query id 2938647 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',29505) ---TRANSACTION 0 3960350, not started, OS thread id 24872 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 101, query id 2938449 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',16880) ---TRANSACTION 0 3960404, not started, OS thread id 32088 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 100, query id 2938611 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',30878) ---TRANSACTION 0 3960411, not started, OS thread id 27864 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 99, query id 2938632 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',23231) ---TRANSACTION 0 3960379, not started, OS thread id 21300 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 98, query id 2938536 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',28169) ---TRANSACTION 0 3960352, not started, OS thread id 14844 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 96, query id 2938455 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',28119) ---TRANSACTION 0 3960393, not started, OS thread id 28572 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 95, query id 2938578 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',20730) ---TRANSACTION 0 3960398, not started, OS thread id 36236 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 94, query id 2938593 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',25874) ---TRANSACTION 0 3960365, not started, OS thread id 34608 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 93, query id 2938494 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',27872) ---TRANSACTION 0 3960358, not started, OS thread id 16516 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 92, query id 2938473 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',20369) ---TRANSACTION 0 3960389, not started, OS thread id 29112 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 91, query id 2938566 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',30259) ---TRANSACTION 0 3960326, not started, OS thread id 37596 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 90, query id 2938377 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',25043) ---TRANSACTION 0 3960369, not started, OS thread id 15060 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 82, query id 2938506 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',26856) ---TRANSACTION 0 3960420, not started, OS thread id 43060 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 83, query id 2938659 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',30556) ---TRANSACTION 0 3960391, not started, OS thread id 4232 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 84, query id 2938572 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',27256) ---TRANSACTION 0 3960383, not started, OS thread id 24052 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 85, query id 2938548 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',26391) ---TRANSACTION 0 3960370, not started, OS thread id 43028 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 86, query id 2938509 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',31091) ---TRANSACTION 0 3960421, not started, OS thread id 39704 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 87, query id 2938662 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',17062) ---TRANSACTION 0 3960402, not started, OS thread id 13984 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 88, query id 2938605 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',33572) ---TRANSACTION 0 3960345, not started, OS thread id 2780 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 89, query id 2938434 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',29992) ---TRANSACTION 0 3960363, not started, OS thread id 12044 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 79, query id 2938488 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',24469) ---TRANSACTION 0 3960343, not started, OS thread id 41768 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 80, query id 2938428 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',30042) ---TRANSACTION 0 3960349, not started, OS thread id 38104 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 53, query id 2938446 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',29560) ---TRANSACTION 0 3960367, not started, OS thread id 16188 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 58, query id 2938500 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',27897) ---TRANSACTION 0 3958085, not started, OS thread id 13588 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 59, query id 2931651 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',26769) ---TRANSACTION 0 3960419, not started, OS thread id 24580 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 60, query id 2938656 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',21127) ---TRANSACTION 0 3960424, not started, OS thread id 28168 MySQL thread id 61, query id 2938669 localhost 127.0.0.1 root call pinsdel2() ---TRANSACTION 0 3960392, not started, OS thread id 30768 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 62, query id 2938575 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',27127) ---TRANSACTION 0 3960410, not started, OS thread id 26056 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 63, query id 2938629 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',24681) ---TRANSACTION 0 3960390, not started, OS thread id 26612 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 64, query id 2938569 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',29892) ---TRANSACTION 0 3960371, not started, OS thread id 26584 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 65, query id 2938512 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',29465) ---TRANSACTION 0 3960328, not started, OS thread id 33312 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 66, query id 2938383 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',26917) ---TRANSACTION 0 3960422, not started, OS thread id 4788 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 67, query id 2938665 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',31164) ---TRANSACTION 0 3960362, not started, OS thread id 19360 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 68, query id 2938485 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',30863) ---TRANSACTION 0 3960327, not started, OS thread id 14776 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 69, query id 2938380 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',28502) ---TRANSACTION 0 3960368, not started, OS thread id 1140 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 70, query id 2938503 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',25595) ---TRANSACTION 0 3960334, not started, OS thread id 5264 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 71, query id 2938401 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',20871) ---TRANSACTION 0 3960348, not started, OS thread id 15288 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 72, query id 2938443 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',29601) ---TRANSACTION 0 3960361, not started, OS thread id 30148 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 73, query id 2938482 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',27881) ---TRANSACTION 0 3960375, not started, OS thread id 23032 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 74, query id 2938524 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',23980) ---TRANSACTION 0 3960356, not started, OS thread id 16940 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 75, query id 2938467 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',27017) ---TRANSACTION 0 3960417, not started, OS thread id 19896 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 76, query id 2938650 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',24998) ---TRANSACTION 0 3960409, not started, OS thread id 25104 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 77, query id 2938626 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',22655) ---TRANSACTION 0 3960385, not started, OS thread id 34252 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 78, query id 2938554 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',18421) ---TRANSACTION 0 3960378, not started, OS thread id 42452 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 57, query id 2938533 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',23837) ---TRANSACTION 0 3960344, not started, OS thread id 13148 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 56, query id 2938431 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',20291) ---TRANSACTION 0 3960406, not started, OS thread id 25172 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 55, query id 2938617 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',24339) ---TRANSACTION 0 3960372, not started, OS thread id 34516 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 54, query id 2938515 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',26599) ---TRANSACTION 0 3960366, not started, OS thread id 26400 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 52, query id 2938497 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',26735) ---TRANSACTION 0 3960382, not started, OS thread id 15468 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 51, query id 2938545 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',30850) ---TRANSACTION 0 3960418, not started, OS thread id 17424 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 50, query id 2938653 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',25120) ---TRANSACTION 0 3960342, not started, OS thread id 42820 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 49, query id 2938425 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',25861) ---TRANSACTION 0 3960355, not started, OS thread id 34864 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 48, query id 2938464 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',22519) ---TRANSACTION 0 3960403, not started, OS thread id 25860 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 47, query id 2938608 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',19933) ---TRANSACTION 0 3960373, not started, OS thread id 42212 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 46, query id 2938518 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',26560) ---TRANSACTION 0 3960351, not started, OS thread id 42748 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 39, query id 2938452 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',23875) ---TRANSACTION 0 3960341, not started, OS thread id 28880 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 37, query id 2938422 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',29460) ---TRANSACTION 0 3960360, not started, OS thread id 26592 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 38, query id 2938479 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',26980) ---TRANSACTION 0 3960408, not started, OS thread id 21840 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 40, query id 2938623 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',23939) ---TRANSACTION 0 3960376, not started, OS thread id 17780 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 41, query id 2938527 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',17160) ---TRANSACTION 0 3960413, not started, OS thread id 22592 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 42, query id 2938638 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',21520) ---TRANSACTION 0 3960340, not started, OS thread id 13268 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 43, query id 2938419 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',28879) ---TRANSACTION 0 3960346, not started, OS thread id 7868 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 44, query id 2938437 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',30259) ---TRANSACTION 0 3960396, not started, OS thread id 22508 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 45, query id 2938587 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',29913) ---TRANSACTION 0 3960384, not started, OS thread id 24040 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 31, query id 2938551 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',22692) ---TRANSACTION 0 3960401, not started, OS thread id 15276 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 34, query id 2938602 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',29060) ---TRANSACTION 0 3960387, not started, OS thread id 13576 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 32, query id 2938560 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',26016) ---TRANSACTION 0 3960397, not started, OS thread id 4128 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 30, query id 2938590 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',26653) ---TRANSACTION 0 3960388, not started, OS thread id 25324 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 29, query id 2938563 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',29375) ---TRANSACTION 0 3960412, not started, OS thread id 12876 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 33, query id 2938635 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',28722) ---TRANSACTION 0 3960339, not started, OS thread id 32276 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 28, query id 2938416 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',21121) ---TRANSACTION 0 3960407, not started, OS thread id 23528 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 26, query id 2938620 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',26965) ---TRANSACTION 0 3960357, not started, OS thread id 18260 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 27, query id 2938470 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',24011) ---TRANSACTION 0 3960331, not started, OS thread id 23632 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 23, query id 2938395 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',20789) ---TRANSACTION 0 3960377, not started, OS thread id 6064 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 22, query id 2938530 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',27446) ---TRANSACTION 0 3960386, not started, OS thread id 43672 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 35, query id 2938557 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',23959) ---TRANSACTION 0 3960337, not started, OS thread id 20084 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 36, query id 2938410 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',22346) ---TRANSACTION 0 3960399, not started, OS thread id 38672 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 24, query id 2938596 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',31437) ---TRANSACTION 0 3960374, not started, OS thread id 35696 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 25, query id 2938521 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',26848) ---TRANSACTION 0 3960330, not started, OS thread id 8172 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 20, query id 2938389 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',22795) ---TRANSACTION 0 3960359, not started, OS thread id 13240 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 21, query id 2938476 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',30252) ---TRANSACTION 0 3960380, not started, OS thread id 36464 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 19, query id 2938542 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',30044) ---TRANSACTION 0 3960423, not started, OS thread id 10772 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 16, query id 2938668 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',23279) ---TRANSACTION 0 3960394, not started, OS thread id 43868 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 17, query id 2938581 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',21218) ---TRANSACTION 0 3960395, not started, OS thread id 16828 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 18, query id 2938584 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',23746) ---TRANSACTION 0 3960335, not started, OS thread id 15704 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 15, query id 2938404 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',16916) ---TRANSACTION 0 3960325, not started, OS thread id 10372 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 14, query id 2938374 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',13859) ---TRANSACTION 0 3960414, not started, OS thread id 38644 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 8, query id 2938641 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',12867) ---TRANSACTION 0 3960336, not started, OS thread id 1356 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 13, query id 2938407 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',42185) ---TRANSACTION 0 3960400, not started, OS thread id 9492 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 9, query id 2938599 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',35371) ---TRANSACTION 0 3960354, not started, OS thread id 6872 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 12, query id 2938461 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',13188) ---TRANSACTION 0 3960415, not started, OS thread id 15548 sleeping before joining InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 10, query id 2938644 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',9791) ---TRANSACTION 0 3960333, not started, OS thread id 29792 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 11, query id 2938398 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',15611) ---TRANSACTION 0 3960338, not started, OS thread id 32284 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 7, query id 2938413 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',40255) ---TRANSACTION 0 3960353, not started, OS thread id 13308 waiting in InnoDB queue mysql tables in use 22, locked 22 MySQL thread id 6, query id 2938458 localhost 127.0.0.1 root updating DELETE FROM pinsdel2_tbl WHERE id = NAME_CONST('del_count',16857) -------- FILE I/O -------- I/O thread 0 state: wait Windows aio (insert buffer thread) I/O thread 1 state: wait Windows aio (log thread) I/O thread 2 state: wait Windows aio (read thread) I/O thread 3 state: wait Windows aio (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 1; buffer pool: 0 92 OS file reads, 1451 OS file writes, 364 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 1.21 writes/s, 0.26 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 207619, used cells 2, node heap has 1 buffer(s) 3837.14 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 53288211 Log flushed up to 0 53285907 Last checkpoint at 0 52972124 1 pending log writes, 0 pending chkp writes 310 log i/o's done, 0.11 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 128300072; in additional pool allocated 1048320 Dictionary memory allocated 119560 Buffer pool size 6400 Free buffers 6019 Database pages 380 Modified db pages 1 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 82, created 298, written 1111 0.00 reads/s, 0.00 creates/s, 1.05 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 8 queries inside InnoDB, 99 queries in queue 1 read views open inside InnoDB Main thread id 37324, state: flushing log Number of rows inserted 11000, updated 0, deleted 10877, read 11097 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set, 1 warning (12.20 sec) mysql> slave: ----------- E:\mysql-5.1.23-rc-winx64\bin>mysqld-release --console --skip-grant-tables --log-warn=2 --skip-grant-tables --server-id=2 --port=3307 --innodb_buffer_pool_size=100M --innodb_flush_log_at_trx_commit=0 080725 16:11:10 InnoDB: Started; log sequence number 0 30611865 080725 16:11:10 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=xp64-relay-bin' to avoid this problem. 080725 16:11:10 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:3306',replication started in log 'xp64-bin.000001' at position 13341928 080725 16:11:10 [Note] Slave SQL thread initialized, starting replication in log 'xp64-bin.000001' at position 13341928, relay log '.\xp64-relay-bin.000002' position: 13342072 080725 16:11:10 [Note] mysqld-release: ready for connections. Version: '5.1.23-rc-community' socket: '' port: 3307 MySQL Community Server (GPL) E:\mysql-enterprise-gpl-5.0.42-win32\bin>mysql -uroot test -P3307 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 Server version: 5.1.23-rc-community MySQL Community Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show processlist; +----+-------------+-----------+------+---------+------+----------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------------+-----------+------+---------+------+----------------------------------+------------------+ | 1 | system user | | NULL | Connect | 568 | Waiting for master to send event | NULL | | 2 | system user | | NULL | Connect | 218 | Reading event from the relay log | NULL | | 5 | root | localhost | test | Query | 0 | NULL | show processlist | +----+-------------+-----------+------+---------+------+----------------------------------+------------------+ 3 rows in set (2.50 sec) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 127.0.0.1 Master_User: root Master_Port: 3306 Connect_Retry: 60 Master_Log_File: xp64-bin.000002 Read_Master_Log_Pos: 4289974 Relay_Log_File: xp64-relay-bin.000005 Relay_Log_Pos: 1987972 Relay_Master_Log_File: xp64-bin.000002 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1987828 Relay_Log_Space: 4290416 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 232 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: 1 row in set (13.36 sec)