(Ulf Wendel) Psst, you want some client-side MySQL load balancing with and without sharding for your PHP application? PHP 5.3 has something to offer for you. It is free. It requires no to very little changes to your applications.

(Sean Hull) Cloud deployments of internet sites are becoming much more prevalent everyday. Let’s take a look at what type of special considerations we’ll need to make for hosting MySQL successfully in the cloud.

(Ronald Bradford) In the past I’ve used the profiling features (e.g. SHOW PROFILES) in MySQL to help with timing SQL statements, especially those in the < 10 millisecond range. [membership level="0"] [pmpro_button level="14" text="Read More - Register for Free Membership"][/membership] [membership][standout-css3-button href="http://ronaldbradford.com/blog/changes-in-using-profiling-in-mysql-5-5-2011-01-19/" opennewwindow=true]Read More[/standout-css3-button] (Community content) [/membership]

(Michael McLaughlin) One of my students asked for some help on developing a MySQL stored procedure that would conditionally drop a foreign key constraint. I put together a quick example, which compiled fine but failed at run time. With some investigation it appears that either the MySQL 5.5 Document

(Ilan Hazan) I will start by defining the MySQL Many to Many relationship (Experts can skip to the next paragraph).

(Chris Calender) Even when the output of EXPLAIN doesn’t show “using temporary”, a temporary file may still be used in certain cases.

(Peter Zaitsev) You might know if you have long running transactions you’re risking having a lot of “garbage” accumulated in undo segment size which can cause performance degradation as well as increased disk space usage.

(Singer Wang) I’ve seen many a good DBA make the master of starting slaves from the position in the master.info file, most recently this week, that I want to bring it to everyone’s attention. Of course I mean the underlying issue and not the names of the DBA because that would be cruel.

(Baron Schwartz) This isn’t actually new — it has been out for a few releases. The mk-query-digest tool from Maatkit now outputs information about each class of queries’ variance-to-mean ratio. The new output goes in a couple of places, including perhaps most usefully the “profile” report. Here’s an

(Rob Gravelle) Many groups and individuals are involved in the field of data management, from MySQL administrators, architects, developers, as well as infrastructure support people. Each of these plays a part in the security, maintenance, and performance of a MySQL installation.