List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:September 22 2010 4:44pm
Subject:Re: document for mysql performance improvement
View as plain text  
Can you show us the output of: show status like '%innodb%'

JW


On Tue, Sep 21, 2010 at 10:11 PM, vokern <vokern@stripped> wrote:

> And this is the innodb file size, does this matter for performance?
>
> $ du -h ibdata*
> 11G     ibdata1
> 11G     ibdata2
> 11G     ibdata3
> 59G     ibdata4
>
>
>
> 2010/9/22 vokern <vokern@stripped>:
> > This is piece of the setting in my.cnf:
> >
> > set-variable = innodb_buffer_pool_size=4G
> > set-variable = innodb_additional_mem_pool_size=20M
> > set-variable = innodb_flush_log_at_trx_commit=2
> > set-variable =
> innodb_data_file_path=ibdata1:10G;ibdata2:10G;ibdata3:10G;ibdata4:10G:autoextend
> >
> > key_buffer              = 1024M
> > sort_buffer             = 1M
> > read_buffer             = 1M
> > max_allowed_packet      = 1M
> > thread_stack            = 192K
> > thread_cache_size       = 8
> > max_heap_table_size     = 64M
> > myisam-recover         = BACKUP
> > max_connections        = 800
> > query_cache_limit       = 1M
> > query_cache_size        = 16M
> >
> >
> > the disk:
> >
> > # fdisk -l
> >
> > Disk /dev/sda: 598.0 GB, 597998698496 bytes
> > 255 heads, 63 sectors/track, 72702 cylinders
> > Units = cylinders of 16065 * 512 = 8225280 bytes
> > Disk identifier: 0x0004158f
> >
> >
> >
> > from iostat -x:
> >
> > Device:         rrqm/s   wrqm/s     r/s     w/s   rsec/s   wsec/s
> > avgrq-sz avgqu-sz   await  svctm  %util
> > sda               0.79   309.57   31.06   50.98  1306.74  2860.71
> > 50.80     0.29    3.59   0.97   7.93
> > dm-0              0.00     0.00    0.56    0.42     4.49     3.40
> > 8.00     0.33  338.96   1.14   0.11
> >
> >
> > The db is still slow. Thanks for the future helps.
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 
-----------------------------
Johnny Withers
601.209.4985
johnny@stripped

Thread
document for mysql performance improvementvokern21 Sep
  • Re: document for mysql performance improvementJohan De Meersman21 Sep
  • Re: document for mysql performance improvementa.smith21 Sep
    • Re: document for mysql performance improvementvokern21 Sep
      • Re: document for mysql performance improvementa.smith21 Sep
        • Re: document for mysql performance improvementvokern21 Sep
          • Re: document for mysql performance improvementa.smith21 Sep
          • Re: document for mysql performance improvementGiles Coochey21 Sep
    • Re: document for mysql performance improvementBaron Schwartz22 Sep
  • RE: document for mysql performance improvementJangita21 Sep
    • Re: document for mysql performance improvementBruce Ferrell21 Sep
Re: document for mysql performance improvementvokern21 Sep
Re: document for mysql performance improvementvokern21 Sep
Re: document for mysql performance improvementa.smith21 Sep
  • Re: document for mysql performance improvementJohan De Meersman21 Sep
    • Re: document for mysql performance improvementJohan De Meersman21 Sep
      • Re: document for mysql performance improvementpetya21 Sep
        • Re: document for mysql performance improvementvokern22 Sep
          • Re: document for mysql performance improvementvokern22 Sep
            • Re: document for mysql performance improvementJohnny Withers22 Sep
              • Re: document for mysql performance improvementVokern23 Sep
                • Re: document for mysql performance improvementJohnny Withers23 Sep