Are the the FK on your largest columns? So if you have a char(255) and it's index - for each row added you will have added an additional 255 bytes added to your index as well as your data file.
If you want to optimize a table use OPTIMIZE TABLE or myisamchk -r -S -a // when the server is off DVP ---- Dathan Vance Pattishall http://www.friendster.com > -----Original Message----- > From: Paul Beer [mailto:[EMAIL PROTECTED] > Sent: Monday, May 23, 2005 1:57 PM > To: mysql@lists.mysql.com > Subject: MYISAM MYI > > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
