…/mysql- –with-innodb and next startup options were used: libexec/mysqld –no-defaults –user=root –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread-concurrency=8…=pOIo5aX59b6Z8eWjePZU-JQ or on our page http://www.mysqlperformanceblog.com/files/benchmarks/innodb_scale.html (Note: This benchmark is synthetic micro benchmarks…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_log_buffer_sizeblogpercona.commanual innodb_log_file_sizeblogpercona.commanual innodb_log_files_in_groupblogpercona.commanual innodb_log_group_home_dirblogpercona.commanual Innodb_log_waitsblogpercona.commanual Innodb_log_write_requestsblogpercona.commanual Innodb_log…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…innodb-io-capacity=1000 innodb-log-buffer-size=32M innodb-log-file-size=128M innodb-open-files=1000 innodb_fast_checksum innodb-purge-threads=1 innodb-read-ahead=linear innodb-read-ahead-threshold=8 innodb…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…innodb_file_per_table=1 innodb_file_format=barracuda innodb_log_file_size=512M innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit=2 innodb_flush_method=O_DIRECT query_cache_size…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… Replication Master Server (default) # binary logging is required for replication log-bin=db1-bin log-…innodb_buffer_pool_size = 8000M #innodb_additional_mem_pool_size = 80M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 1000M #innodb_log_buffer_size = 32M #innodb_flush_log…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… /usr/bin/mysqld_safe –defaults-file=/etc/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 3137 78 Nov19 ? 1-11:17:30 /usr/libexec/mysqld –defaults-file… is the absence of innodb_log_file_size. I won’t give you a full rundown over every option in the file. But again, you…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 64M innodb_buffer_pool_size = 26G innodb_buffer_pool_instances=16 innodb_log_file_size = 2000M innodb_log_files…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…_size=24G, innodb_log_file_size=2000M (innodb_log_files_in_group=2), and innodb_flush_log_at_trx_commit=2. Also, innodb_adaptive_flushing (ON) / innodb_adaptive_checkpoint (estimate) were the default…:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=4G innodb_log_block_size=4096 innodb_thread_concurrency=0 innodb…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
…of OK with default key_buffer_size even with large data set but it will crawl with default innodb_buffer_pool_size. Also Innodb buffer …much memory Innodb allocates for misc needs. innodb_log_file_size Very important for write intensive workloads especially for large data sets. Larger sizes offer …
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…-112-39-98 log_slave_updates innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 innodb_buffer_pool_size=400M innodb_log_file_size=64M You can….1 local0 log 127.0.0.1 local1 notice maxconn 4096 chroot /usr/share/haproxy user haproxy group haproxy daemon defaults log global…
