June 18, 2013

Post: Ultimate MySQL variable and status reference list

…constantly referring to the amazing MySQL manual, especially the option and variable reference table. …Key_writesblogpercona.commanual languageblogpercona.commanual large_files_supportblogpercona.commanual large_page_sizeblogpercona.commanual large_pagesblogpercona.commanual last_insert_idblogpercona…

Post: How InnoDB handles REDO logging

… the pages inside the database. Instead of logging whole pages (…‘insert’, ‘after record at offset 8192’, ‘(38, Percona, …will never complete. Both the MySQL configuration and hardware will… be beneficial to have very large transaction logs which allow… logs beyond the InnoDB limit of 4G. As a…