Re: Page IO statistics for Ignite

2018-10-02 Thread Юрий
Hi, Thanks you for participate here. I've prepared some draft of IEP-27 , which aggregate information from the thread. Please take a look and give your feedback. Also there are some open questions: 1) We can simple g

Re: Page IO statistics for Ignite

2018-09-25 Thread Alex Plehanov
Hi, I've made some investigation a couple of months ago about a statistics collected by some RDBMS vendors (Oracle, Postgres, MySQL). These databases collect detailed IO statistics in dimensions such as queries, database objects (tables and indexes), files, sessions, users, event types etc. Some

Re: Page IO statistics for Ignite

2018-09-25 Thread Vladimir Ozerov
Hi Yuriy, I think this is great idea. But we need to collect more details on how and what to collect. I think one of the most interesting parts for us would be index and data page usages, split by different "dimensions": 1) Global node statistics 2) Per-cache statistics 3) Per-index statistics We

Re: Page IO statistics for Ignite

2018-09-21 Thread Denis Magda
Hello Yuri, I might give useful feedback if see how the metrics will look like from the API standpoint. If it's not difficult please create a draft. AS for the interface, in addition to JMX and SQL we need to ensure Visor CMD and Web Console gets updated. *Alex K.*, please join the thread and sha

Page IO statistics for Ignite

2018-09-21 Thread Юрий
Hi Igniters, I started IGNITE-8580 ticket related to print page read/write metrics and did some investigation what other databases provide for the similar purposes. Based on the investigation I want to propose my raw vision of how to IGNITE can