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 |…
Tag: 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?
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…
Alternate queries on results pages making it easier for future evilness?
John Battelle implies that the new search result page being testing by Google could make evilness easier in the future. The premise is that offering alternate queries might be useful now, but it would make it easier to insert paid listings later. I’m confused though, and John doesn’t have a comment link in his RSS…