… engine API diminishing importance of the Innodb storage engine. The Falcon storage engine was announced as a potential Innodb successor. A… on showing what is on top is what really matters. Falcon, SolidDB, NitroSecurity, PBXT, StorageEngine for S3 and IBM DB2 integration… MySQL Alternatives including keynotes for Drizzle and MariaDB. MySQL 5.5 replaced MySQL 5.4 as next planned GA release. Percona releases GA version…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… schema and queries are described here Used hardware CentOS release 4.4 (Final) 2 Ñ… Dual Core Intel XEON 5130 model name… 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql-5.1-falcon for Falcon (Please note this is a first release of Falcon…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
…_id = t1.id AND t1.stat=1 AND t2.val = 5 LIMIT 1206,18\G *************************** 1. row *************************** id: 1 select_type: SIMPLE… Queries/sec 1 51 2 79 4 116 8 142 16 164 As you can see Falcon perform extremely poorly when single… 4 threads – which is quite unexpected for CPU bound load on system with 4 Cores. Here is comparison of MyISAM Innodb and Falcon…
Post: MySQL 5.1 went to GA. Was it a good move ?
December 10, 2008 By 4 Comments
… MySQL I’ve seen big and famous companies shipping MySQL 4.1 beta build into their hardware solutions. This is to… to do with MySQL 5.1 stability. I know people who are happy with MySQL 6.0 and Falcon stability for months… started to use it in production (because they started with 5.1RC during their development) without clear understanding how it is…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/…`zip` varchar(8) NOT NULL default ”, `country_id` smallint(5) unsigned NOT NULL default ’0′, PRIMARY KEY (`id… Red Hat Enterprise Linux AS release 4 (Nahant Update 4) 2 Ñ… Quad Core Intel XEON cpu …
Post: MySQL sources from development tree
January 9, 2007 By 1 Comment
…-build TAG: mysql-5.0.30 TAG: clone-5.0.30-build TAG: mysql-4.1.22 TAG: clone-4.1.22-build TAG… run: bkf clone -rmysql-5.0.30 bk://mysql.bkbits.net/mysql-5.0 mysql-5.0.30 Latest Falcon release is available on bk://mysql.bkbits.net/mysql-5.2-falcon Full list…
Page: Presentations
May 3, 2006 By
… OSCON 2007 , Portland,OR , July 2007 Presentation looks into PBXT, Falcon and SolidDB Storage engines and compares them in terms of… This presentation shows in numbers performance differences in MySQL 4.1 and 5.0, showing most important performance improvements and regressions known… application design practices. Download MySQL: New Features in versions 4.1, 5.0, 5.1 Open Source Forum 2005, Moscow, Russia Presentation speaks…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… feature is now scheduled for an upcoming version of MySQL 5.4. The Backup API makes it possible to pull a consistent… using MVCC is one of the main differences in the Falcon storage engine. PBXT supports row-level locking and foreign keys… iterations (MySQL code was also changing during the development of 5.1) before we came up with the current solution: create…
Comment: Filtered MySQL Replication
November 9, 2007 By 8 Comments
… as with high concurrency transactional engines – I’m not sure Falcon or PBXT could use logical replication at all. It surely… than Innodb Cluster is. Funny enough back when 4.1 was in beta and 5.0 was in early development (before NDB… replication is good enough, highlighting new features planned for MySQL 5.0 like Stored Procedures and Triggers can be hard to…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… this Commodity Space in terms of overall feature complexity. MySQL 5.2 will give you many storage engines to play with… also would likely loose portability. If you look at MySQL 4.0 you could simply ask if person knows MySQL or… for Falcon storage engine. Relatively simple 1000 page book which would cover pretty much all of MySQL features in version 4.0…
