How to determine which SQL query is slow on the server

F

Fidget2012-09-19 16:08:05

SQL

Fidget, 2012-09-19 16:08:05

Hey!

Prompt how to define what SQL request brakes on the server.
Centos system.

Reply

Answer the question

In order to leave comments, you need to log in

4 answer(s)

D

Dmitry Guketlev, 2012-09-19
@Yavanosta

Using a profiler for your DBMS. Nothing more can be said from the information provided.

S

Stdit, 2012-09-19
@Stdit

Many subds have a special log for slow queries .

C

charliez, 2012-09-19
@charliez

the easiest way is to watch show full processlist at the time of accessing the slow page of the site (if we are talking about a slow site on a standard LAMP bundle and suspicions fall on mysql)

S

script88, 2012-09-19
@script88

apache status + show full processlist - to determine what is currently
loading Chop slow query log (if MySQL)