… #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on…_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. Fixed the upstream bug #69379 which caused MySQL clients…. Bug fixed #1186690. Under very rare circumstances, deleting a zero-size bitmap file at the right moment would make server stop…
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
…align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/…query started returning data to indicate an incomplete result set. Bug fixed #1185040. The INNODB_CHANGED_PAGES table couldn’t be queried… expand too fast around 500KB tablespace size. Bug fixed #1169494. Fixed the RPM …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside single… MySQL 5.5 and MySQL 5.6. In order to understand more about differences between results… innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… result. In the best possible combination I got ~15k operations per second for MySQL 5.6.11. Conclusion: In CPU-bounds case MySQL… in MySQL 5.6. In IO-bound cases MySQL still has performance issues around mutexes and Percona Server shows much better results Configurations…=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only loose-innodb…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…vCache performance results were obtained with the default vCache configuration, I think vCache can be declared the clear winner. Base MySQL & …binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…’s see what results we have. The results are in …size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query…size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…from a partitioned table, as, depending on the size of the partitions, the whole partition can be … probably only recently read records will be cached, resulting in more disc reads. 2. If you need…you do queries on any other column, these could easily be quicker on a partitioned table, as Mysql can…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… a single base table. Knowing this, the query result set is treated as a materialized view…any size. Set processing is massively parallel . In fact, it is embarassingly parallel. Because Shard-Query…MySQL storage nodes are supported. Amdahl’s law applies to the distributed processing. The results from…
Post: Be productive with the MySQL command line
December 21, 2012 By 14 Comments
…results. It can be annoying but it is easily solved by using the pager command: mysql> pager more PAGER set to ‘more’ mysql…when you want to estimate a good size for you InnoDB redo logs: the … the Unix tee command: mysql> tee queries.log Logging to file ‘queries.log’ mysql> use sakila Reading table…
Post: How Much memory do you use to run MySQL
November 2, 2012 By 8 Comments
… issues with MySQL Server related to amount of memory you have in the system – these range from problems with large size Query Cache to bad drop table performance with large Innodb Buffer Pool size. As such I wonder… when it will be frozen so we do not get results from multiple years mixed.
