riendFinder 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.
On 28 Oct 2003 at 13:59, Dan Greene wrote:
> Is there a way to do this on a live running (i.e. production) server?
http://www.mysql.com/doc/en/OPTIMIZE_TABLE.html
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list
go 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]
--&
than 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: My
-->-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
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.
--
