Hi,
I am getting the following message in analyzer:
* I SQL commands executed: 49211
CON: PureSQL_Cmds > INTERVAL * 5
VAL: 49211 > 901 * 5
* W1 Catalog cache hitrate (SQL Pages) 86.73%, 29811 of 224626 accesses
failed
CON: Cat_Hit < 90 && ( SQL_Cmds ) > INTERVAL
VAL: 86.73 < 90 && ( 49461 ) > 901
* W1 Selects and fetches selectivity 4.62%: 14006 selects and fetches,
262105903 rows read, 12109016 rows qualified
CON: SelFetSel < 5.0
VAL: 4.62 < 5.0
* W1 13819 table scans, selectivity 4.58%: 261869095 rows read, 12003982
rows qualified
CON: TabScanSel < 5.0
VAL: 4.58 < 5.0
* W3 91 index range accesses, selectivity 0.19%: 217982 rows read, 418 rows
qualified
CON: InxRgSel < 0.3
VAL: 0.19 < 0.3
The system is very slow.
Anybody can help me?
--
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
