(Peter Zaitsev) Quite frequently I would log in to customers system and find MySQL using too much memory. I would look at memory consumed by Innodb (it is often higher than innodb_buffer_pool_size) substract memory used by other global buffers such as query_cache_size and key_buffer and will in many

(Jan Kneschke) If you use replication with MySQL and memcache at the same time you have the problem to make sure that the memcached and the slave are in sync. If you announce the memcached to mark a entry as dirty and let it update the value from the slave BEFORE it is updated, you fetch a old value

(Baron Schwartz) There is much discussion of why MySQL is more widely adopted than PostgreSQL. The discussion I’ve heard is mostly among the PostgreSQL community members, who believe their favorite database server is better in many ways, and are sometimes puzzled why people would choose an inferior

(Peter Zaitsev) MySQL Server does not require you to specify name of the index if you’re running ALTER TABLE statement – it is optional. Though what might be good practical reasons to specify the key name or omit?

(Greg Sabino Mullane) I recently released a new version of check_postgres.pl, the Postgres monitoring script. The URL has changed to http://bucardo.org/check_postgres, as the emphasis is less on Nagios and more on generic monitoring; I hope to have it directly support other monitoring systems in the

(Sheeri Cabral) One of the most frequently needed functionality in the MySQL Proxy is the need to know which server you are on. This is not given, on purpose, by the proxy, because the proxy is supposed to be transparent. It is not supposed to matter which back-end server you are on.

(Roberto Giorgetti) I recently got fed up with using the usual shared-directories mechanism to implement file sharing. Not only are there too many permissions to define at the administrator level, it also requires all the actions for sharing files among different operating systems. And what if you h

(Baron Schwartz) Recently I had an interesting surprise with concurrent inserts into a MyISAM table. The inserts were not happening concurrently with SELECT statements; they were blocking and the process list was filling up with queries in Locked status.

(Justin Swanhart) I’ve come up with some interesting workarounds for missing features using @session variables and I’d like to share one with you today: DELETE … JOIN … LIMIT N;

(Leo Hsu and Regina Obe) The below is by no means an exhaustive comparison of these 3 databases and functionality may not be necessarily ordered in order of importance. These are just our experiences with using these 3 databases. These are the databases we use most often. If we left your favorite da