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 Nov 11, 2022
Ratna Pratiwi
from Yonne, France

Skills & Expertise Required

Database Design Database Architecture Database mysql

Open for hiringApply before - Aug 21, 2024

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$26.80

Cost

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

Real Estate Development Plan Creation - Hourly
Product design for fun pet product! - Hourly
Research programmer for new computer language and Bible Parser - Hourly
Instagram Page manger - Fixed
AWS security advice - Hourly
Logo design - Fixed
Data Engineer Job Specification - Hourly
Java Expert - Hourly
Innovative Logo for software development company - Hourly

Similar Projects

Dev Ops/Load Balancer

Looking for an EXPERT with experience with Nginx, Django rq, Python Django, gunicorn, celery, amzon web services. Python Django experience would definitely help.

Need SQL and PHP Programmer I need a database management tool built so I can query data fields

looking to build a database management system in SQL. Will need to be able to query by data points we designate, as well as sort and match.

PHP Developer Required

I started my new business venture website; however, my developer had an opportunity to move to a new country so I need someone to continue with this ongoing engagement.
Lets discuss the vision and overall plan, then we can build milestones per p...read more

PostGIS/Python/django small project Tutor

I have a small mapping project that I would I am able to get working locally but cannot get the PostgreSQL database deployed. I have all the code working but no luck with database . I think this should not take very long

AzureDB DBA Expert

We have recently migrated our infrastructure from MSSQL to AzSQL and we need someone to tune, monitor and help us take advantage of the Azure platform.

Pretty simple requirement. We have worked with a previous DBA on MSSQL and we need to ma...read more