(Peter Zaitsev) Following up on my Previous Post I decided to do little test to see how accurate stats we can get for for Index Stats created by ANALYZE TABLE for MyISAM and Innodb.

(Gregory J. Haase) First in our series of Use Case reports on new MySQL 5.1 features, we have Greg Haase of Lotame describing his innovative use of partitioning. Usually, the creators of new applications are unaware of the various tweaking that users may submit their features to, in order to achieve

(Peter Zaitsev) As you might know ANALYZE TABLE just quickly updates table statistics using index dives, unlike with MyISAM when it scans indexes holding table lock for long period of time.

(Henrik Ingo) One way to look at a database is that –there is data, and –there are ways to access data.

(Peter Zaitsev) This week Ive worked with the customer doing certain work during maintenance window which involved a lot of data copying around between MySQL boxes. We had prepared well and had measured how fast we could copy the data between servers of these kind connected to the same network, and

(Giuseppe Maxia) If you are using MySQL replication, you know how hard is to monitor it properly. You have a wide choice of commercial and free tools, all of which check the health of your replication system from the outside.

(Brooks Johnson) One should use timestamps rather than datetimes as timestamps are four bytes and datetimes are eight bytes, right? This makes sense as smaller indexes and tables are faster than larger ones. However, when I was trying to quantify the improvement (Im strange that way), I found the e

(Oldag) I had a hard time coming up with a title for this blog post. I really wanted to capture its essence. Several discarded titles include, but are not limited to: –How It Works –The Gory Details –Everything You Never Wanted to Know –The Insider’s Perspective

So pictured here is a histogram of a moderately large set of random integers. Each vertical line represents the total number of entries at each particular integer. Since each number is made up of multiple random factors (10 different random numbers, each between 0 and 100, added together), the distr

(Sunny Walia) My friend today asked me how to convert all spaces in filenames under a specified directory to underscores. Also, at the same time lowercase all of the filenames. Here is a quick script to do what is needed.