03-26-2009
Lock_time indicates the time spent waiting for a lock, due to another query holding a lock
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
I am an absolute newbie and whatever I've written in the shell script (below) has all been built with generous help from googling the net and this forum. Please forgive any schoolboy mistakes.
Now to the qn, my input file looks like this -
2009:04:03 08:21:41:513,INFO... (7 Replies)
Discussion started by: sowmitr
7 Replies
2. Shell Programming and Scripting
Hi guys,
i know how to run a single query using mysql embedded in a shell script as follows:
`mysql -umyuser -pmypass --host myhost database<<SQL
${query};
quit
SQL`
However, how would i be able to run several queries within the same connection?
The reason for this is i am creating... (3 Replies)
Discussion started by: muay_tb
3 Replies
3. Web Development
We have a few slow queries in forums. I am trying to track them down and see if I can fix them somehow. Here is an example from our mysql-slow.log:
# Time: 090929 9:04:54
# User@Host: unixdb @ localhost
# Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 75157
SELECT... (2 Replies)
Discussion started by: Neo
2 Replies
4. UNIX for Advanced & Expert Users
hi all,
i want to monitor mysql processes/threads/queries with respect to cpu usage.how can i do it?
show processlist is of no use as no information abt cpu usage is given.
plz help (7 Replies)
Discussion started by: rohitmahambre
7 Replies
5. Shell Programming and Scripting
I need to compare the 2 mysql database tables. there are around 50 tables in each DB.
my idea is
in DB1
extract result select * from table1; to alog file1
in DB2
extract result select * from table1; to alog file2
now compare log file 1 file 2
pls help me out ...
thanks in advance (5 Replies)
Discussion started by: kalyankalyan
5 Replies
6. Red Hat
Hi,
Can anyone tell me how in BIND 9.x (running 9.7.3) do you configure it to put the answer to each query in the log. I see the query, the IP who asked the query but not what the answer to the query is.
thanks for your help,
Phil (3 Replies)
Discussion started by: pcblack23
3 Replies
7. Red Hat
I know this is a duplicate question but the original has never been answered properly. I've got Bind 9.x set up on my box and the logging turned on. I can see queries being logged but I still can't get it to log the answers to those queries. Here is my named.conf file:
# File: /etc/named.conf
... (2 Replies)
Discussion started by: Vadim B
2 Replies
8. Solaris
Hi,
i am workiing on HP servers with solaris 10
SunOS vmsvApp01 5.10 Generic_142910-17 i86pc i386 i86pc
i am facing a dealyed log in problem,
As soon i log in ... server is taking around 40-50 seconds to prompt password.
please suggest
Anand, (1 Reply)
Discussion started by: anand87
1 Replies
9. IP Networking
Hello all friends
I am using ulogd with iptables to import iptables log into mysql but it is not working , Is there any way to log iptables log into mysql , i am using centos 6
Thanks (0 Replies)
Discussion started by: rink
0 Replies
LEARN ABOUT SUNOS
pthread_rwlock_unlock
pthread_rwlock_unlock(3C) pthread_rwlock_unlock(3C)
NAME
pthread_rwlock_unlock - unlock read-write lock object
SYNOPSIS
cc -mt [ flag... ] file... -lpthread [ library... ]
#include <pthread.h>
int pthread_rwlock_unlock(pthread_rwlock_t *rwlock);
The pthread_rwlock_unlock() function is called to release a lock held on the read-write lock object referenced by rwlock. Results are unde-
fined if the read-write lock rwlock is not held by the calling thread.
If this function is called to release a read lock from the read-write lock object and there are other read locks currently held on this
read-write lock object, the read-write lock object remains in the read locked state. If this function releases the calling thread's last
read lock on this read-write lock object, then the calling thread is no longer one of the owners of the object. If this function releases
the last read lock for this read-write lock object, the read-write lock object will be put in the unlocked state with no owners.
If this function is called to release a write lock for this read-write lock object, the read-write lock object will be put in the unlocked
state with no owners.
If the call to the pthread_rwlock_unlock() function results in the read-write lock object becoming unlocked and there are multiple threads
waiting to acquire the read-write lock object for writing, the scheduling policy is used to determine which thread acquires the read-write
lock object for writing. If there are multiple threads waiting to acquire the read-write lock object for reading, the scheduling policy is
used to determine the order in which the waiting threads acquire the read-write lock object for reading. If there are multiple threads
blocked on rwlock for both read locks and write locks, it is unspecified whether the readers acquire the lock first or whether a writer
acquires the lock first.
Results are undefined if any of these functions are called with an uninitialized read-write lock.
If successful, the pthread_rwlock_unlock() function returns 0. Otherwise, an error number is returned to indicate the error.
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Interface Stability |Standard |
+-----------------------------+-----------------------------+
|MT-Level |MT-Safe |
+-----------------------------+-----------------------------+
pthread_rwlock_init(3C), pthread_rwlock_rdlock(3C), pthread_rwlock_wrlock(3C), pthread_rwlockattr_init(3C), attributes(5), standards(5)
23 Mar 2005 pthread_rwlock_unlock(3C)