開啟AWS RDS LOG設定
PG內修改，套用之後重開RDS
general_log 1
slow_query_log 1
因LOG預設是存放在TABLE中
有會吃掉RDS預設的空間
如果需手動清除，需在MySQL內執行以下指令2次
PROMPT> CALL mysql.rds_rotate_slow_log; PROMPT> CALL mysql.rds_rotate_general_log;
CategoryAWS
登入RDS MySQL 之後
輸入下列字串
DELIMITER |
CREATE PROCEDURE mysql.store_time_zone ()
IF NOT (POSITION(‘rdsadmin@’ IN CURRENT_USER()) = 1) THEN
SET SESSION time_zone = ‘+8:00’;
END IF
|
DELIMITER ;
測試有無修改完成
CALL mysql.store_time_zone; select now()
實際套用需要在Parpmeter Groups內
修改 init_connect 加入 call mysql.store_time_zone
之後重啟RDS
需先安裝AWS Cli
#查詢本機id
#call api 給cloudwatch
#aws cloudwatch put-metric-data –namespace HttpServerMetrics –metric-name –dimension InstanceId=$instance_id –value $mem –unit “Megabytes”
#監控shellscript
#!/bin/bash
disk=`df -lha|grep /dev|head -1|awk ‘{printf $5}’`
aws cloudwatch put-metric-data –namespace disksize–metric-name disksizeuse –dimension InstanceId=$id –value $disk –unit “Percent”
© 2024 Kila's IT Home
Theme by Anders Norén — Up ↑
近期留言