June 20, 2013

Post: Watch out for Marketing benchmarks

…. Same applies to comparing MySQL to other vendors. If you ask me if MySQL is faster than Oracle or PostgreSQL I would say… from Oracle) more than once or twice, and interesting enough many of these customers stayed with MySQL for other applications or checked MySQL… benchmarked of MySQL vs PostgreSQL and try my best to get best performance out of both of them, I still know MySQL much…

Post: 7 Reasons why MySQL Quality will never be the same

… was even the early Marketing strategy for MySQL. Marten used to frequently say Oracle is Overkill for most users and most users… use 5.1 vs row level replication or events. I think less than 5% are using both features. MySQL 4.1 was…. Innodb/Oracle relationship complexities. If the bug happen to affect Innodb things become even more complicated slow. Even though MySQL and Innodb…

Post: New MySQL Community Release Policies published

… main issue for me is Change policy for MySQL Community version. We are patching MySQL with minor extension so this concerns us… interesting to note 4 source releases for MySQL Community Version vs Monthly rapid updates for MySQL Enterprise version – to me this means a… argument MySQL is Commercial Company and has to make money, sure enough, and I’m not blaming MySQL for that. Microsoft and Oracle

Post: State of MySQL Market and will Replication live ?

… or $revenue/server the difference for most enterprises vs most of web applications in insane. Not …so most of them instead of “upgrading” to Oracle or other systems which offer more performance …response to these requirements ? From MySQL side we have further development of MySQL Cluster to be more …

Post: MySQL 5.6.7-RC in tpcc-mysql benchmark

… INDEX MySQL 5.6.7-rc crashed under tpcc-mysql workload But at the end, is not this why RC for? And Oracle asked for a feedback, so I do my part. Benchmark date: Oct-2012 Benchmark goal: Test how MySQL 5.6… get more stable results. So there it is with 2x4GB vs 2x8GB innodb logfiles. Obviously the result is quite better with…

Post: Report from OSCON 2008

… effort to implement right – without sacrificing speed or flexibility. The MySQL presence on this conference was also very interesting. There was…. My talk on MySQL Storage Engines was pretty well received and I had interesting crowd attending. Speaking about MySQL vs PostgreSQL it is… and MySQL are largerly ignoring each other at the conference – PostgreSQL mentions Oracle, DB2 etc as the competitor they are after and MySQL

Post: MySQL and PostgreSQL SpecJAppServer benchmark results

… is not only as fast or faster than MySQL, but almost as fast as Oracle (since the hardware platforms are different, it… can see some 5% difference in CPU frequency alone (2600Mhz vs 2800Mhz) and it well may be more in terms of… databases) is not where most of MySQL sweet spots come from. MySQL performance gains usually come from MySQL unique features – non transactional MyISAM…

Post: Why MySQL could be slow with large tables ?

… respect and what works well for Oracle,MS SQL, PostgreSQL may not work well for MySQL and other way around. Even storage… the table. The times for full table scan vs range scan by index: mysql> select count(pad) from large; +————+ | count(pad) | +————+ | 31457280… large data sets. In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues IO requests one by…

Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6

And with the mysql vs. /usr/bin/mysql changes in the Oracle packages it will even get harder to get the correct dependencies: https://bugs.launchpad.net/percona-xtrabackup/+bug/1095972

Post: Open Development vs Making a Big Splash

… is exactly how Innodb Plugin was released last year or MySQL 5.4 performance improvements this year. Community did not know… is fair and I appreciate it. So why Sun and Oracle are after big splashes ? Well I think this is the…