… as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places… PROCESSLIST Group commit for the binary log makes the server much faster with the binary log enabled Faster queries through speedier joins… a couple years back I told Monty, “fix subqueries and you will change the world for a lot of MySQL users.” Well…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
Hello All – I have created a backup of my mysql database using the innobackupex-1.5.1 command. I have … configuration file. I have the backup folder which contains xtrabackup log files, xtrabackup checkpoint file and a folder for my database… restore using the copy-back command. I am able to get the database in my /var/lib/mysql folder. But I am…
Comment: How Does Semisynchronous MySQL Replication Work?
March 17, 2012 By 23 Comments
…after the events have been written to its relay log and flushed to disk. ” “Compared to asynchronous replication, …exists in at least two places” – (cf http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html)…(which is by default set to 10sec), replication goes back to asynchronous…
Post: Configuring MySQL For High Number of Connections per Second
January 6, 2012 By 17 Comments
… any account. When a new connection to MySQL is made, it can go into the back_log, which effectively serves as a queue for new connections on operating system size to allow MySQL to handle spikes. Although MySQL… for improvement, see this post by Domas]), With MySQL 5.5 default back_log of 50 and 2000 connections created per second it…
Post: MySQL Connection Timeouts
April 19, 2011 By 2 Comments
… connection. I’ll explain the math below. Second – is MySQL parameter back_log which has default value of just 50. You may want… as 3000 connections come in. Under such conditions the default back_log of 50 is enough just for 17 milliseconds, and if…. I would suggest sizing your tcp_max_syn_backlog and back_log value to be enough for at least 2 seconds worth…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual,….commanual back_logblogpercona….log_binblogpercona.commanual log_binblogpercona.commanual log_bin_indexblogpercona.commanual log_bin_trust_function_creatorsblogpercona.commanual log_errorblogpercona.commanual log_isamblogpercona.commanual log_outputblogpercona.commanual log…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
… the binary log files which could still lead to data loss depending on the interval you back them up. Recently in MySQL 5.6, mysqlbinlog got a new feature addition that supports connecting to remote MySQL instances and dumping binary log data to local disks ( http://dev.mysql.com/doc/refman/5.6…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have…/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log…_log_files_in_group = 2 innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 200 port = 3306 back_log…
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
… slow query log may be growing too rapidly to follow, so we implemented slow query log filter (based on parse_mysql_slow_log by… query log first to fix worse queries and then come to find more optimization candidates. So “tail -f mysql-slow.log | mysql_slow_log_filter… of time and then get back to logging only very slow queries. Once you have created full log – parse it and check queries…
Post: How InnoDB handles REDO logging
February 3, 2011 By 18 Comments
… log at all, your transaction will never complete. Both the MySQL configuration and hardware will affect the speed at which InnoDB can log… window between REDO logging and the checkpoint on disk. Vadim touched upon this subject recently in his post MySQL 5.5.8… consistent set of data. A change may be logged and then later rolled back do to an error or a specific request…
