Mac OS X / MySQL 4.1.14 compiled slowness issue

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]

Reply via email to