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

CURL XML Request [From C to PHP]
Hi,

I need some help converting this into something that will work with PHP.

Code: #

Tournament Brackets (Double Elimination)?
Is making a double elimination tournament style bracket system capable of being done in php?

Pagination
Hi All,

I think I'm finally getting somewhere with pagination!

I can now submit a quer

Find current logon time
Hi,
in my sql script i want to query and find out the logon time of the current session.
<

Basic Question about Threading and PHP...
I have a page that I am working on and it is taking several hours to process. The basics of what th

WORDPRESS - Multiple Loops Only Going to One Post?
I have various pages with multiple loops and i need them to be individual to all other categories.

How do I replace any number of character occurences with one occurrence?
How do I replace any number of character occurences with one occurrence?

Let's say I have:

Odd or Even
Inside of a while loop I need to echo several rows of info...easy enough.

In the loop (for th

Parse Error
Hi Guys,

I have a function in my class which returns a string link variable. The problem is i

Better Method of a Member Cloud
I assume most people know how tag clouds work, where the tags most used are bigger and the least use