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 Mandalika has written an article showing how to develop C++ database applications for MySQL and another article showing how to install MySQL Connector/C++ from the source.

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