基礎(chǔ)帖 求解 \s 輸出疑問

czq_linux

Threads: 31  Questions: 92944400  Slow queries: 3  Opens: 2644  Flush tables: 1  Open tables: 512  Queries per second avg: 1382.977
--------------
如上 所示：
疑問：Questions 和  queries 有區(qū)別么？都是查詢請(qǐng)求？也就是select語句的執(zhí)行次數(shù)？（一般翻譯書都是怎么翻譯這倆個(gè)單詞的？）
opens 和open tables 指的是什么？ 后者是打開的表，是否是當(dāng)下哪些表正在被訪問？ 那opens指的是？
Threads開啟的線程，專指connection 線程 還是也包括例如 主從開啟的線程等？

czq_linux

基礎(chǔ)問題~  沒人愿意回答？ 大俠都出差了？

czq_linux

czq_linux

來個(gè)人唄。支持一下新手。

czq_linux

頂?shù)接腥嘶卮馂橹埂！?/td>

TomLeng

*      Uptime
      The number of seconds the MySQL server has been running.
    *      Threads
      The number of active threads (clients).
    *      Questions
      The number of questions (queries) from clients since the server was started.
    *      Slow queries
      The number of queries that have taken more than long_query_time seconds. See Section 5.2.4, “The Slow Query Log”.
    *      Opens
      The number of tables the server has opened.
    *      Flush tables
      The number of flush-*, refresh, and reload commands the server has executed.
    *      Open tables
      The number of tables that currently are open.

czq_linux

謝謝！

ubuntuer

*      Uptime
      The number of seconds the MySQL server has been running.
    *      Threads
  ...
TomLeng 發(fā)表于 2011-03-23 10:36

   和詳細(xì)

ruochen

*      Uptime
      The number of seconds the MySQL server has been running.
    *      Threads
  ...
TomLeng 發(fā)表于 2011-03-23 10:36