Archive for the 'mysql' Category

MySQL vs PostgreSQL Benchmarks | Random Bugs

Sunday, December 13th, 2009

yet another mysql vs postgresql benchmark using “OSDB”. Small difference between the two, but consider that benchmark was done on 2-way SMP, 3GB ram, 1 SATA DISK and a small dataset.

Optimizing Linux for random I/O on hardware RAID – Fishpool

Wednesday, October 7th, 2009

explains use linux IO scheulers with presence of smart RAID controllers.

NPW2009 – my.opera.com scalability v2.0

Thursday, September 17th, 2009

slides from my.opera.com architecture presentation. Iptables/linux lvs -> apche/mod_perl -> mysql replication, varnish, memcached

[php mvc] Framework – mzz.ru

Monday, August 10th, 2009

kind of cool MVC framework, supports a lot of modern features like url routing, etc. documentation seems to be only available in russian

Open Source Database Magazine

Thursday, July 23rd, 2009

pdf magazine that covers open-source databases, MySQL, PostgreSQL and alike.

[RUS] PostgreSQL vs MySQL

Wednesday, June 10th, 2009

test uses db schema and usage pattern from popular blog-hosting site. Benchmark uses optimized queries

A look at the MySQL forks [LWN.net]

Thursday, May 14th, 2009

describes recent forks, patch-sets and build of mysql. If you looking at this page deciding which fork of mysql will be better suited for your new project — maybe better to use PostgreSQL instead

Benchmarking Databases I. Volatile Storage. – Pon un sol en tu vida

Friday, February 20th, 2009

PostgreSQL, MySQL and Oracle are compared using reasonable hardware setup and TPC-C like test with BenchmarkSQL tool (JDBC ) . This post will probably disappear soon as the author clearly violates oracle license that does not permit publishing benchma…

Cache Performance Comparison | MySQL Performance Blog

Wednesday, November 19th, 2008

gives you an idea how different caching methods perform. Read it before implementing something

Cookies are for Closers » LinkedIn Architecture

Thursday, June 5th, 2008

interesing notes about LinkedIn architecture (JAVA + MYSQL + ORACLE)