Need Experienced Help with MySQL Database Optimization for MPOS Cryptocurrency Mining Pool

$10-80 USD

Completed

Posted

almost 6 years ago

$10-80 USD

Paid on delivery

NOTE: Please read the entire description before bidding. We have been running a test server for an MPOS Cryptocurrency Mining Pool for a few weeks now and have started to run into issues with database slowdown. The more shares that have been submitted to our shares table, the more intensive the CPU cycles become and the slower the website performs. The engine used for our MPOS tables is InnoDB. We need help with optimizing our MPOS database so that share query performance is scalable and optimized to the maximum extent of MySQL and our hardware. Please, only bid on this project if you have productive and professional skills and experience with MySQL database administration/optimization/maintenance. Otherwise, WE WILL NOT PAY YOU. If your work for this project is sufficient in solving our problem and scales well with increasing share query rates, we will consider commissioning you for future database-oriented work.

Database Administration

MySQL

Project ID: 17160211

About the project

3 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@nnesarikar

I have over 12+ years of database administration experience and I am not new to MySQL. I have worked on MySQL apart from Oracle, MS SQL Server and Sybase

$66 USD in 10 days

0.0

(0 reviews)

0.0

3 freelancers are bidding on average $71 USD for this job

@himamahi09

Hi , As I have production experience in MySQL for 5+ years, I think I can solve this issue. And, I myself wont accept money if I am not able to solve the issue. Few queries I would like to put before you accept this bid: * Which MySQL version are you running on? * Where is the server deployed, like bare metal or some cloud ? * Are you ok with query changes if required for optimization? * Are you ok with a application downtime if required for the maintenance of tables? * What is the current database size and the capacity of the host it is running on? * What is the TPS on the database, read and write?

$80 USD in 6 days