… systems. Veritas File System can do it for Solaris. Most SAN systems would work as well. What …Recovery time is as fast as putting data back and standard MySQL crash recovery, and it can be reduced … backup. Normally you can skip slow query logs and error log while taking backup. You also can skip …
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… to be periodically printed into MySQL error log. You can later disable logging by simply dropping the table…the stored information is read back to user. To make things more difficult, MySQL keeps the file deleted… However on many systems such as Linux or Solaris, but possibly also others, there is a …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…help the write performance of Innodb on Solaris? HT: Yes, if your ‘write working set’…log flushes. A question is why to use a flash memory at all, when a battery-backed disk controller write-back…buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent …
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
…has posted some numbers on it a while back. After you have decided with database size … tables (mysql database, temporary etc) will need it, .frm file, binary logs, or relay logs, Innodb Transactional Logs also … need to do anything. On Linux, FreeBSD, Solaris you need to set innodb_flush_method=O…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
…back cache only No read cache or read-ahead No drive write cache enabled Partitioning You want to run only MySQL…dev/sda1 2048 7813119 3905536 82 Linux swap / Solaris Partition 1 does not end on cylinder boundary…. =version 2 bsize=4096 ascii-ci=0 log =internal log bsize=4096 blocks=50608, version=2 =…
