… a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still register to view the recording and… an infinite variety of queries. The query optimizer analyzes queries for common patterns the MySQL designers know can be improved. But there…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… it’s currently up and available for viewing over at percona.com. My apologies …a virtual-machine approach, but for the optimal production deployment you want two identical physical… file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was built with YaSSL which could… fixed #1131187 (Alexey Kopytov). Removed trx_list scan in read_view_open_now() which is another problem originally reported as upstream…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… transaction states to determine which transactions are seen in the view later. To this end, InnoDB scans trx_list (i.e… TRANSACTION READ ONLY MySQL transactions created by a non-locking SELECT statement in the autocommit mode. The relevant optimization in MySQL 5.6… the perfect case for read-only optimization in MySQL 5.6 and as you can see MySQL 5.6 shines in this benchmark…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…with an empty transaction list when creating read views. However, the more general descriptors optimization in Percona Server showed fairly close results… cause much confusion. Even though the read-only transactions optimization in MySQL 5.6 virtually eliminates contention on the mutex protecting the…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… InnoDB transaction processing that notably affects MySQL performance – for every transaction InnoDB creates a read view and allocates memory for this structure… (due to the read-only transactions optimization), but it still allocates/frees memory for read view structure and that causes drops at…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was built with YaSSL which could… fixed #1131187 (Alexey Kopytov). Removed trx_list scan in read_view_open_now() which is another problem originally reported as upstream…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… benefits and drawbacks. Benefit being you can get extra optimizations by optimizer knowing index is UNIQUE the drawback is insert buffer will… key significantly fragmented. I also would note there are some MySQL optimizer restrictions in how well it can deal with primary key… can we manage indexes on servers from DBA point of view ? Is there any management required or server does everything itself…
Post: How Can Percona MySQL Server Development Services Help ?
January 28, 2013 By 3 Comments
… when optimizing for specific workload can provide substantial gains, ranging from tens of percents to 10x or more. For example, MySQL Optimizer doing… broad view of your MySQL server needs. Chances are custom MySQL server development should be one pillar of your strategy, and Percona MySQL Server…
Post: MySQL VIEW as performance troublemaker
August 12, 2007 By 57 Comments
… you assume MySQL would optimize your VIEWs same way as more advanced database systems would. Same as with subqueries and derived tables MySQL 5… solve the same problem having things more modular and using MySQL VIEWs ? mysql> create view user_counts as select user_id,count(*) cnt from… overhead but only in case they are used with caution. MySQL has long way to go getting queries with VIEWs properly optimized.
