lianxiaoyi
V2EX  ›  问与答

mysql State starting 这个是啥

  •  
  •   lianxiaoyi · Oct 30, 2018 · 2227 views
    This topic created in 2760 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
        1
    xiaoxinshiwo  
       Oct 30, 2018   ❤️ 1
    没起来吧
    lianxiaoyi
        2
    lianxiaoyi  
    OP
       Oct 30, 2018
    @xiaoxinshiwo 我 APP 接口又是正常的啊。
    xiaoxinshiwo
        3
    xiaoxinshiwo  
       Oct 30, 2018
    @lianxiaoyi #2 不懂了,慢 sql 一般在配置文件配置吧,slow_query_log 和 long_query_time
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   3603 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 29ms · UTC 05:01 · PVG 13:01 · LAX 22:01 · JFK 01:01
    ♥ Do have faith in what you're doing.