| Hi, | | we have a large database which receives many questions and inserts | all the time. | | we are facing a problem, for it is holding some queries longer than | desired. we got | some statistics from the process list that shows the below | information. Seems that | some insert/selection are locked we do not know why. How to get rid | of this? We | would like the database running smoothly. We also would like to know | what does | that locked on the state column means. I got some documents about | users lock, and system lock, but | not just lock. | | thanks | | joao | +-------+---------+---------------+-----------+----------------+-------+---- | -----------------------------------------+-------------------------------- -- | --------------------------------------------------------------------+ | | Id | User | Host | db | Command | Time | | State | Info | | | +-------+---------+---------------+-----------+----------------+-------+---- | -----------------------------------------+-------------------------------- -- | --------------------------------------------------------------------+ | | 18 | DELAYED | localhost | wnidb | Delayed_insert | 4 | | Waiting on cond | log_ip | | | | 58 | wni | localhost | wnidb_tmp | Sleep | 2 | | | | | | | 59 | DELAYED | localhost | wnidb_tmp | Delayed_insert | 9 | | Waiting on cond | event_log_tmp | | | | 74 | DELAYED | localhost | wnidb_tmp | Delayed_insert | 0 | | Waiting on cond | log_pos_tmp | | | | 82 | wni | localhost | wnidb_tmp | Sleep | 0 | | | | | | | 104 | wni | localhost | wnidb_tmp | Sleep | 41 | | | | | | | 445 | wni | gerenciamento | | Binlog Dump | 28908 | | Slave connection: waiting for binlog update | | | | | 30680 | wni | gerenciamento | wnidb | Query | 602 | | Sending data | SELECT log_pos_id FROM log_pos | WHERE tstamp > FROM_UNIXTIME(1013033689) AND msg_status <> 99 AND equ | | | 30682 | wni | gerenciamento | wnidb | Query | 600 | | Locked | INSERT INTO log_pos | (log_pos_id, equipment_id, msg_status, tstamp, msg_type, tm_recv_from_pos, | tm_r | | | 30683 | wni | gerenciamento | wnidb_tmp | Sleep | 600 | | | | | | | 30912 | wni | localhost | wnidb | Query | 367 | | Locked | SELECT log_pos.equipment_id, | log_pos.msg_type, log_pos.msg_status, count(*), sum(missed_ack_up), sum | | | 30947 | wni | localhost | wnidb | Query | 339 | | Locked | SELECT radio.base_id, | log_pos.msg_type, log_pos.msg_status, count(*), sum(missed_ack_up), | sum(missed | | | 31305 | wni | localhost | | Query | 0 | | | show processlist | | | +-------+---------+---------------+-----------+----------------+-------+---- | -----------------------------------------+------------------------------ |
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
