|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| UNIX and Linux Applications Discuss UNIX and Linux software applications. This includes SQL, Databases, Middleware, MOM, SOA, EDA, CEP, BI, BPM and similar topics. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| queries about exit | Arunprasad | Shell Programming and Scripting | 2 | 10-01-2008 03:21 AM |
| my queries | whizkidash | Shell Programming and Scripting | 4 | 03-27-2008 06:58 AM |
| Two small queries | skyineyes | UNIX for Advanced & Expert Users | 3 | 07-05-2007 02:58 PM |
| Some queries... | 12yearold | UNIX for Advanced & Expert Users | 6 | 07-14-2006 04:12 PM |
| SQL queries in background? | jpprial | UNIX for Dummies Questions & Answers | 1 | 03-07-2001 08:17 PM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
03-23-2009
|
||||
|
||||
|
MySQL Slow Queries Log: Lock_time
In MySQL's slow queries log, it'll have an entry like this: Code:
# User@Host: scc_service[scc_service] @ [192.168.249.209] # Query_time: 43 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET timestamp=1237769209; UPDATE loan SET funding_status="scheduled",datetime_approved=now() WHERE loan_id = '00000'; What does Lock_time refer to? Is that how long the query spent waiting for a lock, or how long this query locked the database? |
|
03-26-2009
|
|||||
|
|||||
|
Lock_time indicates the time spent waiting for a lock, due to another query holding a lock
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Hybrid Mode
