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; …

PORTLAND, Ore.--Tim O'Reilly is giving a keynote speech at the Ubuntu Live conference, even as I type. I spoke just before him, and he's now throwing out much of what I said. :-) (I argued that we need to be more religious about open source, not less, by which I meant "filled with passion," not "filled with fury toward unbelievers," which is not a religion that I've seen much of here.)

O'Reilly is talking about the rising tide of Ubuntu, using book data, search data and other things (see right) that lead him to believe that Ubuntu is clearly growing in popularity. Tim warns, however, that we need to not get infatuated with open source qua licensing but rather need to think about how it (and, in this …

Based upon a user request, this is a follow up entry to show how jMaki on Rails For Dummies work on NetBeans 6 Milestone 10. Some of the steps are simplified and more details are provided. The updates from the previous blog entry are highlighted in this color.

1. Download NetBeans 6.0 M10 (Full version) and configured to install only "Base IDE", "Java IDE", "Web and Java EE" and "Ruby" modules. A cutting-edge build can be obtained from the hudson build.
2. Download and install …

A

By Brady Forrest

Mappam is a new ad network that specializes in placing text ads on user mapping sites. The site launched in late June and already hosts a number of tools for both advertisers and hosts. The founders are Nick Black and Steve Coast, both are core members of Open Street Map.

Mappam ads can technically be put on Google, Yahoo!, Microsoft, Multimap, OpenStreetMap/Openlayers maps. They can currently be found on Tagzania (see an ad), …

If you are running a Linux laptop that uses NetworkManager, you can get a list of every wireless network that NetworkManager knows about by doing

gconftool-2 --all-dirs /system/networking/wireless/networks

If you want to delete one, do

gconftool-2 --recursive-unset /system/networking/wireless/networks/BADNETWORKNAME

I find this useful when I'm in a venue, such as a tech conference, where there is both a free conference wireless network, and a paid wireless network run by the convention center. If you ever accidentally associate with the paid network, then whenever the signal strength of the paid network is higher, NetworkManager will prefer it to the free one. The fix is to delete the paid network data from the gconf database.