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.
Posted in benchmark, database, dba, mysql, performance, postgres, postgresql, sql | Comments Off | permalink
explains use linux IO scheulers with presence of smart RAID controllers.
Posted in database, for:collidr, IO, kernel, Linux, mysql, performance, postgresql, raid, sysadmin, tuning | Comments Off | permalink
slides from my.opera.com architecture presentation. Iptables/linux lvs -> apche/mod_perl -> mysql replication, varnish, memcached
Posted in iptables, lvs, memcached, mod_perl, mysql, performance, scalability, web2.0 | Comments Off | permalink
kind of cool MVC framework, supports a lot of modern features like url routing, etc. documentation seems to be only available in russian
Posted in framewok, mvc, mysql, opensource, php, russian, web2.0, webdev | Comments Off | permalink
pdf magazine that covers open-source databases, MySQL, PostgreSQL and alike.
Posted in CouchDB, database, db, drizzle, hadoop, magazine, mysql, opensource, pdf, postgresql | Comments Off | permalink
test uses db schema and usage pattern from popular blog-hosting site. Benchmark uses optimized queries
Posted in benchmark, database, db, for:collidr, mysql, performance, postgresql | Comments Off | permalink
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
Posted in database, dba, development, for:collidr, mysql, opensource | Comments Off | permalink
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…
Posted in benchmark, database, dba, for:charlesnw, for:collidr, mysql, oracle, performance, postgresql, tpc-c | Comments Off | permalink
gives you an idea how different caching methods perform. Read it before implementing something
Posted in development, for:collidr, memcached, mysql, performance, php, programming, scalability, speed, sql, web | Comments Off | permalink
interesing notes about LinkedIn architecture (JAVA + MYSQL + ORACLE)
Posted in architecture, database, design, java, linkedin, mysql, partitioning, scalability | Comments Off | permalink
You are currently browsing the archives for the mysql category.
Konstantin Antselovich (c) 2004-2011
powered by WordPress
Entries (RSS)
and Comments (RSS).