Ditutup

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, 14.207 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 (0.01 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 (0.55 sec)

Your job would be to find and eliminate the problem.

Kemahiran: Apache, Linux, MySQL, Sistem Admin

Lihat lebih lanjut: apache problem, test out, performance test job, find on-line, find job on line, so slow, linux find, out of the box, 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, php server performance test script, mysql query slow, mysql query php, linux server performance, mysql slow

Tentang Majikan:
( 0 ulasan ) India

ID Projek: #4091628

24 pekerja bebas membida secara purata $78 untuk pekerjaan ini

edsiper

hi, please check my private message for proposal details

$100 USD dalam sehari
(10 Ulasan)
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 Lagi

$120 USD dalam 3 hari
(85 Ulasan)
6.7
jthoma

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

$100 USD dalam 2 hari
(168 Ulasan)
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 dalam sehari
(23 Ulasan)
6.0
vctheguru

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

$200 USD dalam 2 hari
(28 Ulasan)
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 dalam 0 hari
(96 Ulasan)
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 dalam sehari
(25 Ulasan)
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 Lagi

$150 USD dalam 3 hari
(48 Ulasan)
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 dalam sehari
(17 Ulasan)
4.7
gr8support

I can fix this for you.

$75 USD dalam sehari
(51 Ulasan)
4.5
sumitgarg44

Can tune [url removed, login to view] to start now

$50 USD dalam sehari
(18 Ulasan)
4.1
developerlance

Hello, Please check PMB.

$100 USD dalam 3 hari
(4 Ulasan)
3.9
MakeYouBelieve

Hi, I can do it. Regards.

$50 USD dalam sehari
(13 Ulasan)
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 dalam 7 hari
(7 Ulasan)
3.6
matrafox

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

$30 USD dalam sehari
(7 Ulasan)
3.5
ficuric

Hello! ready to do this job for you :)

$100 USD dalam 2 hari
(5 Ulasan)
2.9
ibaydan

I am a linux professional

$30 USD dalam 0 hari
(3 Ulasan)
2.0
sumitgoyal1110

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

$30 USD dalam sehari
(1 Ulasan)
1.2
abdsh

I have experience in apche

$80 USD dalam 7 hari
(0 Ulasan)
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 dalam 2 hari
(0 Ulasan)
0.0