… features regarding replication in MySQL 5.6. They open up a lot of opportunities to make the… topology. However you should keep in mind some limitations of the current implementation. This post is the … servers have gtid_mode set to ON. Could it be interesting to run file-based replication when gtid_…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…The SSB benchmark consists of four sets of queries. Each set is known as a “…good for raw performance, but there are limitations which MyISAM imposes that are difficult to …file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… All of Percona’s software is open-source and free, all the details…integers now. Bug fixed #714925. mysql_set_permission was failing on Debian …limiting performance on write-intensive workloads. Bug fixed #1171699. Missing path separator between the directory and file name components in a bitmap file…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…. All of Percona’s software is open-source and free, all the details …mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed …file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… of set of empty tables which is about 10 times smaller for MyISAM. I found no significant difference whatever limit of open files was… the same, taking 1sec (on the second time) . Whenever innodb_open_files_limit was 64 (virtually all misses ) or 16384 (all hits) performance… 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…
Comment: How innodb_open_files affects performance
April 14, 2010 By 4 Comments
…/ asking about open_file_limit. One thing I see that is not talked about is how the os ulimit of “open files“, mysql setting “open_file_limit” affects the OS/MySQL and I believe is non-biased to MyISAM and InnoDB table types. If the max open_file_limit…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…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: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… 56 rows in set (0.05…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…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
… ========== freehold: [client] port=3323 socket=/tmp/mysqld_mdmp.sock character-sets-dir=/home/mysqld/sys/5.5.8/share/mysql/charsets… max_heap_table_size=128M event_scheduler=ON query_cache_limit = 10M open_files_limit = 8088 back_log=128 max_allowed_packet = 50M # performance… max_heap_table_size=128M event_scheduler=ON query_cache_limit = 10M open_files_limit = 8088 back_log=128 max_allowed_packet = 50M # performance…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…, 31014 + 27426 = 58440 os file descriptors. So – 1) Do I get errno: 24 becuase I have the open_files_limit set to 40000? 2) Could you explain the difference between MyISAM and InnoDB and the difference in how the OS handles opened files… thread_cache_size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp…
