MySQL 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 which 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 Mar 14, 2020
Samir Singh
from Limerick, Ireland

---

---

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