怎么显示在 MySQL 上执行的最后一个查询?

本教程将介绍如何显示在 MySQL 上执行的最后一个查询?的处理方法,这篇教程是从别的地方看到的,然后加了一些国外程序员的疑问与解答,希望能对你有所帮助,好了,下面开始学习吧。

怎么显示在 MySQL 上执行的最后一个查询? 教程 第1张

问题描述

Is there any query/way to show the last queries executed on ALL servers?

解决方案

For those blessed with MySQL >= 5.1.12, you can control this option globally at runtime:

    Execute SET GLOBAL log_output = 'TABLE';

    Execute SET GLOBAL general_log = 'ON';

    Take a look at the table mysql.general_log

If you prefer to output to a file instead of a table:

    SET GLOBAL log_output = "FILE";.

    SET GLOBAL general_log_file = "/path/to/your/logfile.log";

    SET GLOBAL general_log = 'ON';

I prefer this method to editing .cnf files because:

    you're not editing the my.cnf file and potentially permanently turning on logging

    you're not fishing around the filesystem looking for the query log - or even worse, distracted by the need for the perfect destination. /var/log /var/data/log /opt /home/mysql_savior/var

    You don't have to restart the server and interrupt any current connections to it.

    restarting the server leaves you where you started (log is by default still off)

For more information, see
MySQL 5.1 Reference Manual - Server System Variables - general_log

好了关于怎么显示在 MySQL 上执行的最后一个查询?的教程就到这里就结束了,希望趣模板源码网找到的这篇技术文章能帮助到大家,更多技术教程可以在站内搜索。