Config:
Running on 8G Server.. Currently utilizing 7G.. running only mysql..
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer_size = 384M
max_allowed_packet = 1M
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
thread_concurrency = 8
max_connections = 802
wait_timeout = 15
log-bin=mysql-bin
server-id = 1
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
innodb_buffer_pool_size = 384M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 100M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
On Thu, May 5, 2011 at 2:46 PM, Reindl Harald <h.reindl@stripped>wrote:
> please post your my.cnf settings becuase stats are useless without
> knowing the configuration and without knowing your hardware (memory!)
> nobody can say what buffers are making sense
>
> i would use "mysqltuner.pl" because it shows in the most cases good
> advises
>
> Am 05.05.2011 20:42, schrieb J M:
> > Hi,
> >
> > I have this stats: I have tuned some of it but I was wondering if
> someone
> > can give inputs regarding it:
> >
> > *
> > __ Key _________________________________________________________________
> > Buffer used 54.63M of 384.00M %Used: 14.23
> > Current 123.21M %Usage: 32.09
> > Write hit 99.97%
> > Read hit 100.00%
> >
> > __ Questions ___________________________________________________________
> > Total 87.40M 18.4/s
> > QC Hits 50.63M 10.7/s %Total: 57.93
> > DMS 24.04M 5.1/s 27.50
> > Com_ 8.52M 1.8/s 9.75
> > COM_QUIT 4.24M 0.9/s 4.85
> > -Unknown 28.31k 0.0/s 0.03
> > Slow 10 s 9.21k 0.0/s 0.01 %DMS: 0.04 Log: OFF
> > DMS 24.04M 5.1/s 27.50
> > SELECT 21.98M 4.6/s 25.14 91.41
> > UPDATE 1.74M 0.4/s 1.99 7.24
> > INSERT 211.35k 0.0/s 0.24 0.88
> > DELETE 111.77k 0.0/s 0.13 0.46
> > REPLACE 0 0/s 0.00 0.00
> > Com_ 8.52M 1.8/s 9.75
> > set_option 4.26M 0.9/s 4.87
> > change_db 4.22M 0.9/s 4.83
> > show_table_ 9.33k 0.0/s 0.01
> >
> > __ SELECT and Sort _____________________________________________________
> > Scan 838.37k 0.2/s %SELECT: 3.81
> > Range 2.12M 0.4/s 9.64
> > Full join 988 0.0/s 0.00
> > Range check 0 0/s 0.00
> > Full rng join 0 0/s 0.00
> > Sort scan 3.71M 0.8/s
> > Sort range 3.63M 0.8/s
> > Sort mrg pass 82.85k 0.0/s
> >
> > __ Query Cache _________________________________________________________
> > Memory usage 3.75M of 32.00M %Used: 11.72
> > Block Fragmnt 28.39%
> > Hits 50.63M 10.7/s
> > Inserts 16.38M 3.4/s
> > Insrt:Prune 14.39:1 3.2/s
> > Hit:Insert 3.09:1
> >
> > __ Table Locks _________________________________________________________
> > Waited 53.43k 0.0/s %Total: 0.17
> > Immediate 31.57M 6.6/s
> >
> > __ Tables ______________________________________________________________
> > Open 512 of 512 %Cache: 100.00
> > Opened 3.02k 0.0/s
> >
> > __ Connections _________________________________________________________
> > Max used 145 of 802 %Max: 18.08
> > Total 4.24M 0.9/s
> >
> > __ Created Temp ________________________________________________________
> > Disk table 3.61M 0.8/s
> > Table 3.72M 0.8/s Size: 16.0M
> > File 165.71k 0.0/s
> >
> > __ Threads _____________________________________________________________
> > Running 69 of 71
> > Cached 0 of 8 %Hit: 99.02
> > Created 41.74k 0.0/s
> > Slow 0 0/s
> >
> > __ Aborted _____________________________________________________________
> > Clients 6.48k 0.0/s
> > Connects 25.00k 0.0/s
> >
> > __ Bytes _______________________________________________________________
> > Sent 1.18T 247.9k/s
> > Received 15.27G 3.2k/s*
> >
>
> --
>
> Mit besten Grüßen, Reindl Harald
> the lounge interactive design GmbH
> A-1060 Vienna, Hofmühlgasse 17
> CTO / software-development / cms-solutions
> p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
> icq: 154546673, http://www.thelounge.net/
>
> http://www.thelounge.net/signature.asc.what.htm
>
>
