1,287 reputation
718
bio website blog.9minutesnooze.com
location New York, United States
age
visits member for 5 years, 6 months
seen Dec 18 at 15:52

Jul
2
awarded  Curious
Jun
9
awarded  Popular Question
Jun
3
awarded  Yearling
Dec
17
awarded  Nice Answer
Jun
3
awarded  Yearling
May
21
accepted Determine if LUKS/dmcrypt key is present
May
20
comment Determine if LUKS/dmcrypt key is present
Thanks for the response, Hauke. The reality that I've observed is that while it's only a few seconds to unlock the volume, it completely saturates a CPU during this operation which could prove problematic on a database in an OLTP scenario. Thanks for the alternatives, also.
May
17
asked Determine if LUKS/dmcrypt key is present
Feb
7
revised Rebooting an EC2 Instance
added 1 characters in body
Oct
12
awarded  Popular Question
Oct
11
awarded  Nice Answer
Aug
7
awarded  Notable Question
Jul
10
comment MySQL Slow Writes
I think the query cache is completely separate from the storage engine. It basically serializes all write operations by forcing everything to go through and scan the query cache for queries to invalidate. I've never found a use case for it and it has always caused problems.
Jul
10
comment MySQL Slow Writes
query_cache_size is enormous, too. Every insert will require up to 6GB of cache to be flushed.
Jun
25
comment How to automatically kill slow MySQL queries after N seconds?
Why not use pt-kill?
Jun
25
comment How to automatically kill slow MySQL queries after N seconds?
pt-kill is very well tested and solves your exact problem. It takes like 10 minutes to figure out the command line parameters and get it running. What more do you want?
Jun
3
awarded  Yearling
May
10
awarded  Necromancer
Apr
19
comment What is more important for a database server? Mem? Mem speed? Cores?
InnoDB Plugin can be installed easily in 5.1. Also, Percona Server 5.1 is based on InnoDB plugin.
Apr
19
comment What is more important for a database server? Mem? Mem speed? Cores?
Since MySQL was specifically mentioned, faster processors are usually a better choice than more (assuming you're not talking about just 1 or 2), as the speed of a single query is fundamentally limited by the speed of a single processor. Even the most recent MySQL versions don't scale as well as some other RDBMSes across multiple cores due to internal mutex and semaphore contention. I run several 24 core servers and I would give my left arm to trade them in for half as many cores that are 1.5x faster.