May 26, 2012

Post: Sphinx: Going Beyond full text search

in this case is we do not only want to match links directed to “mysql.com” but links to “www…keywords” on the fly. As results we now can pull up results even for youtube.com…in MySQL makes its use rather inconvenient and pre-generating data is inconvenient or impossible. If you’re attending OSCON 2007

Post: Analyzing air traffic performance with InfoBright and MonetDB

in this. I tried to analyze a bigger dataset and I took public available data http://www… improve documentation), but finally I ended up with next load statement: /usr/…2007 | 7455458 | | 2008 | 7009728 | +——+———+ And execution time: MonetDB: 6.3s and InfoBright: 0.31s To group all results

Post: PBXT benchmarks

… READ queries, similar to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs… warm-up run (duration 180 sec), and then run three effective runs (duration of each is 60 sec). As the final result we get a maximal result of three runs. The raw numbers are available here: http://www.mysqlperformanceblog.com/files…