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 more

SQL 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 more

MySQL 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 more

MySQL 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 more

Off 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 more

Speaking 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 more

MySQL 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 more

MySQL 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 more

Got 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 more

Top 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