ld如何监控mysql --I

ld如何监控mysql

• [go] 可以使用MySQLAdministrator.exe，嘻嘻，pope早就安装了，但是没有try，连接一下看看了
  
  
  • help-内容
    • Chapter 14. Health

      • 14.1. Introduction

        【popexizhi:可下面的介绍在 server connections 中看到了全部的连接】
        Note that clicking on the status pages will open an additional connection to the MySQL server, which you can see when viewing threads and users in the Server Connections section.
        
        
        

        14.2. Connection Health

        This tab provides information about connections to the MySQL server. The following three pre-made graphs are displayed:
        
        
        
        • • Connection Usage: Displays a percentage of the maximum number of simultaneous clients allowed (threads connected / max_connections). If this value gets close to 100%, it could indicate that you should increase the value of max_connections, which you can do in the Startup Variables section. The maximum number of connections since MySQL Administrator was loaded is also shown. For more information on server connections, see SHOW VARIABLES Syntax, and Too many connections.
            
          
          
          • Traffic: This is a representation of the bytes_sent  status variable. This does not represent total bytes sent since server startup, but instead represents the current number of bytes sent (the bytes_sent variable is a cumulative total). The initial maximum value of the graph is 102400, this maximum value will be automatically increased as needed.
            
          【popexizhi:这个应该是bytes_sent 的当前内容显示，上面介绍说初始化的最大值是102400 ，但是可以按需求自动增长
          go 了一下，mysql的官方文档上这样描述：
          
           Bytes_sent
          The number of bytes sent to all clients. This variable was added in MySQL 3.23.7.
          来源:http://dev.mysql.com/doc/refman/4.1/en/server-status-variables.html#statvar_Bytes_sent
          】
          
  • [thinking] 这个工具使用root权限可以查看的数据，应该是root命令可以获得的，回头在命令行try一下:)
    【popexizhi：回头看看题目，总感觉自己有点儿跑题了。细想，不是跑题，自己有点儿短见了，ld的最终目的是ana，而这个要是不同数据为基础的，所以多虑了：）】