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 [...]

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 …

My first Podcast, yeah!

Early the a week I recorded a short introduction to CouchDB for PHP Abstract.

If you like to quote, or copy or anything (after all this is under a Creative Commons license), here’s the transcript:

CouchDB

CouchDB is a new database system that breaks with a lot of traditions. Prepare to be confused or even offended. While a lot is different from traditional data management systems, the core concepts should be familiar to you.

Try to forget, just for a moment, all you know about SQL, relations, replication and all simple and advanced techniques you use to solve your problems when it comes to data storage. Instead, remember the days when you were a beginning PHP developer (if you are a beginner, perfect). …

I have been talking about many theories in the past and in my last post, I decided to start doing something instead of just talking about it.
So here we go..

Adding a Business Rule

We need to start adding some logic-rules to the database. There are two ways you can do this:

1. To create a View with IFs and other functions - this will process the data every time to give you the results

2. To save the result of the logic to the database table using a trigger - this might save some of the repeating processes but will take up more space and might slow things down during new inserts.

Both of these, you can do in your application right now. You can make a complicated …

Just when I thought I?d be in for a quiet last day in the office before Christmas? IBM has announced that it is to acquire in-memory database specialist Solid Information Technology in a move that sees it competing directly up against the TimesTen functionality that Oracle acquired in June 2005.

The aqcuisition also has implications for MySQL given Solid’s development of the SolidDB for MySQL engine, an optional replacement for InnoDB (also of course acquired by Oracle).

While MySQL is in the firing line, it does not appear to be the intended …