List:General Discussion« Previous MessageNext Message »
From:Jim McAtee Date:July 23 2003 7:28pm
Subject:Is it necessary to compress tables?
View as plain text  
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?

Thanks.


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