…my.cnf…innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 innodb_buffer_pool_size=400M innodb…default_backend pxc-back frontend stats-front bind *:80 mode http default…database and a userfor it. mysql> create database…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
…defaults-file=/etc/my.reg.cnf…set by –use-memory parameter) InnoDB: Log scan progressed past the checkpoint lsn 3 763355707 090730 23:22:43 InnoDB: Database…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…as close to the original one as possible (e.g. to have the same set of storage engines or default…factors such as storage engines used (InnoDB will take significantly longer to close than MyISAM), database configuration, … one as it enables the logging. If you don’t specify it in my.cnf file…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… not up to date as we would due to the database latency. To give you more information, this is my.cnf: [mysqld] datadir=/var…64M default-collation=utf8_unicode_ci default-character-set=utf8 default-storage-engine=InnoDB bulk_insert_buffer_size=8M # Innobd Tuning #innodb_force_recovery=2 innodb_thread…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (…- query cache disabled. Not a big surprise though as this is default value I believe there was attempt …lot better in Innodb (and we have patches for this) Operating System Notes from database server: UFS …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… (which are used by default) have to live in …my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb…setting. Summary For the two workloads that are most relevant to databases …see the difference in production as I had another machine …
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…As the name implies, CDC software captures the changes made to database… unique server_id in the my.cnf log_slave_updates=1,…increment primary key, > c2 int > ) > engine=innodb; Query OK, 0 rows affected …is because this is the default config filename to search … 3 rows in set (0.00 sec) As you can see,…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
…InnoDB. If your server really hasn’t been configured — that is, it’s running with a default…, I sometimes see unlikely settings, such as making the sort buffer size… my.cnf file. It’s sometimes possible to look at the my.cnf…database. These changes can give a much greater improvement in your database…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
…database server. So, my…my.cnf configuration file [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default…innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file_path = ibdata1:100M:autoextend set-variable = innodb_buffer_pool_size=100M set-variable = innodb…
Comment: Time for Zero Administration effort at MySQL ?
January 9, 2012 By 4 Comments
…innodb_buffer_pool_instances. These and a few other settings are usually fine in their default setting…settings (from my.cnf or SHOW GLOBAL VARIABLES) and just tells you how much memory will be allocated for those settings…
