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]

Reply via email to