Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• Subject: mysql openssl Question
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• Update one field with more fields from another table
• Subject: Getting Identity after INSERT
• ERROR 2002: Can 't connect to local MySQL server through socket
• mysql test 4 1 fails with the gis test
• Subject: MySQL Cluster Software
• Downgrade Mysql from 4 to 3 23
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Can 't access mysql after kernel upgrade
• Executing MySQL Commands From Within C Program
• Comparing and writing out BLOBS
• Subject: Re: Preventing Duplicate Entries
• FULLTEXT query format question
• Strange behavior, Table Level Permission
• Does the binary log enabling affect the MySQL performances?
• mysql:it 's a db not a dbms how it 's possible?!
• mysql have same function mthod as Oracle decode()
 
User in wait state

User in wait state

2007-08-29       - By Daniel Castro

 Back
Hi,

What this Vwait state means?
* W3  User task 93 blocked in state 'Vwait', parseid:
00145AE20025380123000000, application pid 3292
     CON: ! ( USER_TASK_STATE["93"] like "Command*" ) &&
USER_TASK_DISPATCHCNT[""] == 0
     VAL: ! ( "Vwait"               like "Command*" ) &&
0                         == 0
* W3  User task 94 blocked in state 'Vwait', parseid:
00145AF60024580123000000, application pid 3276
     CON: ! ( USER_TASK_STATE["94"] like "Command*" ) &&
USER_TASK_DISPATCHCNT[""] == 0
     VAL: ! ( "Vwait"               like "Command*" ) &&
0                         == 0
* W3  User task 100 blocked in state 'Vwait', parseid:
00145A810179220123000000, application pid 3152
     CON: ! ( USER_TASK_STATE["100"] like "Command*" ) &&
USER_TASK_DISPATCHCNT[""] == 0
     VAL: ! ( "Vwait"                like "Command*" ) &&
0                         == 0
* W3  User task 101 blocked in state 'Vwait', parseid:
00145ADC0025570123000000, application pid 1624
     CON: ! ( USER_TASK_STATE["101"] like "Command*" ) &&
USER_TASK_DISPATCHCNT[""] == 0
     VAL: ! ( "Vwait"                like "Command*" ) &&
0                         == 0
* W3  User task 118 blocked in state 'Vwait', parseid:
00145B220006360123000000, application pid 836
     CON: ! ( USER_TASK_STATE["118"] like "Command*" ) &&
USER_TASK_DISPATCHCNT[""] == 0
     VAL: ! ( "Vwait"                like "Command*" ) &&
0                         == 0
* W3  User task 91 processing parseid '00145ACF0003AB010A000000' last 61
seconds, 12956 dispatches, application pid 2244
     CON: USER_TASK_COMM_CNT[""] == 0 && USER_TASK_DISPATCHCNT[""] > 1
     VAL: 0                      == 0 && 12956                     > 1
* W3  12955 physical reads for user task 91, 0 commands, application pid
2244
     CON: USER_TASK_READCNT[""] > INTERVAL * 60 ||
USER_TASK_READAVG_ABSTIME[""] > 100
     VAL: 12955                 > 61       * 60 || 0

And if it means that the process is waintin for a COMMIT from another
process is ppossible to see who is making the others wait?

best regards,

--
Daniel Castro - ?????
MSN: danielti@(protected)
Skype: danielti2005
ICQ : 316727989
Jabber: danielti
Linux User: 387864
AOL User: Danielti2005
Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus, Soli Deo Gloria