Remote Network And System Administration Job In IT And Networking

mysl-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 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

Skills & Expertise Required

Database Design Database Architecture Database mysql

Open for hiringApply before - Sep 20, 2024

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$26.84

Cost

Offer to work on this project closes in 78 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

Other jobs by this client

Video Editor needed for American Football highlight recap - Fixed
Using UTF-8 with PHP on Vertica database - Fixed
Convert a QlikView file to QlikSense - Fixed
Ecommerce Development - Fixed
Cobol specialist - Hourly
C# Developer with Devexpress Winforms Experience - Hourly
Scraper Something - Hourly
Fortimail Setup in Azure - Hourly
Find & list stock prices for Google on Thursday & Friday at NOON in a spreadsheet - Hourly
Russian to English translation of financial presentation. - Hourly
Salesforce Tree Grid Component - Hourly

Similar Projects

php based application

Looking to hire someone to build a custom web based application that will do the following:

-Formatted into template
-Print ready from said template
-Re-Editable fields, easly clearable

So this is what is trying to be accomp...read more

Need APIs (Restful) for Ride Sharing App

Only looking to develop API for my ride sharing app idea that will work closely with my app developer to develop APIs based on our requirements. .

The API should have great response time and ability to handle future growth. The API i need i...read more

Quality Database

Looking for a C# programmer to create a new database for our manufacturing company that wikk utilize quite a few forms, tables, and foldout-end interaction with the shop floor people. This is a longer-term project that will require Skype meetings nor...read more

Developer required for a location based application with few banking features.

A mobile application developer for android who can design and develop the application. It is a location based application which should be able to verify bank account and PAN card.

Need mentoring for SQL Database Servers, and WordPress web development.

I am working to adapt an existing SQL server and Wordpress page to work for a similar application. I would like to learn the basics of working with the server and webpage to eliminate problems with simple solutions.

I am a recent college gra...read more