Hi,
I'm doing some mass INSERTs (CSV-Files) INTO MySQL
5.0.22 on a Windows 2003 Server using prepared statements and PHP's
MySQLi extension. Before inserting I ALTER TABLE DISABLE KEYS
and afterward ENABLE KEYS. My indexes file grows huge.
When I drop the index over a DATETIME field and then add the very same
index the MYI files grows to an absolutely acceptable size.
What is MySQL doing? Indexing columns that are already indexed by that
time?
ANALYZE TABLE does not state there is an issue but the MYI file is
after recreating the index much smaller than it was after the large
number of INSERTs and previously disabling the keys.
Best,
Bernhard
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
