> -----Original Message----- > From: Daniel Castro [mailto:[EMAIL PROTECTED] > Sent: Montag, 12. Juni 2006 21:11 > To: maxdb@lists.mysql.com > Subject: Query identification > > 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 !
Did you try to find out using hints in http://dev.mysql.com/tech-resources/articles/maxdb-performance-primer.pd f for example : Diagnose Monitor? That is the way I would recommend. Elke SAP Labs Berlin By the way: 7147899 commands with 155968 reads does not seem to be bad. Why did you see some need to find out the sequence of commands (a sequence of more than 7 millions!) ? > -- > 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 > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
