http://www.chriscalender.com/?p=66 Tips and Solutions for MySQL, MySQL Proxy, and other MySQL-related Topics Wed, 08 Sep 2010 01:48:10 +0000 http://wordpress.org/?v=2.7 hourly 1 http://www.chriscalender.com/?p=66&cpage=1#comment-259 SELECT RAND() » Blog Archive » Upgrading from MySQL 4 – user stories Thu, 07 Jan 2010 16:27:53 +0000 http://www.chriscalender.com/?p=66#comment-259 [...] You may want to log a sample of queries on your older setup and replay them on your new setup to catch the errors. Peter suggested using mk-upgrade in the maatkit tool which is a very sensible choice, also on my end I decided to catch live errors using mysql-proxy and the capture filter function. [...] [...] You may want to log a sample of queries on your older setup and replay them on your new setup to catch the errors. Peter suggested using mk-upgrade in the maatkit tool which is a very sensible choice, also on my end I decided to catch live errors using mysql-proxy and the capture filter function. [...]

]]> http://www.chriscalender.com/?p=66&cpage=1#comment-247 Writing output to a log file using MySQL Proxy « Chris on MySQL Mon, 30 Nov 2009 20:57:05 +0000 http://www.chriscalender.com/?p=66#comment-247 [...] Chris on MySQL Tips and Solutions for MySQL, MySQL Proxy, and other MySQL-related Topics « Capturing Erroneous Queries with MySQL Proxy [...] [...] Chris on MySQL Tips and Solutions for MySQL, MySQL Proxy, and other MySQL-related Topics « Capturing Erroneous Queries with MySQL Proxy [...]

]]> http://www.chriscalender.com/?p=66&cpage=1#comment-242 Log Buffer #168: a Carnival of the Vanities for DBAs | Pythian Group Blog Fri, 06 Nov 2009 17:47:51 +0000 http://www.chriscalender.com/?p=66#comment-242 [...] Mark Leith has been catching erroneous queries, without MySQL proxy, having been inspired by Chris Calender’s post, Capturing Erroneous Queries with MySQL Proxy. [...] [...] Mark Leith has been catching erroneous queries, without MySQL proxy, having been inspired by Chris Calender’s post, Capturing Erroneous Queries with MySQL Proxy. [...]

]]> http://www.chriscalender.com/?p=66&cpage=1#comment-240 Catching erroneous queries, without MySQL proxy at Xaprb Sun, 01 Nov 2009 20:41:49 +0000 http://www.chriscalender.com/?p=66#comment-240 [...] is now, but the concept remains the same: direct your database traffic through a man-in-the-middle. Chris Calender’s post on capturing erroneous queries with MySQL Proxy shows one use for Proxy. But wait. MySQL Proxy is just inspecting the MySQL protocol. And unless [...] [...] is now, but the concept remains the same: direct your database traffic through a man-in-the-middle. Chris Calender’s post on capturing erroneous queries with MySQL Proxy shows one use for Proxy. But wait. MySQL Proxy is just inspecting the MySQL protocol. And unless [...]

]]>