On one of my servers today I noticed some DELETE statements that had been running for more than 14000 seconds due to system locks.

Queries: 180.2M  qps: 1294 Slow:  173.3k         Se/In/Up/De(%):    09/02/33/00
             qps now: 2065 Slow qps: 8.1  Threads:  463 ( 225/ 738) 06/01/49/00
 Cache Hits: 610.9k Hits/s:  4.3 Hits now:   4.1  Ratio:  3.9% Ratio now:  3.3%
 Key Efficiency: 99.2%  Bps in/out: 134.7k/ 1.5M   Now in/out: 203.9k/ 1.3M

      Id      User         Host/IP         DB      Time    Cmd Query or State
      --      ----         -------         --      ----    --- ----------
18951229       www   192.168.1.170     fl_db1     14516  Query DELETE FROM user_
19003358       www   192.168.1.107     fl_db1     14273  Query DELETE FROM user_
19014485       www   192.168.1.105     fl_db1     14221  Query DELETE FROM user_
19117224       www   192.168.1.109     fl_db1     13733  Query DELETE …

To say I have a lot of books is too under value the phrase "a lot".

At last move I had more then 36 crates of books, that was three years
ago. Today? I am not sure, though I have started to catalog all of
them with Delicious Monster.

I even bought the bluetooth barcode scanner :)

Delicious Monster just uses Amazon, so I am at the mercy of Amazon's
database. At this point I have almost all of my computer related
books cataloged (missing about 90 books that I need to complete), and
all of my graphic novels. This means I haven't touched my geology
text books or my science fiction collection.

The problem?

ISBN and UPC.

Namely, Amazon isn't a complete repository. Sure, it misses some
graphic novels, but it has also missed about a dozen O'Reilly
…

Just came across interesting and really disturbing information about MySql :

As you might noticed there are no recent MySQL Community versions available for download from MySQL Download Area This applies both to binaries (which is expected with new polices) but also to the source files which were promised to be available.

So what is if you would like to use recent MySQL code while staying with community version ? I chatted with Monty on this topic today.

So, if you need mysql binaries for new versions you have 2 options:

1. Use your distribution vendor’s builds (in Gentoo, Ubuntu and Debian)
2. or Build your own binaries from …

The yearly PHP community summaries are already appearing throughout the blogosphere. Every year they just get better and better and it becomes clear that the PHP community's accomplishments outshine those of the previous year.

PHP for many years has been the leader in Web development. In the past couple of years though this leadership has become even more noticable. Evans Data Corporation has estimated that over 4.5M developers worldwide use PHP today. Not only is that an impressive number on its own, but when you dig into the numbers you can see that in 2007 PHP is expected to surpass Java in areas like Europe; and that includes all permutations of Java usage including in environments where PHP doesn't attempt to be relevant such as the desktop.

2006 has clearly been a very exciting year for PHP. It comes at a time where the Web, Web applications and Web services …

Brian M, who still has patches to commit, asked me to draw up a
skeleton for a MySQL Engine Project. The goal was to get all of the
Makefiles right and put in just enough of a skeleton to make it easy
to create projects quickly.

URL: http://hg.tangent.org/skeleton-mysql-engine

You will need to do a regular expression edit across all files on
"EXAMPLE" to change the name of the engine. If you aren't licensing
under the GPL you will also need to change the license text and the
pointer to license type in handlerton.

A few things still to do:

1) Make it so you can just drop the directory into the storage/
directory of MySQL and have it compile statically (this is pretty
easy to fix).

2) Maybe rewrite the thing to be a perl script that asks you …

Sheeri Kritzer has published the 25th edition of Log Buffer, the weekly review of database blogs, on The MySQL She-BA. I’d like to wish all our readers and editors a Happy and Peaceful New Year. See you all in 2007! Over to you, Sheeri!

December 29th, 2006 - by Sheeri Kritzer

Welcome to the 25th edition of Log Buffer, the DBA community?s Carnival of the Vanities-style blog of blogs about the database world.

This is the last Log Buffer of calendar year 2006. The database world seems to be a series of series lately, so let’s jump right in:

If, like me, you have no idea what doors and signals are in Solaris 10, you might want to read part 4 of Frank Mash’s “Managing MySQL on Solaris 10″, entitled Solaris Doors and Signals.

On a more theoretical level, Random Notes describes lack of …

From the blogosphere I get this feeling that everyone who writes up
a predictions post for 2007 believes that the iTV is going to be a
hit. Let me describe why it might just suck:

1) DRM. Front Row, the media interface for the Mac, was
useless for me until I found a plugin which would allow me to enable
all video formats. I pull video from the web from many sources. Front
Row was useless until I made it universal. If iTV doesn't allow
consumers to get past whatever DRM Apple has sold its soul for then
its going to be very niche. By niche I mean iTunes store only.

2) Speed. I have a lot of content available via Front Row. The
interface is just slow when it hits a directory with a lot of files
in it. When I push the button on the remote I expect an action to
occur. The current "pause" is just annoying, I think it will drive
…

As you might noticed there are no recent MySQL Community versions available for download from MySQL Download Area This applies both to binaries (which is expected with new polices) but also to the source files which were promised to be available.

So what is if you would like to use recent MySQL code while staying with community version ? I chatted with Monty on this topic today.

Download sources from MySQL FTP Site I have no idea why this location is not advertised on download pages but it really has sources for all recent releases, both for Unix and Windows.

Use MySQL Supplied by Distribution Vendor. Some vendors already offering MySQL 5.0.30 - Gentoo, Ubuntu and Debian at the time of this writing. Fedora might also get update soon.

…