(Johan Andersson) There are currently three derivates of MySQL Cluster 5.1: MySQL Cluster 5.1 MySQL Cluster 5.1 – Carrier Grade Edition (CGE) 6.2 MySQL Cluster 5.1 – Carrier Grade Edition 6.3

(Roland Bouman) Many MySQL users like to use the MySQL monitor. The MySQL monitor is the executable bin/mysql (or if you are on MS Windows, binmysql.exe) and is perhaps better known as the MySQL command-line tool or MySQL command-line client.

(W. Jason Gilmore) Graphically oriented MySQL administration tools abound, but for true speed and no-frills management perhaps nothing is more effective than the command-line driven MySQL client. However, the inordinate amount of typing due to executing common queries, determining what database you’

(Martin Farach-Colton) So far, I’ve analyzed point and range queries. Now it’s time to talk about insertions and deletions. We’ll call the combination updates. Updates come in two flavors, and today we’ll cover both.

(Mark Callaghan) Decimal is the default numeric data type in MySQL5. By this I mean that Decimal is the type for most numeric literals, is much improved over the implementation in MySQL4, and is the numeric type preferred by just about anyone who has to explain the semantics of decimal to binary flo

(Peter Zaitsev) Finding largest tables on MySQL instance is no brainier in MySQL 5.0+ thanks to Information Schema but I still wanted to post little query I use for the purpose so I can easily find it later, plus it is quite handy in a way it presents information:

(Carsten) One of the cooler inventions in recent versions of MySQL is having the slow log and general log available as plain-text files as well as CSV-engine type tables directly within the mysql database.

(Peter Zaitsev) One performance gotcha with MEMORY tables you might know about comes from the fact it is the only MySQL storage engine which defaults to HASH index type by default, instead of BTREE which makes indexes unusable for prefix matches or range lookups. This is however not performance gotc

(Leo Hsu and Regina Obe) Many in the PostgreSQL community use Microsoft Access as a front-end to their PostgreSQL databases. Although MS Access is strictly a windows application and PostgreSQL has its roots in Unix, the two go well together. A large part of that reason is because the PostgreSQL ODBC

(Roland Bouman) MySQL 5.1 offers an extremely useful feature called information_schema plugins. This feature allows dynamic runtime loading of a shared library into the MySQL server to implement a table in the information_schema database. The SQL standard (ISO/IEC 9075-11:2003) allows database imple