Archive for the 'database' Category

How InnoDB handles REDO logging – MySQL Performance Blog [by Ewen Fortune]

Friday, May 6th, 2011

How MySQL InnoDB implements transaction log, aka REDO (Oracle), aka WAL (PostgreSQL)

How InnoDB handles REDO logging – MySQL Performance Blog [by Ewen Fortune]

Friday, May 6th, 2011

OTN Discussion Forums : SQL*Plus 10.2.0.1.0 does not work on … | times(NULL) = loop

Friday, May 6th, 2011

It 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, 2011

blog 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, 2011

Notes 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, 2010

An 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, 2010

Google 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, 2010

Full 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, 2010

http://www.pgcon.org/2010/schedule/attachments/141_PostgreSQL-and-NoSQL.pdf