Can you post the output of SHOW FULL PROCESSLIST during the time when
both sets of queries are running?
Also what storage engine are you using for your tables?
Chris Kantarjiev wrote:
We're having some serious problems with concurrent queries.
This is a dual-processor amd64 machine with 16GB RAM, running NetBSD
and MySQL 4.0.25. key_buffer_size is 3GB.
When I have a long running query going, otherwise short queries take
a very very long time to execute. For example, I have
insert ignore into trimble.old_crumb select * from trimble.crumba_rolled
which is appending a lot of 'live' data to an 'archive' table.
Meanwhile, I'm trying to execute
INSERT IGNORE INTO link_area
(link_ID, dir_Travel, area_ID)
VALUES
(20202178, 'F', 21014195);
This latter query is taking between 6 and 45 *seconds* to run. Yow!
mysql> explain link_area;
+------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------+------+-----+---------+-------+
| link_ID | bigint(20) | | PRI | 0 | |
| dir_Travel | char(1) | | PRI | | |
| area_ID | int(11) | | MUL | 0 | |
+------------+------------+------+-----+---------+-------+
help?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
