In reference to my earlier message, I think I've figured out that the equivalent command for OPTIMIZE TABLE is: myisamchk -r --sort-index --analyze
That isn't documented anywhere... and in fact, the French language version says something conflicting (I don't speak French but a Google search brought me there). Here's my problem: I've got a bunch of tables with hundreds of millions of rows in them. Every night, I delete about couple million rows and then run millions of searches on these tables. What should I worry about more? A sorted index or a data file with no deleted rows in it? I don't mind running either OPTIMIZE TABLE (which apparently rebuilds everything and sorts it) or just the myisamchk to sort the index. Does anyone know which one might get me more mileage? Thanks! Mark > -----Original Message----- > From: Mark Hazen [mailto:[EMAIL PROTECTED] > Sent: Sunday, February 08, 2004 11:46 AM > To: [EMAIL PROTECTED] > Subject: myisamchk vs OPTIMIZE TABLE > > > Hi all! > > Running 4.0.17. > > I hope this isn't a stupid question, but it appears that OPTIMIZE TABLE is > NOT equivalent to: > myisamchk --quick --check-only-changed --sort-index --analyze > > Maybe I'm missing something, but OPTIMIZE TABLE rebuilds both the > data file > and the index file (I see a TMD and TMM file being built). myisamchk only > appears to rebuild the TMM file. Why is this? How do you get the > equivalent OPTIMIZE TABLE in myisamchk? > > Thanks > Mark > > > -- > 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]
