Re: Mac OS X / MySQL 4.1.14 compiled slowness issue

2005-10-07 Thread Gleb Paharenko
Hello. Rolling back a transaction might take a long time. It depends on the size of log files. See: http://dev.mysql.com/doc/mysql/en/innodb-tuning.html James C Knotts wrote: > We are having slowness issues with MySQL on Mac OS X 10.4. Here is what > has been done... > > 1) Tiger's

Mac OS X / MySQL 4.1.14 compiled slowness issue

2005-10-06 Thread James C Knotts
We are having slowness issues with MySQL on Mac OS X 10.4.  Here is what has been done...1) Tiger's native version of mysql was installed.2) A delete was attempted on 1.5 million records    Note: These records are heavily referenced to other tables3) 8+ hours later the delete was cancelled and it t