Locking mysql tables with php

Posted on 16th Feb 2014 07:03 pm by admin

Hi

BACKGROUND:
I have multiple instances of the same php script running in a WAMP environment. The script contains mysql queries to lock certain tables in the database. I'm getting some very odd behaviour which would seem to suggest that the locks are not working, and that one instance of the script is reading from a table that another instance of the script should have a write lock on.

ACTUAL QUESTION:
Do two instances of the same php script running through WAMP get totally independent locks on tables in a database?

I didn't post this question in the mysql forum because although it is about locking tables, it is about locking tables from the point of view of a php script. Please move it if I have posted in the wrong forum.

Cheers

Paul

Your Answer:

Login to answer

Other forums

How to know if online site made with PHP
Hello,
I see some sites that does not display extensions at all , for example:

www.site.co

send message to the java application
Oracle 10g with Windows platform.

I have a java application that periodically pings the d

creating a 1 to 100 in a table
hi guys I am a newb in php need some help.

I have a table with 1 column and 100 rows and in

ereg_replace issue
hi there people

i have this code happening with regards to my wamp server. is this something

quick question
Hi ..

i have a question
how do i set a var so it displays via an echo
Code: $logo = '&a

type check while uploading
Hi Everyone,

How can I check the exact type of a file while uploading on my site?

Here

problem with php mysql query
Hi guy's...

I'm totally lost here..because don't have any idea how to make a query for grab r

need help with this contact form
I made this form and I need it to read the data and write the data to a table and its not working ca

How can i steam a video on my PHP site? (non YouTube)
Basically I have a PHP site and don't want to give page rank to YouTube. I just want to stream a bas

Return X values where an ID number doesnt matter
Well as for subject heading, thats the best i could think of.

Currently im having a problem w