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

Forgot password won't work
My forgot password thing is not working properly. It is giving me this errorMailbox unavailable. The

Question about the upload of large files
Hi there,

I have a question about the upload of large files, like videos (files generally abo

pagination - need help on passing of search query.
Hi, i have been trying for days but couldn't get this sorted out. Would like some professional help

apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?

Search function
I am looking for some guidance from the experts.

I am trying to create a search function. It

first id from db not showing
I have a php script which displays the content of a mysql table as a html table with sorting, delete

having a small php error tha deals with the 'foreach'
Last night i was working on a script for a cart and it seemed to working good, until this morning. F

PO Release Strategy Issue
Hi Experts,

I am facing an issue related to PO release strategy. The details are-
<

Converting numbers to months
The porgram works -just need the last function(month_convert_ to convert numbers to months -thanks.

SESSION question
I am building an application , a directory for auctions.
For SEO i made a script which copies a p