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.rei...@thelounge.net>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 > >
