Hello,
I have configured XtraDB cluster in there nodes. All the there servers has same MySQL configurations, 32 GB RAM and CentOS 5.
The Server version is 5.5.29-23.7.1 (64 bit).
During the load test we are getting the Too Many Connection error. I have found that MySQL process list occupied with creating tmp table statements which leads to reaching the Thread connection threshold value 1000.
The creating tmp table issue occurs randomly in one server, other two servers are working as expected.
Please let me know increasing the tmp table size will fix this issue or any thoughts why this issue happens,
The Current my.cnf values,
Temp Tables
tmp-table-size = 256M
max-heap-table-size = 128M
Networking
max-connections = 1000