AIX Oracle tuning Posted on June 15, 2010, updated on September 2, 2021 by Yannick JaquierTable of contents Preamble Environment variables Maximum number of processes VMM tuning VMM background maxclient% maxperm% minperm% lru_file_repage page_steal_method Memory monitoring LOCK_SGA Large page memory Asynchronous I/O Concurrent I/O Filesystems tuning I/O monitoring References Continue reading
MySQL Initialization Parameters Tuning Posted on October 7, 2009, updated on June 25, 2015 by Yannick JaquierTable of contents Preamble Generic parameters Generic memory parameters Optimizer parameters Binary logging MyISAM InnoDB Query cache Recommended MySQL initialization parameters for InnoDB data model Continue reading