Skip navigation links

MySQL Forums :: Performance :: Tunning MySQL 5.1.X


Advanced Search

Tunning MySQL 5.1.X
Posted by: Michael Cahill ()
Date: October 04, 2012 08:39AM

I have an application that is leveraging MySQL 5.1.x as the back end. I have the ability to tune the my.cf. I am hoping I can tune the DB ability to leverage the server resources, and then try to work with the DB design team to alter it for additional performance.

Current performance: Database running on high performance SAN, and seeing almost no disk I/O's except temp tables, due the large amount of RAM. However, I am only seeing the database use 18GB of RAM, and want to drive more queries and requests into RAM if possible.

Any recommendations would be greatly appreciated.

Server: Windows 2008 R2
- 32 Cores / 500GB of RAM
---------------------------
my.cf
----------------------------

[mysqld]
basedir=X:\\mysql
tmpdir=X:\\mysql\\data\\tmp

innodb_data_home_dir=innodb
innodb_max_purge_lag=100000
query_cache_type=1
query_cache_size=4096M
query_cache_limit=1024M
wait_timeout=1800
interactive_timeout=1800

innodb_buffer_pool_size=16384M
innodb_additional_mem_pool_size=100M

innodb_thread_concurrency=0
innodb_flush_log_at_trx_commit=2
innodb_file_io_threads=10
innodb_lock_wait_timeout=50
max_allowed_packet=32M
innodb_log_group_home_dir=logs
innodb_log_files_in_group=3

innodb_log_file_size=256M
#innodb_log_file_size=512M

innodb_log_buffer_size=8M
transaction-isolation=READ-COMMITTED
default-table-type=InnoDB

thread_cache_size=30
join_buffer_size=1024M
read_buffer_size=128M
read_rnd_buffer_size=128M
sort_buffer_size=256M

table_open_cache=15000

tmp_table_size=1024M
max_heap_table_size=1024M

key_buffer_size=1024M

myisam_sort_buffer_size=5M

innodb_file_per_table
port=3306

max_connections=300

Options: ReplyQuote


Subject Views Written By Posted
Tunning MySQL 5.1.X 1183 Michael Cahill 10/04/2012 08:39AM
Re: Tunning MySQL 5.1.X 503 Rick James 10/05/2012 11:39AM
Re: Tunning MySQL 5.1.X 455 Michael Cahill 10/06/2012 05:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.