List:General Discussion« Previous MessageNext Message »
From:Jim McAtee Date:July 23 2003 9:35pm
Subject:Re: Is it necessary to compress tables?
View as plain text  
Since I received no responses, maybe someone can take a moment to explain why
this is such a stupid question.


----- Original Message ----- 
From: "Jim McAtee" <jmcatee@stripped>
To: <mysql@stripped>
Sent: Wednesday, July 23, 2003 1:28 PM
Subject: Is it necessary to compress tables?


> Does MySQL automatically handle deleted row cleanup, or is it necessary to
> periodically do this manually for tables with a lot of deletions?  If it's
> manual, what are the SQL commands to do this?
>
> Also, what happens when changes are made to a field definition?  From, say,
int
> to smallint, or tinyint to int, or varchar(255) to varchar(10)?  Do temporary
> tables get created and the data copied over, or does unused space end up in
the
> data files, to be collected later?

Thread
Is it necessary to compress tables?Jim McAtee23 Jul
  • Re: Is it necessary to compress tables?Jim McAtee23 Jul
    • Re: Is it necessary to compress tables?Dan Nelson23 Jul
    • Re[2]: Is it necessary to compress tables?Stefan Hinz24 Jul
    • Replication stopped without reasontrashMan24 Jul
      • Re: Replication stopped without reasonDominicus Donny24 Jul
        • R: Replication stopped without reasontrashMan24 Jul
          • Re: R: Replication stopped without reasonEgor Egorov25 Jul
            • R: R: Replication stopped without reasontrashMan25 Jul
  • Re: Is it necessary to compress tables?Jim McAtee24 Jul
Re: Replication stopped without reasonInfo26 Jul