Check reads per sec and CPU utilization
I was not able to find any information how to check CPU utilization and read per sec for a query. Any ideas how to get these results? Thanks in advance.
indeed. for such details you should become an OS expert, starting by understanding memory-mapped file technology.
On 11 apr. 2016, at 18:12, Shmagi Kavtaradze
wrote: I was not able to find any information how to check CPU utilization and read per sec for a query. Any ideas how to get these results?
Thanks in advance. _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Maybe there are already some scripts at least to get some raw data?
On Mon, Apr 11, 2016 at 6:52 PM, Martin Kersten
indeed. for such details you should become an OS expert, starting by understanding memory-mapped file technology.
On 11 apr. 2016, at 18:12, Shmagi Kavtaradze
wrote: I was not able to find any information how to check CPU utilization and read per sec for a query. Any ideas how to get these results?
Thanks in advance. _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Hi, here are links to timing and performance monitoring tools that MonetDB provides, i.e., "stethoscope", "tomograph", & "tachograph": https://www.monetdb.org/Documentation/Manuals/MonetDB/Profiler https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/QueryTiming For more, please consult the tools that your OS provides and their documentation. Best, Stefan ----- On Apr 11, 2016, at 7:07 PM, Shmagi Kavtaradze kavtaradze.s@gmail.com wrote:
Maybe there are already some scripts at least to get some raw data?
On Mon, Apr 11, 2016 at 6:52 PM, Martin Kersten < Martin.Kersten@cwi.nl > wrote:
indeed. for such details you should become an OS expert, starting by understanding memory-mapped file technology.
On 11 apr. 2016, at 18:12, Shmagi Kavtaradze < kavtaradze.s@gmail.com > wrote:
I was not able to find any information how to check CPU utilization and read per sec for a query. Any ideas how to get these results?
Thanks in advance. _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
participants (3)
-
Martin Kersten
-
Shmagi Kavtaradze
-
Stefan Manegold