Skip to content

Mysql query logging via https://dev.mysql.com/doc/refman/8.0/en/query-log.html #21

Open
@chriscalip

Description

@chriscalip

Who wants it? Can we have it?!

https://dev.mysql.com/doc/refman/8.0/en/query-log.html

use XXX\Database;
use Performance\Config;
use Performance\Performance;
Performance::point('Overall start', TRUE);
Database::setActiveConnection('default');
$db = Database::getConnection();
$db->query("SET GLOBAL general_log = 'ON'");

//
// Run test code
//

Performance::finish();
Performance::results();

// SQL results from mysql general log.

$db->query("SET GLOBAL general_log = 'OFF'");

Instead of log file get logs through mysql table via https://tableplus.com/blog/2018/10/how-to-show-queries-log-in-mysql.html

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions