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.
>
