….info file, and any later # change in this file to the …info file, unless you shutdown # the slave server, delete master…size innodb_log_file_size = 1000M #innodb_log_buffer_size = 32M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql…
Comment: How to calculate a good InnoDB log file size
June 1, 2010 By 38 Comments
…mysql/ innodb_log_arch_dir = /var/lib/mysql/ innodb_buffer_pool_size = 2048M innodb_additional_mem_pool_size = 20M innodb_log_file_size = 512M innodb_log_files_in_group = 2 innodb_log_buffer_size = 8M innodb_thread_concurrency = 8 innodb…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 17 Comments
…log file size. On my system I set to 128M, which does not 100% accurately reflect log file size x 4 factor. But I can change…innodb_log_file_size…innodb log file RECREATE did NOT seem to work if you are going to delete the log files…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…innodb_force_recovery=1 and as you can see even though I get the message in the log file…deleted rows or dropped table. I should also mention at Percona we offer assistance in MySQL Recovery, including recovery from Innodb corruptions and deleted…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…DELETE CASCADE -> ) ENGINE=INNODB; — 0 Tickets Used Query OK, 0 rows affected (0.00 sec) mysql…size=24G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_files_in_group=2 innodb_log_file_size=1900M innodb…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
…InnoDB, it is also important that your transaction logs…mysql> show binary logs; +——————+———–+ | Log_name | File_size | +——————+———–+ … | mysql-bin.000022 | 336797725 | | mysql-bin.000023 | 107 | +——————+———–+ 23 rows in set (0.00 sec) mysql…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…innodb hot backup or snapshot backup) as this is only way practical at this point for databases of decent size…file size. Though in this example we used MySQL binary log file…delete this particular file. BZIP compression for this file took 298 seconds which is just 3.4 MB/sec though compressed file…
Post: Why you can't rely on a replica for disaster recovery
July 31, 2010 By 25 Comments
…files. After running fsck on the replica, the InnoDB data files were entirely deleted…InnoDB file” contained blocks of data that were obviously from other files, such as Python exception logs…changed…MySQL replication has the same weakness. If you rely on a MySQL…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…size=20M innodb_file_io_threads=4 innodb_lock_wait_timeout=15 # CHANGED from 50 innodb_log_files_in_group=3 innodb_flush_log_at_trx_commit=0 #innodb_log_file_size…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… to innodb_flush_log_at_trx_commit=2). A major change was completed…are no longer needed and deletes them from the database. The…sizes can be set using compile time switches. However, if the index page size is changed….frm file. One extreme example of this is PBXT recovery. When MySQL calls the…
