My previous post contained a lua script for MySQL proxy that would generate benchmarking information. However, just days (or maybe hours?) after I published it, release 0.7 of mysql-proxy was published, making my script obsolete. I’ve fixed this (it needed just a minor tweak), so here‘s a tarball with the following: trace.lua, which is the […]

Related posts:

1. Using MySQL Proxy to benchmark query performance By transparently sitting between client and server on each request,...
2. New release of MySQL Proxy GPL MySQL Proxy has a new release, just three days ago,...
3. …

With the introduction of MySQL Connector/C++, now C++ application developers have one additional option to choose from, to connect to MySQL Server 5.1 or later from a C++ application. Admittedly, as of today, there isn't enough documentation with examples to show the capabilities [and gotchas] of MySQL Connector/C++. I tried to fill that gap with the technical article, Developing Database Applications Using MySQL Connector/C++. Hopefully it serves as a starting point for the C++ developers while waiting for the MySQL Connectors documentation team to publish the official documentation on MySQL Developer Zone.

While you are at it, don't forget to check the supplement document, Installing MySQL Connector/C++ from Source, in case if you …

With the introduction of MySQL Connector/C++, now C++ application developers have one additional option to choose from, to connect to MySQL Server 5.1 or later from a C++ application. Admittedly, as of today, there isn't enough documentation with examples to show the capabilities [and gotchas] of MySQL Connector/C++. I tried to fill that gap with the technical article, Developing Database Applications Using MySQL Connector/C++. Hopefully it serves as a starting point for the C++ developers while waiting for the MySQL Connectors documentation team to publish the official documentation on MySQL Developer Zone.

While you are at it, don't forget to check the supplement document, Installing MySQL Connector/C++ from Source, in case if you …

Giri, has done a very nice job creating a tutorial on using MySQL Connector/C++.

This Connector is modeled after JDBC making it very easy to access MySQL using C++.

Giri, has done a very nice job creating a tutorial on using MySQL Connector/C++.

This Connector is modeled after JDBC making it very easy to access MySQL using C++.

Giri, has done a very nice job creating a tutorial on using MySQL Connector/C++.

This Connector is modeled after JDBC making it very easy to access MySQL using C++.

Sometimes a MySQL server running InnoDB takes a long time to shut down. The usual culprit is flushing dirty pages from the buffer pool. These are pages that have been modified in memory, but not on disk.

If you kill the server before it finishes this process, it will just go through the recovery phase on startup, which can be even slower in stock InnoDB than the shutdown process, for a variety of reasons.

One way to decrease the shutdown time is to pre-flush the dirty pages, like this:

PLAIN TEXT CODE:

1. mysql> set global innodb_max_dirty_pages_pct = 0;

Now run the following command:

…

Sorry for the delay, as you can see I'm not a proficient blogger. :)

Anyway, I'd like to point out that in the last months I've delivered many new Italian webinars on interesting topics. The full list of recorded webinars can be found here:

http://www.mysql.it/news-and-events/on-demand-webinars/

Anyway it's worth to mention the latest like:

• Migliorate le prestazioni con MySQL Query Analyzer;
• Migrazione a MySQL, fa per voi; 
• Come scalare MySQL con Sun Systems;

Many others are coming. Hint: Data Warehousing is one of the most interesting field for MySQL!

See you soon.

Luca 

The Kickfire MySQL Appliance is offically launched!

We just announced today, along with a new customer, and strategic partnerships with ten leading service companies including Percona, the MySQL performance experts.

Look for more news next week from Kickfire as we head into the MySQL conference. Kickfire will also give a keynote on the first day of the conference and will make a surprise announcement! Stay tuned …

I’ll be travelling all over the US to talk about CouchDB and meet the community for hacking & fun. If you’d like to meet & greet & talk about anything CouchDB, get in touch.

The “tour dates” are:

April 19th – 22nd: CouchHack, Asheville, NC

CouchHack.org is a four-day hacker event featuring 4/7th of the CouchDB developer group including original author Damien Katz. But you can also meet Paul Davis and J Chris Anderson.

We’ll be hacking on cutting-edge CouchDB features and help everybody there to get up to speed with CouchDB usage and internal development.

It’s a free event, just go to the …