(Mike Taluc) Ruby’s ActiveRecord provides a very robust means of manipulating database table structures especially in the context of automated deployments such as Capistrano.

(Stewart Smith) or… “the case of Stewart recognizing parameters to the read() system call in strace output”.

(Chris Calender) When InnoDB appears hung, I know the natural reaction is to check SHOW ENGINE INNODB STATUS.

(Ulf Wendel) The catchy theme/motto of the PECL/mysqlnd_ms 1.2 release will be Global Transaction ID support. Hidden behind the buzzword are two features.

(Michael McLaughlin) This demonstrates how to create an Java infrastructure for reading and writing large text files to a MySQL database. The example provides:

(Andrew Morgan) I was speaking with a MySQL customer last week and he had a feature request for MEM. He wants different servers to have different threshold values for certain MEM advisor rules and suggests that users be allowed to override the thresholds when scheduling the rule against a server – j

(Shlomi Noach) Unless your MySQL is configured to use ANSI_QUOTES in sql_mode, you are able to quote your text in one of two forms: using single quotes or double quotes:

(Tony Darnell) A friend of mine was asking me for my recommendation of a good desktop database program to use to keep track of his inventory of cargo containers. I suggested to him that he should use MySQL and write a web page interface to do everything that he needed. He then reminded me that he is

(Simon Mudd) I want to keep a record of the configuration of the MySQL servers I manage. The configuration of some servers differs from others and over time the configuration may vary, partly as a result of upgrades in the mysql version or the use of the particular mysql instance, so tracking this i

(Ulf Wendel) The mysqli quickstart series is coming to an end. Today, the post is about non-prepared statements. You may also want to check out the following related blog posts: