How do you capture the SQL queries running in a CakePHP page?

Question

I have a production CakePHP site where I need to troubleshoot a slow SQL query. I want access to that great table CakePHP creates with the actual SQL query, execution time, etc, but I can't set the DEBUG level to 3 on a production site.

I imagine this is a simple but I just can't seem to figure out how I can get this information for a specific script and do something with it, like save it to a log file.

bancer · Accepted Answer · 2010-10-12 21:56:22Z

4

This article will help you.

If you have access to MySQL configuration file you can log slow queries by enabling log-slow-queries setting.

answered Oct 12, 2010 at 21:56

bancer

7,5257 gold badges41 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Justin Over a year ago

Good article. I wanted to avoid the slow query log, but oh well.

deceze · Accepted Answer · 2010-10-13 01:18:05Z

2

For Cake 1.3 (not sure if this works in 1.2), have a look at /cake/libs/view/elements/sql_dump.ctp and adapt it to your needs:

$sources = ConnectionManager::sourceList();

foreach ($sources as $source) {
    $db =& ConnectionManager::getDataSource($source);
    if (!$db->isInterfaceSupported('getLog')) {
        continue;
    }

    $log = $db->getLog();

    // examine $log...
}

answered Oct 13, 2010 at 1:18

deceze♦

525k89 gold badges807 silver badges954 bronze badges

Comments

Simon E. · Accepted Answer · 2015-03-10 22:14:58Z

0

DebugKit is your friend. There should be versions suitable for Cake 1.3, 2.x and 3.x. It has a beautiful toolbar that displays all your SQL queries and the time taken to run each.

https://github.com/cakephp/debug_kit

answered Mar 10, 2015 at 22:14

Simon E.

59.3k18 gold badges146 silver badges140 bronze badges

Collectives™ on Stack Overflow

How do you capture the SQL queries running in a CakePHP page?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related