Yesterday I wrote about the new Full-text search for InnoDB. Some of you may have not noticed there is a package on Labs.MySQL.Com named mysql-5.6-labs-innodb-features that needs attention. Some of the features are already in the main MySQL source trunk and others will soon be there. Code to support solid state drives with 4K and 8K pages is there. Along with REDO logs up to 2TB in size. There is better thread scheduling and an option to pre-load the buffer pool for better performance after a restart.
Full-text searching with InnoDB tables is now available for your evaluation at Labs.MySQL.Com. Those used to the full-text search from MyIsam will find the basics are familiar. The
MATCH() ... AGAINST syntax is there and has been augmented with some new features. How about better performance?
To whom it may concern -
One of the typical problems I see setting up ext2/3/4 file system is sticking to defaults when it comes to behavior on errors. By default these filesystems are configured to Continue when error (such as IO error or meta data inconsistency) is discovered which can continue spreading corruption. This manifests itself in a worst way when device have some “flapping” problems returning errors every so often as this would cause some random pieces of data and meta data to be lost. Not good for system running mySQL Server.
Linuxcon was a celebration of twenty years of Linux. I remember colleagues telling me to try the funny little operating system for PCs instead of a BSD variant, their excitement, and making distro ‘floppies’ for . The time has flown, Linux has become a core infrastructure for IT, and many technologies built upon upon Linux has flourished. But could it be better? At least for the database world, things could be better.
Oracle Technology Network Developer Day MySQL – Washington will be held Wednesday, August 24, 2011 at the Renaissance Washington, DC Downtown Hotel (999 Ninth Street NW Washington, DC 20001). And it is FREE!
Boy, the conference planners here must have some pull in high places, because they got a 5.9 earthquake to help them with their “Shake IT Up” slogan for Innovation Nation and GOSCON. I was in the upstairs conference hall, and it was pretty dramatic. I’ve never seen/felt/experienced anything quite like that before. All the walls were twisting and shimmying in different directions, and fixtures fell out of the ceiling. Just little ones — but I decided not to rush to the exit, as I was in a huge room and others were already rushing.