How to lock,unlock MYSQL tables?
Posted: Fri Jul 17, 2009 3:09 am
Hii every one..
I am fresher in PHP. I am developing a site using PHP,AJAX and MYSQL.
Actually mysite requires maximum use of mysql databases. If every thing goes right my site might have visitors of more than 10 users accesing the mysql tables at a time indirectly thgh site. my problem is each user access to the mysql tables may change some numerical values in the database which should be effected to the next user. For example lets take share market. Many users buy or sell a PLC's share at a point of time. and the share value will be reflected in the next user who is selling or buying.
So i want to lock unlock the database at a point of time while sql exection is on. And the other users who are accesing the database should wait until execution of the user finishes.
The users here are not of mysql. They are the users of the site.
Please help me with this. Do i need to change any thing in the code or settings in PHP or MYSQL???
And are there any automation tools by which i can test this?
I am fresher in PHP. I am developing a site using PHP,AJAX and MYSQL.
Actually mysite requires maximum use of mysql databases. If every thing goes right my site might have visitors of more than 10 users accesing the mysql tables at a time indirectly thgh site. my problem is each user access to the mysql tables may change some numerical values in the database which should be effected to the next user. For example lets take share market. Many users buy or sell a PLC's share at a point of time. and the share value will be reflected in the next user who is selling or buying.
So i want to lock unlock the database at a point of time while sql exection is on. And the other users who are accesing the database should wait until execution of the user finishes.
The users here are not of mysql. They are the users of the site.
Please help me with this. Do i need to change any thing in the code or settings in PHP or MYSQL???
And are there any automation tools by which i can test this?