… matters. Falcon, SolidDB, NitroSecurity, PBXT, StorageEngine for S3 and IBM DB2 integration were all present at this show. Marten reports revenues…, vice president of Oracle‘s MySQL engineering team, along with some technical talks directly from the Oracle MySQL engineers who brought us MySQL 5.6…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… in MySQL 4.1 but you still could not run (and still can’t) most of your Oracle/DB2/MS SQL Queries on MySQL because subqueries optimizer weakness. I’m saying about XA which were released in MySQL 5… inside who can figure things out and even patch MySQL if needed. So MySQL went to chase Enterprise market and develop enterprise…
Post: MySQL Stored Procedures problems and use practices
June 12, 2007 By 21 Comments
… you to use a lot of foreign constructs to “original” MySQL style – to process data via cursors, handle error via Handlers…. If you spent last 10 years writing Stored Procedures for Oracle or DB2 it may be cool and convenient for you, but… helper Debug Storage Procedure which will log some information in MySQL table but it is not convenient enough. Bad Parser Error…
Post: MySQL wins C'T Database Contest
August 29, 2006 By 27 Comments
… of Database Contest (results on German available here http://www.mysql.de/ct-dbcontest). Peter and me spent quite some time working on this project while being employed by MySQL and it is great to see results finally publicly available… 
): MySQL5/PHP (our solution) : 3664 orders per minute DB2/Java : 1537 opm Oracle / Java: 1412 opm PostgreSQL / PHP: 120 opm MySQL5/PHP…
Comment: Using CHAR keys for joins, how much is the overhead ?
November 12, 2007 By 18 Comments
I believe this is true from across the database environments; be it MS-SQL or MySQL or ORACLE or DB2 or any other.
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
September 20, 2007 By 117 Comments
… applied for, and all ‘universal’ is called ‘horilla’ in MySQL forums: Oracle, DB2. Want to compare test results for a simple query SELECT…
Comment: Instrumentation and the cost of Foreign Keys
December 20, 2011 By 9 Comments
… MUST be used. I have used everything from DB2 to Oracle and find mySQL every bit as robust and efficient as any commercial… own mySQL implementation. It is my believe that a good mySQL DBA could get just as much out of mySQL as any good DB2 DBA could get out of DB2. Maybe I…
Comment: Interesting MySQL and PostgreSQL Benchmarks
December 1, 2006 By 20 Comments
… feature/engine in MySQL that is touted as a perfect replacement for enterprise solutions in regards to Oracle, MSSQL Server, DB2 etc is… can MySQL expect enterprise level clients switch to MySQL? The money such clients would save on transaction costs would justify using Oracle/MSSQL/DB2…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… is more simple to use than SAN, MySQL is more simple to use than Oracle or DB2, PHP is more simple than Java… support. Interesting enough the fact MySQL is Open Source puts it in a worse shape than Oracle and other systems here – typically you get charged more for Advanced features but with MySQL everything is free…
Comment: Moving Subtrees in Closure Table Hierarchies
January 23, 2013 By 18 Comments
… many other RDBMS implementations support this. AFAIK, Oracle 11g, Microsoft SQL Server 2005, IBM DB2 v7.2, PostgreSQL 8.4, and the H2 database for Java support recursive CTE syntax. MySQL does not support…://bugs.mysql.com/bug.php?id=20712 (Jun 2006) http://bugs.mysql.com/bug.php?id=21893 (Aug 2006) http://bugs.mysql.com…
