List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:May 22 2012 11:25am
Subject:Re: Reducing ibdata1 file size
View as plain text  

Am 22.05.2012 13:19, schrieb Johan De Meersman:
> ----- Original Message -----
>> From: "Reindl Harald" <h.reindl@stripped>
>>
>> as multiple said the default of a single table space
>> is idiotic in my opinion, but however this is well
>> known over years
> 
> I suppose there's a certain logic to favouring one-shot allocation and never giving
> up free space, in that it reduces on-disk fragmentation.

well but for what price?
the problem is the DEFAULT

users with enough knowledge could easy change the default
currently what is happening is that mostly every beginner
is caught in the trap with single-table-space and hearing
from "innodb_file_per_table" after is is way too late

______________________

BTW:

>> From: "Pothanaboyina Trimurthy" <skd.trimurthy@stripped>
>>
>> hi sir,
>Please keep the list in CC, others may benefit from your questions, too

NO - do NOT set any CC
send lists to a mailing-list ONLY to the list-address

with this idiotic "list as cc" you are breaking "reply-to-list"
button for every user with a well working mail-client





Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
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