(Giuseppe Maxia) Returning an error message is one of the tasks that may become common when working with MySQL Proxy.

(Federico Kereki) Odds are, if you design Web sites with a database back end, you’ve worked with MySQL. You can manage this database from the command line, but it’s not very user-friendly. Using the graphical tool phpMyAdmin helps, but not all Web hosting providers offer it or allow you to install i

(Giuseppe Maxia) How do you return a dataset using MySQL Proxy? This being a common task, as many that we will see in these pages, it is worth implementing with a function.

(Leo Hsu and Regina Obe) PuTTY was developed by Simon Tatham and is a very common light-weight MIT-Licensed free and open source Secure Shell (SSH) client for connecting to Linux/Unix systems via a Teletype (TTY) terminal emulation mode console. Currently there are ports for Microsoft Windows, other

Lately, I’ve been trying to keep up with at least one of the MySQL Forums: Partitioning.

(Sergey Petrunia) The work on subquery optimizations goes on, and we’re already curious how the assortment of new 6.0 subquery optimizations compares to what is found in other DBMSes. MySQL’s new strategies are not DBMS theory breakthroughs, similar ideas have been implemented in other DBMSes, but w

(Tim Soderstrom) Recently, I noticed a post on Planet MySQL expressing distaste for surrogate keys. Ever since reading it the topic has been bugging me so I thought I would finally break out a defense for surrogate keys.

(Peter Zaitsev) Few days ago I wrote about testing writing to many files and seeing how this affects sequential read performance. I was very interested to see how it shows itself with real tables so I’ve got the script and ran tests for MyISAM and Innodb tables on ext3 filesystem.

(Mark Robson) A lot of people seem to spend a lot of effort comparing storage engine in MySQL – chiefly focusing on the difference between MyISAM and InnoDB.

(Deepal Jayasinghe) When you look back the computer industry, you can clearly identify different different technologies in different time periods. In any given time period, databases have a very high priority in the industry, from small scale to large scale business. You know that Web Services are b