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 …
[Read more]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.
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), …
[Read more]
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 …
[Read more]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.
I’m at Ubuntu Live today in Portland, Oregon, with my colleague Jay Lyman. Jay and I both live in Portland, making this the shortest conference trip of the year, traffic permitting. The conference takes place just prior to OSCON in the same venue, produced by O’Reilly Media.
MySQL AB CEO Mårten Mickos just finished a keynote this morning. During the Q&A portion following his talk, an audience member inquired about MySQL’s potential adoption of the GPLv3. The answer? “I think it very well might happen,” said Mickos. He went on to discuss the successes of the GPLv2 and the point that even if it takes three to five years for MySQL to embrace the GPLv3, a waiting period isn’t a big deal. Mickos sees no benefit in rushing the process to adopt the new license as the MySQL project is successful today …
[Read more]