List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:June 30 2014 11:30am
Subject:Re: Optimizing InnoDB tables
View as plain text  
*please* don't use reply-all on mailing-lists
the list by definition distributes your message

Am 30.06.2014 13:14, schrieb Antonio Fernández Pérez:
> Thanks for your reply. Theorically the fragmented tables not offer the best
> performance to the InnoDB engine,
> that's correct or not?

practically it don't matter because the hot data should
anways be in innodb_buffer_pool and so in memory and
the fragmentation don't really matter as long it is
not extremely

you just can't have always unfragmented data because
that would mean the must be space reserved left and
right to fill growing data there

how much space will you reserve and how will the holes
impact performance if it comes to read data at startup

anyways: a state of "no single fragmentation" is not
possible and seeking for a solution because some tool
displays data without any emotion is "a fool with a
tool still is a fool"





Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
Optimizing InnoDB tablesAntonio Fernández Pérez24 Jun 2014
  • Re: Optimizing InnoDB tablesWagner Bianchi24 Jun 2014
    • Re: Optimizing InnoDB tablesAntonio Fernández Pérez24 Jun 2014
  • Re: Optimizing InnoDB tablesshawn l.green24 Jun 2014
    • Re: Optimizing InnoDB tablesReindl Harald24 Jun 2014
      • Re: Optimizing InnoDB tablesshawn l.green24 Jun 2014
        • Re: Optimizing InnoDB tablesAntonio Fernández Pérez25 Jun 2014
          • Re: Optimizing InnoDB tablesJohan De Meersman25 Jun 2014
          • Re: Optimizing InnoDB tablesAndre Matos25 Jun 2014
            • Re: Optimizing InnoDB tablesAntonio Fernández Pérez27 Jun 2014
              • Re: Optimizing InnoDB tablesReindl Harald27 Jun 2014
                • Re: Optimizing InnoDB tablesAntonio Fernández Pérez27 Jun 2014
                  • Re: Optimizing InnoDB tablesshawn l.green27 Jun 2014
                  • Re: Optimizing InnoDB tablesJohan De Meersman27 Jun 2014
                    • Re: Optimizing InnoDB tablesAntonio Fernández Pérez30 Jun 2014
                      • Re: Optimizing InnoDB tablesReindl Harald30 Jun 2014