… using solid state disks for storing ib_log* files; I know that innodb writes files in the log file group in a round robin fashion… the first file in a log file group. My questions are: What is always being written to the first file in the log file group? HT… these non-mysql processes drops rapidly when you increase the amount of system memory. We just deployed a new Linux/Mysql server for…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
…: innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 3 xtrabackup: innodb_log_file_size = 536870912 xtrabackup: use O_DIRECT >> log scanned up to (3 767617628) Copying ./ibdata1 to /data/vadim/mysql/export//ibdata1 >> log scanned… 78 for 5.0.83 unknown-linux-gnu (x86_64) xtrabackup: cd to /data/vadim/mysql/export/ xtrabackup: This target seems to…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
…file InnoDB: position 0 12501110, file name bin.000025 InnoDB: Last MySQL binlog file position 0 90914, file name /var/log/mysql…_64 x86_64 GNU/Linux Also currently: these config (my…log_file_size to 25 % of buffer pool size #innodb_log_file_size = 100M #innodb_log_buffer_size = 8M #innodb_flush_log…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… that page size is no bigger than stripe element; second – logs are actually written in 512 byte units (in Percona Server… blocks bigger than 4k (page size) on Linux unless you are using HugePages). Some file systems let you set stripe width and… End Size Type File system Flags 1 2048s 19531775s 19529728s primary ext4 boot 2 19531776s 27920383s 8388608s primary linux-swap(v1) 3…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… work on virtually any Linux distribution and possibly under most other systems. The patch is currently available for MySQL 5.0.45… log_slow_filter. log-slow-queries[=name] Log slow queries to this log file. Defaults logging to hostname-slow.log file. Must be enabled to activate other slow log… the log file won’t be created. This is also the only option which you cannot change at runtime from MySQL console wit…
Comment: A (prototype) lower impact slow query log
September 28, 2012 By 12 Comments
… a synchronization mechanism. The page for the Linux dup2() doesn’t make any guarantee, and …_slow_query_log.log.1 -> (somewhere/lese to change the folder of the rotated query log file (they …file rotation would be taking place at all). However, the log folder needs to be only writable by mysql…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… MyISAM tables (mysql database, temporary etc) will need it, .frm file, binary logs, or relay logs, Innodb Transactional Logs also … to serve writes to these log files as IO to the log files is not aligned to the page… VMSTAT “si/so” columns are zero on Linux. Couple of swaps per minute would not …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… declared inside InnoDB 442 mysql tables in use 1, locked 0 MySQL thread id 8079, query…Linux you will always see 4 helper threads, on Windows it however can be adjusted by innodb_file…logs and not flushed from buffer pool so such log sequences can’t be overwritten in log files. By monitoring log…
Post: The tool I've been waiting for years
March 18, 2008 By 10 Comments
… core for 1 file; 24169.00 pages, 94.4 Mbytes per file. So we can see one of Innodb log files is practically uncached while other has about 1/3rd cached – this makes sense, perhaps second log file is being… direct IO to log files on Linux because it is not aligned. [root@DB01 mysql]# du -h ibdata* 246G ibdata1 [root@DB01 mysql]# perl /tmp…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… myism tables and run on linux with 16gigs or ram. Here is our my.cnf # sammple MySQL config file for very large systems…/local/mysql/data/ #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend #innodb_log_group_home_dir = /usr/local/mysql/data/ #innodb_log_arch_dir… = 80M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 1000M #innodb_log_buffer_size = 32M #innodb_flush_log_at_trx…
