…file to # /etc/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_flush_log…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…RAM 12 Core Processor 1TB – Disk My.cnf ========== freehold: [client] port=…innodb_flush_method=O_DIRECT innodb_thread_concurrency=16 innodb_buffer_pool_size = 4500M innodb_lock_wait_timeout=60 innodb_log_buffer_size = 32M innodb_log_file_size = 512M innodb_open_files=2048 #Replication-skip replicate…
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: 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_flush_log…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…my.cnf should look something like this on a relatively weak machine. [mysqld] server_id=1 binlog_format=ROW log…log_slave_updates innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 innodb_buffer_pool_size=400M innodb_log_file_size… not permitted) at galera/src/replicator_str.cpp:prepare_for_…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
…innodb_log_file_size = 48M This is still too small for any real load but a lot better than 5MB. Good to see innodb log re-sizing…log_info settings. James also promises updated sample my.cnf and getting rid of old my-huge.cnf which are great. Perhaps my jokes about my-huge my…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… not forget you may need to increase size of your Innodb log files to be able to use a …innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible to InnoDB…that table on a separate computer, maybe a replication slave. Can you make the reorganization run …
Comment: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
January 13, 2010 By 20 Comments
… databases on this box. The defaul /etc/my.cnf is fine and i can take the …sock \ –innodb_log_file_size=20M \ –innodb_data_file_path=ibdata1:10M:autoextend \ –innodb_log_group_home_dir=/data/comdb-slave/mysql/datafiles/ \ –innodb_data…this is happening. The slave is good and replicating data …
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…logging. If you don’t specify it in my.cnf file, the remaining part of the configuration will not matter, because the log file…innodb] msl patch currently can log three types of information: query timings, execution plan details and InnoDB…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
…file /etc/my.cnf,i add wsrep_cluster_address=gcomm:// to fill it ,the mysql server will not running [root@mysql1 ~]# vi /etc/my.cnf…innodb_autoinc_lock_mode=2 the wrong infomaton : 130221 17:59:00 mysqld_safe WSREP: Running position recovery with –log…
