Hello All, Database version 7.6.00.10, DMBGUI 7.6.00.03 I don't know when it start ( i think when i switch from 7.5 to 7.6 ), but when i look at cache statistics with DBMGUI , data cache accesses and data cache successfull show 0. On the activity screen, logical read show also 0. When i use dbmcli, same result: dbmcli on srv-sgbd : torpedo>info caches OK END Type | Accesses | Successful | Unsuccessful | Hit Ra (%) DATA | | | 1837966 | 100 SEQUENCE | 675 | 671 | 4 | 99 COMMANDPREPARE | 0 | 0 | 0 | (null) COMMANDEXECUTE | 0 | 0 | 0 | (null) CATALOGCACHE | 6666906 | 6615734 | 51172 | 99 CATALOG | 218 | 218 | 0 | 100 CATALOG | 12209 | 12209 | 0 | 100 CATALOG | 170 | 170 | 0 | 100 CATALOG | 618904 | 618904 | 0 | 100 CATALOG | 17897 | 17897 | 0 | 100 CATALOG | 1139 | 1139 | 0 | 100 CATALOG | 8672 | 8672 | 0 | 100 CATALOG | 629 | 629 | 0 | 99 CATALOG | 1384 | 1384 | 0 | 100 CATALOG | 1135 | 1135 | 0 | 100 CATALOG | 0 | 0 | 0 | (null)
But when i use info IO: dbmcli on srv-sgbd : torpedo>info IO OK END Name | Logical Reads | Logical Writes | Physical Reads | Physical Writes Catalog | 25417649 | 1356 | 1945 | 690 Perm Data | 1334039590 | 69535813 | 1834202 | 323059 Temp Data | 1280013554 | 219708972 | 1797 | 1780 Long Data | 0 | 0 | 0 | 0 Leaf | 1675872740 | 285160326 | 1823936 | 297347 Level 1 | 676794446 | 3118397 | 13537 | 26328 Level 2 | 274935620 | 967345 | 463 | 1847 Level 3 | 11859561 | 7 | 8 | 7 Level 4 | 0 | 0 | 0 | 0 Level 5 | 0 | 0 | 0 | 0 Sum (Tree) | | 289246075 | 1837944 | 325529 Converter | 0 | 0 | 0 | 17097 Logical read is not null... And with SqlStudio: Select * from monitor_caches: DESCRIPTION VALUE Data cache accesses 2641545404 Data cache accesses successful 2639707287 Data cache accesses unsuccessful 1838117 Data cache hit rate (%) 100 Catalog cache accesses 1504725665 Catalog cache accesses successful 1462069833 Catalog cache accesses unsuccessful 42656189 Catalog cache hit rate (%) 97 Sequence cache accesses 675 Sequence cache accesses successful 671 Sequence cache accesses unsuccessful 4 Sequence cache hit rate (%) 99 Data cache sqlpage accesses 2606836594 Data cache sqlpage accesses successful 2604998477 Data cache sqlpage accesses unsuccessful 1838117 Data cache sqlpage hit rate(%) 100 Data cache OMS accesses 0 Data cache OMS accesses successful 0 Data cache OMS accesses unsuccessful 0 Data cache OMS hit rate (%) 0 Data cache OMS log accesses 0 Data cache OMS log accesses successful 0 Data cache OMS log accesses unsuccessful 0 Data cache OMS log hit rate (%) 0 Data history/undo accesses 34708810 Data history/undo accesses successful 34708810 Data history/undo accesses unsuccessful 0 Data history/undo hit rate (%) 100 Data cache no of SQL data pages 49755 Data cache no of OMS data pages 0 Data cache no of history/undo pages 0 Data cache no of unloaded version pages 0 Looks like there is a integer overflow on logical read somewhere... Fred. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
