Not the answer you need?
Register and ask your own question!

Too many deadlocks

Gayan YapaGayan Yapa EntrantInactive User Role Beginner
Hi, we are doing concurrent read and write at time to a table whche is having about100,000 records.
The cluster has 3 nodes percona cluster with Haproxy LB.
At a time concurrently about 20 request goes to the table ( read and write), So that the mySQL connection goes to about 600 and drive the entire system to slowness because of deadlocks.
Do you advice any parameter to change in the my.cfn file to solve this.

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.