…MySQL 5.1.69, this release will include all the bug fixes in it. All of Percona’s software is open…not need to read any bitmap files. Bug fixed #1184427. Incorrect schema …limited to 32-bit signed integers. Fixed so that these values can be 64-bit unsigned integers now. Bug fixed #714925. 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
…=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3…All of Percona’s software is open-source and free, all the … the directory and file name components in a bitmap file name could stop …for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug …
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… good for raw performance, but there are limitations which MyISAM imposes that are difficult to work…mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file…32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
…new features regarding replication in MySQL 5.6. They open up a lot of… you should keep in mind some limitations of the current implementation. This post…mysql> show slave status\G [...] Auto_Position: 1 -> GTID-based positioning # Slave #2 mysql> show slave status\G [...] Auto_Position: 0 -> File…
Comment: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
April 17, 2013 By 10 Comments
…/mysql2 –plugin-dir=/usr/lib64/mysql/plugin –user=mysql –log-error=/var/log/mysqld2.log –open-files-limit=32768 –pid-file=/var/lib/mysql2/g4.dmz.local.pid –socket=/var/lib/mysql2/mysql.sock –port=3307 $ sudo cat /proc/35967/limits Limit…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…MySQL 5.6 virtually eliminates contention on the mutex protecting the list of transactions, its applicability is quite limited…= 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = …_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the …Open_filesblogpercona.commanual open_files_limitblogpercona.commanual Open_streamsblogpercona.commanual Open_table_definitionsblogpercona.commanual Open_tablesblogpercona.commanual Opened_filesblogpercona.commanual Opened_table_definitionsblogpercona.commanual Opened…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… keep open file descriptor when table is open – open table is purely logical state and appropriate .ibd file may be open or closed. Furthermore besides MySQL table… with innodb_open_files=16384 I got about same crash recovery speed though with no warnings. So it looks like innodb_open_files_limit=300…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_open_files was increased to 2000 from 300. Good change considering open_files_limit was also raised. Unlikely to cause significant gains unless opening and closing files is expensive operation (such as using MySQL on NFS file…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… which would mean limit disabled. Very few users actually need DOS prevention this variable strives to provide as MySQL is typically protected by Firewall to begin with. open_files_limit = 5000 strangely enough this is where…
