Disable Keys/Enable Keys
Running MySQL 4.1.2 MyISAM tables.....
I have a script that inserts 50,000 records daily into a table that has 6 million records currently in it and growing. I was looking for a way to speed up the insert, and I stumbled apon the 'disable keys' and 'enable keys' commands. The disabling of the keys and the insert runs extremly fast. However, the enabling of the keys takes quite a bit of time to complete, like 5 minutes.
What do you think maybe causing this? Could this possibly be a key caching issue?
Any help is appreciated.
Edited 1 time(s). Last edit at 02/08/2006 10:33AM by Nicollette Marquez.
Subject
Views
Written By
Posted
Disable Keys/Enable Keys
26390
February 08, 2006 10:30AM
15421
February 08, 2006 07:28PM
10155
February 09, 2006 03:30AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.