Lukket

Find out why mysql is very slow - repost

I have a VPS with apache, mysql and PHP installed with out-of-the-box configuration.

There seems to be a problem with mysql - it's incredibly slow. Single update query takes [url removed, login to view] to complete.

Disk I/O is good:

1073741824 bytes (1.1 GB) copied, [url removed, login to view] s, 75.6 MB/s

and php performance is also very good - a test script completes in 5 seconds, whereas it takes my Intel i7 SSD windows machine 17s to complete it .

So I guess it's related to mysql setup and configuration. When I run the query through my windows command line (my local server) I get this:

Query OK, 1 row affected ([url removed, login to view] sec)

Rows matched: 1 Changed: 1 Warnings: 0

Whereas when it is run on the VPS server, it's like this:

Query OK, 0 rows affected ([url removed, login to view] sec)

Your job would be to find and eliminate the problem.

Færdigheder: Apache, Linux, MySQL, System Administrator

Se mere: apache problem, test out, performance test job, find job line, so slow, linux find, find why, find local, setup mysql linux, windows server admin script, 2013 query, query performance, windows command script, mysql slow query update, mysql server performance, mysql performance test, vps setup admin, linux mysql setup, mysql query slow, mysql query php, linux server performance, mysql slow, vps problem, linux performance, vps setup script

Om arbejdsgiveren:
( 0 bedømmelser ) India

Projekt-ID: #4091628

24 freelancere byder i gennemsnit $78 for dette job

edsiper

hi, please check my private message for proposal details

$100 USD på 1 dag
(10 bedømmelser)
6.8
shakoush2001

Hi I am a CISSP,RHCE,CCNA,MCSA,Linux+ and a CEH. I do have 7+ years experience in System Administration . I have experience in a high availability environment with 100+ servers and more than 500 000+ subscribers, I kno Mere

$120 USD in 3 dage
(85 bedømmelser)
6.7
jthoma

I have been doing this for the past 10+ years, and would like to do this for you.

$100 USD in 2 dage
(168 bedømmelser)
6.2
JeffLee21

I've heavy experience with Linux development and administration more than 7 years. I've experienced with various Linux utility programming, server configuration comprising httpd(web server), ftp, mysql etc..

$40 USD på 1 dag
(23 bedømmelser)
6.0
vctheguru

Hi, I have experience in doing similar tasks. I will fix it. regards VC

$200 USD in 2 dage
(28 bedømmelser)
5.7
managedserverMS

Hi, I will be happy to help you, please see my past reviews related to system administration in PM. lets complete this project thanks.

$40 USD in 0 dage
(96 bedømmelser)
5.7
f1x3r

Hi, I am experienced systems and database administrator. I can handle analyzing the issue regardless if it's mysql, system or a script issue.

$50 USD på 1 dag
(25 bedømmelser)
4.8
osmanlicilegi

I'm interested with your job. I can deliver it on time with your needs. I'm working as a system administrator for more than 10 years and I'm good at *nix. You should see it by my testimonials. Please feel free to ask a Mere

$150 USD in 3 dage
(48 bedømmelser)
4.7
leandrodardini

Hello, I am a Linux sysadmin with strong knowledge in Mysql optimization. I have already made similar works with full client satisfaction. About me, I am from Italy, ready to work for you.

$30 USD på 1 dag
(17 bedømmelser)
4.7
gr8support

I can fix this for you.

$75 USD på 1 dag
(51 bedømmelser)
4.5
sumitgarg44

Can tune this.Ready to start now

$50 USD på 1 dag
(18 bedømmelser)
4.1
developerlance

Hello, Please check PMB.

$100 USD in 3 dage
(4 bedømmelser)
3.9
MakeYouBelieve

Hi, I can do it. Regards.

$50 USD på 1 dag
(13 bedømmelser)
3.8
simpletechnology

I have extensive experience that meets the qualifications, and would be happy to complete this work for you. We can speak via telephone, skype, yahoo im, aim, msn messenger, or irc chat. Thank you, Sean Brady

$150 USD in 7 dage
(7 bedømmelser)
3.6
matrafox

Hello I have over 9 year of experience with dedicated server.

$30 USD på 1 dag
(7 bedømmelser)
3.5
ficuric

Hello! ready to do this job for you :)

$100 USD in 2 dage
(5 bedømmelser)
2.9
ibaydan

I am a linux professional

$30 USD in 0 dage
(3 bedømmelser)
2.0
sumitgoyal1110

i have the resolution of the issue.. give me chance to do this

$30 USD på 1 dag
(1 bedømmelse)
1.2
abdsh

I have experience in apche

$80 USD in 7 dage
(0 bedømmelser)
0.0
etterack

I work for a VPS company with a similar LAMP set up. I troubleshoot MySQL performance issues on almost a daily basis.

$50 USD in 2 dage
(0 bedømmelser)
0.0