› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
reid2017
V2EX  ›  MySQL

mysql 慢查询日志

  •  
  •   reid2017 · Jan 9, 2018 · 4802 views
    This topic created in 3186 days ago, the information mentioned may be changed or developed.

    mysql 的慢查询日志里有 commit 语句,是怎么回事? google 了半天也没找到相关信息。

    User@Host: tester[tester] @ [192.168.2.38]

    Thread_id: 171 Schema: dddder QC_hit: No

    Query_time: 0.524212 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0

    SET timestamp=1515512553; commit;

    User@Host: tester[tester] @ [192.168.2.38]

    Thread_id: 17 Schema: dddder QC_hit: No

    Query_time: 0.522975 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0

    SET timestamp=1515512553; commit;

    User@Host: tester[tester] @ [192.168.2.38]

    Thread_id: 331 Schema: dddder QC_hit: No

    Query_time: 0.510277 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0

    SET timestamp=1515512553; commit;

    2 replies  •  2018-01-09 20:52:26 +08:00
    likuku
        1
    likuku  
       Jan 9, 2018
    0.5 秒上下还觉得慢?
    alcarl
        2
    alcarl  
       Jan 9, 2018 via Android
    应用程序有提交操作就有 commit 不是很正常吗
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   2413 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 27ms · UTC 06:55 · PVG 14:55 · LAX 23:55 · JFK 02:55
    ♥ Do have faith in what you're doing.