… log at all, your transaction will never complete. Both the MySQL configuration and hardware will affect the speed at which InnoDB can log… the record is skipped. This behavior can be seen by enabling the innodb_recovery_stats option in Percona Server, which allows… logs which allow a larger window between REDO logging and the checkpoint on disk. Vadim touched upon this subject recently in his post MySQL…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
…enable logging queries which do not use indexes even if they take less time (–log-queries-not-using-indexes) Slow query log…log first to fix worse queries and then come to find more optimization candidates. So “tail -f mysql-slow.log | mysql_slow_log… you to keep the other window open and find query …
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…enabling named pipes on Windows # (via the “enable-named-pipe” option) will render mysqld useless! # #skip-networking # Replication Master Server (default) # binary logging…ibdata2:10M:autoextend #innodb_log_group_home_dir = /usr/local/mysql/data/ #innodb_log_arch_dir = /usr/local/mysql/data/ innodb_…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
… time, no keying time), it uses MySQL C API and the server side … does not fit in memory. Attention!(Windows only): You should not use with … uses 1 insert buffer thread, 1 log thread, 1 read thread, 1 write … controls [enable/disable] of read-ahead. 3: normal 2: enable linear read-ahead only 1: enable…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…can be happening on Unix at a time. On Windows, InnoDB uses native async I/O, and can … write at 100MBps vs 33MBps. Any plans to enable tuning of the checkpointing rate? Postgres exposes this …MySQL‘s binlog and InnoDB’s log must have the transactions in the same order, for a recovery based on MySQL…
