MySQLsla
So, going way off topic here, I was worried about some slow SQL queries, and, logs being mighty useless, I looked for a slow-sql log analyzer. In steps mysqlsla. Woo hoo, plain, simple, and to the point. Found out some weird queries that I can’t even find with a simple grep are some of the slowest.
Which leads me to my next problem, I need a search engine for source code, gonzui turns up in a quick freshmeat search. I’m running the import on the directories now, and I’ll let you know how it turns out!
Finding small SQL queries that take a long time(and need to be questioned of their existence before they are optimized) in old, old code mixed with new code and not-as-new code, is not easy.
Write a comment