(Sean Michael Kerner) One of the biggest areas of concern that helped to delay Oracle’s (NASDAQ: ORCL) acquisition of Sun last year was the open source MySQL database. As it turns out, Oracle has accelerated MySQL development, and this week previewed its next generation.

(Shinguz) With the new MySQL 5.6 release there are some more InnoDB Data Dictionary Tables in the INFORMATION_SCHEMA:

(Mark Callaghan) We limit the maximum number of concurrent connections per database account via the max_user_connections option. We are more interested in limiting the maximum number of concurrent queries and transactions per account to reasonable values while allowing much larger numbers of connect

(Shlomi Noach) How would you check whether some TIMESTAMP column falls within a given day, say July 26th, 2011?

(Baron Schwartz) I got a serendipitous call (thanks!) yesterday asking what would be needed to tune[1] a database for better performance. It is a question that I hear often, but I never thought about answering it in public. Here’s a consolidated version of what I explained during our conversation.

This programming tutorial will teach you how to create a simple, yet secure login script utilizing PHP using MySQL and bracing for XSS attack prevention.

(Nilnandan Joshi) There are several types of indexes are available in MySQL:

(Tony Darnell) Scripting Python to connect to a MySQL database is fairly simple, even if you don’t have any much experience with Python.

(Alejandro Gervasio) It’s hard to admit, but sooner or later we have to face the facts: most web developers (including myself) are reluctant to write SQL queries from scratch.

(Shinguz) Heating up the InnoDB Buffer Pool during the MySQL instance startup should significantly improve InnoDB Performance in the beginning of the life of the Instance. This is achieved by sequential scans of the needed data instead of random I/O reads which would happen when we just let the syst