I have a MYISAM table that has both the MYD and MYI files growing at similar rates. We have this same database installed in other locations and the MYI file stays static but the MYD grows. From the docs I can see that the MYI file contains the index information. There are three foreign keys in the table, but I can't see why this MYI file should ever grow in size. I have already run "myisamchk.exe -r" on the table and it said it fixed the index, but then started growing again. Has anyone experienced anything like this? Anyone have any thoughts? I'm using MYSQL Version 4.1.8;
Thx, Paul -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
