The latest from the MySQL community

First it was Oracle buying Innobase (though Oracle has so far played fair). Now it's IBM buying Solid Information Technology. Given much of the proprietary world's public attitude toward open source ("Open source a threat? What's open source?), it's surprising that IBM would even bother to hedge its bets against MySQL.

After all, who's afraid of little MySQL? I mean, who besides everyone with a database business that depends on lock-in, overpriced licenses, and 20th Century software? Matthew Aslett doesn't think this was targeted at MySQL, and he's likely right. But it impacts MySQL all the same, as the New York Times …

This is not a HOWTO, but more a RFC. I'm in the need for a portable, fast build-system. For lighttpd, for MySQL Proxy, ...

I need what autotools + gmake do, just in a portable (yes, including windows) and fast way. Up to now I tried SCons and cmake as alternatives and both fell short in important categories (like make dist).

If you are reading this blog since a while you know what comes next: Let's write a full replacement in LUA.

Requirements

I like what the autotools (automake, autoconf and libtool) do. From the users point of view it is:

$ ./configure ...
$ make 
$ make install

With automake you also get:

$ make uninstall
$ make dist
$ make distcheck

Especially the distcheck target is very neat if you are a packager …

So current benchmark run:

generate_hsieh_consistent

Testing generate_data                                    6.983 [ ok ]
Testing get_read                                         5.545 [ ok ]
Testing delete_generate                                  5.143 [ ok ]
Testing generate_data                                    7.173 [ ok ]
Testing mget_read                                        1.369 [ ok ]
Testing mget_read_result                                         1.379 [ ok ]
Testing mget_read_function                                       1.308 [ ok ]
Testing mdelete_generate                                         1.001 [ ok ]
Testing cleanup                                  0.047 [ ok ]

I've added this function:

memcached_return memcached_fetch_execute(memcached_st *ptr,
                                              unsigned int (*callback[])(memcached_st *ptr, memcached_result_st *result, void …

This is not a HOWTO, but more a RFC. I'm in the need for a portable, fast build-system. For lighttpd, for MySQL Proxy, ...

I need what autotools + gmake do, just in a portable (yes, including windows) and fast way. Up to now I tried SCons and cmake as alternatives and both fell short in important categories (like make dist).

If you are reading this blog since a while you know what comes next: Let's write a full replacement in LUA.

Requirements

I like what the autotools (automake, autoconf and libtool) do. From the users point of view it is:

$ ./configure ...
$ make 
$ make install

With automake you also get:

$ make uninstall
$ make dist
$ make distcheck

Especially the distcheck target is very neat if you are a packager and …

I've written before about how to figure out which connection is holding the InnoDB locks for which other connections are waiting. In other words, how to figure out who's blocking you from getting work done. The short and sweet: turn on the InnoDB lock monitor and use innotop to look at the locks held and waited-for. This has some disadvantages, so I made a patch to solve the issue the way I like it. The result is significantly more ability to find and solve InnoDB lock wait issues.

Today's entry, provided by Luke Welling, is entitled Following the Big Dogs on Web Application Security.

Name

Luke Welling

Blog

lukewelling.com

Biography

Luke Welling is from Melbourne, Australia, but currently lives near Washington, DC, where he ekes out a living as a security nerd at OmniTI. He sees lots of good PHP and bad PHP, and tries to write more good than bad. Over the last decade, he has applied PHP in many places where it was intended, and in many places where it was never meant to go. With his wife Laura, he wrote the bestselling book PHP and MySQL Web Development and often speaks about PHP at conferences and user groups. His hobbies …

JRuby 1.0.3 was recently released and so was Rails 2.0. I decided to try JRuby 1.0.3 + Rails 2.0 and realized that a few additional steps (because of Rails 2.0) are required to get a trivial Hello World applcation up and running. Here are the steps:

1. Unzip JRuby 1.0.3.
   1. Make sure to set JAVA_HOME and JRUBY_HOME.
   2. Also include JAVA_HOME/bin and JRUBY_HOME/bin in PATH for convenience.
2. Install Rails 2.0 as shown below:
   
   …

PING mysqlnd.team (MySQL) - 56(84) bytes of data
64 bytes from mysqlnd.team - icmp_seq=1 ttl=3weeks time=1month

Yes, there are delays. But not for the reason that we are having any problems. We have been borrowed out to other teams recently. A short status report.

PONG from mysqlnd.team

Andrey could not resist and has continued researching on parallel and background query operation. Georg was not too happy about this. Not that Georg does not support the idea, no, but Andrey had some other urgent assignments. Well, Andrey sometimes works in sort of waves: do little for some time, hack like crazy on other days. Again, Miha Nedok from http://www.izklop.com/, our alpha-beta-everything-tester number one, has given Andrey’s code studies a test drive and he did not regret it. However, I haven’t tested anything myself. I cannot …

PING mysqlnd.team (MySQL) - 56(84) bytes of data
64 bytes from mysqlnd.team - icmp_seq=1 ttl=3weeks time=1month

Yes, there are delays. But not for the reason that we are having any problems. We have been borrowed out to other teams recently. A short status report.

PONG from mysqlnd.team

Andrey could not resist and has continued researching on parallel and background query operation. Georg was not too happy about this. Not that Georg does not support the idea, no, but Andrey had some other urgent assignments. Well, Andrey sometimes works in sort of waves: do little for some time, hack like crazy on other days. Again, Miha Nedok from http://www.izklop.com/, our alpha-beta-everything-tester number one, has given Andrey’s code studies a test drive and he did not regret it. However, I haven’t tested anything myself. I cannot …

Welcome readers to the seventy-sixth edition of Log Buffer, the weekly review of database blogs. As I mentioned in LB#75, this is Yule Log Buffer, a special edition for the busy holiday season. In lieu of a full edition, I’m throwing this one open to you, gentle readers, by asking for your [...]