…_suffixblogpercona.commanual delay_key_writeblogpercona.commanual Delayed_errorsblogpercona.commanual delayed_insert_limitblogpercona.commanual Delayed_insert_threadsblogpercona.commanual delayed_insert_timeoutblogpercona.commanual delayed_queue_sizeblogpercona.commanual Delayed_writesblogpercona…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…. delay_key_write Delay updating indexes for MyISAM tables. Good for performance but tables will be badly corrupted on crash. delayed_insert_limit, delayed_insert_timeout, delayed_queue_size Delayed inserts…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… ‘Created_tmp_files’, ’4001′ ‘Created_tmp_tables’, ’669137′ ‘Delayed_errors’, ’0′ ‘Delayed_insert_threads’, ’0′ ‘Delayed_writes’, ’0′ ‘Flush_commands’, ’5′ ‘Handler_commit’, ‘…_files_limit=6144 max_connect_errors=10000 interactive_timeout=3600 wait_timeout=3600 key_buffer_size=32M # Only for MyISAM …
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
…_mode 1 innodb_buffer_pool_size 55050240000 innodb_change_buffering inserts innodb_checksums ON innodb_commit_concurrency 0 innodb_concurrency_tickets…_force_recovery 0 innodb_io_capacity 200 innodb_lock_wait_timeout 50 innodb_locks_unsafe_for_binlog OFF innodb_log_buffer…_read_io_threads 4 innodb_replication_delay 0 innodb_rollback_on_timeout OFF innodb_spin_wait_delay 6 innodb_stats_on_metadata ON…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
… node without needing to worry about replication delay However, good engineers know there is always… (this is where deadlocks and lock wait timeouts can happen). By the time the transaction …varchar(32) DEFAULT NULL, PRIMARY KEY (`i`) node2 mysql> insert into autoinc (j) values (‘node2′ ); Query OK, …
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
July 25, 2012 By 57 Comments
… taking minutes do run (most of times I got a timeout). I thought that I need to optimize the database and… automatically inserting this SQL_CALC_FOUND_ROWS in my queries, without my knowledge, and that’s what caused the long delay. When…
