RedHat mysqlreport installation Configuration

ArticleDirectory

• I. Software Packages

I. Software Packages

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

DBD-mysql-4.014.tar.gz

Mysqlreport-3.5.zip

Ii. Installation Steps

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 performance monitoring:

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.00 K of 16.00 M % used: 0.09

17. Current 1.86 M % 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 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 per second

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.0 m

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.49 M 4.3 K/s

78. Received 80.19 K 98.8/s

79.

80. _ InnoDB buffer pool __________________________________________________

81. Usage 320.00 K of 8.00 m % 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