Find more Network And System Administration Remote Jobs posted recently Worldwide

Required Database Design,Database Architecture,Database,mysql freelancer for MySQL Export Performance-issues with big table job

Posted at - Mar 5, 2023


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

Skills & Expertise Required

Database Design Database Architecture Database mysql 

Candidate shortlisted and hiredHiring open till - Sep 1, 2023

Work from Anywhere
40 hrs / week
Hourly Type
Remote Job
$26.87
Cost

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


Apply on more work from home jobs posted in Network And System Administration category.


Related Jobs


Latest In Database Design Jobs


Latest In Database Architecture Jobs


Latest In Database Jobs


Latest In mysql Jobs