How InnoDB handles REDO logging – MySQL Performance Blog [by Ewen Fortune]
Friday, May 6th, 2011How MySQL InnoDB implements transaction log, aka REDO (Oracle), aka WAL (PostgreSQL)
Archive for the 'database' Category
How InnoDB handles REDO logging – MySQL Performance Blog [by Ewen Fortune]
Friday, May 6th, 2011OTN Discussion Forums : SQL*Plus 10.2.0.1.0 does not work on … | times(NULL) = loop
Friday, May 6th, 2011It appears to be an interesting bug in some versions of Oracle 10g, on Linux 2.6.x oracle process goes in loop doing times() system call if machine uptime < 199 days. Nice!!! / Oracle refs are bug 4612267 and 5867987 ) . The solution is to reboot.
InnoDB Flushing: Theory and solutions – MySQL Performance Blog
Friday, April 29th, 2011blog posts that describes how MySQL InnoDB flushes data to disk (also see bgwriter, checkpoint_* parameters in PostgreSQL)
Understanding the StackOverflow Database Schema – SQLServerPedia
Tuesday, April 19th, 2011Notes about schema used by StackOverflow.com and related websites. It is very simple, only several tables used. (most likely because there are performance problems with joins)
Robert Haas: MySQL vs. PostgreSQL, Part 1: Table Organization
Tuesday, November 30th, 2010An article from a well-known PostgreSQL developer comparing MySQL InnoDB and PostgreSQL table structures
Google Translate "Again about SQL " — route costs lookup for telephony operator
Tuesday, November 23rd, 2010Google translate of 2 posts in Russian section of LJ about route costs look up problem commonly faced by telephony operators
Comparing BenchmarkSQL Performance on Red Hat® Enterprise Linux 5 to Windows Server Enterprise
Wednesday, September 22nd, 2010“This paper compares the performance of an Online Transaction Processing (OLTP) based
PostgreSQL versus Oracle!
Thursday, July 29th, 2010Full Text Search benchmark, Oracle vs Postgres, on 2x Quad core Xeon, 8G RAM, 2 SSDs x RAID 1. Pg is being slightly faster when query contains several words, once word count increases, oracle leaps ahead (suggesting a more mature FTS implementation)
PGCon2010: Perspectives on NoSQL [Gavin M. Roy, CTO of MyYearBook.com]
Monday, July 12th, 2010http://www.pgcon.org/2010/schedule/attachments/141_PostgreSQL-and-NoSQL.pdf