PUBLISHED : _DEBUG_SLOW_QUERIES

**SPIP**

# Article validated

The article "**\_DEBUG\_SLOW_QUERIES**
(https://www.spip.net/en_article6561.html)" was validated by
<multi>[ar]جورج[fr]George [en]George</multi>.

* * *

## \_DEBUG\_SLOW_QUERIES

Thursday 21 May 2020 , by [jack](.././?page=auteur&id_auteur=593&)

This constant makes it possible (since SPIP version 3.0.9
(https://www.spip.net/ecrire/?exec=article&id_article=5619)) to trace
requests which are too slow.

To trace too slow queries in the "slow-queries"
(https://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html) log file
(MySQL only), you can define the constant **`_DEBUG_SLOW_QUERIES`** in your
file `config/mes_options.php` (see the article dedicated to it
(https://www.spip.net/ecrire/?exec=article&id_article=4909)).

example :

    // add trace information to mysql's slow queries logs

    define
    
     (http://www.php.net/define)
    
    &#40;

    '_DEBUG_SLOW_QUERIES'

    ,

    true

    &#41;

    ;

— Sent by SPIP (https://www.spip.net/)

rubon199.jpg