How do I generate a MySQL report?
Overview
The following will show you the steps to run a MySQL Report on your MySQL GridContainer(dv) Dedicated-Virtual Server. This report generates a large, comprehensive report that displays values for practically every MySQL server statistic available, along with explanations. Use this report to analyze specific areas of your MySQL usage patterns and uncover performance bottlenecks.
Requirements
Before you start, this article has the following dependencies:
- AccountCenter access
- A MySQL GridContainer activated on your (gs).
- You must have SSH access set up for root or a sudo user.
READ ME FIRST
The publishing of this information does not imply support of this article. This article is provided solely as a courtesy to our customers. Please take a moment to review the Statement of SupportStatement of Support.
Instructions
- Log into your AccountCenter.
- Click on your primary domain for your (gs) Grid-Service.
-
Click on Manage Databases:
-
Click on the MySQL Container tab:
-
Click on Run MySQL Report:
NOTE:
If you have already ran this report once you must first view your current report, after which you will be able to see the option to run a new report.
-
For more information on how to use this information, refer to the guide located on the right. Here is an example report:
- Connect to your (dv) Dedicated-Virtual Server via SSH as the root or sudo user.
-
Grab the MySQL Report Script:
wget hackmysql.com/scripts/mysqlreport -
Now, simply run the script using the following command:
NOTE:
Be sure to replace password123 with your MySQL admin password.
perl mysqlreport --user admin --password password123 -
You should now see results similar to:
MySQL 5.0.45 uptime 6 1:4:11 Thu Oct 30 15:20:04 2008 __ Key _________________________________________________________________ Buffer used 33.00k of 8.00M %Used: 0.40 Current 943.99k %Usage: 11.52 Write hit 0.00% Read hit 91.97% __ Questions ___________________________________________________________ Total 55.58k 0.1/s COM_QUIT 20.01k 0.0/s %Total: 36.01 QC Hits 17.82k 0.0/s 32.06 DMS 9.33k 0.0/s 16.79 Com_ 8.67k 0.0/s 15.60 -Unknown 254 0.0/s 0.46 Slow 10 s 0 0/s 0.00 %DMS: 0.00 Log: OFF DMS 9.33k 0.0/s 16.79 SELECT 8.46k 0.0/s 15.22 90.65 UPDATE 664 0.0/s 1.19 7.11 DELETE 169 0.0/s 0.30 1.81 REPLACE 35 0.0/s 0.06 0.38 INSERT 5 0.0/s 0.01 0.05 Com_ 8.67k 0.0/s 15.60 set_option 2.82k 0.0/s 5.08 admin_comma 1.16k 0.0/s 2.09 show_variab 1.11k 0.0/s 2.00 __ SELECT and Sort _____________________________________________________ Scan 5.70k 0.0/s %SELECT: 67.35 Range 23 0.0/s 0.27 Full join 8 0.0/s 0.09 Range check 0 0/s 0.00 Full rng join 0 0/s 0.00 Sort scan 637 0.0/s Sort range 3 0.0/s Sort mrg pass 0 0/s __ Query Cache _________________________________________________________ Memory usage 6.31M of 8.00M %Used: 78.90 Block Fragmnt 0.05% Hits 17.82k 0.0/s Inserts 6.80k 0.0/s Insrt:Prune 6.80k:1 0.0/s Hit:Insert 2.62:1 __ Table Locks _________________________________________________________ Waited 0 0/s %Total: 0.00 Immediate 15.71k 0.0/s __ Tables ______________________________________________________________ Open 64 of 64 %Cache: 100.00 Opened 4.31k 0.0/s __ Connections _________________________________________________________ Max used 4 of 100 %Max: 4.00 Total 20.02k 0.0/s __ Created Temp ________________________________________________________ Disk table 1.98k 0.0/s Table 4.74k 0.0/s Size: 32.0M File 5 0.0/s __ Threads _____________________________________________________________ Running 1 of 1 Cached 0 of 0 %Hit: 0 Created 20.02k 0.0/s Slow 0 0/s __ Aborted _____________________________________________________________ Clients 8 0.0/s Connects 89 0.0/s __ Bytes _______________________________________________________________ Sent 13.35M 25.6/s Received 5.45M 10.4/s __ InnoDB Buffer Pool __________________________________________________ Usage 2.00M of 2.00M %Used: 100.00 Read hit 98.90% Pages Free 0 %Total: 0.00 Data 127 99.22 %Drty: 0.00 Misc 1 0.78 Latched 0 0.00 Reads 257.22k 0.5/s From file 2.83k 0.0/s 1.10 Ahead Rnd 0 0/s Ahead Sql 12 0.0/s Writes 486 0.0/s Flushes 146 0.0/s Wait Free 0 0/s __ InnoDB Lock _________________________________________________________ Waits 0 0/s Current 0 Time acquiring Total 0 ms Average 0 ms Max 0 ms __ InnoDB Data, Pages, Rows ____________________________________________ Data Reads 2.84k 0.0/s Writes 335 0.0/s fsync 258 0.0/s Pending Reads 0 Writes 0 fsync 0 Pages Created 1 0.0/s Read 2.83k 0.0/s Written 146 0.0/s Rows Deleted 15 0.0/s Inserted 25 0.0/s Read 9.92k 0.0/s Updated 84 0.0/s - For more information on how to read these results, please visit The Guide To Understanding mysqlreport.
Resources
User Comments
No visitor comments posted. Post a comment
Fields marked with an asterisk(*) are required. Comment on this article