In the laundry list of items I did today, I pulled the sphinx storage engine code that was just released. I had seen a blog post on its release and I wanted to see how the developers had implemented it.

I have not yet tried the code, I just read through it to see how they implemented it. I had been curious to see how they would do this, since the fulltext code in MySQL is not very well exposed in the storage engine interface (a bit better in 5.1, but not perfect). They took the approach of using a special field in the schema to pass along search queries. This means that you will have to define your tables in exactly their schema format (much how the ha_httplog engine works, though it has a slightly more flexible approach to schema). They reused the Federated connection field to determine location, and did the correct thing of extending the URL mechanism that Federated uses.

They pass the query by identifying the "query" …

So once a week I pull roughly 250,000 RSS feeds in a single snapshot. Its not consistent and only represents what a slice of blogosphere has published at any given time. I've polled websites for years, and more recently URLs/RSS. An article on Business 2.0 got me interested in breaking up the entries by individual word. I was curious to just see how often some words were being mentioned. The Business 2.0 article was on who and what you should not being putting your attention into. It had the "Slashdot is out, and Digg" is in comment.

While I think Digg is a great site, I just do not buy the work Jeremy pointed out on Slashdot vs Digg. Digg may be growing, but I believe that its relevancy is not as high as Slashdot's. I also think that do to the nature of it being an open site with no editorial, eventually it will water down its own effect by being to broad.

The numbers:

mysql> select word_id, word, …

MySQL AB, the developer of the worldâ??s most popular open source database, today announced its participation in the Microsoft Visual Studio Industry Partner (VSIP) program as an Alliance-level partner. With over 240 members, Microsoftâ??s VSIP program gives partners the tools and resources they need to successfully integrate their tools, components and services into the Visual Studio 2005 development environment.

C.J. Blathers about recent major changes in his life.

https://colliertech.com/~cjcollier/confidential/sateOfTheCJ20060625.ogg
https://colliertech.com/~cjcollier/confidential/sateOfTheCJ20060625.mp3

Mail me for credentials.

Jason Maynard of Credit Suisse First Boston, enfant terrible of the software analyst community (well, if you're a proprietary vendor, anyway), is at it again. He's got a great "Mavericks vs. Microsoft" series going, with a June 23, 2006 report coming from a call with Marten Mickos, CEO of MySQL. He makes some interesting points, including:

1. Currently a private company, MySQL is...the world's most popular open source database with more than 8 million active installations.

2. The primary revenue stream for the company comes from the conversion of free downloads of its database product into support contracts. So far, the conversion rate to paying customers runs about 1 for every 1,000 downloads. MySQL’s database has been downloaded close to 100M …

Today we put the finishing touches on another article for the Developer's Zone page. This one centered on how to implement foreign keys via triggers into MySQL. This is important when your application requires referential integrity and the storage engine you'd like to use, as in the case of MyISAM or more specifically NDB (Cluster), does not support this functionality natively.

In the article we cover:

• Restricting INSERTS
• Restricting UPDATES and DELETES
• Cascading UPDATES and DELETES

Some of the advantages of foreign key enforcement include:

• Assuming the proper design of the relationships, foreign key constraints make it more difficult for a programmer to introduce an inconsistency into the database.
• Centralizing the checking of these constraints by the database server makes it unnecessary to perform these checks on the application side. This …

Sometime it is needed to handle a lot of rows on client side. Usual way is send query via mysql_query and than handle the result in loop mysql_fetch_array (here I use PHP functions but they are common or similar for all APIs, including C).
Consider table:

PLAIN TEXT SQL:

1. CREATE TABLE `longf` (
2.   `f1` int(11) NOT NULL AUTO_INCREMENT,
3.   `f2` date DEFAULT NULL,
4.   `f3` date DEFAULT NULL,
5.   `f4` varchar(14) DEFAULT NULL,
6.   `f5` varchar(6) DEFAULT NULL,
7.   `f6` date DEFAULT NULL,
8.   `f7` smallint(6) DEFAULT NULL,
9.   `f8` smallint(6) DEFAULT NULL,
10.   `f9` varchar(13) DEFAULT NULL,
11.   `f10` varchar(39) DEFAULT NULL,
12.   `f11` int(11) DEFAULT NULL,
13.   `f12` float DEFAULT …

From Monday to Wednesday we at eZ systems AS had our internal developers conference in Skien, Norway.

Since I joined eZ systems only recently, this was the opportunity for me to get to know all employees that gathered from all over the world. Most of the Tuesday was reserved for a "Crew Day" with some "team-building" which took place in a forest nearby.



On Thursday and Friday the eZ publish conference 2006 took place.

During the conference I met with …

From Monday to Wednesday we at eZ Systems AS had our internal developers conference in Skien, Norway.

Since I joined eZ systems only recently, this was the opportunity for me to get to know all employees that gathered from all over the world. Most of the Tuesday was reserved for a "Crew Day" with some "team-building" which took place in a forest nearby.



On Thursday and Friday the eZ publish conference 2006 took place.

During the conference I met with Sébastien Hordeaux of WaterProof SARL, the …

After seeing Frank’s script in “Finding out how far behind are slaves” I figured I would post some nagios plugins I wrote a while ago, that we use at our company. They’re already up at http://www.nagiosexchange.org/, the 3rd party repository for nagios plugins.

So I figured I’d point you to:
Replication Lag Time
and
InnoDB Free Space

I’ll note that backups from a slave server can cause replication lag time to fall behind, for 2 reasons — …