> The table is MyISAM. I searched on google a bit for info on slow > updates with MyISAM and didn't really hit it on the nose. Can I ask > you to elaborate? >
In /etc/my.cnf try adding: long_query_time = 1 log-slow-queries=/var/lib/mysql/mysql-slow.log Restart and then watch the file. If a anything pop's up, do an EXPLAIN on the SQL statement and see what might be slowing it down. This helped me when I was debugging a join between two tables with a where clause between the two on a non-indexed field (with 100k rows in one, 30k rows in another). It wasn't too slow but I was able to turn the 5+ second response to around .2 seconds on one of our test servers. My dev environment that I'm testing my 50M row database on is a P4 HT workstation running under xen DomU (with 1gb of ram in the DomU). At first I thought all my sluggish responses were because of hardware but low and behold, it was just in need of some good indexes. With that said, don't go index crazy. If that fails and nothing else seems to help, add lots of ram and cpu's :). Hope that helps. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
