A problem I Encountered and Solved

A month ago I was working on data using MysQL so it was performing poorly especially trying to query the data. So these were the steps I took to solve the problem
1. I analyzed the data but saw that everything was alright

2. I used Index Profiler to look deep into the data I then realized there was deadlock and execution issues

SOLUTION
I then realized the main problem was from the indexing then
1. I updated the index
2. I set regular monitoring to ensure optimal performance

 

About myself, and MY Expectations from HNG Internship
I am a software developer with a keen interest in Backend. I ventured into tech a year ago. I hope to hands-on experience and industry standard from HNG

 

Comments

Post a Comment