You are here
MySQL performance tuning
Thu, 2014-03-13 12:52 — kalasha
Dear Sir,
Please help me to finalize the memory requirement by calculating below details
Server Configuration
***********************
Processor - Quad-Core AMD Opteron(tm) Processor
Memory - 16GB
HDD - for mysql data - 500 GB
Expected Transaction
********************
expected TPS is - 203.4259259
business transaction per day - 846000
business transaction per hour- 141000
business transaction per second - 29
Current queries per second in server is 103
Please find my below cnf file
*****************************
#skip-locking
skip-name-resolve
table_cache=2048
thread_cache_size=50
back_log=100
max_connect_errors=10000
open-files-limit=20000
interactive_timeout=3600
wait_timeout=600
connect_timeout=10
max_connections=1000
max_allowed_packet=512M
tmp_table_size=32M
max_heap_table_size=32M
binlog_format=mixed
query_cache_size=32M
query_cache_type=1
# Per-Thread Buffers
# ------------------
sort_buffer_size=8M
read_buffer_size=8M
read_rnd_buffer_size=8M
join_buffer_size=8M
innodb_log_file_size=512M
innodb_log_buffer_size=16M
innodb_additional_mem_pool_size =32M
innodb_buffer_pool_size=4G
innodb_doublewrite=OFF
thread_concurrency=8
innodb_flush_log_at_trx_commit=1
innodb_flush_method=O_DIRECT
open-files-limit=65535
key_buffer_size=64M
myisam_sort_buffer_size=16M
What are the requirements?!
kalasha,
Could you explain more what exactly do you need to achieve?
Performance tuning
The Remote-DBA offering would help you solving your requirements