(Tony Darnell) Part One of Two: Checking on database activity when running a large DML (Data Manipulation Language) statement – such as INSERT, DELETE, UPDATE or SELECT.

(Shlomi Noach) Recap on the problem: •A query takes a long time to complete. •During this time it makes for a lot of I/O. •Query’s I/O overloads the db, making for other queries run slow.

(Adam Donnison) So far we’ve looked at many aspects of MySQL, not in any great depth, but hopefully with enough information to get you started and whet your appetite for more. Now we start to look into areas that aren’t in the basic tutorials.

(Tony Darnell) If you have ever built a form on a web page, you might have used a drop-down menu to display the choices available for a particular field. With a drop-down menu, you restrict the choices a user may select so that the user doesn’t enter invalid data (among other reasons). If a user mis

(Robert Eisele) I was asked for help in optimizing a MySQL query where flags are stored in a database and references should be counted based on the flag value. Sounds not complicated at first, but there are several flags that should be counted and also just once per reference.

(Robert Eisele) Dealing with large data sets makes it necessary to pick out only the newest or the hottest elements and not displaying everything. In order to have older items still available, Pagination navigation’s have become established. However, implementing a Pagination with MySQL is one of th

(Ulf Wendel) The free Mysqlnd replication and load balancing plugin now offers load balancing and lazy connections independent of read write splitting. This makes the plugin attractive for MySQL Cluster users.

(Charlie Killian) Using pt-query-digest is an excellent way to perform a SQL review. However, sometimes you don’t have access to the slow_query_log_file. For example, when MySQL runs on Amazon RDS, the slow_query_log_file is unavailable (see the RDS FAQ). To get around this, export the mysql.slow_lo

(Shlomi Noach) I’m having a lot of fun writing common_schema, an SQL project which includes views, tables and stored routines.

(Frazer Clement) In my previous posts I introduced two new conflict detection functions, NDB$EPOCH and NDB$EPOCH_TRANS without explaining how these functions actually detect conflicts? To simplify the explanation I’ll initially consider two circularly replicating MySQL Servers, A and B, rather than