Redhat MysqlReport安装配置详解

一、软件包

perl-DBI-1.52-1.fc6.i386.rpm

DBD-mysql-4.014.tar.gz

mysqlreport-3.5.zip

二、安装步骤

1. Rmp –ivh perl-DBI-1.52-1.fc6.i386.rpm

2. Tar zxvf DBD-mysql-4.014.tar.gz

3. Cd DBD-mysql-4.014.tar.gz

4. perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config

5. make

6. make test

7. make install

8. unzip mysqlreport-3.5.zip

9. cd mysqlreport-3.5

10. cp mysqlreport /usr/local/mysql/bin

11. ./mysqlreport --user=root –password

12. Mysql 性能监控情况如下

13. MySQL 5.0.27-log uptime 0 0:13:32 Thu Jun 10 11:22:11 2010

14.

15. __ Key _________________________________________________________________

16. Buffer used 14.00k of 16.00M %Used: 0.09

17. Current 1.86M %Usage: 11.60

18. Write hit 0.00%

19. Read hit 99.04%

20.

21. __ Questions ___________________________________________________________

22. Total 787 1.0/s

23. COM_QUIT 315 0.4/s %Total: 40.03

24. DMS 306 0.4/s 38.88

25. Com_ 203 0.2/s 25.79

26. -Unknown 37 0.0/s 4.70

27. Slow 10 s 0 0/s 0.00 %DMS: 0.00 Log: OFF

28. DMS 306 0.4/s 38.88

29. SELECT 285 0.4/s 36.21 93.14

30. UPDATE 21 0.0/s 2.67 6.86

31. REPLACE 0 0/s 0.00 0.00

32. DELETE 0 0/s 0.00 0.00

33. INSERT 0 0/s 0.00 0.00

34. Com_ 203 0.2/s 25.79

35. show_fields 200 0.2/s 25.41

36. show_variab 1 0.0/s 0.13

37. show_status 1 0.0/s 0.13

38.

39. __ SELECT and Sort _____________________________________________________

40. Scan 370 0.5/s %SELECT: 129.82

41. Range 82 0.1/s 28.77

42. Full join 0 0/s 0.00

43. Range check 0 0/s 0.00

44. Full rng join 0 0/s 0.00

45. Sort scan 87 0.1/s

46. Sort range 0 0/s

47. Sort mrg pass 0 0/s

48.

49. __ Table Locks _________________________________________________________

50. Waited 0 0/s %Total: 0.00

51. Immediate 419 0.5/s

52.

53. __ Tables ______________________________________________________________

54. Open 20 of 64 %Cache: 31.25

55. Opened 26 0.0/s

56.

57. __ Connections _________________________________________________________

58. Max used 2 of 100 %Max: 2.00

59. Total 317 0.4/s

60.

61. __ Created Temp ________________________________________________________

62. Disk table 200 0.2/s

63. Table 205 0.3/s Size: 32.0M

64. File 5 0.0/s

65.

66. __ Threads _____________________________________________________________

67. Running 1 of 1

68. Cached 0 of 0 %Hit: 0.32

69. Created 316 0.4/s

70. Slow 0 0/s

71.

72. __ Aborted _____________________________________________________________

73. Clients 0 0/s

74. Connects 37 0.0/s

75.

76. __ Bytes _______________________________________________________________

77. Sent 3.49M 4.3k/s

78. Received 80.19k 98.8/s

79.

80. __ InnoDB Buffer Pool __________________________________________________

81. Usage 320.00k of 8.00M %Used: 3.91

82. Read hit 95.71%

83. Pages

84. Free 492 %Total: 96.09

85. Data 20 3.91 %Drty: 0.00

86. Misc 0 0.00

87. Latched 0 0.00

88. Reads 303 0.4/s

89. From file 13 0.0/s 4.29

90. Ahead Rnd 1 0.0/s

91. Ahead Sql 0 0/s

92. Writes 0 0/s

93. Flushes 0 0/s

94. Wait Free 0 0/s

95.

96. __ InnoDB Lock _________________________________________________________

97. Waits 0 0/s

98. Current 0

99. Time acquiring

100. Total 0 ms

101. Average 0 ms

102. Max 0 ms

103.

104. __ InnoDB Data, Pages, Rows ____________________________________________

105. Data

106. Reads 26 0.0/s

107. Writes 3 0.0/s

108. fsync 3 0.0/s

109. Pending

110. Reads 0

111. Writes 0

112. fsync 0

113.

114. Pages

115. Created 0 0/s

116. Read 20 0.0/s

117. Written 0 0/s

118.

119. Rows

120. Deleted 0 0/s

121. Inserted 0 0/s

122. Read 0 0/s

123. Updated 0 0/s