… switched to PostgreSQL, there was no such issue. We do a “VACCUM” every *month* or so and we’re fine. MySQL, I… 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 you…
Comment: Interesting MySQL and PostgreSQL Benchmarks
December 30, 2006 By 20 Comments
MySQL vs. PostgreSQL benchmarks… I found an interessting article at the MySQL Performance blog, pointing me to these benchmarks:MySQL vs. PostgreSQLRDBMS on Solaris vs. LinuxIt’s pretty interessting to see, that PostgreSQL is performing very well, where MySQL is suffering very quickl…
Comment: Announcing PAM authentication plugin for MySQL (early access release)
December 5, 2011 By 9 Comments
… eyeing PostgreSQL’s feature set with frustrated envy, and enjoy the rocking performance and flexibility of the MySQL platform. [Please no flaming – PostgreSQL rocks in its own right, but we have an investment in the MySQL…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
Preamble: On performance, workload and scalability: MySQL has always been focused on OLTP workloads. In fact, both Percona Server and MySQL 5.5.7rc have numerous performance improvements… other database servers such as PostgreSQL or Firebird fairly easily. What machine did I use? I used MySQL 5.5.7rc on…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… quite frequently with MySQL 
[+] Compact Indexes Compact Indexes are great. Huge indexes is where large portion of Innodb performance problems come however… from it after it was implemented. Speaking with Oracle and PostgreSQL developers it looks like they all acknowledge this problem and…
Comment: InnoDB benchmarks
January 8, 2007 By 15 Comments
… runs faster on PostgreSQL than on MySQL. Without knowing what it is it is hard to say the reason for performance difference – might… – some optimization is missing in MySQL. To the question if you can increase features and performance at the same time – yes this… versions add. I’m sure though MySQL can be brought back in terms of performance of simple queries if significant effort is…
Post: SysBench - benchmark tool
August 18, 2006 By 20 Comments
…file I/O performance scheduler performance memory allocation and transfer speed POSIX threads implementation performance database server performance First four is … realesed soon. Originally Sysbench supported only MySQL, but later Oracle and PostgreSQL (and deviations, e.g EnterpriseDB) were added …
Post: What did we want Interns to do
October 5, 2007 By 1 Comment
…, MySQL versions, etc MySQL Patches – there are a lot of little cool things you can do to improve performance monitoring in MySQL Innodb Performance Experiments… Text Search Benchmark – we would like to get comparison for MySQL build in full text search, Sphinx, Lucene, PostgreSQL Searches.
Comment: To UUID or not to UUID ?
March 14, 2007 By 28 Comments
… subject. You have probably seen these benchmarks comparing PostgreSQL and MySQL performance, which show how bad MySQL scales on multicore + multithread environments: http://tweakers….org/~anton/linux/sysbench/ It also seems that the poor performance of glibc’s malloc has been previously documented: http://www…
Comment: MySQL wins C'T Database Contest
August 31, 2006 By 27 Comments
… build great performing applications on Oracle, MySQL or PostgreSQL, and you can build poorly performing one. In this case it is shown MySQL can deliver great results and there are people on MySQL Team which…
