… run FLUSH TABLES WITH READ LOCK Note – this command may take a while to complete if you have long running queries. The catch here is FLUSH TABLES WITH READ LOCK… could have accomulated – especially if you use slave_skip_errors or sql_slave_skip_counter. Cloning master you’re starting from consistent…
Comment: Using LVM for MySQL Backup and Replication Setup
January 16, 2009 By 53 Comments
… I can skip the FLUSH TABLES WITH READ LOCK for my Innodb tables, but I also noticed the warning: “If you’re using only Innodb tables and do not need to synchronize binary log position with backup you can skip this step.” If I… for this so I don’t have to run the FLUSH TABLES WITH READ LOCK?
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
…-bin.001717 All you needed to do is to use –skip-slave-start on the slave server and have a little… do traditional and recommended way with FLUSH TABLES WITH READ LOCK for snapshot creation. This happens when you have large amount of tables or your load pattern… lock is used. You can just take LVM Snapshot (assuming you’re only using Innodb tables and not touching your MyISAM system tables…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…table_definition_cacheblogpercona.commanual table_lock_wait_timeoutblogpercona.commanual Table_locks_immediateblogpercona.commanual Table_locks_waitedblogpercona.commanual table_open_cacheblogpercona.commanual table…with_limitblogpercona.commanual Uptimeblogpercona.commanual Uptime_since_flush…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
… friday) System copes fine with these figures. Queries/sec: …Flush_commands’, ’5′ ‘Handler_commit’, ’19092941′ ‘Handler_delete’, ’0′ ‘Handler_discover’, ’0′ ‘Handler_read_first’, ’1100773′ ‘Handler_read_key’, ’2491307870′ ‘Handler_read… table_cache=512 # Default 64 was used before. skip-locking innodb…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
…skip-locking key_buffer_size = 2000M max_allowed_packet = 32M # table_cache=20M # open-files-limit=20000 table…log_buffer_size = 32M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [... familiar with SQL #safe-updates [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer …
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_…table_size=64M max_prepared_stmt_count=1000000 query_cache_size=0 skip_grant_tables skip_locking sort_buffer_size=64K table…table_size=64M transaction_isolation=REPEATABLE-READ local-infile=1 At first I tried sysbench oltp read-only with…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 116 Comments
…with mysql 3.x # clients (those using the mysqlclient10 compatibility package) old_passwords=1 skip-locking key_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read…
Comment: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…, I have problem with mysql server. here of my server detail : DELL R710…tmp skip-locking key_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read… = 2867M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_thread_concurrency =…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…table = true innodb_buffer_pool_size = 16G innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_flush…lock = 0 (default 1) It skip the updating statistics which needs the lock. (it only affects for “Data_free:” value of TABLE…of InnoDB) Recreated database files with the parameter. Then the …
