…DROP statement at position 336797160: mysql> show binary logs; +——————+———–+ | Log_name | File_size | +——————+———–+ … | mysql-bin.000022 | 336797725 | | …consistent data and still have my salaries table back. Because leaving a production server with active …
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… = 0 innodb_adaptive_flushing_method = keep_average innodb_log_block_size = 4096 innodb_log_file_size = 4G Versions: MySQL 5.5.20… a way to improve throughput in Percona Server: increase innodb_log_file_size. There are stability timeline for Percona Server with… too hard to figure it out, you always can fall back to the vanilla InnoDB-plugin, like MariaDB suggests in Benchmarking…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… PROCESSLIST Group commit for the binary log makes the server much faster with the binary log enabled Faster queries through speedier joins… come a long way. I remember that a couple years back I told Monty, “fix subqueries and you will change the…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… configuration file. I have the backup folder which contains xtrabackup log files, xtrabackup checkpoint file and a folder for my database… able to do a SINGLE DATABASE restore using the copy-back command. I am able to get the database in my…
Comment: How Does Semisynchronous MySQL Replication Work?
March 17, 2012 By 23 Comments
… only after the events have been written to its relay log and flushed to disk. ” “Compared to asynchronous replication, semisynchronous replication… occurs (which is by default set to 10sec), replication goes back to asynchronous.
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
Backing up binary logs are essential part of creating good backup infrastructure as it … backups of the binary log files which could still lead to data loss depending on the interval you back them up. Recently…=$(stat -c%s “$LASTFILE”) if [ $FILESIZE -gt 0 ]; then echo “Backing up last binlog” mv $LASTFILE $LASTFILE.orig$TIMESTAMP fi touch…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… it with (a) write-through and (b) write-back to see if write-back cache would minimize the effects of misalignment. File…_log_files_in_group = 2 innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 200 port = 3306 back_log… 8 threads. Different file sizes made no difference too. Write-back cache gave an incredible performance boost – up to 33x in…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
… can determine how many bytes back in the transaction log our oldest uncheckpointed transaction is by subtracting our ‘Log sequence number’ from the… checkpoint age as roughly the furthest back Innodb will allow us to go in the transaction logs; our Checkpoint age cannot exceed… our transaction logs are circular, and the checkpoint age represents how far back the oldest unflushed transaction is in the log. We cannot…
Post: Configuring MySQL For High Number of Connections per Second
January 6, 2012 By 17 Comments
… connection to MySQL is made, it can go into the back_log, which effectively serves as a queue for new connections on… will cause for some connection attempts to be refused. What back_log variable specifies is second parameter to listen() operating system call… was to increase the value of back_log to one that could handle longer bursts Increasing back_log to 1000 in this case would…
Post: How InnoDB handles REDO logging
February 3, 2011 By 18 Comments
…_log_at_trx_commit = 1 /* Write log buffer to log and flush to disk */ innodb_flush_log_at_trx_commit = 2 /* Write log buffer to log… the logging return before the record is actually on disk. A similar and complementary mechanism is to use a battery backed raid… consistent set of data. A change may be logged and then later rolled back do to an error or a specific request…
