You are here

MySQL performance tuning

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

kalasha,
Could you explain more what exactly do you need to achieve?

abdel-mawlacomment

i need to calculate memory requirement for below Expected Transaction expected TPS is - 203.4259259 business transaction per day - 846000 business transaction per hour- 141000 business transaction per second - 29 .Current average queries per second in server is 103 AND ALSO I WOULD LIKE TO KNOW HOW TO CALCULATE MEMMORY FOR PRODUCTION ENVIRONMENT
kalashacomment

Kalasha, please have a look at the Service section of our Web page. We would be more than happy to help you with your requirements. The Remote-DBA service (http://www.fromdual.com/remote-dba) is a very inexpensive and valuable service. If you want a quote please contact us at inside@fromdual.com Kind regards Inside Sales
harrycomment