… the following Innodb settings: innodb_buffer_pool_size=1G innodb_log_file_size=64M innodb_log_buffer_size=8M innodb_flush_method=O_DIRECT innodb_flush_log_at_trx_commit=0 max_connections = 10000 open_files_limit…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… our Job Openings I like to ask them a basic question -…details, check out detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on your …of short write transactions. innodb_thread_concurrency=8 Even with current Innodb Scalability Fixes having limited concurrency helps. The…
Comment: Limiting InnoDB Data Dictionary
February 12, 2009 By 13 Comments
As innodb_open_files exists as max open handles; it could have been nice if it was controlled by innodb_table_open_cache (same as table_[open_]cache); so that it limits based on table count instead of size
Comment: What to tune in MySQL Server after installation
March 10, 2007 By 118 Comments
MySQL – Standardkonfiguration (InnoDB)… Server Open File Limit > 10000 coredumps müssen funktionieren /etc/my.cnf Gute Referenz:…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… find that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (… log output. The stock MySQL server’s limitation of one-second granularity makes it hide …. It’s like knowing openings in chess — the great chess players study openings exhaustively, but they …
Post: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
February 4, 2013 By 10 Comments
…:20)# cat /proc/`pidof mysqld`/limits | egrep “(processes|files)” Max processes 22888 22888 processes Max open files 6000 6000 files But let’s say that…:45)# cat /proc/`pidof mysqld`/limits | egrep “(processes|files)” Max processes 1024 unlimited processes Max open files 4206 4206 files Now, once this server hits… have a high-traffic MySQL server with a very large InnoDB buffer pool, having to bounce mysqld a second time could…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
… engine it is. We can ignore the upper limit on number of storage engines for MySQL …the server: DROP TABLE RENAME TABLE DROP VIEW open table filling INFORMATION_SCHEMA tables (I think …in InnoDB itself and in the table_definition_cache). Further reading: MySQL Forge Internals document on the FRM file…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…Laurynas Biveinis). The XtraDB used to print the open read view list without taking the kernel…innodb_flush_method=O_DIRECT was set up, log bitmap files were created and treated as InnoDB data files…errors. Fixed by renaming the innodb_changed_pages_limit option to innodb_max_changed_pages. Bug fixed …
Post: Fishing with dynamite, brought to you by the randgen and dbqp
November 16, 2011 By Leave a Comment
… after setting innodb_dict_size The basics of this were that the server was crashing under load when innodb_dict_size_limit was… following options in the test case: server_requirements = [["--innodb-dict-size-limit=200k --table-open-cache=10"]] Granted, these are insanely small values… this bug, we needed to ensure that the server used –innodb_file_per_table and that we used Xtrabackup’s –parallel option…
Post: XtraDB: The Top 10 enhancements
August 13, 2009 By 5 Comments
… of a log file. Â XtraDB improves this with innodb_io_capacity, as well as configuration items for innodb_read_threads, innodb_write_threads… log files (innodb_log_file_size), which is worse for performance. Â In a simple test, XtraDB recovered ten times faster (see docs). InnoDB…). Additional undo slots – In the built-in InnoDB, the number of open transactions is limited to 1023 (see bug report). Â XtraDB allows…
