Can you show us the output of: show status like '%innodb%' JW
On Tue, Sep 21, 2010 at 10:11 PM, vokern <vok...@gmail.com> 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 <vok...@gmail.com>: > > 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=joh...@pixelated.net > > -- ----------------------------- Johnny Withers 601.209.4985 joh...@pixelated.net