… for example results on the same hardware just running PostgreSQL instead of MySQL or having Sun box replaced with comparable Dell or… log for a little bit lless of performance. innodb_thread_concurrency = 0 Good! So Innodb performed best in this workload without restricting… amount of dirty pages Innodb can have to get better performance. It probably was done to deal with “dips” which can…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is … workload! The insert buffer can also cause terrible performance. There are some subtleties about exactly what’s … just published an article on warm standby for PostgreSQL. Link love for interested …
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… recovery time or further degraded performance. In the large databases I run in production relaying on MySQL Replication for HA I often… for MySQL as they use for PostgreSQL for example instead of investing time to learn about MySQL Replication or just looking to keep MySQL… of paying extra performance costs. It is worth to note DRBD also allows building very nice mixed environments with MySQL – for example…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
…in the MySQL ecosystem are Percona customers, including hardware manufacturers, software developers, hosted service providers, and appliance developers. We perform paid and…best fit. For example, we frequently refer people to expert PostgreSQL consultants when needed. We believe that people who need …
Post: Percona is hiring performance experts
February 13, 2009 By 2 Comments
…-level, senior experts in LAMP/Open-Source performance and scalability. Most of our work involves MySQL (at least peripherally, usually centrally) but not all of it; and we are looking for a PostgreSQL expert as… all remote DBA, nor is it all urgent troubleshooting or performance audits; it’s everything you can imagine, and it’s…
Comment: MySQL and PostgreSQL SpecJAppServer benchmark results
July 26, 2007 By 13 Comments
… away from it fully. With MySQL MySQL version 4.1 and 5.0 became slower than MySQL 4.0 for many simple operations… compare MySQL and PostgreSQL MySQL is just flexible in different way – MySQL has large number of storage engines and this causes a lot of performance…
Comment: Why MySQL could be slow with large tables ?
May 23, 2007 By 141 Comments
… MYsql over Postgresql, but this articles about slow performance of mysql on large database surprises me….. By the way….on the other hard, Does Mysql…
Post: Report from OSCON 2008
July 27, 2008 By 7 Comments
… the conference is not as much backend and high performance focused as MySQL Conference or even Velocity, though this year there are… interesting crowd attending. Speaking about MySQL vs PostgreSQL it is worth to say PostgreSQL “owns” OSCON – The PostgreSQL booth had more engineers and large…
Comment: Which adaptive should we use?
September 16, 2009 By 14 Comments
… feature for PostgreSQL only…. Do you prefer PostgreSQL to MySQL??? 
(PostgreSQL is one of the RDBMS which has the most strange characteristic of performance for me. I think you should not tune MySQL…
Post: Watch out for Marketing benchmarks
August 23, 2006 By 7 Comments
… applies to comparing MySQL to other vendors. If you ask me if MySQL is faster than Oracle or PostgreSQL I would say yes, in many cases, but not all cases. There are cases when MySQL… benchmarked of MySQL vs PostgreSQL and try my best to get best performance out of both of them, I still know MySQL much better…
