Want to be debug all the raw MySQL statements sent to your MySQL box?

Just use wireshark.

In fact… here’s the magical command you need to run:


apt-get install apt-get install tshark


… now the command line version of wireshark is installed.

Now you can just start dumping the SQL commands running against your sever:


tshark -i 1 -T text -V -f ‘dst port 3306′ |grep -i ’statement: ‘ | cut -b20-


This will then dump all the SQL running against your server. For example:

SELECT COUNT( * ) FROM FOO WHERE FOO.ID = 'k~OVOe8XfxM'
SHOW COLLATION
SET autocommit=1
SHOW SLAVE STATUS /* lbpool */
SHOW PROCESSLIST /* lbpool */
SHOW SLAVE STATUS /* lbpool */
SHOW PROCESSLIST /* lbpool */
SELECT COUNT( * ) FROM FOO WHERE FOO.ID = 'dpm516E79n0'
SELECT COUNT( * ) …

I was with a customer last week, who leads technology and operations for one of the world's largest companies. We were talking through his priorities for the upcoming year, and on a page filled with various traditional priorities (consolidation, energy management, disaster recovery, regulatory compliance) were two interesting words.

"Open Source."

I asked what that meant, why it was there. He said they'd done an audit of the firm's development activities, and found an overwhelming number ("hundreds") of open source

projects that had been completed behind the scenes, beyond management's oversight. The projects were designed to solve problems deemed too expensive or difficult to solve with proprietary technologies - from meeting a tough budget, to automating a new process. And rather than fight the trend, they figured it was …

MySQL is generally an all-around kickass piece of software, and like any good open source application, there are a host of tools you can use to squeeze every last drop of goodness out of it. Nearly all of them, however, are geared towards the operational DBA, leaving the wayward developer out in the cold.

Lately I’ve been working on optimizing our stored procedure library which is primarily responsible for generating all sorts of fancy reports for the users. We use lots of nested procedure calls and finding potential targets for optimization is a tricky and time consuming job. Enter Ghetto Profile.

It’s still pretty basic but gets the job done. How’s it work?

1
2
3

ghetto_profile.rb --attach crappy_code.sql
mysql < crappy_code.sql
ghetto_profile.rb --stats -uroot …

Is Microsoft irrelevant? Perhaps according to some folks at OSCON. READ MORE

This MySQL event with Kaj Arno was well received. Kaj talked about the product, from different aspects, both technical and business with bit of short history, how the community could contribute, how safe MySQL at the hands of Sun, etc. It was very engaging and informative.

In his typical style of localising presentations beyond english , he started the presentations with speaking couple of sentences in few local languages: Kannada, Tamil and Hindi. The audiences were pleasantly surprised and this received huge applause.

I talked about specifically how to contribute code to MySQL-- how to get started with a focus to contribute code. I put lots of urls through out the presentation and I promised to make the slides available through my blog. Here is the slides uploaded to slideshare.net :

…

This MySQL event with Kaj Arno was well received. Kaj talked about the product, from different aspects, both technical and business with bit of short history, how the community could contribute, how safe MySQL at the hands of Sun, etc. It was very engaging and informative.

In his typical style of localising presentations beyond english , he started the presentations with speaking couple of sentences in few local languages: Kannada, Tamil and Hindi. The audiences were pleasantly surprised and this received huge applause.

I talked about specifically how to contribute code to MySQL-- how to get started with a focus to contribute code. I put lots of urls through out the presentation and I promised to make the slides available through my blog. Here is the slides uploaded to slideshare.net :

…

Back in May 2006, I have started my blog using the Blogger platform and one month later moved it to my own website using Wordpress. Couple month later, I joined Pythian and, since then, the vast majority of my blogging activities has been on the Pythian Group Blog.

The Pythian blog has grown significantly since then and many more excellent authors started blogging there. While the Pythian blog was mostly focused on Oracle database just a couple years ago, it’s has got very broad coverage now and is including MySQL, SQL Server and Oracle databases as well as Oracle Application Server, Oracle eBusiness Suite and …

Lewis Cunningham is running a survey to discover which databases people are using, and in which contexts. Lewis wanted to do an open survey, meaning not only would the results be published but all of the data behind the published results would be open, as well.

It's a noble ...

John F. Duffy, a professor of Law at The George Washington University Law School, recently wrote that the United States Patent and Trademark Office has increasingly taken stands on patents that "will invalidate many and perhaps most software patents." If only.

Duffy worries that "the PTO's new interpretation of ...

Yesterday I attended the Franken Web Montag meetup in Nürnberg. This time the nice folks at insertEFFECT hosted us and opened up their terrasse.
Florian Bailey opened with a talk about Facebook applications. It was quite interesting. To me these applications are just annoying, but I can see now how they are used, and how success can mean making money within Facebook. They made also a test application called 'Who is the Kitchen Master?' (needs account).
I did also try to talk about something, but I …