Richard Wallman - a MySQL® DBA http://www.mysqldba.co.uk/articles Wed, 25 Nov 2009 21:56:43 +0000 http://backend.userland.com/rss092 en Introduction to stored routines (part 3) http://www.mysqldba.co.uk/articles/2008/12/10/introduction-to-stored-routines-part-3/ Introduction to stored routines (part 2) http://www.mysqldba.co.uk/articles/2008/12/03/introduction-to-stored-routines-part-2/ Introduction to stored routines http://www.mysqldba.co.uk/articles/2008/11/26/introduction-to-stored-routines/ Why turning on binary logging is good http://www.mysqldba.co.uk/articles/2008/10/06/why-turning-on-binary-logging-is-good/ Re-ordering columns without deleting data http://www.mysqldba.co.uk/articles/2008/09/26/re-ordering-columns-without-deleting-data/ Diagnosing “Too many connections” errors http://www.mysqldba.co.uk/articles/2008/09/12/diagnosing-too-many-connections-errors/ Let sleeping dogs die - automatically close idle connections http://www.mysqldba.co.uk/articles/2008/06/19/let-sleeping-dogs-die-automatically-close-idle-connections/ Starting to improve performance http://www.mysqldba.co.uk/articles/2008/03/24/starting-to-improve-performance/ What are ‘index prefixes’? http://www.mysqldba.co.uk/articles/2008/03/02/what-are-index-prefixes/ How to calculate cardinality http://www.mysqldba.co.uk/articles/2008/02/26/how-to-calculate-cardinality/