The latest from the MySQL community

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.

After some stagnation, the test creator is on the move. Currently it can record the client's input and the server's response to write the .test file and the .result file. The implementation of some major test keywords are on the way as well.

The site for the project is http://code.google.com/p/mysql-test-creator

The milestones:
-July 23: testing keywords and a basic test
-July 30: test to prove test works
-August 6: handle multiple connections
-August 13: multiple connections / complete the macro module
-August 20: full test suite w/ documentation
-August 27: fix bugs, test with different versions of MySQL

They did it

The order had been delayed. Shipping should now happen somewhere in September. Two more months?! Amazon had to be kidding. I want that book and I want it now. Or tomorrow. Or before the weekend — BUT NOT IN SEPTEMBER.

This was last Wednesday and my shouting must have been heard. I got a mail later that day telling me my order had been shipped. Nice. It arrived on Thursday afternoon, good job Amazon.

The book is a full 209 pages including index and glossary and I love the index: It has soaking and NIH and freakouts and Spiderman. Rands has quite a vocabulary, a vocabulary that is perfectly suited for a …

All content on these blogs are copyright (c) M. Zack Urlocker 2005-2007.  All rights reserved. Material may not be reproduced without explicit permission from the author.