(Rob Gravelle) Viewing the process list is a key step in debugging many common server problems, including bottlenecks, poor performance, deadlocks, connection issues, and many others. For that reason, knowing how to bring up relevant information on running processes is crucially important. In today’

(Leo Hsu and Regina Obe) Today’s modern web application workflow in its simplest form looks something like this:

(Chris Travers) In general, in most languages, programmers try to keep their subroutines down to a couple screens in size. This helps, among other things, with readability and ease at debugging. Many SQL queries are significantly longer than that. I have queries which are over 100 lines long in L

(Michael McLaughlin) Back in May I explained how to create MySQL striped views with session variables. A couple folks wanted to know how to implement them through PHP programs. The trick is sharing the same connection between a call to the function before a query against the striped view.

(Robert Eisele) You often see databases with huge dynamic text fields, such as VARCHAR(255), TEXT, or as I recently was allowed to see the blanket use of LONGTEXT (max 4GiB) in order to be invulnerable from all contingencies.

(Michael McLaughlin) Somebody wanted an example of how to handle column values using PHP to query a MySQL database. While I thought there were enough examples out there, they couldn’t find one that was code complete.

(Leo Hsu and Regina Obe) As we discussed in file_textarray_fdw Foreign Data Wrapper, Andrew Dunstan’s text array foreign data wrapper works great for bringing in a delimited file and not having to worry about the column names until they are in. We had demonstrated one way to tag the field names to a

(Mark Leith) I’ve written before about how you can monitor the last wait per connection with Performance Schema in MySQL 5.5.

(Shlomi Noach) What is the difference between the following three syntaxes?

(Ike Walker) When I first started using MySQL, I was happy to see that MySQL had the familiar SYSDATE() function that I’d been using for years in Oracle. I wrote a bunch of code using SYSDATE() in MySQL, and then one day I noticed that my slave database sometimes had higher timestamp values than the