Find out why mysql is very slow

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.

NOTE: DO NOT send me any messages, or attempt to contact me on Skype. Such bids will not be considered. Thank you.

Kemahiran: Apache, Linux, MySQL, Sistem Admin

Lihat lagi: 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, php windows apache server performance

Tentang Majikan:
( 36 ulasan ) Sombor, Serbia

ID Projek: #4091571