I am hosting gibbon on the AWS t2.medium instance (bacillary on t2.micro increase size due to performance issue)
- There are a total of 2 std and 104-110 students in the system.
- other read-only pages have good performance but when I follow the following test case the there is a performance issue.
- I am adding multiple students via the application form
- I am accepting the application form
Home > Students >Manage Applications
the first form is accepted quickly but when i click on next form the response time is increasing it goes to 20 to 30 seconds . and that same time i can not access read-only pages also . it looks like the issue is in MySQL connection thread . in our application we are opening only one connection and it is waiting for closing
Mysql> show processlist;
±----±-----±----------±-----±--------±-----±---------±-----------------+
| Id | User | Host | db | Command | Time | State | Info |
±----±-----±----------±-----±--------±-----±---------±-----------------+
| 21 | root | localhost | NULL | Query | 0 | starting | show processlist |
| 301 | star | localhost | star | Sleep | 40 | | NULL |
±----±-----±----------±-----±--------±-----±---------±-----------------+
please check some following links
https://stackoverflow.com/questions/19822558/how-to-set-max-connections-in-mysql-programmatically
https://stackoverflow.com/questions/12194241/show-processlist-in-mysql-command-sleep
can you please suggest me how to increase performance? any suggestions for MYSQL tuning
regards
Pavan PAwar