I think you have some missing problems in database installment and DNS setting.
I sincerely hope you are doing well and safe from covid-19.
What can I support for my client?
? Excellent knowledge of Backend development
? Outstanding communication and interpersonal skills
? Exceptional creativity
? Being loyal, committed to the task and responsible for the outcome
Nice to meeting you
I built many web projects using php, jsp, ASP.net, VB.net ....
For the last 6 years, Developing more than 4 websites, I have met and solve many problems and enough experiences in database management.
The techniques I got about database optimization are following:
- Optimizing Queries with EXPLAIN. We can look execution plan of optimizer.
- MySQL Query Log. slow executed query is stored here.
- Optimizing Database Schema. Limiting the number of columns, Normalization
- Use Indexes
- MySQL Query Caching. provides database caching functionality.
- Converting OUTER JOINs to INNER JOINs
...
As you can see my profile, I have many experiences with website development.
Please, check this url: https://www.freelancer.com/u/artemanhel
So my experiences in this area will help you to get a good result in a short time.