10

2 Gmail Tricks I Bet You Didn't Know About


Posted by Artem Russakovskii on August 17th, 2009 in Awesomeness, Google, My Favorites, Technology, Tutorials

OK, maybe you did know them – just see for yourself.

Introduction

The tricks I am going to describe allow you to create unique gmail addresses that still hit your existing gmail inbox, without actually making new gmail accounts.

This can be useful in a variety of situations when you need to use multiple email addresses without having the pain of maintaining them, such as

  • using unique emails while registering for the same service more than once (say, paypal)
  • giving out a unique email address to see if you start getting spam to it later – that way you know exactly who to blame for it
  • more generally, easily create email rules to sort incoming emails into folders, delete them,
  • Read the rest of this article »

14

MySQL Slave Lag (Delay) Explained And 7 Ways To Battle It


Posted by Artem Russakovskii on September 5th, 2008 in Databases, Programming

Updated: September 16th, 2012

http://forge.mysql.com/w/images/1/1e/Dolphin_Laptop_cropped-386x222.jpgSlave 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
  • Read the rest of this article »

11

Getting The Most Out Of The MySQL Conference


Posted by Artem Russakovskii on March 26th, 2008 in Databases, Personal

As half of the world population already knows, the MySQL conference is coming in less than 3 weeks. Since this event only happens once a year, lasts only 4 days, and costs more than a Russian mail-order bride, I'd really like to get the most out of it. Considering that the schedule is completely packed, with 8 (!!) events going on in parallel, I imagine things can get a little frantic. Additionally, I've never been to a conference of such size before and I'm not sure what to expect.

So… I'm contemplating:

  • printing out the event schedule and drawing a zig-zagging "map" of exactly where I'll be jumping to next, once the previous presentation ends. I'm actually wondering
  • Read the rest of this article »