web development makes pessimistic
> > > > locking much more difficult, because of the user closing the browser,
> > > > and a bunch of other factors I can't control.
> > > >
> > > > Question: which type of locking do you usually implement in your
unch of other factors I can't control.
> > >
> > > Question: which type of locking do you usually implement in your
web
> > > apps, and do you do it at a DB level or in your application layer?
> > >
> > > Any thoughts on a custom locking scheme
t; apps, and do you do it at a DB level or in your application layer?
> > >
> > > Any thoughts on a custom locking scheme (ie, a lock table that is
> > > written to with a user id and record id and timestamp)?
> > >
> > > Other solutions/suggestions
in your application layer?
> >
> > Any thoughts on a custom locking scheme (ie, a lock table that is
> > written to with a user id and record id and timestamp)?
> >
> > Other solutions/suggestions are greatly appreciated.
> >
> > Thanks in advance.
>
a lock table that is
> written to with a user id and record id and timestamp)?
>
> Other solutions/suggestions are greatly appreciated.
>
> Thanks in advance.
>
> Scott.
>
I don't use record locking until it's time to actually do something to the
data. Even th
nage total number of
users.
Best Regards
Mathias FATENE
Hope that helps
*This not an official mysql support answer
-Original Message-
From: Scott Klarenbach [mailto:[EMAIL PROTECTED]
Sent: vendredi 29 avril 2005 20:28
To: My SQL
Subject: Pessimistic Record Locki
Hello,
I'm using MySQL 5.0.3 Beta, and I'm hoping for some general
tips/experience you guys may have had regarding optomistic vs
pessimistic locking in a web app (PHP 5.0.3)
I'm more of a windows programmer, and I've always implemented
pessimistic over optomistic as it's much more professional an
Hello.
Use:
set autocommit=0;
or begin a transaction before executing 'select ... lock in share mode'.
Commit the tramsaction to release lock.
"Mojtaba Faridzad" <[EMAIL PROTECTED]> wrote:
> Hi,
> I am trying to learn more about InnoDB to convert MyISAM to InnoDB.
> according to MyS
Hi,
I am trying to learn more about InnoDB to convert MyISAM to InnoDB.
according to MySQL document, I can lock a record like this:
SELECT * FROM mytable WHERE id = '100' LOCK IN SHARE MODE;
I run this query and showed a message to stop the screen (waiting) and on
the other computer I run the sa
in mySQL?
> As far as my understanding goes, only innoDB tables
> support record locking
> level. I am currently using mySQL version 3.23 and
> my tables are in myISAM.
>
> Thanks in advance for any assistance.
>
> Mike
>
>
---
how me how to lock a record in mySQL?
> > As far as my understanding goes, only innoDB
> tables
> > support record locking
> > level. I am currently using mySQL version 3.23
> and
> > my tables are in myISAM.
hi all,
Can someone show me how to lock a record in mySQL?
As far as my understanding goes, only innoDB tables support record locking
level. I am currently using mySQL version 3.23 and my tables are in myISAM.
Thanks in advance for any assistance.
Mike
You
would have to check that out yourself.
Cheers
/rudy
-Original Message-
From: Dan Ullom [mailto:[EMAIL PROTECTED]
Sent: dinsdag 15 juli 2003 19:04
To: [EMAIL PROTECTED]
Subject: Single Record Locking - Permanent?
Is it possible to lock single records for all but a certain se
2 methods I can think of:
1) Move the records into a different table, and set permissions
accordingly (allow updates on for managers on that table)
2) Control authentication and access in your program.
-Cameron Wilhelm
On Tuesday, July 15, 2003, at 11:03 AM, Dan Ullom wrote:
Is it possible t
Is it possible to lock single records for all but a certain set of users,
permanently?
The intention is to make old items permanently unchangeable by anyone but
managers.
Thanks,
Dan Ullom
TechCentric
314-991-2594
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi..
I'm new to this list, and I am sort of new to MySQL and PHP. I was
wondering, if you create an html-form based interface to a database, lets
say its a database of customers, how can you lock a record if one person has
it open? Lets say PersonA opens up Joe Blow's record on the intranet, and
Hi,
I am using jsp-mysal combination in my application.
In my case i need the second user accessing the record to edit to get a
error message "this record is being edited by another user. try later" if
the record is being edited by first user.
In the page i have used
i have set autocommit=0
then
I am experiencing problems with record locking on database updates.
When I use an Access update query to modify a record subsequent updates
to the same records result an Access 97 message stating that the record
is in use by another user. This happens if I am the sole user of the
database. It
18 matches
Mail list logo
