A slow query logs parser in Golang.
go get github.com/devops-works/slowql
In a nutshell, you can use it as follows:
package main
import (
"fmt""github.com/devops-works/slowql"
)
funcmain() {
// Imagine that fd is an io.Reader of your slow query logs file...// Create the parserp:=slowql.NewParser(slowql.MySQL, fd)
// Get the next query from the logq, err:=p.GetNext()
iferr!=nil {
panic(err)
}
// Do your stuff, for example:fmt.Printf("at %d, %s did the request: %s\n", q.Time, q.User, q.Query)
fp, err:=q.Fingerprint()
iferr!=nil {
panic(err)
}
fmt.Printf("the query fingerprint is: %s\n", fp)
srv:=p.GetServerMeta()
fmt.Printf("the SQL server listens to port %d", srv.Port)
}Running the example given in cmd/ without any fmt.Printf against a 292MB slow query logs from a MySQL database provides the following output:
parsed 278077 queries in 8.099622786s
which is approx. 34760 queries/second (Intel i5-8250U (8) @ 3.400GHz).
With this package we created some tools:
- slowql-replayer: replay and benchmark queries from a slow query log
- slowql-digest: digest and analyze slow query logs. Similar to
pt-query-digest, but faster. 🙃
Not all kind of slow query logs have been tested yet:
- MySQL
- MariaDB
- Percona-db
- Percona-cluster (pxc)
Issues and pull requests are welcomed ! If you found a bug or want to help and improve this package don't hesitate to fork it or open an issue 😄
MIT