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