Nginx & Mysql optimization

I have a website that has some traffic.

My current issue is that MySQL consumes 100% CPU all the time, sometimes even more(from top -c).

Even tho the machine load is not high, mysql process shows as using 100% CPU.

I have upgraded the machine and even isolated Web Server and MySQL. Web Server is now on a dedicated server. MySQL is on another.

I have upgraded the hardware and both are now on SSD Discs, so it is now a hardware issue.

I have changed from mysql to mariadb, myisam to innodb and tried a lot of different settings on my.cnf. Ramdisk for tmp tables. Ran the mysql tuner perl script and all good. Load still high.

I need some *really* expert in MySQL to optimize the settings so it does not use so much CPU. I need find the root cause.

I also want to have nginx (php-fpm) optimized to my reality, basically a check on what might be possibly wrong on any nginx settings, because after the migration, I had to change some settings on php-fpm as the website sometimes used to hang.

But my main issue is on the MySQL(MariaDB). The Nginx is more to optimize, but it doesnt really look to have an issue.

Typo: it is NOT a hardware issue

Færdigheder: Ingeniørarbejde, Linux, MySQL, Nginx, Shell Script

Se mere: web traffic engineering, mysql top 10, migration expert, php-fpm, optimize mysql, nginx, php cpu 100, php php fpm cpu 100, php fpm cpu 100, web server optimization, php fpm nginx, optimize server traffic, mysql php migration, php mysql optimize, mysql nginx, optimize nginx fpm, cpu 100, php fpm, nginx perl, hardware php script, mysql migration website, mysql cpu load optimize, optimize php fpm, server mysql, nginx php fpm

Om arbejdsgiveren:
( 2 bedømmelser ) patos, Brazil

Projekt-ID: #6052609

29 freelancers are bidding on average $159 for this job


Dear Customer, this is Yaseen, and i am glad to work for you project. We specialise in Server Management, Enterprise Email Systems, Email Marketing and Asterisk VOIP Support. Please see my past projects https://www Mere

$289 USD in 3 dage
(347 bedømmelser)

Hi, I am expert in finding bottlenecks and debugging code/mysql. Can handle this without problems, check my reviews to know about my skills. Jose

$200 USD in 2 dage
(99 bedømmelser)

A proposal has not yet been provided

$147 USD in 3 dage
(83 bedømmelser)

Please see here what I can do for your website: [url removed, login to view] [url removed, login to view] I'm a experienced System and Network administrator with more than 10 Mere

$155 USD in 3 dage
(23 bedømmelser)

i am a skilled server admin, i can tune the server for you. i am a skilled server admin, i can tune the server for you.

$210 USD in 3 dage
(88 bedømmelser)

Hi The most likely the issue is in indexes. Queries optimization might be needed as well. I can do both. See my feedbacks from the previous projects in this field. All the best Alexei

$166 USD in 5 dage
(55 bedømmelser)

Dear sir, I will complete your project within 2 days, LIFETIME free bug guarantee and provide ONE YEAR support... I have gone through your outsourced requirement "Nginx & Mysql optimization" and have analyzed th Mere

$179 USD in 365 dage
(27 bedømmelser)

Hey, can I take a look into the db? Do not award me the project, let me see first and we can leave the bid as a price if I fix your issues

$111 USD in 3 dage
(54 bedømmelser)

Hello Sir, I am Working with 3 Tier Data Center Organization as a Linux Expert, I have more than 6 years experience in Web hosting and Database Servers, working on more than 1000 of Web/Database servers. I have read yo Mere

$100 USD in 2 dage
(55 bedømmelser)

Hi there , We are just keen to know if you are looking for eye catching Design with unlimited chances for changing .Further Theme Conversion as well as website development support .SEO friendly design and no extra cha Mere

$206 USD in 10 dage
(7 bedømmelser)

Please provide some more details (is it custom software or some open source based? slow queries log? etc.) so then I could estimate time and effort needed for this task and adjust my bid accordingly.

$250 USD in 5 dage
(18 bedømmelser)

Hi there, I'm an Linux expert with a very long professional web hosting experience, see my profile at [url removed, login to view] I have also very long experience in building for a companies scallable XEN/OpenVZ/KVM/AWS Mere

$200 USD in 3 dage
(8 bedømmelser)

CPU overeating by mysql process is result of unuse indexes, long queries and lock tables. I can invistigate your mysql and found problem queries, give your solution how to avoid this problem. SSH root access is r Mere

$111 USD in 10 dage
(17 bedømmelser)

Hi, We are fast growing hosting company in India. We have expertise in Linux server setup with management. We used to work with many hosting panels like cpanel, plesk, webmin , direct admin , ispconfig, zpanel, we Mere

$127 USD på 1 dag
(6 bedømmelser)

I have been in working as a lead web developer and devops. My last 4 years were in high traffic web apps one with data mining companies engine and lots of heavy data processing. Though my experience with php-fpm is Mere

$100 USD in 2 dage
(2 bedømmelser)

Hello, I'm a sysadmin with 8 years of professional experience. I have worked with several hosting companies, and I have a lot of experience solving problems very quickly. I think I can help you finding your issue. Mere

$166 USD in 3 dage
(7 bedømmelser)

Hi, I am DB developer with PHP/website speed optimization experience. I propose to work with you to tune your database such that load comes down. This proposal is only for mysql tuning (and no changes in nginx Mere

$166 USD in 3 dage
(2 bedømmelser)

I`m unix/linux engineer with 15+ years of experience. I work with most major new technologies like I will be happy to help U. From your descriptions i can only guess that there is somewhere so called "hidden io" Mere

$155 USD in 3 dage
(5 bedømmelser)

I have long experiance in this field, because it's my day job. I would do slow query log analysis, as the first step in resolving issue.

$87 USD in 3 dage
(3 bedømmelser)

Nie złożono jeszcze oferty.

$144 USD in 3 dage
(4 bedømmelser)