html tool

2012年7月24日星期二

ld如何监控mysql --II


  •                Number of SQL Queries: This is a representation os the com_select status variable. This does not represent total queries since server startup, but instead represents the current number of queries (the com_select variable is a cumulative total). The initial maximum value of the graph is 10, this maximum value will be automatically increased as needed.
【popexizhi:和上面那个bytes_sent相似,这个是当前的com_select的值的实时显示,初始化最大值为10,这个值根据需要自动增加。官方文档的说如下:
来源:http://dev.mysql.com/doc/refman/4.1/en/server-status-variables.html#statvar_Com_xxx

The Com_xxx statement counter variables were added beginning with MySQL 3.23.47. They indicate the number of times each xxx statement has been executed. There is one status variable for each type of statement. For example, Com_delete and Com_insert count DELETE and INSERT statements, respectively. However, if a query result is returned from query cache, the server increments the Qcache_hits status variable, not Com_select. See Section 7.5.3.4, “Query Cache Status and Maintenance”.


看这里的简介 这个到应该是select的执行条目数,但是我用导入数据库的脚本执行时这里显示的很高,并且查了一下Graph的参数为 ^[Questions],这个好像不是com_select吧?反正感觉有问题,测试自己加了一个Qcache_hits
也没有显示对应的内容,晕,这个到底是什么呢?[?]】    

没有评论:

发表评论