Updated: December 16th, 2009

image It's not a secret that my Sprint HTC Hero has been having trouble keeping battery charge – by the time I came home from work, the battery level would oftentimes be at 10% or the phone would be simply dead.

One would give up and accept this futility but I had 2 reasons to keep trying to figure out why:

  • my co-worker's battery would consistently hold twice as much charge as mine – by the time I was at 50%, he was at 75%
  • a wide range of responses on Internet forums and blog posts suggested some people experienced excellent battery life, while others, like me, did not have as much luck
I received feedback from many people that the

Read the rest of this article »

0

Is Your Simplifymedia For Winamp Broken On A 64 Bit Windows 7? Here's How To Fix It


Posted by Artem Russakovskii on November 17th, 2009 in Tips

image

SimplifyMedia is an extremely useful program, which allows super easy song and playlist sharing via streaming between multiple computers. It also works as a Winamp plugin, so the shared songs simply show up inside Winamp's own media library – each computer sharing music appears under the special "Shared" tab. And the beauty is – there is no need to muck around with network settings, open ports, or even touch your router.

Here's a screenshot of how it's supposed to work:

image

The Problem

Since I recently installed Windows 7 64bit on my laptop, I wanted to set up SimplifyMedia on it and listen to some tracks in my favorite music player Winamp. However, after I downloaded and installed it and …

Read the rest of this article »

33

How To Fix Palm Pre's "Error Sending Mail" Problem


Posted by Artem Russakovskii on July 14th, 2009 in Personal, Technology

Updated: January 30th, 2013

imageThe Problem

My fiancée Emilie has had her Palm Pre for about 2 weeks now, and one specific problem that started showing up last week has been incredibly annoying, causing us all kinds of trouble.

After Emilie got the phone, she added 3 email accounts – Gmail, Hotmail, and Yahoo. One day, after sending an email through the Pre, a popup showed up that said "Error sending" followed by the subject of that specific email. Swiping the error away didn't help – it just came back 5 minutes later. In fact, it has been coming back every 5 minutes of every day since, lighting up the screen each time. Thus, not only it was annoying, but it was running down …

Read the rest of this article »

Updated: June 24th, 2020

Introduction

If you, like me, are building or thinking of implementing a MySQL-powered application that has any need for prioritizing selecting certain data over other data, this article is for you.

Example

As a real world example, consider a queue-like video processing system. Your application receives new videos and processes them. The volume of incoming videos can at times be higher than the processing rate because the process is CPU bound, so occasionally a pretty long queue may form. You will try to process them as fast as you can but…

Note that I am using a queue here, so the next item to be processed is a result of sorting by some sort of field in a ascending order

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 »