… not need to read any bitmap files. Bug fixed #1184427. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT… due to missing libdbd-mysql-perl package. Fixed by adding the package dependency. Bug fixed #1003776. XtraDB changed page tracking used to…_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. Fixed the upstream bug #69379 which caused MySQL…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…. Bug fixed #1181887. Changed page tracking used to hold the log system mutex for the log reads needlessly, potentially limiting performance on… thus does not need to read any bitmap files. Bug fixed #1184427. Query to the INNODB_CHANGED_PAGES table would cause server…. Release notes for Percona Server for MySQL 5.6.11-60.3 are available in our online documentation. Bugs can be reported…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both…are faster than a b-tree index. Also accessing pages from the buffer pool should be faster than getting…table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size=8M …
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…_get_free_block(buf_pool_t*) | | | |–94.84%– buf_page_init_for_read(dberr_t*, unsigned long, unsigned long, unsigned long, unsigned… for MySQL 5.6.11. Conclusion: In CPU-bounds case MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…In some corner cases this could lead to assertion errors in the log parser or bad changed page… in the read_view_create_low() in most cases. This significantly improves InnoDB scalability on read-only… Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
… Oracle MySQL may diminish in importance within the ecosystem as alternatives including Percona Server and MariaDB grow in relevance I invite you to read… access all of the currently available slides from one web page, visit the conference website and complete the Sessions Slides form… a single web page, complete the Keynotes Recordings form To view the keynote recordings without slides, visit the Percona MySQL YouTube channel…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…’ll be at the Percona Live MySQL Conference and Expo next week in Santa Clara, California so look…the standby server will not have recently accessed pages. When it starts handling queries after failover, …a never-ending stream of queries to playback. Read-only playback Using the –session-init-query …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…In some corner cases this could lead to assertion errors in the log parser or bad changed page… in the read_view_create_low() in most cases. This significantly improves InnoDB scalability on read-only… Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…page output (relatively static pages) Full objects (user or cart object built from several queries) Infrequently changing data (configurations, etc) In…MySQL 5.6 GA distribution, there is a memcached plugin included in the base plugin directory (/usr/lib64/mysql…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…and, potentially, submaximal, rate compared to dirty-page-threshold flushing, which kicks in at a given level and then …–percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration…
