…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…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…innodb_file_per_table innodb_log_group_home_dir = /log/mysql/var/ innodb_checksums = 0 innodb_doublewrite = 0 innodb_buffer_pool_size = 5000m innodb_additional_mem_pool_size = 20M innodb_log_file_size = 1600M innodb_log_buffer_size = 16M innodb…
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…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
…size=4G innodb_additional_mem_pool_size=20M # Set the log file size to about 25% of the buffer pool size innodb_log_group_home_dir = /mnt/log_mysql innodb_log_file_size=1G innodb_log_buffer_size=64M innodb_flush_log…me “if you don’t know how to do it, hire a guy that know how to do it…” Thanks a …
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
…to have it 20MB (sometimes larger) so you can see how much memory Innodb allocates for misc needs. innodb_log_file_size Very important for write intensive workloads especially for large data sets. Larger sizes…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
…MySQL 5.5 the setting of innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log_file_size are important for tuning. Also, upgrading to…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…tpcc-mysql, 500w (around 50GB of data) on RAID10. I used innodb_buffer_pool_size=24G, innodb_log_file_size=2000M (innodb_log_files_in_group=2), and innodb_flush_log_…are supposed to fix the buffer pool scalability issue. Let’s see how MySQL performance changes for the last workload if we set innodb_…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…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: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
…second to execute; logging every query; MySQL was run with default settings except following: [mysqld] user=root max_connections=3000 innodb_log_file_size=128M innodb_flush_log…case is about 1000 per second. Logging to /dev/null It is interesting to know how much from performance degradation caused …
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
…to show how to meassure the impact of my.cnf changes replaying a slow query log…mysql-host=127.0.0.1 –mysql-user=root –mysql-schema=my_db –query-log-file=slow.log…to ignore that. Second try, add 2GB of InnoDB Log Files (innodb_log_file_size=1G, innodb_log_files…
