mysl-Export. Performance-issues with big table

We are looking for a very experienced mysql-database export.

We are currently experiencing issues with a big table in mysql (21GB).
Inserts of 100 records vary between milli-seconds but also go up to 30 seconds
records to this database are written and deleted very frequently (multiple thousands during data imports) and when users are active in a specific segment in our tool, records are added and deleted instantly with every action.

the issue we are having is when imports are running and at the same time there is a lot of activity in the tool. the time for the queries is going up wich results into timeouts in our tool.

More information:
- Table-size: 21GB
- columns have indexes
- memory is 64GB (RDS: R5.2xlarge)
- innodb_buffer_pool_size is set to: DBInstanceClassMemory*3/4

Looking forward to hearing from you
About the recuiter
Member since Sep 14, 2017
Lance Hirahon
from Jalisco, Mexico

---

---

Offer to work on this project closes in 130 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions