… to Kick Ass. Walking in exhibition hall you could see KickFire, Infobright, Tokutek, ScaleDB. I have not seen NitroDB in the… it even complicated most of these solutions are close source (Kickfire also uses proprietary custom hardware) which makes it hard to… your application does a lot of primary key lookups and MySQL Cluster promises good performance and scalability. But if at the…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… MySQL Storage Engines, some of which as InfoBright or KickFire take over execution after parsing, Sphinx MySQL support has nothing to do with MySQL… | 2735703 | 139448919 | 2735703 | +————+——–+———-+———–+———+ 10 rows in set (32.47 sec) MySQL mysql> select max(forum_id) as m,author_id as a…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… point: Use InnoDB Assuming that you will use the stock MySQL server, InnoDB is usually your best bet. (Actually, XtraDB might… save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the… do!) you’ll see results on this blog. Another is Kickfire — also something I have not had a chance to properly…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… scale sites. As response to these things few things happen – MySQL kept being “simple” and introduced relatively simple performance boosters – Query… see as response to these requirements ? From MySQL side we have further development of MySQL Cluster to be more usable for web… used with MySQL to get very fast IO and so consolidate system suffering from IO bound workloads. There is KickFire appliance around…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
Reading Barons post about Kickfire Appliance and of course talking to them directly I learned … rows and wrote little stored procedure to make timing easier: mysql> DELIMITER // mysql> CREATE PROCEDURE test_read(pl INT) -> BEGIN -> DECLARE t…; -> END; -> // Query OK, 0 rows affected (0.00 sec) mysql> DELIMITER ; mysql> call test_read(1000); Query OK, 0 rows affected (1…
Comment: TPC-H Run on MySQL 5.1 and 6.0
April 22, 2008 By 16 Comments
…://www.tpc.org/results/individual_results/Kickfire/Kickfire_2300_ES_TPCH_100G_041408.pdf) it appears MySQL/Sun have some real challenges ahead in this area (unless they’ll buy Kickfire or sue it out of existence etc). I’m not affiliated with Kickfire in any way, shape…
Comment: TPC-H Run on MySQL 5.1 and 6.0
April 22, 2008 By 16 Comments
… compared to 16G of memory the Dell box had. Furthermore Kickfire uses column store which reduces IO needed dramatically in case…. As I mentioned Kickfire indeed handles some kind of queries just great but I would not put it as “MySQL Killer” especially…-on experiences with it to understand Its limits. Infobright, NitroDB, Kickfire all promise great speed improvements for certain kind of operations…
Comment: TPC-H Run on MySQL 5.1 and 6.0
April 22, 2008 By 16 Comments
… here. First – KickFire is positioned as Datawarehouse engine right now – it is not designed for OLTP etc. Second – MySQL just handled these particular queries very badly. In real MySQL world if you have such queries you either rewrite your queries or you do not use MySQL.
Comment: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 12, 2010 By 46 Comments
… lot about database bugs. I have a number of open MySQL bug reports, and I even contributed a fix to a serious replication bug in MySQL too. I worked very closely with the QA department at Kickfire while employed there, identifying defects… be clear, I would not go out and buy Infobright, Kickfire, InfiniDB, Oracle or any other database product unless I was…
Comment: Will Falcon fly?
June 24, 2008 By 11 Comments
… things I see involving so far is the business and MySQL cluster, the core Product itself is stalling at best. The… down another bit (I don’t really have insight into MySQL, I read about some people leaving and well there are… things in the future will be in my opinion the Kickfire appliance and Primebase XT.
