Remote Network And System Administration Job In IT And Networking

MySQL Export Performance-issues with big table

Find more Network And System Administration remote jobs posted recently Worldwide

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
Naresh N/a
from Jarva, Estonia

Skills & Expertise Required

Database Design Database Architecture Database mysql 
Candidate shortlisted and hired
Hiring open till - Feb 6, 2023

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$26.85

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

Other jobs by this client

Graphic designer needed for various material for a martial arts gym in Barcelona - Fixed
Python: Improving an existing screw detector - Fixed
need andriod and good knowledge php developer - Fixed
Developer needed for creating Transportation app - Hourly
Customize the News App and admin Panel - Fixed
Videographer for public relations interview training - Fixed
Facebook page creation for t-shirt campaign - Fixed
SmartSheets Set up for lab data alerts and notifications - Hourly
Quick turn around beauty edits. - Fixed
Senior Open-cart Developer (Remote - Individuals only - No Agencies) Pay is not a problem. - Hourly

Similar Projects

DevOps - Kubernetes, Rancher, DigitalOcean

Hi, we need Kubernetes, Rancher on DigitalOcean DevOps Support.

we need to solve daily based tasks or/and adhoc error solving

More details in one to one call

i need some one that fit in my team on daily scrum meetings, <...read more

C# Developer Needed With Microsoft Office 365 OAuth Authentication Experience

We are looking for an Expert C# Developer with experience using Microsoft Office 365 OAuth Authentication.

Youll need this OAuth expertise to login to our Office 365 email accounts to process and send emails. I will share some documents fo...read more

CI/CD set up

We are looking a code intergrator and code deployer for our projects. Just to set up the work flow of our projects.

Php backend coder

Needs to really good PHP mainly.

Need to understand and code in PHP
We have multiple web-based applications using PHP.
Must know the server-side too. SQL, DATABASE, SERVER SETUP. API, ETC...
The more skills you have the more you...read more

Building an APP Testing Environment with VMware ThinApp & AWS

The deliverables for this project is the following:

1. Deploy a Windows Server 2016 using AWS
2. Install and Configure Windows Horizon Agent 7 (Server) using AWS
3. Install and Configure VMware ThinApp, and deploy individual applicat...read more