MySQL Proxy
SQL Analysis with MySQL Proxy – Part 2
As I outlined in Part 1 MySQL Proxy can be one tool for performing SQL analysis. The impact with any monitoring is the art of monitoring will affect the results, in this case the performance.
Read moreSQL query analysis with MySQL Proxy
Long before there was the official Query Analyzer (QUAN), a component of MySQL Enterprise, SQL analysis was possible using MySQL Proxy . The following is an introduction to logging and query analysis with MySQL Proxy.
Read moreMySQL Proxy lua scripts from presentation
The following Lua scripts are the examples are from my MySQL Proxy @ OSCON 08 presentation. analyze_query.lua MySQL Proxy Analyze Query . Requires MySQL Proxy Logging Module . What is released is the Version for MySQL 5.
Read moreMySQL Proxy @ OSCON 08
Today I presented with Giuseppe Maxia of Sun Microsystems Inc at OSCON 08 on “MySQL Proxy: From Architecture to Implementation”. I was surprised to find that MySQL has a strong showing with a number of presentations this week.
Read moreOff to OSCON
I will be heading to my first OSCON next week where I will be presenting MySQL Proxy: from Architecture to Implementation in conjunction with Giuseppe Maxia . As was written by Colin Charles Our booth is yours… Sun at OSCON , Sun/MySQL would appear to also have a reasonable turnout.
Read moreSpeaking at OSCON
I’ve been accepted to speak at the upcoming 2008 OSCON Conference in Portland Oregon July 21-25 2008, where I’ll be speaking with Giuseppe Maxia on MySQL Proxy . I haven’t seen a schedule yet, so I’m interested if there are any other presenters on MySQL topics!
Read moreMySQL NY Meetup Presentation
Tonight I spoke at the NY MySQL Meetup . The topic “Practical Performance Tips & Tricks” was a full packed 1 hour session, with 4 x 15 minute sections on Beginner, Intermediate, Advanced and MySQL Proxy.
Read moreMySQL Proxy. Playing with the tutorials
I was playing with the 5 sample tutorial Lua scripts available here with the MySQL Proxy , but I was doing something a little inefficiently. I started mysqld, then I started the MySQL Proxy with the lua script, then connected to MySQL via the proxy.
Read moreGot MySQL Proxy yet!
If you haven’t got MySQL Proxy yet, then stop and get it now. Jan announced the release a few days ago of this new product offering from MySQL . I first heard about MySQL Proxy at the recent MySQL Conference 2007 and actually used it a few weeks later to help address slow running queries during benchmarking with a granularity of milliseconds — Wow.
Read moreTop 5 wishes for MySQL
Note: My views are just that: mine. 1. Real time Query Monitoring MySQL 5.0 GA provides only 3 ways to look at queries that are executed on a server in some way or another.
Read more