Need MYSQL DB expert


We are running one PHP application with an MYSQL database.

PHP server has 8GB ram and MYSQL is a digital ocean managed database.

Everything works fine if we don't have traffic, if we have more than 1500 live users our DB server not working, it reached 100% CPU usage and throughput is very high, we already upgraded the server lot of time, but it's not working, We need some DB expert help to figure out and fix that issue.

Once it's figured, we need to know how to test this without spending our money on promotion, for now whenever we are doing promotion, we are getting lost.

Skills: MySQL, PHP, Linux, Database Administration, Apache

See more: need micorsoft access expert complete assignments, send keystrokes running application, running application vista patch, need google api expert, linux mysql 100 cpu usage, find mysql security expert, winwordexe process running application closed, need linux apache mysql security expert, need talk html expert, php mysql leave management approval web application system, php mysql script expert, years need spend become expert redhat linux, need mysql assistance, need php script expert, need microsoft word expert, mysql db iphone application, need mysql expert use trigger, need mysql expert, need memory dump running application

About the Employer:
( 2 reviews ) chennai-87, India

Project ID: #30129058

10 freelancers are bidding on average ₹1120/hour for this job

(513 Reviews)

Hi, I will check server and will fix this CPU consumption on server. I have 11 years of experience in server and hosting. Please discuss. Thank you

₹575 INR / hour
(521 Reviews)
(383 Reviews)

I can qualitatively assist with troubleshooting of database performance issues because I am exceptionally well qualified SQL developer with 10+ years' seniority and with long term professional experience in implementat More

₹2500 INR / hour
(35 Reviews)

Hello, i'm expert Database servers, i can help you and check what exactly hitting your Mysql Server and make this high CPU consuming, in addition to tuning your Mysql Server performance to be able to get more traffic w More

₹1000 INR / hour
(62 Reviews)

Hi, I am a web designer & developer with 9+ years of experience. I have expertise in Laravel, CodeIgniter, Magento, WordPress, CMS, ecommerce, JavaScript, HTML, CSS, MySQL, PHP, Angular, React, React Native, Vue.js, bo More

₹700 INR / hour
(1 Review)

Hi I have 15 years of experience in SQL server Database development, MySQL, Postgress development, C#, Python, power bi. I will be able to help you with the project. please ping me offline to discuss further

₹2222 INR / hour
(4 Reviews)

Your queries to read/write DB are not efficient. They need to be fixed. I can take care of them. Also I will take a look into your server configuration if needed or to check if we can do some optimization there as well More

₹750 INR / hour
(1 Review)

We have 100+ warehouse running and 10000+ active user and the system runs on 8gb server and works smoothly. I can help you configure your system, also help you find if any particular query is taking time and leading t More

₹500 INR / hour
(0 Reviews)

hey there, i hope you are well aware of load balancer, in php queries you mush need load balancer. if you dont mind, can you tell me which framework of php you used for your application? its my first time online but i More

₹700 INR / hour
(0 Reviews)