…Innodb. You can see current log sequence number – which is amount of bytes Innodb has written in log files…InnoDB, 0 queries in queue 1 read views open inside InnoDB…
Post: Limiting InnoDB Data Dictionary
February 11, 2009 By 13 Comments
… 100.000+ tables InnoDB is consuming gigabytes of memory, keeping definition in memory all time after table was once opened. Only way…/files/patches/innodb_dict_size_limit_standalone.patch. Currently patch is on testing stage, but later will be included into our releases. To limit…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… – innodb_open_files which defines how many files Innodb will keep open while working in innodb_file_per_table mode. Unlike MyISAM Innodb does not have to keep open file descriptor… test 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 is…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… limited MySQL command output. First one is that you can have innodb-status-file option set in your my.cnf. This will make InnoDB…-closed files (file is physically removed only after it is no longer open by any process). First be sure to run SHOW ENGINE InnoDB… the file descriptors that are being kept open by the process. So go to /proc/
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 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. …
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…-queries=/var/log/mysql/slow-queries.log max_connections=650 open_files_limit=6144 max_connect_errors=10000 interactive_timeout=3600 wait_timeout… MySQL innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 innodb_lock_wait_timeout=15 # CHANGED from 50 innodb_log_files_in_group=3 innodb…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… Number – Happily now there is a limit on total number of prepared statements (… technique with innodb_file_per_table. However you can’t control growth of Innodb system…opening transaction and doing a lot of updates, or simply keeping transaction open and allowing other users to do updates – Innodb…
Post: What is the longest part of Innodb Recovery Process ?
December 20, 2007 By 2 Comments
… keep server completely unusable (some limitations still apply though). In the …innodb_file_per_table so “InnoDB: Reading tablespace information from the .ibd files…” stage was taking most of the time. Happily Innodb…well – “Opening Tables”. As Innodb has to recompute the stats first time it opens …
Post: Living with backups
November 6, 2008 By 28 Comments
…copying physical data files, in order not to saturate the I/O you can limit the rate…a file that was opened with O_DIRECT flag, the file needs to be aligned to the file…InnoDB tablespaces, other MySQL data files do not comply with this requirement. The trick could be used here perhaps to read the file…
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…). Additional undo slots – In the built-in InnoDB, the number of open transactions is limited to 1023 (see bug report). Â XtraDB allows…
