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

RTF fomatting to email content
Im trying to sen an email with content is picked up from a rtf-file (file_get_contents('*.rtf'). Mai

Hom to make one url to open together with another url
I have a chat, which i want to be opened, as soon as the users login to the site. As it is now, when

having probem inserting data into db table
hi

i have a table with following columns in it
Code: candidate_id, degree, cgpa, institute

login and redirect
hello! can someone help me.. can you give me an idea.. I want to make a login page and redirects it

present value of sequence?
Hi

Please help me to find out the present value of sequence?

Thanks

User registration and login
I don't know whether this is the correct forum, if not i apologise but am pretty desperate at the mo

SAP Management Console is blank
Dear All ,

I am facing problem in my des sever suddely in SAP Management Console is blank and

Posting to another Site?
I have software that people install.
When they install it, is there a way to make it post their d

how to load php class from another domain?
how to load php class from another domain?

What exactly is net neatrality?
What exactly is it? I think it's anti-censorship and... stuff... but I don't really understand it