List:General Discussion« Previous MessageNext Message »
From:Jan Steinman Date:May 22 2012 4:23pm
Subject:Re: Reducing ibdata1 file size
View as plain text  
Okay, my mistake. I should write precisely when communicating with precise people. :-)

What I meant was, dumping and importing is the "common knowledge" way of "virtually"
shrinking innodb files.

So, now that I've conceded the meta-argument, what do you think of the linked procedure
for reducing innodb files?

On 22 May 12, at 06:40, Claudio Nanni wrote:

> Jan,
> 
> that's not common wisdom, Innodb datafiles ***never*** shrink,
> that in the blog from 22th of May is a workaround, one of the many.
> If you ask my my favourite is to use a stand by instance and work on that.
> 
> Claudio
> 
> 2012/5/22 Jan Steinman <Jan@stripped>
> > From: Claudio Nanni <claudio.nanni@stripped>
> >
> > No, as already explained, it is not possible, Innodb datafiles *never* shrink.
> 
> That's been the common wisdom for a long time.
> 
> However, this just popped up on my RSS reader. I haven't even looked at it, let alone
> tried it.
> 
> I'm interested in what the experts think...
> 
> "Getting rid of huge ibdata file, no dump required: You have been told (guilty as
> charged), that the only way to get rid of the huge InnoDB tablespace file (commonly named
> ibdata1), when moving to innodb_file_per_table, is to do a logical dump of your data,
> completely erase everything, then import the dump."
>       
> http://code.openark.org/blog/mysql/getting-rid-of-huge-ibdata-file-no-dump-required
> 
> ----------------
> Four multinational companies control over seventy percent of fluid milk sales in the
> U.S... These giants have grown through debt-fueld acquisitions and mergers and by keeping
> payments to dairy farmers as low as possible. -- Ron Schmid
> :::: Jan Steinman, EcoReality Co-op ::::
> 
> 
> 
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
> 
> 
> 
> 
> -- 
> Claudio

----------------
No man is so foolish but he may sometimes give another good counsel, and no man so wise
that he may not easily err if he takes no other counsel than his own. He that is taught
only by himself has a fool for a master. -- Ben Johnson
:::: Jan Steinman, EcoReality Co-op ::::




Thread
Reducing ibdata1 file sizeManivannan S .21 May
  • Re: Reducing ibdata1 file sizeClaudio Nanni21 May
  • Re: Reducing ibdata1 file sizeJohan De Meersman21 May
    • Re: Reducing ibdata1 file sizeKishore Vaishnav22 May
      • Re: Reducing ibdata1 file sizeClaudio Nanni22 May
        • Re: Reducing ibdata1 file sizeKishore Vaishnav22 May
          • Re: Reducing ibdata1 file sizeAnanda Kumar22 May
            • Re: Reducing ibdata1 file sizeKishore Vaishnav22 May
              • Re: Reducing ibdata1 file sizeReindl Harald22 May
                • Re: Reducing ibdata1 file sizeKishore Vaishnav22 May
                  • Re: Reducing ibdata1 file sizeAnanda Kumar22 May
                  • Re: Reducing ibdata1 file sizeReindl Harald22 May
                    • Re: Reducing ibdata1 file sizeJohan De Meersman22 May
                      • Re: Reducing ibdata1 file sizeReindl Harald22 May
                        • Re: Reducing ibdata1 file sizeJohan De Meersman22 May
                          • Re: Reducing ibdata1 file sizeReindl Harald22 May
                            • Re: Reducing ibdata1 file sizeJohan De Meersman22 May
                              • Re: Reducing ibdata1 file sizeReindl Harald22 May
                      • Re: Reducing ibdata1 file sizeBaron Schwartz22 May
              • Re: Reducing ibdata1 file sizeAnanda Kumar22 May
          • Re: Reducing ibdata1 file sizeClaudio Nanni22 May
  • RE: Reducing ibdata1 file sizeRick James22 May
Re: Reducing ibdata1 file sizeJohan De Meersman22 May
  • Re: Reducing ibdata1 file sizeAnanda Kumar22 May
    • Re: Reducing ibdata1 file sizeJohan De Meersman22 May
      • Re: Reducing ibdata1 file sizeAnanda Kumar22 May
        • Re: Reducing ibdata1 file sizeJohan De Meersman22 May
          • Re: Reducing ibdata1 file sizeReindl Harald22 May
            • Re: Reducing ibdata1 file sizeJohan De Meersman22 May
              • Re: Reducing ibdata1 file sizeAnanda Kumar22 May
                • Re: Reducing ibdata1 file sizeAnanda Kumar22 May
Re: Reducing ibdata1 file sizeJan Steinman22 May
  • Re: Reducing ibdata1 file sizeJohan De Meersman22 May
  • Re: Reducing ibdata1 file sizeClaudio Nanni22 May
    • RE: Reducing ibdata1 file sizeKay [DAS] Rozeboom22 May
    • Re: Reducing ibdata1 file sizeJan Steinman22 May