Updated: March 10th, 2009
I could not be more excited about the upcoming Starcraft 2. Announced in 2008, a whopping 10 years after the first Starcraft release, the news sent shockwaves through millions of Starcraft fans, myself included.
I’ve been watching and anxiously awaiting the release and, while the final release date is unknown at this point (I'll update the post when it is announced), I’ve assembled a list of current Starcraft 2 facts, summarized as bullet points.
But before I get into that, here’s the most important part you need to know to be able to get your hands on the game right after it’s released and play online ($49):
MySQL Slave Lag (Delay) Explained And 7 Ways To Battle It
Updated: September 16th, 2012
Slave delay can be a nightmare. I battle it every day and know plenty of people who curse the serialization problem of replication. For those who are not familiar with it, replication on MySQL slaves runs commands in series – one by one, while the master may run them in parallel. This fact usually causes bottlenecks. Consider these 2 examples:
- Between 1 and 100 UPDATE queries are constantly running on the master in parallel. If the slave IO is only fast enough to handle 50 of them without lagging, as soon as 51 start running, the slaves starts to lag.
- A more common problem is when one query takes an hour to run (let's say, it's an UPDATE with a
…
beer planet is a blog about technology, programming, computers, and geek life. It is run by Artem Russakovskii - a local San Francisco geek who is currently pursuing his own projects and regularly enjoys hacking Android, PHP, CSS, Javascript, AJAX, Perl, and regular expressions, working on Wordpress plugins and tools, tweaking MySQL queries and server settings, administering Linux machines, blogging, learning new things, and other geeky stuff.
