…-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions…5.3 isn’t the only exciting thing, however. MariaDB 5.3 is based on MySQL 5.1, but MariaDB 5.5 will be based on MySQL 5.5…, “fix subqueries and you will change the world for a lot of MySQL users.” …
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 6 Comments
… itself was taking same 5 seconds, which points to problem with optimizer performance. Note though if you have subqueries these might need to… in MySQL 5.5 which can produce very expensive plan selections ? Investigating this further I found the following explanation from Timour Katchaounov in MySQL…
Post: MySQL VIEW as performance troublemaker
August 12, 2007 By 53 Comments
… assume MySQL would optimize your VIEWs same way as more advanced database systems would. Same as with subqueries and derived tables MySQL 5.0 will fail and perform very inefficiently in many counts. MySQL has two ways of…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… use them same as single MySQL server with improved performance and high availability. Of course there is MySQL Cluster but it does not… Queries on MySQL because subqueries optimizer weakness. I’m saying about XA which were released in MySQL 5.0 without consistent work with MySQL close…
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… hear about release plans for MySQL 5.1 (Q1 2008) and MySQL 6.0 (Q4 2008) – which … before. Somewhere in 6.x series proper performance monitoring instrumentation and semi-synchronous replication is … Robin also showed some optimized improvements for subqueries in MySQL 6.0 which are pretty cool and …
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
…MySQL or PostgreSQL was configured or about queries. Furthermore MySQL and PostgreSQL has a bit different implementations (ie SubQueries avoided for MySQL… and it is merged into MySQL 5.0.30 “Enterprise” but according … Woodcrest has best performance in this test (and in many other MySQL tests), …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… 5 5 iostat -dx 5 5 If you don’t know how to read these, there’s a full explanation in our book, High Performance MySQL… at this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up… careful judgment for queries with subqueries in the FROM clause, which will actually execute the inner subquery!), and examine the query plan…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
… 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… faster than just running the SQL via MySQL. The remainder of Vadim’s queries use subqueries in the FROM clause, which Shard…
Post: Watch out for Marketing benchmarks
August 23, 2006 By 7 Comments
… look at MySQL 5.0 Benchmarks Whitepaper and guess which type is this ? You can also compare it to my MySQL Performance 5.0 vs… all cases. There are performance bugs, some of them as Innodb Scalability were known long before MySQL 5.0 was stable but were… MySQL sucks and you better to do things differently or use other database. For example it happens with many types of subqueries…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…MySQL. There are many successful applications, using tens of thousands of tables per host and archiving great performance…Read more in my Why MySQL Could be slow with Large Tables article. 5. The n+1 … in this case. This most applies to subqueries Where Subselects with IN() become corellated even …
