… 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-… a look at the graphs have a better view of the whole picture. Note, in the above …performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance…
Comment: MariaDB 5.3 is released as GA!
March 7, 2012 By 17 Comments
… would say MariaDB is seriously underrepresented on places like planet mysql. (Ie possibly real MariaDB usage must be higher than what…’t see the problem distros have with the MySQL model. Contrary to common belief MySQL maintenance releases have never included new features… issues whereas MySQL also fixes non-security bugs like server crash, wrong result or just performance regressions. From my point of view the…
Post: MySQL VIEW as performance troublemaker
August 12, 2007 By 53 Comments
… used to perform it relatively efficient, however for large derived tables it will become nightmare. So be very careful implementing MySQL VIEWs in your application, especially ones which require temporary table execution method. VIEWs can be used with very small performance overhead…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… from the dictionary directly to determine the contents of the view. mysql> select flexviews.get_sql( -> flexviews.get_id(‘demo’,'dashboard_customer… views took about 40 minutes to build Deleted 100 order lines. Refreshed both views. Compared the refresh performance and query results. The view type…
Post: A workaround for the performance problems of TEMPTABLE views
May 19, 2010 By 7 Comments
… can use EXPLAIN EXTENDED to see that MySQL rewrites the view query to include the restriction: mysql> explain extended select c1, count(*) from… the second view using a filter on c1, performance is not good. MySQL is scanning the entire table to produce the result: mysql> select… make a trade off between increased query complexity for improved view performance.
Post: Derived Tables and Views Performance
August 31, 2006 By 14 Comments
… for views was added. These features are quite related to each other but how do they compare in terms of performance ? Derived Tables in MySQL 5.0 seems to have different implementation from views, even though I would… view creator. What does it mean in terms of performance: Query on base table executes using index and it is very fast mysql…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, …Performance_schema_mutex_classes_lostblogpercona.commanual Performance_schema_mutex_instances_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance…commanual updatable_views_with_…
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
… desired point in time. But enabling the binary log reduces MySQL‘s performance dramatically. It is not the logging itself that’s… adds an fsync call for every transaction. And the server performs an XA transaction between InnoDB and the binary log. This… server internals fully enough to have a 50-thousand-foot view of it all. The binary logging and replication code, and…
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
Running EXPLAIN for problematic queries is very powerful tool for MySQL Performance optimization. If you’ve been using this tool a lot… difference is join_buffer which reduces number of passes MySQL had to perform and so number of row combinations really examined. LIMIT… need at least an alternative view. If you want to find more information about understanding EXPLAIN output, MySQL manual EXPLAIN page is…
Post: Percona's Sessions at the O'Reilly MySQL Conference and Expo
April 7, 2011 By Leave a Comment
… Server and XtraBackup: painless operations Forecasting MySQL Performance and Scalability Summary tables, aggregate tables and materialized views using Flexviews Scaling Applications with Caching, Sharding and Replication (Monday Tutorial) Innodb and XtraDB Architecture and Performance Optimization (Monday Tutorial) Using MySQL…
