Thanks. Whith InnoDB tables I have to do something similar or it's not necessary?
Iago. -----Mensaje original----- De: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] Enviado el: martes, 28 de octubre de 2003 19:49 Para: 'Iago Sineiro'; 'MySql Mail List' Asunto: 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] ---Publicidad-------------------------------------------------------- Únete a los miles de sin pareja en Meetic... ˇte vas a enamorar! http://www.iespana.es/_reloc/email.meetic -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
