Is your job OLTP?
- Yes hv to process transaction on production db
Do you really need hundreds of simultaneous connections?
- Yes i need multiple simultaneous connection to speed up processing.
- mostly 30-40 lacs inserts per day done through master-slave replication so on replication level i want parallel processing also.
Are you using InnoDB?
- Yes using Innodb and testing on mysql-5.6.15 enterprise version.
-- As per mysql document(http://dev.mysql.com/doc/refman/5.6/en/thread-pool-installation.html) i check thread_pool.so file is there and add it in my.cnf
[mysqld]
plugin-load = thread_pool.so
-- i am using following tool to check performance
sysbench --db-driver=mysql --num-threads=[16 to 64] --max-requests=100000 --test=oltp --oltp-table-size=1000000 --oltp-test-mode=complex --mysql-user=root --mysql-password=[PASSWORD] run
I am interested for mysql commercial product and its supports but first i need to confirm wheater i will get as good performance as they shown in following link.
How they measure such performance so i can check from my side.
http://www.mysql.com/products/enterprise/scalability.html
Thanks