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]
