mike0 MYI is the index's MYD is the data
Can't think why it would suddenly grow in size. Try the CHECK TABLE command to get more detail. David > -----Original Message----- > From: //mikezero/ [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 08, 2002 12:37 PM > To: [EMAIL PROTECTED] > Subject: actual database filesizes > > > can anyone think of a reason that the .MYD and .MYI files would > overnight grow to sizes over 5 gigs. and which file holds what data? > any help would be greatly appreciated. i included a copy of > the text > returned from ls. > > 12 -rw-rw---- 1 mysql mysql 8662 Sep 21 2001 > track_log.frm > 5940028 -rw-rw---- 1 mysql mysql 6076641280 May 4 08:02 > track_log.MYD > 5725520 -rw-rw---- 1 mysql mysql 5857197056 May 5 04:02 > track_log.MYI > > //mikezero/ > //radiotakeover > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php