# Findings of NFR Run

1. Mysql query timeout to be honoured/configured in simple-proxy
2. Check the innodb buffer pool sizes according to https://jira.fkinternal.com/browse/IXPUGC-3516
Venkat Nirmal Gavarraju(Tech&IT-Mantri)12:14 AM
3. Exceptions with "No operations allowed after connection closed." -> We need to see if all the connections in the pool are closed ? It should have recreated the connections
Venkat Nirmal Gavarraju(Tech&IT-Mantri)12:21 AM
Don't touch this box 10.35.0.147

--------

Findings

1. Simple Proxy Mysql is not using query timeout.
2. RnR Box restarted on some load which caused RnR boxes to go OOR.
3. RnR boxes CPU went to 100%.
4. Check the mysql configuration and configure bucket. https://jira.fkinternal.com/browse/IXPUGC-3516
5. Exceptions with "No operations allowed after connection closed." -> We need to see if all the connections in the pool are closed ? It should have recreated the connections.
6. Move c16 box to slave or replace c8 with c16.

AI:

- [x] 1. Test Bulk User State in isolation by removing rate limit.
- [x] 2. Make Simple proxy changes
- [x] 3. Mysql cluster findings changes
- [x] 4. inno_db_buffer_pool_size
- [ ] 5. Move c16 box to slave or replace c8 with c16.
- [ ] 6. RnR Box restarted on some load which caused RnR boxes to go OOR. and CPU went to 100%.
- [ ] 7.Create one more c 16 box in mysql and destroy one c-8

elb-cli -z in-chennai-1 vip create http -a ugc-mysql-preprod -g preprod -s REGIONAL -n ugcPreProdMySql -b 3306

elb-cli -z in-chennai-1 vip list -a ugc-mysql-preprod