http://www.xaprb.com/blog Stay curious! Mon, 08 Feb 2010 19:36:15 +0000 http://backend.userland.com/rss092 en I explored two interesting topics today while learning more about Postgres. Partial page writes PostgreSQL's partial page write protection is configured by the following setting, which defaults to "on": full_page_writes (boolean) When this parameter is on, the PostgreSQL server writes the entire content of each disk page to WAL during the first modification of ... http://www.xaprb.com/blog/2010/02/08/how-postgresql-protects-against-partial-page-writes-and-data-corruption/ Many times I've heard people advise on "best practices" for a MySQL database. This often includes routine maintenance, such as "you should run OPTIMIZE TABLE on all of your InnoDB tables once a week to defragment them for better performance." But this advice is unsubstantiated and could even be detrimental. ... http://www.xaprb.com/blog/2010/02/07/how-often-should-you-use-optimize-table/ InfiniDB has a sensible Enterprise/Community release process, which seems similar to what I suggested for MySQL. Its simplicity also stands in stark contrast to MySQL's new release policy, which is hard to understand and has been confusing people. Related posts:Thank you for the MySQL 5.4 Community Release MySQL 5.4 How ... http://www.xaprb.com/blog/2010/02/04/infinidb-gets-the-release-process-right/ Yes, Maatkit's name was inspired by Ma'at, which has an apostrophe. But there is NO apostrophe in the name of the popular toolkit for MySQL users. I'm just sayin'. Related posts:Learn about Maatkit at the MySQL Conference I’m Speaking about Maatkit at CPOSC I’m Making Maatkit more Open Source one step ... http://www.xaprb.com/blog/2010/01/26/there-is-no-apostrophe-in-maatkit/ I'm on the voting committee of the MySQL Conference this year. I was on the same committee in 2008. This year's submissions are awesome. Much different from previous years, for whatever reason. Some of the proposals are sales pitches, infomercials, or just generally BS, but there's a gang ... http://www.xaprb.com/blog/2010/01/25/the-mysql-conference-will-be-very-good-this-year/