mysql性能分析工具mysqlreport)资源-CSDN文库

共4个文件

html：2个

mysqlreport：1个

copying：1个

mysql

report

5星 · 超过95%的资源需积分: 50 196 浏览量 2009-02-10 10:32:11 上传评论 2 收藏 42KB ZIP 举报

资源推荐

资源详情

资源评论

收起资源包目录

mysqlreport-3.5.zip （4个子文件）

mysqlreport-3.5

COPYING 34KB

mysqlreport 38KB

mysqlreportdoc.html 12KB

mysqlreportguide.html 52KB

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <title>The Guide To Understanding mysqlreport</title> <meta name="keywords" content="guide,understanding,interpret,mysqlreport,report" /> <meta name="description" content="The Guide To Understanding mysqlreport." /> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" /> </head> <body> <div id="Content"> <h1>The Guide To Understanding mysqlreport</h1> <div class="inset_c"> This guide to understanding <a href="http://hackmysql.com/mysqlreport">mysqlreport</a> explains everything that mysqlreport can report. It also teaches how to interpret and understand all the values in context so that after reading a mysqlreport report ("a report") the fundamental question that mysqlreport was created to answer can be answered: How well is the MySQL server running? The current version of mysqlreport automatically generates a complete report that covers practically every applicable MySQL status value. (This is different from all previous versions which required the --all command line option to generate a complete report.) The complete report has 14 report sections for a total of 121 lines. Depending on the MySQL server configuration, some of the report sections may not be generated. For example, if query caching is turned off, the forth report section, Query Cache, will not be generated. Therefore, the report can vary in length. To facilitate better understanding and insight, this guide is written as a walk-through interpretation of a complete report. The guide begins with the very first line and examines and interprets every report section and line to the end. The complete report that this guide will interpret is given below. Line numbers are added to make examining the report easier. Most line numbers are links to the explanation of that line. <pre> <a name="l1" href="#report_header">1</a> MySQL 5.0.3 uptime 0 0:34:26 Fri Sep 1 19:46:02 2006 2 <a name="l3" href="#key_report">3</a> __ Key _________________________________________________________________ <a href="#key_report:buffer_used">4</a> Buffer used 380.00k of 512.00M %Used: 0.07 <a href="#key_report:buffer_usage">5</a> Current 59.32M %Usage: 11.59 <a href="#key_report:write_ratio">6</a> Write hit 97.04% <a href="#key_report:read_ratio">7</a> Read hit 99.58% 8 <a name="l9" href="#questions_report">9</a> __ Questions ___________________________________________________________ <a href="#questions_report:total">10</a> Total 98.06k 47.46/s <a href="#questions_report:dtq">11</a> DMS 81.23k 39.32/s %Total: 82.84 <a href="#questions_report:dtq">12</a> QC Hits 16.58k 8.02/s 16.91 <a href="#questions_report:dtq">13</a> COM_QUIT 200 0.10/s 0.20 <a href="#questions_report:dtq">14</a> Com_ 131 0.06/s 0.13 <a href="#questions_report:dtq">15</a> -Unknown 82 0.04/s 0.08 <a href="#questions_report:slow">16</a> Slow 5 s 0 0.00/s 0.00 %DMS: 0.00 Log: ON <a href="#questions_report:dms">17</a> DMS 81.23k 39.32/s 82.84 <a href="#questions_report:dms">18</a> SELECT 64.44k 31.19/s 65.72 79.33 <a href="#questions_report:dms">19</a> INSERT 16.75k 8.11/s 17.08 20.61 <a href="#questions_report:dms">20</a> UPDATE 41 0.02/s 0.04 0.05 <a href="#questions_report:dms">21</a> REPLACE 0 0.00/s 0.00 0.00 <a href="#questions_report:dms">22</a> DELETE 0 0.00/s 0.00 0.00 <a href="#questions_report:com">23</a> Com_ 131 0.06/s 0.13 <a href="#questions_report:com">24</a> change_db 119 0.06/s 0.12 <a href="#questions_report:com">25</a> show_fields 9 0.00/s 0.01 <a href="#questions_report:com">26</a> show_status 2 0.00/s 0.00 27 <a name="l28" href="#sas_report">28</a> __ SELECT and Sort _____________________________________________________ <a href="#sas_report">29</a> Scan 38 0.02/s %SELECT: 0.06 <a href="#sas_report">30</a> Range 14 0.01/s 0.02 <a href="#sas_report">31</a> Full join 3 0.00/s 0.00 <a href="#sas_report">32</a> Range check 0 0.00/s 0.00 <a href="#sas_report">33</a> Full rng join 0 0.00/s 0.00 <a href="#sas_report">34</a> Sort scan 14 0.01/s <a href="#sas_report">35</a> Sort range 26 0.01/s <a href="#sas_report">36</a> Sort mrg pass 0 0.00/s 37 <a name="l38" href="#qc_report">38</a> __ Query Cache _________________________________________________________ <a href="#qc_report:usage">39</a> Memory usage 17.81M of 32.00M %Used: 55.66 <a href="#qc_report:frag">40</a> Block Fragmnt 13.05% <a href="#qc_report:hip">41</a> Hits 16.58k 8.02/s <a href="#qc_report:hip">42</a> Inserts 48.50k 23.48/s <a href="#qc_report:hip">43</a> Prunes 33.46k 16.20/s <a href="#qc_report:ratios">44</a> Insrt:Prune 1.45:1 7.28/s <a href="#qc_report:ratios">45</a> Hit:Insert 0.34:1 46 <a name="l47" href="#tl_report">47</a> __ Table Locks _________________________________________________________ <a href="#tl_report">48</a> Waited 1.01k 0.49/s %Total: 1.24 <a href="#tl_report">49</a> Immediate 80.04k 38.74/s 50 <a name="l51" href="#tables_report">51</a> __ Tables ______________________________________________________________ <a href="#tables_report">52</a> Open 107 of 1024 %Cache: 10.45 <a href="#tables_report">53</a> Opened 118 0.06/s 54 <a name="l55" href="#conn_report">55</a> __ Connections _________________________________________________________ <a href="#conn_report">56</a> Max used 77 of 600 %Max: 12.83 <a href="#conn_report">57</a> Total 202 0.10/s 58 <a name="l59" href="#temp_report">59</a> __ Created Temp ________________________________________________________ <a href="#temp_report">60</a> Disk table 10 0.00/s <a href="#temp_report">61</a> Table 26 0.01/s Size: 4.00M <a href="#temp_report">62</a> File 3 0.00/s 63 <a name="l64" href="#thd_report">64</a> __ Threads _____________________________________________________________ <a href="#thd_report">65</a> Running 55 of 77 <a href="#thd_report">66</a> Cache 0 %Hit: 0.5 <a href="#thd_report">67</a> Created 201 0.10/s <a href="#thd_report">68</a> Slow 0 0.00/s 69 <a href="#thd_report">70</a> __ Aborted _____________________________________________________________ <a href="#thd_report">71</a> Clients 0 0.00/s <a href="#thd_report">72</a> Connects 8 0.00/s 73 <a href="#thd_report">74</a> __ Bytes _______________________________________________________________ <a href="#thd_report">75</a> Sent 38.46M 18.62k/s <a href="#thd_report">76</a> Received 7.98M 3.86k/s <span

评论收藏

内容反馈