List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:October 24 2011 4:35pm
Subject:Re: large temp files created by mysql
View as plain text  

Am 24.10.2011 18:27, schrieb Joey L:
> -------- Performance Metrics -------------------------------------------------
> [--] Up for: 10s (2K q [237.300 qps], 591 conn, TX: 947K, RX: 261K)
> [!!] Key buffer size / total MyISAM indexes: 2.0G/12.0G
> [!!] Key buffer hit rate: 89.9% (5K cached / 524 reads)
>
> I just did some adjustments and used mysqltuner.pl ---any advice ??
> I have 22gigs of ram on the server - so if i need to allocate - i can

mysqltuner after 10 seconds is mostly useless

but "variables to adjust: key_buffer_size (> 12.0G)" is mandatory
since you do not benfit as mach as you can if your keys are permanently
loaded from disk


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
large temp files created by mysqlJoey L24 Oct
  • Re: large temp files created by mysqlJoey L24 Oct
    • Re: large temp files created by mysqlReindl Harald24 Oct
      • Re: large temp files created by mysqlmos24 Oct
        • Re: large temp files created by mysqlJoey L24 Oct
          • Re: large temp files created by mysqlReindl Harald24 Oct
        • Re: large temp files created by mysqlReindl Harald24 Oct
          • Re: large temp files created by mysqlmos24 Oct
            • Re: large temp files created by mysqlReindl Harald25 Oct
              • Re: large temp files created by mysqlmos25 Oct
                • Re: large temp files created by mysqlReindl Harald25 Oct
                  • Re: large temp files created by mysqlmos26 Oct
                    • Re: large temp files created by mysqlReindl Harald26 Oct
Re: large temp files created by mysqlAntony T Curtis24 Oct
  • Re: large temp files created by mysqlJoey L24 Oct
    • Re: large temp files created by mysqlJohan De Meersman24 Oct
Re: large temp files created by mysqlJan Steinman31 Oct
  • Re: large temp files created by mysqlJan Steinman31 Oct
    • Re: large temp files created by mysqlLuis Daniel Lucio Quiroz24 May
      • RE: large temp files created by mysqlRick James24 May
        • RE: large temp files created by mysqlLuis Daniel Lucio Quiroz24 May