|
|
| Author |
Message |
Hertzsprung
WebHelper
Joined: 30 Jul 2002
Posts: 56
Location: UK
|
 Posted:
Thu Jan 23, 2003 6:38 pm (21 years, 11 months ago) |
  |
I have a small amount of DB experience, and have just started looking at concurrency issues. Could anyone offer and overview of locking in MySQL, and how to use it in a web environment?
Thanks in advance,
Hertzsprung |
|
|
     |
|
Daniel
Team Member
Joined: 06 Jan 2002
Posts: 2564
|
| Posted:
Thu Jan 23, 2003 6:46 pm (21 years, 11 months ago) |
|
I don't know much about these things either, but I do know that all the PHP & MySQL scripts I have looked at do not use locking (even big ones like phpBB). I don't know if that's because it's not necessary in MySQL, or whether it's because their authors don't think it's needed. |
________________________________
 |
|
|
|
Iyonix
WebHelper
Joined: 12 Nov 2002
Posts: 82
Location: Yarm, England
|
| Posted:
Sat Jan 25, 2003 2:33 pm (21 years, 11 months ago) |
|
Is this like the flock() function for file handleing in PHP or am I missing the point? |
________________________________
Iyonix |
|
|
|
Daniel
Team Member
Joined: 06 Jan 2002
Posts: 2564
|
| Posted:
Sat Jan 25, 2003 2:34 pm (21 years, 11 months ago) |
|
Yes, it's something to that effect: you can "lock" tables to prevent reading and/or writing. |
________________________________
|
|
|
|
Hertzsprung
WebHelper
Joined: 30 Jul 2002
Posts: 56
Location: UK
|
| Posted:
Mon Jan 27, 2003 4:17 pm (21 years, 11 months ago) |
|
So no answers then?  |
|
|
|
|
Daniel
Team Member
Joined: 06 Jan 2002
Posts: 2564
|
| Posted:
Mon Jan 27, 2003 5:01 pm (21 years, 11 months ago) |
|
|
|
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot edit your posts in this forum.
You cannot delete your posts in this forum.
You cannot vote in polls in this forum.
|
Page generation time: 0.151498 seconds :: 17 queries executed :: All Times are GMT
Powered by phpBB 2.0
© 2001, 2002 phpBB Group :: Based on an FI Theme
| |
