MySQL主从复制(基于 5.6)

MySQL主从复制(基于 5.6) https://dev.mysql.com/doc/refman/5.6/en/replication.html https://dev.mysql.com/doc/refman/5.6/en/faqs-replication.html https://dev.mysql.com/doc/refman/5.6/en/replication-howto.html

MySQL存储过程样例

//删除存储过程 DROP PROCEDURE IF EXISTS makeInsureAmt; //创建存储过程 DELIMITER // CREATE PROCEDURE makeInsureAmt(IN arg INT,IN arg2 INT) BEGIN DECLARE var INT; SET var=arg; WHILE var < arg2 DO INSERT INTO cic

Elasticsearch最简安装

产品支持矩阵 https://www.elastic.co/cn/support/matrix 下载地址 https://www.elastic.co/cn/downloads/elasticsearch 安装配置 修改Linux配置 cat >> /etc/security/limits.conf ulimit -n 65536 ```` ```shell cat >>

Oracle性能监控SQL

-- 查询会话: SELECT status, type, COUNT(*) as value FROM v$session GROUP BY status, type; -- 查询资源使用情况: SELECT resource_name,current_utilization,CASE WHEN TRIM(limit_value) LIKE 'UNLIMITED' T