October 2013

How to change the Max connection in MySQL

To change the mysql max connections

open my.cnf and change max_connections to the required number of connections.

For example: To set maximum 300 connections

max_connections = 300

If you don't know where the my.cnf exists in Linux/Unix box, use find command.

find / -name my.cnf

How to change the number of concurrency threads in MySQL

To change the number of concurrency threads in MySQL

Open my.cnf and set the innodb_thread_concurrency.

innodb_thread_concurrency = 20

it allow 20 concurrent threads.

To set this to unlimited
innodb_thread_concurrency = 0