What defines instances for the MySQL Enterprise Monitoring (MEM) software and how do they relate to either other and the workings of MEM? 

What defines instances for the MySQL Enterprise Monitoring (MEM) software and how do they relate to either other and the workings of MEM? 

MySQL Proxy is a really neat tool. I remember a few years back when I first saw Jan talking about it. Back in those days it was significantly different than it 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 you’re using it for something else too, having a man in the middle to catch errors is like standing in the middle of the street and blocking traffic to count the cars on the street. Why don’t you stand on the sidewalk to count the cars instead?

Observing without interrupting

Maybe we can use tcpdump. If you search Google you’ll see lots of examples of using tcpdump and grep to extract queries from the MySQL protocol. These examples usually …

A recent photo from Highload.ru

I said in my last post, that we're interested in speaking at MySQL meetups, and I'm happy to say that the Los Angeles MySQL Meetup has taken us up on the offer.

On November 18th, I'll be giving an introductory talk on InnoDB/XtraDB Performance Optimization.  I will be the second speaker, with Carl Gelbart first speaking on Infobright.

What brings me to LA?  On the same day (18th Nov) I'll be teaching a one day class on Performance Optimization for MySQL with InnoDB and XtraDB.  If you haven't signed up yet - spaces are still available.

Entry posted by Morgan Tocker | …

Most common database used with Rails is mySQL but if you ever need to use SQL Server, here is a quick how to.

I am using  Windows Vista, SQL Server 2008, Rails 2.2.

1)  Install  activerecord-sqlserver-adapter gem

 > gem install activerecord-sqlserver-adapter

2) Create a new Login for this new database (say testuser) using SQL Server Management Studio

3) Create a new database in SQL Server 2008 for your project (say testproject) and choose testuser as Owner

4) Create a …

So you have an old Quasar Microwave from the 80’s or 90’s and it’s time to set back/forward the clocks.

I find myself checking online for instructions every six months and finally tinkering to get the clock changed, so for the records this is how you change the clock on a Quasar Microwave.

To set the time on a Quasar Microwave.

1. Press Hold/Clear.
2. Press the Clock button twice.
3. Press the10 Min and 1 Min buttons until the proper hour is displayed (press 10 min once for 10-12, then 1 min once for 11, twice for 12, etc).
4. Press the 10 Sec and 1 Sec buttons until the proper minute is displayed (i.e. press 10 Sec four times and 1 Sec six times for 46).
5. Press Clock to finish setting the time.

Now to either replace this ancient microwave or contact my local representative to have daylight savings time repealed.

MariaDB 5.1 beta is almost out, so it’s time to cover some of its features. The biggest optimizer feature is MWL#17 Table Elimination.

The basic idea behind table elimination is that sometimes it is possible to resolve the query without even accessing some of the tables that the query refers to. One can invent many kinds of such cases, but in Table Elimination we targeted only a certain class of SQL constructs that one ends up writing when they are querying highly-normalized data.

The sample queries were drawn from “Anchor Modeling”, a database modeling technique which takes normalization to the extreme. The slides at anchor modeling website have an in-depth …

MySQL Proxy is a really neat tool. I remember a few years back when I first saw Jan talking about it. Back in those days it was significantly different than it 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.

Ohloh is a fun site. It automatically collects statistics and show some useful analytics about your subversion projects. They picked up Kontrollbase when they ran an automated scan against the Google Code website and I saw it using Google Alerts with the ‘kontrollbase’ keyword alert. Check out the page they have for Kontrollbase and give [...]

Dave Stokes posted earlier that the official list of MySQL Certified will be going away. There has been a MySQL Certified Professionals LinkedIn group for almost 2 years now. It's community managed by myself and Dave, and is open to all MySQL Certified DBAs & Developers, as well as recruiters & hiring managers.

-- Mark
mark@thetajoin.com
http://www.thetajoin.com - The Drupal Hosting & Performance CompanyMySQL DBA & Programming Blog by Mark Schoonover