Hi all , I got following error on mysql 5.7 (error reading communication packets)2015-07-25T22:25:36.782743Z 3314 [Note] Aborted connection 3314 to db: ‘royzez’ user: ‘root’ host: ‘localhost’ (Got an ) , can any one please suggest what are the main variables should be change for heavy load myql database , i have 32 GB ram and 8 core dedicated CPU, and more than 10000 concurrent users in 10 sec, Please suggest what do i change to achive this much of concurrency , all tables are innodb.
Hi susantomahato88;
I would recommend starting with the Percona Configuration Wizard as a base configuration and then building off of that:
[url]MySQL Tools and Management Software to Perform System Tasks by Percona
-Scott