(Vadim Tkachenko) We many times wrote about InnoDB scalability problems, this time We are faced with one for MyISAM tables. We saw that several times in synthetic benchmarks but never in production, that’s why we did not escalate MyISAM scalability question. This time working on the customer system
Tag: Open Source
Managing MySQL Table Relations with Rails’ Active Record Association Types
(Jason Gilmore) In last week’s article, I showed you how Rails’ powerful migrations feature eliminates the long-standing chasm separating the way databases and code are maintained by offering a way to programatically manage table structures. Combined with Rails’ Active Record implementation, program
The MySQL Optimal Configuration Architecture (MOCA)
(George Trujillo) I am a firm believer in establishing best practices for database management and following them. As your databases grow in numbers and size, it becomes critical to establish best practices for your database management. I was asked recently to write down some of these best practices
wormhole: index reads
(Jan Kneschke) I got a few comments about my last example not describing a wormhole, but a whitehole. Time to improve the picture a bit and getting data from another dimension on a shorter route than the long standard way.
Hiding SQL in a Stored Procedure
(Lewis Cunningham) I recently wrote a blog entry (on my Postgres blog) about hiding SQL in a stored procedure, Hiding SQL in a Stored Procedure. I decided to see if I could convert that same concept to a MySQL stored procedure.
MySQL: delay_key_write is good
(Mark Robson) If you’re using MySQL with the MyISAM engine for a high-writes application, delay_key_write is usually very good.
UNION vs UNION ALL Performance
(Peter Zaitsev) When I was comparing performance of UNION vs MySQL 5.0 index merge algorithm Sinisa pointed out I should be using UNION ALL instead of simple UNION in my benchmarks, and he was right. Numbers would be different but it should not change general point of having optimization of moving L
JOINs VS ENUMs
(Tim Soderstrom) So last week MySQL was on site at work for MySQL DBA Certification prep. class (which was very awesome and highly recommended, by the way) and one of the things that came up was how much faster enumerated types would be over using JOINs, say to store things like the categories of a
How to check and optimize MySQL tables in parallel
(Xaprb) I wanted to point out something that might not be obvious from the name: MySQL Parallel Dump can be used as a generic wrapper to discover tables and databases, and fork off worker processes to do something to them in parallel. That “something” can easily be invoking mysqlcheck — or any other
Improved handling of large Falcon transactions
(Robin Schumacher) In previous MySQL 6.0 alpha’s, the new Falcon engine didn’t handle ‘large’ transactions (meaning lots of rows inserted at one time) very well. You typically had to fall back to looping through the data with various commit points to get all the data inserted in a timely fashion.