So, you have a binlog. You want to find out something specific that happened inside of it. What to do? mysqlbinlog has some neat features, which I thought we would look at here.

I should first explain what mysqlbinlog really is. It is a tool that lets you analyze and view the binlogs/relaylogs from mysql, which are stored in binary format. This tool converts them to plaintext, so that they’re human-readable.

For the first tip, let’s start with the --read-from-remote-server option, which allows you to examine a binlog on a master server in order, perhaps, to dump it onto your slave and compare master/slave logs for potential problems*.

$ mysqlbinlog --read-from-remote-server -uwesterlund -p mysql-bin.000001 -h 127.0.0.1 -P 3306 | head -5
Enter password:
/*!40019 SET …

On Saturday, I spent a couple of hours running with Alexander Stubb. No, Alex is not our newest recruit to the MySQL Support Team, he’s the Foreign Minister of Finland (the guy in the yellow T-shirt below).

But let me rewind to the beginning. I have been increasing my running to over 1200 km a year, and when I heard that the Münchner Stadtlauf half-marathon doesn’t crash with Finnish midsummer (something never to be missed), I registered for it and finished it in 1:45:58. And I calculated I would have a chance at going below four hours at a …

Project: MySQL Forge RSS/Atom feeds

Note: I was on vacation for the last 2 weeks (10+11) and didn't have internet access, so this report is a little later than it should be.

KEY ACCOMPLISHMENTS LAST WEEKS

* Installing SeleniumRC.
* Writing basic SeleniumRC test script for the Forge.
* Writing PHPUnit tests for all HiPPo classes.

KEY TASKS THAT STALLED LAST WEEK

* None

KEY CONCERNS
* None

TASKS IN THE UPCOMING WEEK

* Prepare for extending the SeleniumRC test script to cover a larger part of the Forge.
* Submitting the Final Student Survey.

I would like to thank Google, MySQL and specially my mentor Jay for the opportunity to collaborate in the open source community and let me contribute something which will be useful in the future to many other open source hackers I hope.

For me, GSOC was a learning experience. I feel that I’ve learned more

from doing this than I have over the course of all my university

classes. So for me, the things that I’ve learned break down as

follows:

Technical things:

1. Installed cygwin and learnt some basic stuff regarding cygwin. Have never really used cygwin before.

2. Learnt how to use bkclient for downloading mysql source code which was replaced by bazaar in the middle of GSOC. Again I have never realy used a distributed version control system.

3. Learnt how to use bazaar which has more functionality than bkclient

4. Downloaded the mysql source code and built it on Windows as well as Linux.

5. Learnt how to debug the mysql source on Windows using Visual Studio …

For me, GSOC was a learning experience. I feel that I’ve learned more

from doing this than I have over the course of all my university

classes. So for me, the things that I’ve learned break down as

follows:

Technical things:

1. Installed cygwin and learnt some basic stuff regarding cygwin. Have never really used cygwin before.

2. Learnt how to use bkclient for downloading mysql source code which was replaced by bazaar in the middle of GSOC. Again I have never realy used a distributed version control system.

3. Learnt how to use bazaar which has more functionality than bkclient

4. Downloaded the mysql source code and built it on Windows as well as Linux.

5. Learnt how to debug the mysql source on Windows using Visual Studio …

I keep seeing this posts by some of the manager types on planet MySQL about how they or some other guy is worrying about open source vendors not raking in billions or are not stealing billions of money out of peoples pockets that should not be playing on the stock market and things along those lines. While I do agree that its great to see open source software flourish .. actually let me clear that up, why do I even care if open source software flourishes? I care because I think open source software enables a different kind of growth for society, one that is shared, one that lowers barriers, one that I feel is more in tune with a world at peace.

Of course I want people that take part in this to be able to provide themselves and their families a decent life. But the fact of the matter is, these people do not need …

Week 9 (21st – 28th July)

Key Accomplishments Last Week

1. Read about the mysql Benchmarking suite and the importance of this suite for mysql.
2. Covered the chapter on Debugging in “Expert Mysql” by Charles A.Bell.
3. The chapter on debugging helped me to get to speed to debug mysql source code on Windows using Visual Studio
4. I also practiced debugging mysql on Linux using ddd and gdb.
5. P.S. I would like to thank Brian, Collin and Leslie for their patience and support. If God wills, I should start some serious hacking very soon.

Key Tasks that stalled last Week

• 1. Installation of perl interface for executing the Benchmarking suite
     1. Have some issues with the DBD::mysql module on cygwin …

Week 9 (21st – 28th July)

Key Accomplishments Last Week

1. Read about the mysql Benchmarking suite and the importance of this suite for mysql.
2. Covered the chapter on Debugging in “Expert Mysql” by Charles A.Bell.
3. The chapter on debugging helped me to get to speed to debug mysql source code on Windows using Visual Studio
4. I also practiced debugging mysql on Linux using ddd and gdb.
5. P.S. I would like to thank Brian, Collin and Leslie for their patience and support. If God wills, I should start some serious hacking very soon.

Key Tasks that stalled last Week

• 1. Installation of perl interface for executing the Benchmarking suite
     1. Have some issues with the DBD::mysql module on cygwin …

One of the cardinal rules of writing web applications is to escape user-generated input with functions like PHP’s real_escape_string. This is a great rule, but one that can have a negative impact on your application’s performance if used unnecessarily. For instance, when querying data with an integer parameter that is passed internally (not [...]

Whitehurst is focused on growing Red Hat's top line; will open source purists cheer him on? READ MORE