Dear LazyWeb,

I'm looking for a usable C++ IDE for Linux and I'm wondering if you've seen one. Before you start giving the normal suggestions (Ecliipse, NetBeans, just-use-vi) let start off by saying that I've tried Eclipse, Netbeans and Code::Blocks and KDevelop several times, and that I normally hack in some combination of vi and emacs. (yes yes, I know I'm supposed to religiously pick one and be rude to the other... consider me a postmodern hacker)

For it to be usable by me, it must be able to:

1. Handle the fact that my build is run with autoconf/automake.
2. Properly rename a method and have that show up throughout the codebase.
3. Properly encapsulate a variable with getter/setting methods.
4. Correctly answer the question "where is this method being used"
5. Run without consuming all of my RAM and CPU resources.
6. Quickly and easily open a new project/branch (I have …

One of the things I found missing when I came to MySQL from other databases was a good SQL tracing utility that helped me understand exactly what a long running SQL statement was doing. The inclusion of the SQL Profiler in post 5.0 versions of MySQL helped, but I always felt more could be done.

With InfiniDB, you have some new SQL diagnostic and tracing tools that you can use to get more performance data from SQL statements that don’t seem to be running well.  Let me give yoRead More...

I‘ll be giving a webinar version of a well-received presentation from last year‘s Users Conference tomorrow (November 5th) at 10:00 AM Pacific that covers how to configure MySQL Connector/J to deliver the best performance for your Java application running on MySQL. The session is interactive, and we‘ll be answering questions, so bring those along!

Come spend your morning/afternoon break with me and learn a few new tricks for making your applications fly. The information to sign up is at https://www.mysql.com/news-and-events/web-seminars/display-460.html. Hope to see you there!

This week, I am working on putting together test cases which validate the Drizzle transaction log’s handling of BLOB columns.

I ran into an interesting set of problems and am wondering how to go about handling them. Perhaps the LazyWeb will have some solutions.

The problem, in short, is inconsistency in the way that the NUL character is escaped (or not escaped) in both the MySQL/Drizzle protocol and the MySQL/Drizzle client tools. And, by client tools, I mean both everyone’s favourite little mysql command-line client, but also the mysqltest client, which provides infrastructure and runtime services for the MySQL and Drizzle test suites.

Even within the server and client protocol, there appears to be some inconsistency in how and when things are escaped. Take a look at this interesting output from …

1. ChipHacker -- collaborative FAQ site for electronics hacking. Based on the same StackExchange software as RedMonk's FOSS FAQ for open source software.
2. Democracy Live -- BBC launch searchable coverage of parliamentary discussion, using speech-to-text. One aspect we're particularly proud of is that we've managed to deliver good results for speech-to-text in Welsh, which, we're told, is unique. I think of this as the start of a They Work For You for video coverage. I'd love to be able to scale this to local government coverage, which is disappearing as local newspapers turn into …

One of the things I found missing when I came to MySQL from other databases was a good SQL tracing utility that helped me understand exactly what a long running SQL statement was doing. The inclusion of the SQL Profiler in post 5.0 versions of MySQL helped, but I always felt more could be done.

With InfiniDB, you have some new SQL diagnostic and tracing tools that you can use to get more performance data from SQL statements that don’t seem to be running well.  Let me give yoRead More...

At times you need to install multiple MySQL instances on same machine. This article is a brief step-by-step tutorial on the subject task which is divided into the following main…

The post Install 2 MySQL Server instances replication on Windows first appeared on Change Is Inevitable.

“Show Slave Status” command has a last column “Seconds_Behind_Master”, which gives us idea about how much time slave is lagging behind master. It is an important to be considered parameter…

The post Replication slave lag monitoring using heartbeat and windows batch scripts first appeared on Change Is Inevitable.

Yesterday, I covered how you can do an initial “replication” of data from MySQL to DynamoDB and how this can improve performance, and save storage space. The follow on question becomes:

That’s Great Nick. But how do I do keep my data up to date?

We’ve got data in our Airline Performance dataset through 31-DEC-2007. I loaded 1 year, all of 2007, for the previous example. What happens when the FAA publishes their 2008 January results, and we’ve loaded the new months worth of data into MySQL?

MySQL:

select count(*) from otp.ontime; 8061223
select count(*) from ontime where FlightDate > ’2007-12-31′; 605765
select count(*) from ontime where FlightDate <= ’2007-12-31′; …

I'm pleased to announce the release of Spider storage engine version 2.8(beta).
Spider is a Storage Engine for database sharding.
http://spiderformysql.com/

The main changes in this version are following.
- Add table parameter "link_status".
  You can change link_status using "alter table" statement.
  Spider's link fault management is table level.

Please see "99_change_logs.txt" in the download documents for checking other changes.

Enjoy!