(Sheeri Cabral) The easiest way to see the differences between two schemas on a non-Windows machine is to run:

(Peter Zaitsev) It is pretty understood the tables which have long rows tend to be slower than tables with short rows. I was interested to check if the row length is the only thing what matters or if number of columns we have to work with also have an important role. I was interested in peak row pro

(Ronald Bradford) You can apply this approach to many things in life, I apply it to describing and using MySQL the product, and it’s components. The Query Cache like many features in MySQL, and indeed features in many different RDBMS products (don’t get me started on Oracle *features*) have relative

(Michael McLaughlin) One of my students asked how you validate the foreign keys in a MySQL database. First off, this only works if the database engine supports referential integrity (the fancy word for foreign keys as database level constraints). InnoDB and Falcon support referential integrity. The

(Rob Gravelle) Indexes are a feature that you can enable on your MySQL tables to increase performance, but they do have some downsides. When you create a new index, MySQL builds a separate block of information that needs to be updated every time there are changes made to the table. This means that i

(Shlomi Noach) This post follows SQL: Ranking without self join and On user variables evaluation order. I wish to share some insights with regard to user variables evaluation, as well as provide yet another ranking solution, which attempts to overcome the uncertainty factor with user variables.

(Ronald Bradford) The MySQL Innodb storage engine provides ACID compliance, the ‘I’ being isolation. There are four states defined in MySQL with the tx_isolation system variable, READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ and SERIALIZABLE.

(Michael McLaughlin) I always tell my students how to protect their Oracle credentials but hesitated to do the same for MySQL because it involves Windows batch shell scripting (albeit simple one line scripting). Oracle is nice and clean about hiding credentials. If you only provide the USER name at

(Peter Zaitsev) The mistake I commonly see among MySQL users is how indexes are created. Quite commonly people just index individual columns as they are referenced in where clause thinking this is the optimal indexing strategy. For example if I would have something like AGE=18 AND STATE=’CA’ they wo

(Geert Vanderkelen) .. it could have been the title for the next James Bond movie, but no.. It’s much more exciting!