Hrmm, something didn't work quite right. Here's the actual query: select x, y, zoom from map_images where image_data_size = 0 and get_lock(concat(x, ',', y, ',', zoom), 0) = 1 order by zoom , sqrt(pow(x, 2) + pow(y, 2)) limit 1
I've added the image_data_size column and indexed it, and set its current value to length(image_data), and modified my "update" query to set image_data_size correctly once the job is done. When I run more than one compute job, they all start processing the same job simultaneously. What am I missing? Tim Gustafson 831-332-1496 t...@tgustafson.com http://tgustafson.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
