Hi, > One more thing: Is it possible with the page store to retrieve > statistics on disk reads and writes (preferably number of pages, but > number of bytes would also be OK?). I used to query for > > SELECT * FROM INFORMATION_SCHEMA.SETTINGS WHERE NAME = > 'info.FILE_DISK_WRITE' ORDER BY NAME ASC; > SELECT * FROM INFORMATION_SCHEMA.SETTINGS WHERE NAME = > 'info.FILE_DISK_READ' ORDER BY NAME ASC;
With the page store, this information is incorrect. I will add the following information in the next release: info.FILE_WRITE_TOTAL // since the database was created info.FILE_WRITE // since the database was opened info.FILE_READ // since the database was opened info.CACHE_MAX_SIZE info.CACHE_SIZE Regards, Thomas --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
