… into the steady decline of InnoDB throughput. Eventually it…Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql…log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb_log_file_size = 4G innodb_log_files_in_group = 2 innodb_log_block_size…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…Linux…mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… MySQL on. What is important I used Noop IO scheduler, instead of default …file_io_threads = 4 innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_file_size = 256M innodb_log_files_in…it is important to remember as Linux kernels 2.6.18+ (which are …
Post: Be careful rotating MySQL logs
December 9, 2007 By 7 Comments
… or MySQL 5.1 you can get log file to grow huge. Same may happen with general log file. In some cases we’ve got log file sizes of 100G… on typical Linux systems – If you follow most simple process – delete log file you do not need and run “FLUSH LOGS” so file is recreated…. When log file is reopened MySQL will be practically unavailable causing unanticipated downtime. The workaround for this problem is very simple – instead of deleting MySQL log file…
Post: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
… by default in RedHat / CentOS 5.x may be not so good for MySQL. And yesterday….7 anticipatory1465 Here is graph of disk writes (column bo in vmstat) during benchmark As you see…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…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… with the assumption of GNU/Linux, I keep working to get a picture of the OS and hardware… –defaults-file=/etc/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172…the absence of innodb_log_file_size. I won’t give you a full rundown over every option in the file. …
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6.10-linux-glibc2. | | MAX_ALLOWED_PACKET | 1048576 | 4194304 | | JOIN_BUFFER_SIZE…in this system. innodb_stats_on_metadata is disabled by default in MySQL 5.6 Welcome to much faster information_schema queries! innodb_log_file_size…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…log_slave_updates innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 innodb_buffer_pool_size=400M innodb_log_file_size…mysql-port=3306 –mysql-user=sbtest –mysql-password=sbpass –oltp-table-size=10000 –num-threads=8 run This is the status of…
Comment: Benchmarks of new innodb_flush_neighbor_pages
July 3, 2012 By 8 Comments
… the improvements in mysql 5.6 http://dev.mysql.com/tech-resources/articles/whats-new-in-mysql-5.6…reduced the size of binary log file from default 1GB (some systems have it set to 100MB in their default … Deadline scheduler is not the default schedualer of linux but was recommended for ext4. If they…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
…MySQL you might need to deal with RAID recovery every so often. Sometimes because of…in time recovery while backup setup only takes you to the point where last binary log…any generic Linux server. … : left-symmetric Chunk Size : 64K Name : …in a good shape. I also mounted it and checked couple of files…
