…event going concurrently with the conference and announced Percona XtraDB as improved and extended Innodb Plugin version, MySQL 5.1… and BigData space – PostgreSQL, EnterpriseDB, Hadoop,Hbase, MongoDB, CouchBase providing compliments and alternatives to MySQL. The MySQL Community awards are presented…
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
…about how MySQL or PostgreSQL was configured or about queries. Furthermore MySQL and PostgreSQL has a bit different implementations (ie SubQueries avoided for MySQL) …at this level at higher concurrency. MySQL with Innodb shows its ugly face and drops pretty quickly as concurrency growths with peak …
Post: MySQL/Innodb scalability tests after fix
January 3, 2007 By 1 Comment
… MySQL and PostgreSQL with different CPUs. I was in contact with Tweakers.net team to see if they miss something obvious in MySQL… matching PostgreSQL 8.2 results Same as in previous test PostgreSQL is winner with large margin especially when it comes to higher concurrency. The results for MySQL 5.0.20a…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… for example results on the same hardware just running PostgreSQL instead of MySQL or having Sun box replaced with comparable Dell or…_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query… log for a little bit lless of performance. innodb_thread_concurrency = 0 Good! So Innodb performed best in this workload without…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
…=max_connections=1500 log_slow_queries=/var/log/mysql-slow.log sql-mode=TRADITIONAL concurrent_insert=2 low_priority_updates=1 The… websites are using MySQL, but we had neither the budget to throw all that staff, or time, at it. PostgreSQL solved it for us. Sorry for mentioning this on a mysql performance blog. I think what…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
…, both Percona Server and MySQL 5.5.7rc have numerous performance improvements which benefit workloads that have high concurrency. Typical OLTP workloads… a small number of concurrent queries (or only one) to demonstrate how much improvement could be made to MySQL so that is… other database servers such as PostgreSQL or Firebird fairly easily. What machine did I use? I used MySQL 5.5.7rc on…
Comment: To UUID or not to UUID ?
March 14, 2007 By 28 Comments
…probably seen these benchmarks comparing PostgreSQL and MySQL performance, which show how bad MySQL scales on multicore + multithread environments: http://tweakers.net/reviews/649/7 The problem with high concurrency…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… have been implemented outside of MySQL Storage Engine level for MySQL – reading rows in their physical…This is also why Falcon has Optimistic locking concurrency which can give you problems if you … it was implemented. Speaking with Oracle and PostgreSQL developers it looks like they all acknowledge …
