Dibatalkan

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, [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.

Kemahiran: Apache, Linux, MySQL, Sistem Admin

Lihat lebih lanjut: 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, test vps server

Tentang Majikan:
( 36 ulasan ) Sombor, Serbia

ID Projek: #4091571