I never liked how build in Wordpress search works. it shows full documents rather than snippets it does not search comments and it does not have any query language so I always used Google search if I wanted to find something on MySQL Performance Blog.

Today we have published new search functionality for our site which is based on Sphinx. We have developed it as WordPress plugin which will be available as open source software in a few weeks - just want to test it a bit more and write proper documentation before announcing. If you would like to test it however let us know.

As you can see search functionality allows you to specify what would you like to search (Posts, Pages or Comments) as well as if you would like to sort results be relevance of freshness. You can also use query standard Sphinx query language to search phrases or …

connector/odbc 5.1.2 was released today. this will probably be the last beta. we have gone back and triaged all of the bugs filed against connector/odbc, and have identified a few bugs that we have to fix before we will release a release candidate, but overall the trend of bugs is very encouraging. there are only a handful of bugs filed specifically against 5.1, and the total number of connector/odbc bugs is down to under 60.

So far so good. I have a bit over two hundred RSS entries logged in the database for testing purposes. Today I changed the table structure for for the title and description to support longer entries. Here is the pertinent code.

Add feed function:

function add_feed($item,$site_id) {
$each_title = $item['title'];
$each_link = $item['link'];
$each_desc = $item['description'];
if(isset($item['guid'])) { $each_guid = $item['guid'];} else { $each_guid="";}
if(isset($item['pubDate'])) { $each_pubDate = $item['pubDate'];} else { $each_pubDate="";}
//print "\n$each_desc\n";
$sql2=sprintf("
INSERT INTO `extrabigassfries`.`feed_items` (
`id` ,
`rss_site_id` ,
`item_title` ,
`item_link` ,
`item_description` ,
`item_guid` ,
`item_pubDate` ,
`Creation_time`
)
VALUES (
NULL , …

The M&A action around open source continues to thunder into 2008. While we’ve barely had a single week without a major acquisition or two involving open source, a new sign of activity emerged this week. Benchmark Capital is adding entrepreneurs to its ranks with a significant focus on open source.

Benchmark, already a big backer of open source ventures including Red Hat, MySQL, Hyperic, SpringSource and Zimbra, said this week it would be bringing on four new executives, two of whom would work to continue the firm’s success in open source. The new blood at Benchmark includes former Red Hat and JBoss …

It’s the 84th blog-tacular edition of Log Buffer, the weekly review of database blogs! We begin with some Oracle security news. A tutorial of Oracle’s on defending against SQL injection attacks gets a good review on Pete Finnigan’s Oracle security weblog. Pete writes, “This is a superb tutoral, well written and positioned just right. . . . [...]

I’m pleased to announce that after almost one year since the last release, the new version is available. There are many new features this time around. Originally it was titled Monolith MySQL Backup Manager, but because of the new features it has been changed to the new name. You can download here: http://sourceforge.net/projects/monolith-mysql

Screenshots:

Features:

1. Graphing / Trending with variable date reporting
   • Query rate + Data growth
   …

If you're looking for a seasoned, open-source savvy executive team, you might look to MySQL or another leading open-source company. But if you want that team to come with investment dollars attached, you'd do far better to look to Benchmark Capital. In addition to Kevin Harvey (MySQL, Red Hat, etc.) and Peter Fenton (JBoss, Hyperic, SpringSource, etc.), Benchmark just added four new EIRs (Entrepreneurs in Residence), two of which will focus on open-source investment opportunities.

Benchmarks's Bob Kagle notes the importance of EIRs:

By bringing seasoned executives into the firm to found new businesses or work with our portfolio companies, everyone benefits. They understand the challenges of running a start-up, and demonstrate by example what it takes to build, manage and lead …

Some tips around MySQL and SMF on OpenSolaris.

You can enable the MySQL server by starting it through svcadm

% svcadm enable mysql

Although for current builds since the integration on build 79, you need to do this manual stuff first:

% su -
% cd /var
% mkdir mysql
% /usr/sbin/groupadd mysql
% /usr/sbin/useradd -g mysql -d /var/mysql mysql
% chown mysql:mysql mysql

So if your MySQL service is going into maintenance:

% svcs | grep mysql
maintenance    11:03:45 svc:/application/database/mysql:version_50

You could find out more what happened by doing:

% svcs -x
svc:/application/database/mysql:version_50 (MySQL RDBMS)
 State: maintenance since February 15, 2008  2:25:49 PM CET
Reason: Restarting too quickly.
   See: http://sun.com/msg/SMF-8000-L5
   See: MySQL 5.0.45(1)
   See: http://dev.mysql.com/docs
   See: /var/svc/log/application-database-mysql:version_50.log
Impact: This service is …

Looks like I will be at the MySQL Conference and Expo again this year. I try to attend as many sessions as possible, but I always end up meetin’-n-greetin’ and I’m sure this year will be no different.

So if I owe you a beer, or more importantly if you owe me a beer, you know where I’ll be.

Of course and as always, if you are interested in joining the MySQL Support Team you can drop me an email or catch me on Freenode or trip me as I walk by and we can meet up at the conference and discuss the subject!

Some tips around MySQL and SMF on OpenSolaris.

You can enable the MySQL server by starting it through svcadm

% svcadm enable mysql

Although for current builds since the integration on build 79, you need to do this manual stuff first:

% su -
% cd /var
% mkdir mysql
% /usr/sbin/groupadd mysql
% /usr/sbin/useradd -g mysql -d /var/mysql mysql
% chown mysql:mysql mysql

So if your MySQL service is going into maintenance:

% svcs | grep mysql
maintenance    11:03:45 svc:/application/database/mysql:version_50

You could find out more what happened by doing:

% svcs -x
svc:/application/database/mysql:version_50 (MySQL RDBMS)
 State: maintenance since February 15, 2008  2:25:49 PM CET
Reason: Restarting too quickly.
   See: http://sun.com/msg/SMF-8000-L5
   See: MySQL 5.0.45(1)
   See: http://dev.mysql.com/docs
   See: /var/svc/log/application-database-mysql:version_50.log
Impact: This service is …