The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
How to measure IOPS consumed by Vertica cluster
Hello All,
I am trying to figure out a way to measure IOPS / Throughput consumed by Vertica cluster.
Please let me know if you have some idea about this subject.
regards,
Yogi
0
Comments
Is this what you need => iostat ? Install the sysstat package ( yum install sysstat - on redhat ) and check
http://serverfault.com/questions/296552/measure-linux-iops-for-a-running-system
I sugest using iotop wiht the -u option to specifiy the user that is running the process and -o to see only the threads that are doing IO.
Example :
Thanks All for the response.
I understand that Unix tools offer these metrics but I was looking for Vertica to provide this information.
It is very complicated task to run iostat on all nodes and do analysis.
best regards,
Yogi
You can use the io_usage table from the v_monitor schema.
I have done a side schema just for my workload analysis whee i am querying this table every hour or so and store it in a normal table that a run reports on it for time to time.
- i have many queries that read metrics from the system tables and stores them so i can make an idea of how my database is doing
Why do i do this:
- well the data in the tables like dc_* is not stored in an optimized way so this makes it hard to query(to much resources), in my tables i make sure i have them segmented on the same key and order is done i nhte same way so i can make use of optimization stuff from the engine.
Here is the sql that populates, the shell that gets run , and yes the pass & user are passed as variables from the .profile file(so no text passwd would be passed).