…MySQL Cluster and MySQL Press were announced during this event; “High Performance MySQL” 1st edition written by Jeremy and Derek was also available. MySQL… space – PostgreSQL, EnterpriseDB, Hadoop,Hbase, MongoDB, CouchBase providing compliments and alternatives to MySQL. The MySQL Community awards …
Post: MySQL on OSCON
July 26, 2007 By 13 Comments
… MySQL, and Databases for that reason. Our talk comparing performance of MySQL Storage Engines had probably 20-30 people, Monty’s talk on MySQL… there were few MySQL Developers hanging around it most of the time, compared to army of technical guys at PostgreSQL booth. I would say even SolidDB booth was more attended. I’ve heard comments from some MySQL people this…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
… which is scheduled to be fixed before stable release but performance effect of it is yet unknown – how transactional system implements logging and dirty buffers flushing has serious impact on performance. The other gotcha which you should aware at this time… someone joked at the conference “Now so many years after PostgreSQL, MySQL has finally got a storage engine which needs VACUUM” So…
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
… to get performance advantage. Regarding general features I guess some things are faster others are slower in MySQL. For example PostgreSQL is slower at connection creation and MySQL is very fast, while SubSelect optimization is very bad in MySQL for…
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) so…comparison in this test. Woodcrest has best performance in this test (and in many other MySQL tests), Opteron comes second and older…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… other OpenSource projects such as PostgreSQL (plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is changes – now there are plugable storage engines (something even PostgreSQL does not have… use them same as single MySQL server with improved performance and high availability. Of course there is MySQL Cluster but it does not…
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… of MySQL 5.0.20a vs 5.0.32bk as well as matching PostgreSQL 8.2 results Same as in previous test PostgreSQL… increasing concurrency – going from 10 to 20 concurrent connections drops performance from about 620 to 450 TPS which can be nasty…
Comment: Interesting MySQL and PostgreSQL Benchmarks
September 17, 2007 By 20 Comments
[...] Interesting MySQL and PostgreSQL Benchmarks From MySQL performance blog. (tags: mysql performance postgresql) [...]
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
… like Google, Yahoo, LiveJournal,Technocarati MySQL has installations with many billions of rows and delivers great performance. What could be the reason…, PostgreSQL may not work well for MySQL and other way around. Even storage engines have very important differences which can affect performance dramatically…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… you can build the functionality you need and get the performance you need. Because I’ve built two such systems to…, like star schemas. The problem is that MySQL doesn’t tend to perform well on a data warehousing workload. The… to be more. Finally, PostgreSQL is clearly better for some workloads out-of-the-box than MySQL is, especially for more complex…
