I spent the day at the Drizzle Developer Day at Sun’s insane asylum campus. I’m not joking here, the campus was apparently a former insane asylum. First off I battled getting Drizzle to compile on Ubuntu 8.10, where the secret sauce appears to be to know about the drizzle-developer PPA. If you’re using Ubuntu 8.10,…
Category: Mysql
Discovering the CASE statement
In an effort to speed up my database updates, I’ve been looking for ways to batch some of my updates. CASE seems like the way to go: mysql> create table bar(a tinyint, b tinyint); Query OK, 0 rows affected (0.02 sec) mysql> insert into bar(a) values(1), (2), (3), (4), (5); Query OK, 5 rows affected…
Estimating the progress of queries on MySQL
I’ve been doing a lot of batch updates on one of my databases at home recently. show processlist says something like this: mysql> show processlist; +——-+——+—————+————–+———+——-+———-+——————————————+ | Id | User | Host | db | Command | Time | State | Info | +——-+——+—————+————–+———+——-+———-+——————————————| | 18354 | root | maui:37403 | smtp_servers | Query |…
Reducing the MySQL query lock timeout?
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?
Is there any way to access the match text in MySQL rlike selects?
Hi. I am doing a select like this in MySQL 5: select * from foo where bar rlike ‘(.*),(.*)’; The specific example here is made up. Anyway, I’d like to be able to get to the matched text from bar, like I can with various languages regexp libraries. Is this functionality exposed at all in…
Managing MySQL the Slack Way: How Google Deploys New MySQL Servers
Thanks to everyone who came along to Grant and my talk this morning about slack and how we bootstrap MySQL servers. Here is the slide deck as promised.
MySQL Users Conference
Well, they’re definitely thinking about getting started. Like last year I caught the VTA down — it’s hard to beat a $1.75 trip without having to worry about traffic. Registraton wasn’t as smooth this year as last, for example I didn’t get my free book (there didn’t seem to be any attempt to hand those…
Managing MySQL the Slack Way: How Google Deploys New MySQL Servers
I’ll be presenting about Slack (the open sourced tool kit we use for deployment software configuration) at the MySQL user’s conference in Santa Clara in late April. The talk will focus on the interesting aspects of Slack as it relates to MySQL and should be fun. A DBA mate of mine is gonna present with…
MySQL scaling: query snipers
I’ve been wanting a query sniper for a while for MySQL (some people seem to call them “query killers”). They’re basically programs which inspect the MySQL “show processlist” command and decide to kill some processes if they violate specified rules. I have a prototype of one in python, and couldn’t find any other implementations until…
They all use MySQL…
I was walking down Mountain View’s Castro Street this afternoon, and noticed that meebo is advertising for developers and system admins. Interestingly, they seem to match the design pattern used by pretty much every web 2.0 company I have seen around here (except MySpace): linux, MySQL, and Ajax. So, there you go.