… user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool_…=off [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
It seems that in 5.5 the second log file is touched even if a rotation has not occurred, that ….html “If you kept the size of your redo log files artificially low because recovery took a long time, you can…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
Yes, and I also filed http://bugs.mysql.com/bug.php?id=69001 some time ago
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 20, 2013 By 13 Comments
… point standard). The Justice Department (and competitors like Control Data) filed suit to break up the monopolistic stranglehold IBM had on…
Comment: Is Synchronous Replication right for your app?
May 20, 2013 By 18 Comments
… — exactly, I think this really applies to any multi-writer system. second comment, first paragraph — I’d argue this is a…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
… the file to a new name, and then truncates the original file. no copytruncate – Uses the rename() system call to move the file to a new name, and then expects the daemon to be signaled to reopen its log file… operation. This problem is particularly evident when using the ext3 file system (instead of xfs). Use FLUSH LOGS instead of sending SIGHUP…
Comment: Testing the Micron P320h
April 16, 2013 By 7 Comments
… O_DIRECT the majority of the stuff what we expect file system to do is perform IO mapping from physical to direct…
Comment: Testing the Micron P320h
April 16, 2013 By 7 Comments
… about Btrfs or ZFS? Seems like with SSD the newer file systems could be more appropriate. 2) How does P320h compare to…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…. EXT4 is the filesystem, and CentOS 6.4 the operating system, although the pre-release modules I received from Virident required…. Time-based flushing has been disabled. In this case, both systems produce better performance when the dirty-page threshold is set…_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log_files_in_group = 2 innodb_purge_threads = 1 innodb…
Comment: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…://infoscience.epfl.ch/record/149436/files/vldb10aether.pdf The paper doesn’t reference multi-node replicated systems, but I’m fairly certain…
