(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.
Tag: Open Source
Using Partitioning and Event Scheduler to Prune Archive Tables
(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
Beware of running ANALYZE in Production
(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.
Accessing your MySQL data whatever way you want it
(Henrik Ingo) One way to look at a database is that –there is data, and –there are ways to access data.
How network can impact MySQL Operations?
(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
Introducing the MySQL community-driven Replication Monitoring Tools
(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.
Can a timestamp be slower than a datetime?
(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
MySQL Query Analyzer: A Peek Under the Hood
(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
Stats in MySQL Pt. II: Histograms
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
Quick tip: how do you rename all files so spaces are converted to underscores?
(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.
