I've been using MySQL fulltext indexes on a table where I keep a few varchar and one text column that is used for searches. I've had it defined as:

CREATE TABLE `items_text` (
  `item_id` bigint(20) NOT NULL,
  `fts` varchar(4) NOT NULL default 'grzr',
  `author` varchar(80) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `content` text NOT NULL,
  PRIMARY KEY  (`item_id`),
  FULLTEXT KEY `title` (`title`),
  FULLTEXT KEY `author` (`author`),
  FULLTEXT KEY `fts` (`fts`),
  FULLTEXT KEY `content` (`content`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

One of my colleagues pointed out he was experiencing slow performance with this query:

select count(*) from items_text where (MATCH (title, author, content) AGAINST ('+iron +man' IN BOOLEAN MODE))

I ran EXPLAIN just to make sure that the index was being used:

mysql> explain …

I wrote this a few weeks ago and held it back until now. I decided to publish this somewhat in response to Roberto's post. While Roberto is trying to find a band-aid to the problem, I think we need to rethink the root cause of the problem. I've been blogging about OSS for nearly 2 years now. My in-the-trenches experience with OSS goes back to early 2004. The constant drumbeat of "proprietary software is dead, open source is the only path forward" has been deafening at times. I'll admit that I too used to espouse similar words. But, I am... READ MORE

Hey,

As I had mentioned in my previous blog entry about MySQL Admin and NetBeans. There, I had ended the post, with a note that I have filed an issue related to MySQL Server Node in Database Explorer.

After exchanging several mails and updating the bug report at Issuezilla. I told David, that I would be looking for a workaround, as he had set the TBD to 6.5 release. I can’t wait that long!

So, I had two options, either hack the code and fix it by myself, and use it. Else, I should look for a workaround.

I am glad that I could find a workaround for this issue. What I did, when I …

A couple more articles I saw posted out on the web on Sun’s new SSD offerings.  In the The official press release…  their are very scant details on the sun offerings right now.  But the official release says:

“Sun is already shipping Solaris ZFS software optimized for SSD technologies through the OpenSolaris(TM) community and is the first major systems vendor to add an end-to-end Flash-based disk product line to its portfolio, leapfrogging competitors and giving customers 3x better performance at one-fifth the energy consumption of traditional spinning disk offerings.”

Hopefully I am misreading this… 3X performance seems slower then the other SSD I have looked at.

In …

Former VP and GM of North American sales at Red Hat, Ed Boyajian, has been named CEO of EnterpriseDB. Current CEO, Andy Astor, will be shifting roles to lead EnterpriseDB's business development as EVP. Very interesting that EnterpriseDB was able to attract Ed. I'd guess this move speaks more to the potential at EnterpriseDB than anything amiss at Red Hat. A quote from Dave Power, a member of EnterpriseDB's board, and from Ed both point to taking EnterpriseDB to the next level. For instance, Ed states: "The Postgres open source community is active and robust, and the company has a... READ MORE

My earlier post mysql versus postgresql brought me lots of negative comments - that i did not compare the transactional database of pgsql with the transactional engine (innodb) of mysql. The main reason why i did not do that was because i had found InnoDB to be very slow as compared to MyISAM.

But after all those comments i ran the benchmarks again using the same scripts and the same technology

I know that this was talked a lot and recently Mark Callaghan also gave a session in MySQL user conference 2008 about the real bottlenecks.

Other day I was testing my thread pool stuff with MySQL 5.1.24 + InnoDB plugin 1.0.1 along with other miscellaneous benchmark tests by making them CPU bound by keep the working set completely in memory to gauge the performance of threads overhead; and on 8-core box InnoDB seems to be doing better than 4-core. And then immediately I started few tests with mysqlslap by keeping complete data set in the buffer pool to get the proper timing on locking overhead.

Here is the comparison of performance on 8-core box with innodb_thread_concurrency is set to 32 and 0 for variable threads on 64-bit Redhat Linux 4 . The same box is used as …

I have released PBXT 1.0.03 Alpha and it is available for download from http://www.primebase.org/download. I have also posted binary plugins for a few platforms.

If you are building from source I have added a Quick Guide: Building and Installing PBXT from Source, which I hope makes the task really simple. If not, I would appreciate any feedback!

With this version I have completed the implementation of full-durability, and other features that are scheduled for RC and ultimately for the first GA release.

Still to be done is the Windows port which I plan to do before the first Beta release.

Please send any comments, questions, bug reports, etc. directly to me: paul dot mccullagh at primebase dot org.

Who Am I?
My name is Luca Olivari, I'm a technology enthusiast living in Italy. I was born in 1979 and I've created this blog having in mind a nice place to share thoughts about MySQL/Sun, Technology, Business Intelligence and other interestingness.

I'm currently working in Sun Microsystems as a Systems Engineer in MySQL Global Software practice and in my spare time I read, take pictures, travel, run and surf web2.0 sites. I'm interested in technology, science, marketing, communication, advertising, picture, classic books and many other things.

If you are in sync with my interests or you simply like to share something this is the right place.
Feel free to add comment to this post if you like to contribute in any other way to this blog.

I'm glad to meet you all!

If you want to look at some information about my personal interests let's have a look at …

Yesterday, I became a Google employee.I know that there has been quite a hiatus in my MySQL related activities but it wasn't all without good reason. The first proper holiday I have had in a few years.Tomorrow afternoon, I hope to spend some time with Mark Callaghan ... It would be a nice break from the new-employee orientation and tutorials and hopefully a chance to meet more of my new