…lock, it will wait for that lock before proceeding (this is where deadlocks and lock wait timeouts…mysql> SHOW ENGINE INNODB STATUS\G … ———— TRANSACTIONS ———— … —TRANSACTION 83B, ACTIVE 50 sec 2 lock struct(s), heap size 376, 1 row lock…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb-…0 innodb-use-sys-stats-table innodb-write-io-threads=4 join-buffer-size=16M key-buffer-size=64M local-infile=on lock-wait-timeout=…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
… innodb_lock_wait_timeout=60 innodb_log_buffer_size = 32M innodb_log_file_size = 512M innodb_open_files=2048 #Replication-skip replicate-ignore-table=mysql.gsd_runs replicate-ignore-table=mysql… innodb_lock_wait_timeout=60 innodb_log_buffer_size = 32M innodb_log_file_size = 512M innodb_open_files=2048 #Replication-skip replicate-ignore-table=mysql.gsd_runs replicate-ignore-table=mysql…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… 5.1.50, to match the client’s version of MySQL; they are very careful about upgrades. The RDS instance was… innodb_file_per_table ON innodb_flush_log_at_trx_commit 1 innodb_flush_method O_DIRECT innodb_force_recovery 0 innodb_io_capacity 200 innodb_lock_wait_timeout 50 innodb_locks…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
… table_cache = 3600 table_definition_cache = 4096 thread_cache_size = 16K wait_timeout = 120 connect_timeout = 60 tmp_table_size = 192M max_heap_table_size … innodb_buffer_pool_size = 4096M innodb_lock_wait_timeout = 120 innodb_use_sys_malloc = 0 long_query_time = 8 #log-slow-queries = /var/log/mysql…
Comment: How to calculate a good InnoDB log file size
June 1, 2010 By 38 Comments
…innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 I stopped mysqld, deleted the data+log files, but when I start mysql…
Comment: FreeBSD tests
August 4, 2006 By 15 Comments
…innodb_log_files_in_group=2 \ –innodb_log_buffer_size=8M \ –innodb_flush_log_at_trx_commit=1 \ –innodb_lock_wait_timeout=300 \ –innodb_locks_unsafe_for_binlog=1 \ –innodb…
Comment: Choosing innodb_buffer_pool_size
September 24, 2010 By 39 Comments
…. and mysql with Innodb tables. 100mb of data is available. i have set normal configuration in ini with query_cache=64mb and innodb_additional… 0 innodb_log_buffer_size 8M innodb_buffer_pool_size 1G innodb_log_file_size 24M innodb_thread_concurrency 16 innodb_lock_wait_timeout 120 max_heap_table_size…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 75 Comments
… tables are in InnoDB with MySQL 5 and RHEL 5. Its a 32 bit machine with 12 Gb RAM. The imp param for InnoDB… = 2000M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 65M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 A count command with approx 3 million records is taking too long and all my transactions are locked. select…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
…InnoDB tables #innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend #innodb_log_group_home_dir = /var/lib/mysql/ #innodb… size #innodb_log_file_size = 100M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 …
