mysql 语句 2

修改最大连接数

临时生效：
SHOW VARIABLES LIKE "max_connections"; 查看
SET GLOBAL max_connections=9000; 修改

永久生效：
修改 /etc/my.cnf
修改/添加 max_connections=9000 #修改最大连接数为9000
重启服务
SHOW VARIABLES LIKE "max_connections"; 查看是否生效

 

KVM 任务统计

SELECT
t_kvm_backupjobs.job_name AS 任务名,
t_kvm_backupjobs.vm_uuid,
t_kvm_backupjobs.backup_type,
t_policy.policy_name AS 策略名,
t_policy.description,
t_kvm_lcm.versions AS 保留版本,
t_policy.year,
t_policy.month,
t_policy.day,
t_policy.week,
t_policy.day_of_week,
t_policy.hour,
t_policy.minute,
t_policy.second
FROM
t_kvm_backupjobs
LEFT JOIN t_policy ON t_kvm_backupjobs.backup_policy_id = t_policy.id
INNER JOIN t_kvm_lcm ON t_kvm_backupjobs.vm_uuid = t_kvm_lcm.vm_uuid
WHERE t_kvm_backupjobs.vm_uuid like "cba56a0f-185d-498d-ac23-288f87d27a40"

413

KVM 任务运行情况统计

SELECT
t_agent.ip_addr,
t_agent.host,
t_kvm_backupjobruns.pm_uuid,
t_kvm_backupjobruns.job_name AS 任务名,
t_kvm_backupjobruns.vm_uuid AS 虚机UUID,
t_kvm_backupjobruns.dcid AS DCID,
t_kvm_backupjobruns.backup_type AS 备份类型,
t_kvm_backupjobruns.status AS 状态,
t_kvm_backupjobruns.backup_log AS 日志,
t_kvm_backupjobruns.start_time AS 发起时间
FROM
t_kvm_backupjobruns
LEFT JOIN t_agent ON t_kvm_backupjobruns.pm_uuid = t_agent.uuid
WHERE
t_kvm_backupjobruns.start_time > "2020-03-12 20:00:00"
AND t_kvm_backupjobruns.vm_uuid LIKE "%"
ORDER BY
发起时间 DESC;

nbp-rest-api -a start

systemctl list-units| grep nbp

ps -ef| grep vdpp
systemctl start nbp-slave
systemctl start redis
systemctl status redis
systemctl start mariadb
systemctl status mariadb

 

 

 

SELECT
t_agent.ip_addr,
t_agent.host,
t_kvm_backupjobruns.pm_uuid,
t_kvm_backupjobruns.job_name AS 任务名,
t_kvm_backupjobruns.vm_uuid AS 虚机UUID,
t_kvm_backupjobruns.dcid AS DCID,
t_kvm_backupjobruns.backup_type AS 备份类型,
t_kvm_backupjobruns.status AS 状态,
t_kvm_backupjobruns.backup_log AS 日志,
t_kvm_backupjobruns.start_time AS 发起时间
FROM
t_kvm_backupjobruns
LEFT JOIN t_agent ON t_kvm_backupjobruns.pm_uuid = t_agent.uuid
WHERE
t_kvm_backupjobruns.start_time > "2019-12-27 20:00:00"
AND t_kvm_backupjobruns.backup_log LIKE "%time out%"
ORDER BY
发起时间 DESC

 

 

 

 

 

Oracle 任务运行情况：



只看成功的

SELECT
t_oracle_jobruns.agent_id,
t_oracle_jobruns.agent_name,
t_oracle_jobruns.abs_path,
t_oracle_jobruns.backup_log,
t_oracle_jobruns.start_time
FROM
t_oracle_jobruns
WHERE
t_oracle_jobruns.backup_type = "1"
AND t_oracle_jobruns.status = "666"
ORDER BY
t_oracle_jobruns.start_time DESC

 

SELECT
t_agent.ip_addr,
t_oracle_jobruns.agent_name,
t_oracle_jobruns.job_name,
t_oracle_jobruns.backup_type,
t_oracle_jobruns.abs_path,
t_oracle_jobruns.backup_log,
t_oracle_jobruns.status,
t_oracle_jobruns.start_time
FROM
t_oracle_jobruns
LEFT JOIN t_agent ON t_oracle_jobruns.agent_id = t_agent.uuid
WHERE
t_oracle_jobruns.backup_type LIKE "%"
AND t_oracle_jobruns.start_time > "2020-04-09"
AND t_oracle_jobruns.agent_id LIKE "%"
ORDER BY
t_oracle_jobruns.start_time DESC

 

SELECT
t_agent.ip_addr,
t_oracle_backupjobruns.agent_name,
t_oracle_backupjobruns.job_name,
t_oracle_backupjobruns.backup_type,
t_oracle_backupjobruns.abs_path,
t_oracle_backupjobruns.backup_log,
t_oracle_backupjobruns.status,
t_oracle_backupjobruns.start_time
FROM
t_oracle_backupjobruns
LEFT JOIN t_agent ON t_oracle_backupjobruns.agent_id = t_agent.uuid
WHERE
t_oracle_backupjobruns.backup_type LIKE "%"
AND t_oracle_backupjobruns.start_time > "2019-11-27"
AND t_oracle_backupjobruns.agent_id LIKE "%"
ORDER BY
t_oracle_backupjobruns.start_time DESC

 

 

Oracle 任务统计

SELECT
t_oracle_jobs.agent_name AS Oracle数据库主机名,
t_agent.ip_addr AS 数据库服务器IP,
t_storage.host AS 存储节点主机名,
t_storage.mgr_ip AS 存储节点管理IP,
t_storage.data_ip,
t_storage.data_dir AS 存储位置,
t_oracle_instance.instance_name AS 备份实例,
t_oracle_jobs.job_name AS 备份任务名,
t_oracle_jobs.status AS 任务状态,
t_policy.backup_type AS 备份类型,
t_oracle_jobs.policy_id AS 策略id,
t_policy.policy_name AS 策略名,
t_oracle_jobs.versions AS 保留版本,
t_policy.description,
t_policy.year,
t_policy.month,
t_policy.day,
t_policy.week,
t_policy.day_of_week,
t_policy.hour,
t_policy.minute,
t_policy.second
FROM
t_oracle_jobs
LEFT JOIN t_agent ON t_oracle_jobs.agent_id = t_agent.uuid
LEFT JOIN t_storage ON t_oracle_jobs.storage_uuid = t_storage.uuid
LEFT JOIN t_oracle_instance ON t_oracle_instance.id = t_oracle_jobs.instance_id
LEFT JOIN t_policy ON t_oracle_jobs.policy_id = t_policy.id
ORDER BY
数据库服务器IP ASC

 

 

ORACLE

 

 

 

SELECT
t_agent.ip_addr,
t_agent.host,
t_nfv_backupjobruns.backup_type,
t_nfv_backupjobruns.status,
t_nfv_backupjobruns.backup_log,
t_nfv_backupjobruns.start_time
FROM
t_nfv_backupjobruns
LEFT JOIN t_agent ON t_agent.uuid = t_nfv_backupjobruns.agent_id
WHERE
t_nfv_backupjobruns.status = "444"
AND t_nfv_backupjobruns.start_time > "2020-03-12"
ORDER BY
t_nfv_backupjobruns.start_time DESC

 

 

mysql -uroot -p123456 nbp -e "SELECT t_agent.ip_addr, t_agent.host, t_nfv_backupjobruns.backup_type, t_nfv_backupjobruns.status, t_nfv_backupjobruns.backup_log, t_nfv_backupjobruns.start_time FROM t_nfv_backupjobruns LEFT JOIN t_agent ON t_agent.uuid = t_nfv_backupjobruns.agent_id WHERE t_nfv_backupjobruns.status = '444' AND t_nfv_backupjobruns.start_time > '2020-03-12' ORDER BY t_nfv_backupjobruns.start_time DESC\G;"> /root/log.txt

 

 

51 DED38B12-38BD-44DE-AF57-B81BAAD5AEE7
91 9a29cf09-9370-43a2-8271-0e631b4c856d
103 fb71c686-823a-43cd-b606-6e051864f299
220 1f4fc60b-3093-48be-8b32-d5712c8ca7c