Atlas/lib/histogram.lua at master · JavaDevelopRep/Atlas · GitHub

History

192 lines (159 loc) · 5.04 KB

Raw

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

--[[ $%BEGINLICENSE%$

This program is free software; you can redistribute it and/or

modify it under the terms of the GNU General Public License as

published by the Free Software Foundation; version 2 of the

License.

This program is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

GNU General Public License for more details.

You should have received a copy of the GNU General Public License

along with this program; if not, write to the Free Software

Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA

02110-1301 USA

$%ENDLICENSE%$ --]]

local tokenizer = require("proxy.tokenizer")

local parser = require("proxy.parser")

local commands = require("proxy.commands")

local auto_config = require("proxy.auto-config")

-- init global counters

if not proxy.global.config.histogram then

proxy.global.config.histogram = {

collect_queries = true,

collect_tables = true

}

end

-- init query counters

if not proxy.global.norm_queries then

proxy.global.norm_queries = { }

end

-- init table-usage

if not proxy.global.tables then

proxy.global.tables = { }

end

function read_query(packet)

local cmd = commands.parse(packet)

local r = auto_config.handle(cmd)

if r then return r end

if cmd.type == proxy.COM_QUERY then

local tokens = assert(tokenizer.tokenize(cmd.query))

local norm_query = tokenizer.normalize(tokens)

-- print("normalized query: " .. norm_query)

if norm_query == "SELECT * FROM `histogram` . `queries` " then

proxy.response = {

type = proxy.MYSQLD_PACKET_OK,

resultset = {

fields = {

{ type = proxy.MYSQL_TYPE_STRING,

name = "query" },

{ type = proxy.MYSQL_TYPE_LONG,

name = "count" },

{ type = proxy.MYSQL_TYPE_LONG,

name = "max_query_time" },

{ type = proxy.MYSQL_TYPE_FLOAT,

name = "avg_query_time" },

}

local rows = {}

if proxy.global.norm_queries then

for k, v in pairs(proxy.global.norm_queries) do

rows[#rows + 1] = {

v.count,

v.max_query_time,

v.avg_query_time,

}

end

proxy.response.resultset.rows = rows

return proxy.PROXY_SEND_RESULT

elseif norm_query == "DELETE FROM `histogram` . `queries` " then

proxy.response = {

type = proxy.MYSQLD_PACKET_OK,

}

proxy.global.norm_queries = {}

return proxy.PROXY_SEND_RESULT

elseif norm_query == "SELECT * FROM `histogram` . `tables` " then

proxy.response = {

type = proxy.MYSQLD_PACKET_OK,

resultset = {

fields = {

{ type = proxy.MYSQL_TYPE_STRING,

name = "table" },

{ type = proxy.MYSQL_TYPE_LONG,

name = "reads" },

{ type = proxy.MYSQL_TYPE_LONG,

name = "writes" },

}

local rows = {}

if proxy.global.tables then

for k, v in pairs(proxy.global.tables) do

rows[#rows + 1] = {

v.reads,

v.writes,

}

end

proxy.response.resultset.rows = rows

return proxy.PROXY_SEND_RESULT

elseif norm_query == "DELETE FROM `histogram` . `tables` " then

proxy.response = {

type = proxy.MYSQLD_PACKET_OK,

}

proxy.global.tables = {}

return proxy.PROXY_SEND_RESULT

end

if proxy.global.config.histogram.collect_queries or

proxy.global.config.histogram.collect_tables then

proxy.queries:append(1, packet)

return proxy.PROXY_SEND_QUERY

end

function read_query_result(inj)

local cmd = commands.parse(inj.query)

if cmd.type == proxy.COM_QUERY then

local tokens = assert(tokenizer.tokenize(cmd.query))

local norm_query = tokenizer.normalize(tokens)

if proxy.global.config.histogram.collect_queries then

if not proxy.global.norm_queries[norm_query] then

proxy.global.norm_queries[norm_query] = {

count = 0,

max_query_time = 0,

avg_query_time = 0

}

end

-- set new max if necessary

if inj.query_time > proxy.global.norm_queries[norm_query].max_query_time then

proxy.global.norm_queries[norm_query].max_query_time = inj.query_time

end

-- build rolling average

proxy.global.norm_queries[norm_query].avg_query_time =

((proxy.global.norm_queries[norm_query].avg_query_time * proxy.global.norm_queries[norm_query].count) +

inj.query_time) / (proxy.global.norm_queries[norm_query].count + 1)

proxy.global.norm_queries[norm_query].count = proxy.global.norm_queries[norm_query].count + 1

end

if proxy.global.config.histogram.collect_tables then

-- extract the tables from the queries

tables = parser.get_tables(tokens)

for table, qtype in pairs(tables) do

if not proxy.global.tables[table] then

proxy.global.tables[table] = {

reads = 0,

writes = 0

}

end

if qtype == "read" then

proxy.global.tables[table].reads = proxy.global.tables[table].reads + 1

else

proxy.global.tables[table].writes = proxy.global.tables[table].writes + 1

end

Atlas/lib/histogram.lua at master · JavaDevelopRep/Atlas · GitHub

Uh oh!

Expand file tree

Breadcrumbs

histogram.lua

Latest commit

History

Breadcrumbs

histogram.lua

File metadata and controls