List:General Discussion« Previous MessageNext Message »
From:vokern Date:September 22 2010 3:11am
Subject:Re: document for mysql performance improvement
View as plain text  
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.
>
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