Is there a way to do this on a live running (i.e. production) server? > -----Original Message----- > From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 28, 2003 1:49 PM > To: 'Iago Sineiro'; 'MySql Mail List' > Subject: RE: Howto reduce size of MYISAM files after deleting records? > > > Shutdown the mysql server > Goto the datadir (/var/lib/mysql) > > Goto the db directory > Type > myisamchk -r -S -a *.MYI this will reclaim the bad blocks > caused by the > delete. > > > > - Dathan Vance Pattishall > - Sr. Programmer and mySQL DBA for FriendFinder Inc. > - http://friendfinder.com/go/p40688 > > > -->-----Original Message----- > -->From: Iago Sineiro [mailto:[EMAIL PROTECTED] > -->Sent: Tuesday, October 28, 2003 9:52 AM > -->To: MySql Mail List > -->Subject: Howto reduce size of MYISAM files after deleting records? > --> > -->Hi. > --> > -->I delete a lot of records of one MyISAM table in MySQL > 4.0.16. After > that > -->I > -->execute mysqladmin refresh and now the size of the files > of the table > is > -->the > -->same than before. > --> > -->Is something wrong or is necessary doing something more to > reduce the > -->size > -->of the files? > --> > -->Thanks in advance. > --> > -->Iago. > --> > --> > --> > -->-- > -->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] > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
