vertica審計日誌

最近時段的所有請求：

select * from dc_requests_issued order by time desc limit 10;

預設在磁碟上保留50MB：

dbadmin=> SELECT get_data_collector_policy('RequestsIssued');
get_data_collector_policy
-----------------------------------------------------------------------------
2000KB kept in memory, 50000KB kept on disk. Time based retention disabled.
(1 row)

 

預設值太小了，修改為在磁碟上保留5GB

dbadmin=> SELECT set_data_collector_policy('RequestsIssued', '2000', '5000000');
set_data_collector_policy
---------------------------
SET
(1 row)

dbadmin=> SELECT get_data_collector_policy('RequestsIssued');
get_data_collector_policy
-------------------------------------------------------------------------------
2000KB kept in memory, 5000000KB kept on disk. Time based retention disabled.
(1 row)

-------------------------

 

其它日誌：

SELECT MIN(start_timestamp) FROM v_monitor.query_requests;
SELECT MIN(time) FROM v_internal.dc_requests_issued;

當前會話：

select * from sessions;

 

-----------

設定方式在這裡：

https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/ConfiguringDataRetentionPolicies.htm

 

如果想按保留時間來設定，而不是磁碟大小，可以參照這裡：

https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/VerticaFunctions/DataCollection/SET_DATA_COLLECTOR_TIME_POLICY.htm

 

節點的日誌檔案在這裡：

/home/dbadmin/bigdata/v_bigdata_node0001_catalog