(Ronald Bradford) I’ve finally decided to work on a number of improvements in Instrumentation within the MySQL Server I’ve wanted for the first year, See What is the optimal thread specific buffer size?. It’s been a while since I’ve compiled from source, and from these issues, the first under Ubuntu

(Peter Zaitsev) When you’re storing text of significant size in the table it often makes sense to keep it compressed. Unfortunately MySQL Does not provide compressed BLOB/TEXT columns (I would really love to have COMPRESSED attribute for the BLOB/TEXT columns which would make them transparently comp

(Ronald Bradford) So you want to know what join_buffer_size, sort_buffer_size, read_buffer_size and read_rnd_buffer_size values for your application should be? These MySQL thread specific buffers are variables I can never get right because there are insufficient metrics, instrumentation or even abst

(shodan) Sometimes you need to work with big numbers in PHP (gulp). For example, sometimes 32-bit identifiers are not enough and you have to use BIGINT 64-bit ids; e.g. if you are encoding additional information like the server ID into high bits of the ID.

If you have ever taken raw user input and inserted it into a MySQL database there’s a chance that you have left yourself wide open for a security issue known as SQL Injection. This lesson will teach you how to help prevent this from happening and help you secure your scripts and MySQL statements.

(Greg Sabino Mullane) In a previous article, I shared some ways of getting a random row from a table. I focused mainly on the “random column” method, but I’d like to revisit the “range of values” method in more detail, and show why it is a better choice. In short, the random column method (basically

(Roland Bouman) I would like to announce that The MySQL UDF Repository is no more. The rumour is that its growing popularity has caused it to be noticed by some folks at MySQL AB’s legal department, kindly requesting that the project’s name be changed to something even cooler.

(Sheeri Cabral) The listing of Dynamic System Variables on the MySQL Reference Manual’s page is supposed to show those variables you can change on-the-fly.

MySQL and Carahsoft invite you to a complimentary seminar providing you with sufficient training and knowledge transfer, to enable experienced Oracle DBAs to deploy and manage MySQL in a production environment. (R)

(Paul Dubois) Chapter 4,“Generating and Processing Forms,” covered the general techniques involved in creating forms. In this chapter, we’ll use those techniques to write several types of form-based applications, and in Chapter 6,“Automating the Form-Handling Process,” we’ll discuss how you can use