I’ve been looking for a good solution to manage full text search for large data chunks (2GB - 100GB). I’ve written a couple of solutions using Xapian with limited success, but unfortunately I haven’t been satisfied with it overall. Performance was good, but there were a number of issues with flexibility that have me ultimately looking for another solution.

At my usual day job, the topic was brought up and I mentioned Xapian and Lucene as solutions, however we’re looking to stay away from Java as it’s not currently in our architecture, and as I stated before: Xapian doesn’t quite have the capabilities I’m looking for to handle even my own systems. Someone brought up Sphinx as something that was being looked into, and I jumped into the typical research process.

One of the key elements that Sphinx seems to offer …

The MySQL Conference & Expo registration is now open.  This is the official MySQL conference put on jointly by MySQL and O'Reilly and once again, should be an excellent event.  There are more than 100 sessions focusing on a wide range of topics including the new Falcon storage engine, performance tuning, new features in MySQL 5.1, partitioning, monitoring and management, case studies, and more.  Many of these sessions are new for the first time, so even folks who have attended the conference in the past will benefit from many new topics. 

There are also more than a dozen tutorials on topics like scale out, Ruby on Rails, replication, high availability and writing your own storage engine (by MySQL technology guru …

• More on watching ActiveRecord This is one for my ~/.irbrc — now I can do stuff in script/console and see what SQL queries are actually generated without flipping to another tab. (tags: rails rubyonrails tips logging)

If you?ve been using MySQL for any time at all, you know that a unique advantage afforded MySQL users is the ability to use multiple storage engines to manage the underlying data stored on the server. This efficient and modular architecture provides large performance and manageability benefits for those wishing to specifically target a particular application need ? such as data warehousing, transaction processing, high availability situations, etc. ? while enjoying the advantage of utilizing a set of interfaces and services that are independent of any one storage engine. The MySQL server supplies engines that are internally developed, provided by third-party software vendors, and also allows a user to build their own storage engine if they desire.

Wondering what the Oracle announcement of Unbreakable Linux has done for Oracle, and to Red Hat? The results aren't pretty, but the company getting pounded might surprise you:

Note to Mr. Ellison: Better try a different strategy. This one is not working, as Steven Vaughan-Nichols reports.) And I'm not talking about Oracle providing commercial support for MySQL. I somehow think that will be even less successful.

Just work on supporting your own software.

ADVERTISEMENT
CDW
The Right Technology Right Away. …

My MySQL Sandalcamp proposal made the cut for the upcoming MySQL Conference. I hope that I will see some of you down in Santa Clara in April.

One of our clients found a bug with dbms_scheduler: it logs a job as successful when a ORA-01403 is thrown.

SQL> create or replace procedure x_no_data_found is v_dummy varchar2(1); begin select dummy into v_dummy from dual [...]

So, in Europe the street name comes first, then the number of the building.
In the US the number of the building comes first, then the actual street, which makes it a little bit rougher to sort.

Imagine a table like this:

mysql> SELECT * FROM numsort;

+——+
| a |
+——+
| 5 |
| a |
| 2 |
| d |
| 22 |
| c |
| 33 |
| 3 |
+——+
8 rows in set (0.00 sec)

The desired order in this case would be 2, 3, 5, 22, 33, a, b, c, d.

mysql> SELECT * FROM numsort ORDER BY a;
+——+
| a |
+——+
| 2 |
| 22 |
| 3 |
| 33 |
| 5 |
| a |
| c |
| d |
+——+
8 rows in set (0.00 sec)

Ok, we’re far from what we’re …

Every so often someone will ask me "What is this pushbuild thing I
hear MySQL developers talk about?"

The answer is that it is an automated build system that we "push"
code into. It was written by Kristian Nielsen a little over a year
ago. When using BitKeeper you have to "push" code to another
repository. In CVS or Subversion you just commit to one repository,
BitKeeper put the concept of distributed versioning into people's
minds (and its a very powerful tool for distributed development). I
really can not imagine using a non-distributed revision control
system any longer.

What we look for in development, and releases, is a "green tree". The
nice thing about pushbuild is that I can see how my builds work on
different platforms. For example I don't do windows programming but
via pushbuild I can see if my code built on Windows. I've used …

rPath raises an additional $9.1M in funding…Solid shares its 2007 plans for MySQL…Novell launches a training program for Red Hat migrations…and more…

rPath Continues Momentum with Addition of $9.1M in Funding, rPath (Press Release)

Solid Unveils Plan To Deliver Additional Mission-Critical Database Capabilities To MySQL Users, Solid Information Technology (Press Release)

Novell launches New Training to Ease Red Hat-to-SUSE Linux Migration, Novell (Press Release)

Sun and …