>
> Can you post the output of SHOW FULL PROCESSLIST during the time when
> both sets of queries are running?
mysql> show full processlist;
+-----+------+--------------------------+-----------+---------+------+--------------+----------------------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State
| Info
|
+-----+------+--------------------------+-----------+---------+------+--------------+----------------------------------------------------------------------------------------------------------------------+
| 201 | len | dick.landsonar.com:15405 | landsonar | Query | 4033 | Sending
data | insert ignore into trimble.old_crumb select * from trimble.crumba_rolled
|
| 209 | len | dick.landsonar.com:34684 | landsonar | Query | 2 | update
| INSERT IGNORE INTO link_area
(link_ID, dir_Travel, area_ID)
VALUES
(20202282, 'T', 21014142) |
| 216 | len | localhost | NULL | Query | 0 | NULL
| show full processlist
|
+-----+------+--------------------------+-----------+---------+------+--------------+----------------------------------------------------------------------------------------------------------------------+
> Also what storage engine are you using for your tables?
MyISAM. We found InnoDb to be considerably slower for selects for our data,
though it's been a year since I did that experiment.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
