在SQL SERVER下跟踪sql采用事件探查器,而在mysql则用开启日志的方式来跟踪执行的SQL,如下:
log = /www/wwwlogs/my.log
重载配置文件,重启mysql后,执行下SQL语句,可以看到日志中记录如下:
/www/server/mysql/bin/mysqld, Version: 5.5.55-log (Source distribution). started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id Command Argument 170519 23:28:43 1 Connect MyCode@58.248.237.70 on MyCode 1 Query SHOW VARIABLES 170519 23:28:44 1 Query SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP()) 1 Query SHOW COLLATION 1 Query SET character_set_results=NULL 1 Init DB MyCode 1 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ 1 Query BEGIN 1 Query UPDATE `dt_article` SET `add_time` = '2017-05-19 23:28:34.052552', `author` = '', `call_index` = NULL, `category_id` = 0, `channel_id` = 0, `click` = 0, `content` = '<p style=\"white-space: normal;\">在MVC中,我们可以使用简单的方法使用radiobutton ,例如下面的代码:</p><p style=\"white-space: normal;\">测试下</p><p style=\"white-space: normal;\">在MVC中,我们可以使用简单的方法使用radiobutton ,例如下面的代码:</p><p style=\"white-space: normal;\">测试下</p><p style=\"white-space: no', `img_url` = '', `is_hot` = 0, `is_msg` = 0, `is_red` = 0, `is_slide` = 0, `is_sys` = 1, `is_top` = 0, `link_url` = '', `seo_description` = '', `seo_keywords` = '', `seo_title` = NULL, `sort_id` = 99, `source` = '', `status` = 0, `tags` = '', `title` = 'sd', `update_time` = '2017-05-19 23:28:34.052552', `user_name` = 'admin', `zhaiyao` = '&#x5728;MVC&#x4E2D;&#xFF0C;&#x6211;&#x4EEC;&#x53EF;&#x4EE5;&#x4F7F;&#x7528;&#x7B80;&#x5355;&#x7684;&#x65B9;&#x6CD5;&#x4F7F;&#x7528;radiobutton &#xFF0C;&#x4F8B;&#x5982;&#x4E0B;' WHERE `id` = 154; SELECT ROW_COUNT()
如果重启mysql却出现错误,
Starting MySQL.The server quit without updating PID file (/var/lib/mysql/52jiagou.com.pid).[失败]
请参考下面文章解决: