Archive for the 'mysql' Category

How InnoDB performs a checkpoint at Xaprb [by Baron Schwartz {of Perconna, MySQL vendor }

Friday, May 6th, 2011

An article about MySQL InnoDB checkpoint-ing mechanism written by Perconna folks. Read comments as well, several PostgreSQL core committers have participated in the discussion.

“InnoDB’s checkpoint algorithm is not well documented. It is too co…

How InnoDB performs a checkpoint at Xaprb [by Baron Schwartz {of Perconna, MySQL vendor }

Friday, May 6th, 2011

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

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)

MySQL Benchmarks – MySQL 5.0.92 vs 5.1.55 vs 5.5.10 vs Percona 5.1.55 vs Percona 5.5.8 vs MariaDB 5.2.5 | vbtechsupport.com

Saturday, April 23rd, 2011

Sysbench-based benchmark comparing OLTP workloads for different builds and forks of MySQL on 64-core intel machine (Quad Intel Xeon L7555 ) . Only one definitive result is that MySQL cannot scale beyond 8 or 16 cores, or in some cases beyond just 2 cor…

[rus] Vktontante.ru architecture | Архитектура Вконтакте | Insight IT

Tuesday, November 30th, 2010

[ENG] http://translate.google.com/translate?u=http%3A%2F%2Fwww.insight-it.ru%2Fmasshtabiruemost%2Farkhitektura-vkontakte%2F&sl=ru&tl=en&hl=&ie=UTF-8
some info about internals of vkontakte.ru – russian facebook clone, most popular soci…

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

Jobs – Mixpanel | Real-time Web Analytics, Funnel Analysis

Wednesday, November 10th, 2010

GreenSQL | Open Source Database Security, SQL Injection Prevention

Tuesday, March 9th, 2010

SQL-proxy/filtering software for MySQL and PostgreSQL databases, used to prevent SQL-injection-like attacks, filter-out dangerous SQL, etc