Help with MYSQL Process on server causing high CPU
- or -
Post a project like this2598
$$
- Posted:
- Proposals: 4
- Remote
- #1471063
- Awarded
Description
Experience Level: Intermediate
General information for the website: news
Kind of development: Customization of existing website
Description of requirements/features: OK, so here is the story so far...
My website has seen an increase in traffic and I have upgraded to a VPS
I am looking for someone who really knows about High CPU on servers and My SQL processes
I have already tried two developers (waste of time) and different web hosts
Everyone tells me that my hosting should be more than fine for our traffic
100,000 visitors per month and can have up to 1,000 concurrent users
=================================
My VPS web host has said "we I can see that your MYSQL processes are the cause now of the overall load.
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1243 mysql 20 0 7069m 413m 5528 S 95.1 0.4 594:37.64 mysqld
Even with twice the amount of CPU Cores, they are being hammered.
Cpu0 : 92.7%us, 7.3%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 65.2%us, 7.7%sy, 0.0%ni, 27.1%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 95.7%us, 4.3%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 90.1%us, 9.9%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu4 : 55.7%us, 2.3%sy, 0.0%ni, 42.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu5 : 18.7%us, 4.3%sy, 0.0%ni, 76.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu6 : 13.8%us, 1.3%sy, 0.0%ni, 84.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu7 : 52.8%us, 3.0%sy, 0.0%ni, 44.1%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Who is your developer for this website, do you have one to which we can speak with?
=================================
Can you help?
Specific technologies required: mysql
Extra notes:
Kind of development: Customization of existing website
Description of requirements/features: OK, so here is the story so far...
My website has seen an increase in traffic and I have upgraded to a VPS
I am looking for someone who really knows about High CPU on servers and My SQL processes
I have already tried two developers (waste of time) and different web hosts
Everyone tells me that my hosting should be more than fine for our traffic
100,000 visitors per month and can have up to 1,000 concurrent users
=================================
My VPS web host has said "we I can see that your MYSQL processes are the cause now of the overall load.
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1243 mysql 20 0 7069m 413m 5528 S 95.1 0.4 594:37.64 mysqld
Even with twice the amount of CPU Cores, they are being hammered.
Cpu0 : 92.7%us, 7.3%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 65.2%us, 7.7%sy, 0.0%ni, 27.1%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 95.7%us, 4.3%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 90.1%us, 9.9%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu4 : 55.7%us, 2.3%sy, 0.0%ni, 42.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu5 : 18.7%us, 4.3%sy, 0.0%ni, 76.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu6 : 13.8%us, 1.3%sy, 0.0%ni, 84.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu7 : 52.8%us, 3.0%sy, 0.0%ni, 44.1%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Who is your developer for this website, do you have one to which we can speak with?
=================================
Can you help?
Specific technologies required: mysql
Extra notes:
Derek P.
100% (3)Projects Completed
9
Freelancers worked with
8
Projects awarded
69%
Last project
30 Sep 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Your hosting should be able to handle much more traffic without any issues. It all depends on Database size/configuration and how your site using it.
Could you open PMB (private message board) to discuss about it?
Thanks. -
Hi Derek,
Can you let me know the site URL? Or if that's not possible, is the site using a CMS / Framework like Wordpress, Drupal, Cake etc. or is it totally bespoke?
Best wishes,
Joe P. -
Let me know your website url and web host name.
335607335542335515
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies