(Peter Zaitsev) As you may have recently seen there are some articles about scaling MySQL one 256-way system.

(Barzan “Tony” Antal) You are reading the second segment of the four-part article series covering MySQL benchmarking concepts and strategies, benchmarking tools and utilities, and the most common query optimizations, design of optimal schemas, and server tuning tips. In this part we will present som

We talked with Mark Matthews, one of the architects of the MySQL Query Analyzer to give us an inside view into the product.

(Darren L. Oldag) We’re working hard getting MySQL Enterprise Monitor 2.0, featuring Query Analyzer, ready for release. As part of that, we started really ramping up the number of MySQL servers reporting in query data to see how we could scale. Not surprising (to me, anyway), the first efforts did n

(Sheeri Cabral) The maximum length of a VARCHAR is only restricted by the maximum row length. In most storage engines, the maximum row length is the maximum allowed by MySQL, which is 65,535 bytes. Only the NDB storage engine has a different maximum value.

(Maciej Dobrzanski) Everyone does backups. Usually its some nightly batch job that just dumps all MySQL tables into a text file or ordinarily copies the binary files from the data directory to a safe location. Obviously both ways involve much more complex operations than it would seem by my last sen

(Keith Murphy) I was doing some research over the weekend on how transactions work under the hood in MySQL. I thought it might be enlightening if I wrote about what I found.

(Ernest Bonat) Understanding and programming MySQL data load into the DataGridView control is a must for Windows Application Developers today. Many times, in real production environment the end-users need to see a result set of data to make daily business decisions. The main question is about how ma

(Barzan “Tony” Antal) MySQL is the worlds most popular open source relational database management system (RDBMS). As a result, over ten million installations are spread around the globe. Nevertheless, in reality only a small percentage of those are actually high performance, optimized, and tuned ser

(Giuseppe Maxia) A few days ago I was describing a common grievance when using partitions.