Looking for documentation for read_rnd_buffer_size you would find descriptions such as "The read_rnd_buffer_size is used after a sort, when reading rows in sorted order. If you use many queries with ORDER BY, upping this can improve performance" which is cool but it does not really tell you how exactly read_rnd_buffer_size works as well as which layer it corresponds to - SQL or storage engine.

Honestly as it had name very similar to read_buffer_size which is currently only used by MyISAM tables I thought read_rnd_buffer_size is also MyISAM only. But talking to Monty today I learned it is not the case.

read_rnd_buffer can be used for All storage engines not only by MyISAM. It is used for some sorts to optimally read rows after the sort. Here is how it works:

As sort is performed it can be performed having only row pointers together with …

Direct play the episode at: http://tinyurl.com/39576s

Feedback:
http://odeo.com/sendmeamessage/Sheeri

Call the comment line at +1 617-674-2369.
E-mail podcast@technocation.org

News:
MySQL Focuses on Japan
http://www.mysql.com/news-and-events/news/article_1368.html

MySQL Associate Certification Now Available
http://www.mysql.com/certification/

Learning resource:
Pythian Group’s Carnival of the Vanities for the DBA community, published weekly on Fridays.
…

Could not resist the title after reading what Matt wrote. Sexy and exciting, indeed. Most of the crew here have their heads buried with the upcoming releases of Amanda Enterprise and Zmanda Recovery Manager (ZRM) for MySQL. We are continuing to enhance the Management console for Network backup. And with the next release of ZRM for MySQL, backup of MySQL database will never be the same. Dmitri already wrote about how easy it will be to manage MySQL backups from Iphone. Additionally we are fixing stuff in the Management console for ease of use. You can see, touch and feel them at LinuxWorld. …

Feedback:
http://odeo.com/sendmeamessage/Sheeri

Call the comment line at +1 617-674-2369.
E-mail podcasttechnocation.org">podcasttechnocation.org

News:
MySQL Focuses on Japan
http://www.mysql.com/news-and-events/news/article_1368.html

MySQL Associate Certification Now Available
http://www.mysql.com/certification/

Learning resource:
Pythian Group?s Carnival of the Vanities for the DBA community, published weekly on Fridays.
…

Zmanda today announced that its Zmanda Recovery Manager (ZRM) for MySQL is now available with the Zmanda Management Console -- a set of powerful graphical tools designed to simplify and accelerate the complex process of MySQL database backup and recovery. ZRM with the Zmanda Management Console can dramatically reduce the workload of a MySQL database administrator (DBA) while providing enterprise-class, MySQL-specific backup and recovery.

Here is a perfect photo from James Duncan Davidson that illustrates the drive and ambition of Mårten Mickos, our fearless leader, battling with an unfortunate competitor at the Ubuntu Live party on Sunday. Look closely to see the gritty resolve in Mårten's face. Arms outstretched. Teeth clenched. Clearly a ferocious competitor at heart.

In other news, a bunch of us — Kaj, Monty, Brian, Zack, Kelly, and myself — are up here in Portland at OSCON. I gave my tutorial yesterday and it was jam-packed and really a lot of fun. Lots of great questions and laughs. I'll post the tutorial slides, workbook, and the new benchmarking tool …

A few of us from Solid are up in Portland at OSCON. We’ll be showing off a new prototype of our high availability (HA) option for solidDB for MySQL. The HA option allows solidDB for MySQL to act in a hot-standby configuration where there is a primary and secondary server. The data in the primary is automatically synchronously replicated to the secondary. In the case that the primary fails, our HA Manager automatically performs a failover and the secondary server becomes the new primary. The secondary is also always available for read-only requests.

We’ll also be talking about DorsalSource, a community-focused Web site whose goal is to provide developers with easy access to builds of MySQL and related products. Come by booth 820 on Wednesday or Thursday if you want to hear more, …

The Apache Friends team is proud again to announce a new version of XAMPP for Linux and Windows. The new version of XAMPP includes fresh, green and up-to-date versions of: PHP (5.2.3) and MySQL (5.0.45). In case of Linux we also upgraded phpMyAdmin to the recent 2.10.3.

To all beta testers: Thanks so much for all your hard work!

Get XAMPP 1.6.3 here

I've already wrote a few times about various projects using Sphinx with MySQL for scalable Full Text Search applications. For example on BoardReader we're using this combination to build search against over 1 billion of forum posts totaling over 1.5TB of data handling hundreds of thousands of search queries per day.

The count of forum posts being large, is however not the largest we've got to deal in the project - number of links originating from forum posts is a bit larger number.

The task we had for links is to be able to search for links pointing to given web site as well. The challenge in this case is we do not only want to match links directed to "mysql.com" but links to "www.mysql.com" or "dev.mysql.com/download/" as well as they are all …

Apart from sniping the queries, is there any other way to reduce the amount of time that a query will wait before giving up on getting access to a locked table?

Tags for this post: mysql query lock timeout
Related posts: MySQL scaling: query snipers; Estimating the progress of queries on MySQL; Managing MySQL the Slack Way: How Google Deploys New MySQL Servers; …