(Xaprb) At my previous employer, one of the early decisions that had huge payoffs later was the SQL naming conventions. A good naming convention is more than just a nicety. It lets you write programs that dont need to be told about the relationships among tables and columns.

(Keith Murphy) Recently I was working on a problem for a customer. They are converting a server with two InnoDB data files to innodb_file_per_table:

(Ryan Lowe) We have written before about the importance of using numeric types as keys, but maybe you’ve inherited a schema that you can’t change or have chosen string types as keys for a specific reason. Either way, the character sets used on joined columns can have a significant impact on the perf

(Vincent Danen) MySQL is one of the most popular database packages available for any platform. It makes its mark primarily being the backend to Web applications and sites and usually the defaults are fine for most installations. With larger demand and more data, defaults are most likely inefficient

(Martin Brown) Ive mentioned a number of times that the documentation repositories that we use to build the docs are freely available, and so they are, but how do you go about using them?

(Giuseppe Maxia) A relay slave is a slave that writes to its binary log the stream of commands received from the master, thus enabling other slaves to replicate.

(Guy Adams) Parallel Ltd. was founded in 1998 and is based in Milton Keynes, United Kingdom. Our main product is SatManage, a web-based application for managing satellite networks.

(Augusto Bott) The other day we began to encounter weird and random errors on small and innocent queries that shouldnt give any errors at all. It all lead to one of our most basic health checks failing for no apparent reason.

(Arjen Lentz) In MySQL, not all keywords are reserved words, and because of the way function parentheses are handled by default, function names aren’t reserved words either.

(Sheeri Cabral) This is a post about SYSDATE() and NOW() and CURRENT_TIMESTAMP() functions in MySQL.