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 native version of mysql was installed. > 2) A delete was attempted on 1.5 million records > Note: These records are heavily referenced to other tables > 3) 8+ hours later the delete was cancelled and it took 8+ hours to > recover > 4) Same delete was done on a Sempron 2600+ XP with only 512M RAM. Took > 26 minutes. > 5) Version 4.1.14 of mysql was downloaded and isntalled by you via > package manager. Same delete, same result (waited 10 hours this time > though). > 6) Version 4.0.26 was downloaded and compiled from source AFTER a full > reinstall of the OS (reinstall was for reasons not related to the DB > problem) > 7) Same delete, same result. > > Please help as we have no idea what's going on. > > Regards... > > ** > > *Jim C. Knotts | Lead Systems Architect* > > ** > > *JCK & Associates* > > e. [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > w. http://www.jckassoc.com > > aim: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > Professional Profile <https://www.linkedin.com/e/fps/355971/> > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
