(Hazan Ilan) In a case that you copy (INSERT INTO .. SELECT ..) a MyISAM table that have a PRIMARY key, it is much faster to insert the new rows in the primary key order:

(Sean Hull) MySQL tables, including MyISAM and InnoDB, two of the most common types, experience fragmentation as data is inserted and deleted randomly. Fragmentation can leave large holes in your table, blocks which must be read when scanning the table. Optimizing your table can therefore make full

(Ovais Tariq) Replication enables data from one MySQL server, called the master, to be replicated to one or more MySQL servers, called slaves. Replication is mostly used as a scale-out solution.

(Peter Zaitsev) There are many angles you can look at the system to predict in performance, the model baron has published for example is good for measuring scalability of the system as concurrency growths.

(Daniël van Eeden) Since MySQL 4.0 it’s possible to use SSL to secure the connections to MySQL. Unfortunately this is not used very often.

(Baron Schwartz) Among the many things that can cause a “server stall” is a long-running transaction. If a transaction remains open for a very long time without committing, and has modified data, then other transactions could block and fail with a lock wait timeout.

(Giuseppe Maxia) I have just seen Limiting table disk quota in MySQL by Shlomi Noach, and I could not resist.

(Ilan Hazan) If you use a MySQL version >=5.1 use the following command:

(Shlomi Noach) Question asked by a student: is there a way to limit a table’s quote on disk? Say, limit a table to 2GB, after which it will refuse to grow? Note that the requirement is that rows are never DELETEd. The table must simply refuse to be updated once it reaches a certain size.

(Michael McLaughlin) Writing an anonymous block to conditionally drop tables and sequences got very old. I figured it was time to simply put a procedure that would simplify it. Avoiding repetition was important too, so it supports an invoker rights model. This mimics the IF EXISTS syntax available i