… InnoDB: buffer… 120502 11:51:16 InnoDB: Started; log sequence number 119 647537164 1120502 11:51:17 [Note] /usr/libexec/mysqld…my.cnf /etc/my.cnf /etc/my.cnf.old /etc/my.cnf.rpmnew [root@tstlx1 mysql]# cat /etc/my.cnf | grep log_file # Set .._log_file_size to 25 % of buffer pool size innodb…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…_buffer_pool_mutex patch). my.cnf is [mysqld] user=root binlog_cache_size=1M default_table_type=MYISAM ft_min_word_len=4 innodb_additional_mem_pool_size=16M innodb_buffer_pool_size=15G innodb_data…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
…my.cnf to set global options, # mysql-data-dir/my.cnf…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…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… database latency. To give you more information, this is my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql….innodb_buffer_pool_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…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
….573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb-flush-log…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 116 Comments
…41 2.2 706m 172m 4764 S mysqld Below is my.cnf configuration file [mysqld] datadir=/var/lib/mysql socket=/var/…innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file_path = ibdata1:100M:autoextend set-variable = innodb_buffer_pool_size=100M set-variable = innodb_additional_mem_pool_size=10M innodb…
Comment: What to tune in MySQL Server after installation
June 22, 2009 By 116 Comments
… is as follows::: [root@crm ~]$ vi /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib…buffer_size=203K innodb_additional_mem_pool_size=2M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=1M innodb_buffer_pool_size=200M innodb_log_file_size=10M innodb_thread_concurrency=8 My…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb_read_io_threads = 8 innodb…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE …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…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
…innodb_buffer_pool_size = 384M #innodb_additional_mem_pool_size = 20M # Set .._log_file_size to 25 % of buffer pool size #innodb_log_file_size = 100M #innodb_log_buffer_size = 8M #innodb…
