Daniel,

did you get any answers on this one?

Kind regards

robert

2006/6/12, Daniel Castro <[EMAIL PROTECTED]>:
Hi,

I have 2 warnings in dbanalyzer:

* W3  Deletes selectivity 0%: 8 deletes, 6982 rows read, 0 rows qualified
      CON: DelSel < 0.3
      VAL: 0      < 0.3

* W3  155968 physical reads for user task 60, 7147899 commands, application
pid 872
      CON: USER_TASK_READCNT[""] > INTERVAL * 60 ||
USER_TASK_READAVG_ABSTIME[""] > 100
      VAL: 155968                > 901      * 60 || 0

Is there any way to identify the sql sentece which is doing that?

Thank you !
--
Daniel Castro
Website: http://danielti.no-ip.info:2139
MSN: [EMAIL PROTECTED]
Skype: danielti2005
ICQ : 316727989
Jabber: danielti
Linux User: 387864
AOL User: Danielti2005
Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus, Soli Deo Gloria




--
Have a look: http://www.flickr.com/photos/fussel-foto/

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to