This post is originally created by Baron Schwartz at MPB (A.k.a. MySQLPerformanceBlog.com) days ago. What follows is not a realistic benchmark, it’s not scientific, it’s just some quick and dirty tinkering. Baron threw up an Ubuntu 9.04 small server on Amazon. (Because there’s a .deb of MonetDB for it), and created a table with 200 […]
Continue reading…
Databases
PostgreSQL Database Performance Tips
What follows for the next few posts is a somewhat edited version of a set of advice I am giving to a Sun team on redesigning a C++ application which was built for MySQL, ported to PostgreSQL, and never performance optimized. It occurred to me that this advice would be generally useful to the community, […]
Continue reading…
Repair MySQL Replication by SQL_SLAVE_SKIP_COUNTER
If you set up MySQL replication, you probably have ever faced this problem. there are invalid MySQL queries which cause the replication not to work anymore. Here I’ll explain how you can repair the replication on MySQL slave without rebuilding the whole repication environment. There are two steps here:
Continue reading…
MPB: InnoDB vs MyISAM vs Falcon
MySQLPerformanceBlog has issue “Several days ago MySQL AB made new storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks to see how Falcon performs in comparison to InnoDB and MyISAM.
Continue reading…
Performance Tuning PostgreSQL
PostgreSQL is the most advanced and flexible Open Source SQL database today. With this power and flexibility comes a problem. How do the PostgreSQL developers tune the default configuration for everyone? Unfortunately the answer is they can’t. The problem is that every database is not only different in its design, but also its requirements. Some […]
Continue reading…
PostgreSQL Application Performance Tips
Josh Berkus (PostgreSQL Core Team Member) Original Version is here Posted 11/28/2006 What follows for the next few posts is a somewhat edited version of a set of advice I am giving to a Sun team on redesigning a C++ application which was built for MySQL, ported to PostgreSQL, and never performance optimized.
Continue reading…
Falcon Storage Engine Design Review
Now as new MySQL Storage engine – Falcon is public I can write down my thought about its design, which I previously should have kept private as I partially got them while working for MySQL.
Continue reading…
Tuning Linux For Oracle
This article is a step by step guide for tuning and optimizing Red Hat Enterprise Linux on x86 and x86-64 platforms running Oracle 9i (32bit/64bit) and Oracle 10g (32bit/64bit) standalone and RAC databases. This guide covers Red Hat Enterprise Linux Advanced Server 3 and 4 and the older version 2.1.
Continue reading…