Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I got a stored procedure in mysql:

....
SET @_time = _time;
    SET @minLat = minLat;
    SET @maxLat = maxLat;
    SET @minLon = minLon;
    SET @maxLon = maxLon;
    SET @_sex = _sex;
    SET @_lang = _lang;
    SET @_city = _city;
    SET @_prov = _prov;
    SET @_ctry = _ctry;
    SET @_lat0 = _lat0;
    SET @_lon0 = _lon0;
    SET @_radius = _radius;

....
            EXECUTE FETCH_AFTER_MAX USING @_time, @_after, @minLat, @maxLat, @minLon, @maxLon, @_sex, @_lang, @_loc, @_ctry, @_lat0, @_lat0, @_lon0, @_radius, @_max;

Is there a race condition going on about those session variables if that stored proc is getting called more than once in parallel (like, on multiple db persistent connections) ?

thanks!

share|improve this question
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.