lianxiaoyi
V2EX  ›  问与答

mysql State starting 这个是啥

  •  
  •   lianxiaoyi · Oct 30, 2018 · 2647 views
    This topic created in 2928 days ago, the information mentioned may be changed or developed.

    [{"Id":"15230955","User":"xxx","Host":"xxxxx","db":"xxxxx","Command":"Execute","Time":"2","State":"starting","Info":null}]

    写了一个运行超过 2s 的 SQL 监测脚本,然后今天一直在收到这个报警,百度谷歌了好久,这个 starting 是个啥意思啊?难道是我 mysql 在不停的重启?

    3 replies  •  2018-10-30 10:15:36 +08:00
    xiaoxinshiwo
    xiaoxinshiwo
    Oct 30, 2018❤️1
    1
    没起来吧
    lianxiaoyi
    lianxiaoyi
    OP
    Oct 30, 2018
    2
    @xiaoxinshiwo 我 APP 接口又是正常的啊。
    xiaoxinshiwo
    xiaoxinshiwo
    Oct 30, 2018
    3
    @lianxiaoyi #2 不懂了,慢 sql 一般在配置文件配置吧,slow_query_log 和 long_query_time
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   2507 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 31ms · UTC 15:05 · PVG 23:05 · LAX 07:05 · JFK 10:05
    ♥ Do have faith in what you're doing.