OPTIMIZE TABLE but... it will bring down your server if the table being optimize requires any sort of traffic. Depending on which mysql version your using OPTIMIZE TABLE will take longer since you can't allocate more memory as you can on the command line with myisamchk, unless you restart the server.
- Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -->-----Original Message----- -->From: Dan Greene [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, October 28, 2003 10:59 AM -->To: Dathan Vance Pattishall; Iago Sineiro; MySql Mail List -->Subject: RE: Howto reduce size of MYISAM files after deleting records? --> -->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]
