API C MYSQL vs lock table ???


 
Thread Tools Search this Thread
Top Forums Programming API C MYSQL vs lock table ???
# 1  
Old 08-12-2008
Question API C MYSQL vs lock table ???

(sorry for my english)

Hi, i have an app that uses MYSQL API C.. i trying do a timeout until the table is locked by an other thread , in the docs of Mysql i can see that MYSQL_OPT_READ_TIMEOUT is not implemented for linux ¿?¿?.. any body knows a way to do a timeout until the table is locked by other process???

my process hang forever if the table is locked...:
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to lock Oracle table through UNIX?

Hi frndz, Can anyone provide me some input or pseudo code for my req as mentioned below... I am loading 2 files through unix script into oracle table...as i am doing some updates also i am getting an error where both files try to update the table simultaneously and my script fails.. so i... (3 Replies)
Discussion started by: gnnsprapa
3 Replies

2. Red Hat

MySQL is not running, but lock exists

# service mysql status MySQL is not running, but lock exists I deleted the lock using rm /var/lock/subsys/mysql still the problem persists. I tried using mysqld_safe, still the same issue. Unable to start mysql # mysqld_safe nohup: ignoring input and redirecting stderr to... (3 Replies)
Discussion started by: hiten.r.chauhan
3 Replies

3. UNIX and Linux Applications

mysql table disappear

I have set a mysql file to excute everyday morning to generate a html file displayng 2 tables from the database. Sometime they cannot be shown, and it shows the tables are not existed. I have not drop any table, and those 2 tables are not used by any other excution. Anybody know what is happening?... (0 Replies)
Discussion started by: c203040
0 Replies

4. Programming

Man pages for C API for MySql

Hi, I am on Ubuntu 9.04 tweaking some programs demanding MySql queries. I got the program working by installing following package: sudo apt-get install libmysqlclient-dev and using proper include and library folder However I was unable to access any man pages for these C api's (Strangely... (1 Reply)
Discussion started by: dheerajsuthar
1 Replies

5. Shell Programming and Scripting

Help Inserting data in mysql table

Cant understand the error #!/bin/bash temp="" A="" D=$(date +"%Y-%m-%d") H=$(date +"%R") temp=$(wget -q -O - website | grep -o "Temperature:]**" | grep \-E -o "+") mysql -D "weather_wise" -e "INSERT INTO weather (Date, Hour, Degrees) VALUES ($D,$H, $temp)"; my data types for... (11 Replies)
Discussion started by: vadharah
11 Replies

6. Shell Programming and Scripting

MySql: create table error

Hi, iam learning MySql. Iam trieing to create a table in the database "guestbook" at the command line in mysql heres what i type but i get a error mysql>create table guestbook ->( -> name varchar(40) null. -> url varchar(40) null. -> comments ... (3 Replies)
Discussion started by: perleo
3 Replies

7. Programming

Sendmail & mail.local + MySQL API

I've searched this message board, and the newgroups THOROUGHLY, in search of any information towards implenting the MySQL API with C... I'm a "beginner" to the C language I suppose, and i've made a few functions in C that can be implemented into the source code of Sendmail/mail.local, so that any... (2 Replies)
Discussion started by: CGrusden19
2 Replies
Login or Register to Ask a Question
apache_mod_perl-108~358::mod_perl-2.0.7::docs::api::APR:UsereContributed Peapache_mod_perl-108~358::mod_perl-2.0.7::docs::api::APR::ThreadMutex(3)

NAME
APR::ThreadMutex - Perl API for APR thread mutexes Synopsis use APR::ThreadMutex (); my $mutex = APR::ThreadMutex->new($r->pool); $mutex->lock; $mutex->unlock; $mutex->trylock; Description "APR::ThreadMutex" interfaces APR thread mutexes. API
"APR::ThreadMutex" provides the following functions and/or methods: Unsupported API "APR::ThreadMutex" also provides auto-generated Perl interface for a few other methods which aren't tested at the moment and therefore their API is a subject to change. These methods will be finalized later as a need arises. If you want to rely on any of the following methods please contact the the mod_perl development mailing list so we can help each other take the steps necessary to shift the method to an officially supported API. "DESTROY" META: Autogenerated - needs to be reviewed/completed Destroy the mutex and free the memory associated with the lock. $mutex->DESTROY(); obj: $mutex ( "APR::ThreadMutex object" ) the mutex to destroy. ret: no return value since: subject to change "lock" META: Autogenerated - needs to be reviewed/completed Acquire the lock for the given mutex. If the mutex is already locked, the current thread will be put to sleep until the lock becomes available. $ret = $mutex->lock(); obj: $mutex ( "APR::ThreadMutex object" ) the mutex on which to acquire the lock. ret: $ret ( integer ) since: subject to change "new" Create a new mutex my $mutex = APR::ThreadMutex->new($p); obj: "APR::ThreadMutex" ( class name ) arg1: $p ( "APR::Pool object" ) ret: $mutex ( "APR::ThreadMutex object" ) since: subject to change "pool_get" META: Autogenerated - needs to be reviewed/completed META: should probably be renamed to pool(), like all other pool accessors Get the pool used by this thread_mutex. $ret = $obj->pool_get(); obj: $obj ( "APR::ThreadMutex object" ) ret: $ret ( "APR::Pool object" ) apr_pool_t the pool since: subject to change "trylock" META: Autogenerated - needs to be reviewed/completed Attempt to acquire the lock for the given mutex. If the mutex has already been acquired, the call returns immediately with APR_EBUSY. Note: it is important that the APR_STATUS_IS_EBUSY(s) macro be used to determine if the return value was APR_EBUSY, for portability reasons. $ret = $mutex->trylock(); obj: $mutex ( "APR::ThreadMutex object" ) the mutex on which to attempt the lock acquiring. ret: $ret (integer) since: subject to change "unlock" META: Autogenerated - needs to be reviewed/completed Release the lock for the given mutex. $ret = $mutex->unlock(); obj: $mutex ( "APR::ThreadMutex object" ) the mutex from which to release the lock. ret: $ret ( integer ) since: subject to change See Also mod_perl 2.0 documentation. Copyright mod_perl 2.0 and its core modules are copyrighted under The Apache Software License, Version 2.0. Authors The mod_perl development team and numerous contributors. perl v5.16.2 2011-02apache_mod_perl-108~358::mod_perl-2.0.7::docs::api::APR::ThreadMutex(3)