orderbynull / lottip Goto Github PK

Hi,
Thank you for this great application. It is very useful to have overall view on query profiling of mysql DB.

Since there is no Wiki page, I used Issues panel to ask this question. Is it possible to filter queries by USER on this app? For example; I want to know queries executed by a specific user X. Can this application handle this?

I have tens of mysql DB running for a realtime application and there are 5 admin accounts who have root privileges on those and I want to track each user action. I know this can be done via general.log or slow.log, however it impacts performance dramatically.

Currently I used Mysql-Proxy as workaround. Having such a feature as GUI will be very helpful indeed.

Regards.

Hi,

I wanted to ask your opinion on the production readiness of the proxy. I would like to run it between hundreds of clients and multiple databases including replicas.

Do you think it can handle handle this with grace?

Do you plan on having lottip be modular so that one can easily add new RDBMS (some sort of interface-based API)? Doing so would make it easier for individuals to add support for new RDBMS.

A query is being cut-off. The query in question is over 14580 characters long. It's also left in a permanent pending state.

I tried forking your project and increasing both the pingPeriod and writeDeadlinePeriod with no help to the problem.

Hello, thanks for the great tool!
I tested it with Laravel and it works fine but I have some proposals and it would be nice if you consider some of them for future release.

• Ability to see query duplicates for each session (by query text and by query text + PDO parameters combination). It would help to optimize query caching or eager loading of ORM relationships.
• Ability to change sort order of session (newest on top)
• Display total time and total queries for each session.
• Display each session as table row and open details on click (or even in new tab). Now interface is overloaded if we have many sessions. Ideally if we can sort sessions by total time, total queries, session start time and so on by click on table header. Total values of each parameter in the table bottom.
• Display query time with more digits after point (because now most of them are 0.00s). Maybe abitility to change units to milliseconds.
• Add EXPLAIN in query menu for SELECT queries.
• Ability to view and copy full query without ? (with replaced bindings)
• Top queries by count for all sessions to see most required queries.
• Display information about MySQL server: version, uptime, etc.
• Ability to hide / ignore queries by substring
• Ability to show only slow queries by specify time limit (slow log emulation)
• Open GUI in default browser on startup.
• JSON config ability (instead of passing CLI options)

Thanks!

In proxy.go you're doing all kinds of unsafe map operations. The program panics almost immediately when I try to run under any load. Please have a look at https://golang.org/doc/faq#atomic_maps . If I have a chance to put in PR with a fix I will, but haven't had time just yet. One common approach would be to add a sync.Mutex (or sync.RWMutex) and use that around map access calls.