摘要:
1 [root@htdb2 ~]# /u01/app/crs/bin/oifcfg getif 2 eth11 192.168.20.0 global public 3 eth12 10.0.0.0 global cluster_interconnect 4 [root@htdb2 ~]# /u01/app/crs/bin/oifcfg setif -global eth13... 阅读全文
摘要:
1 11g中引入DBMS_SHARED_POOL.PURGE删除指定的某个sql_id不用清空shared_pool 2 查看包DBMS_SHARED_POOL定义 3 desc sys.DBMS_SHARED_POOL; 4 PROCEDURE PURGE 5 Argument Name Type In/Out Default? 6 ... 阅读全文
摘要:
1 mysql> SHOW VARIABLES LIKE 'innodb_file_per_table'; 2 + + + 3 | Variable_name | Value | 4 + + + 5 | innodb_file_per_table | ON | 6 + + + 7 1 row in 阅读全文
摘要:
测试表employees.t_emp水平分片,按照emp_no分片 配置mycat schema rule 1 [mycat@redis04 conf]$ cat schema.xml 2 <?xml version="1.0"?> 3 <!DOCTYPE mycat:schema SYSTEM " 阅读全文
摘要:
mysql> select emp_no,first_name,last_name,gender into outfile '/home/mycat/t1.txt' -> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMIN 阅读全文
摘要:
gzip -c /home/mysql/test_db-master/load_employees.dump | ssh mycat@192.168.20.204"gunzip -c - >/home/mycat/load_employees.dump" nc -l 12345 | tar xvzf 阅读全文
摘要:
下载 wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz 创建用户和组及变更权限 groupadd mysqluseradd mysql -g mysql pass 阅读全文
摘要:
修改网卡规则:先关闭网络服务,修改配置文件网卡的HWADDR值和/etc/udev/rules.d/70-persistent-net.rules文件中网卡的ATTR值一致,然后再修改/etc/udev/rules.d/70-persistent-net.rules中对应的网卡名称,最后再关闭和重启 阅读全文
摘要:
1、查看加密组件[qdtais1]@ht01[/home/oracle]$adapters Installed Oracle Net transport protocols are: IPC BEQ TCP/IP SSL RAW SDP/IB Installed Oracle Net naming 阅读全文
摘要:
删除统计信息并锁定 exec dbms_stats.delete_table_stats(ownname => 'scott',tabname =>'a'); exec dbms_stats.lock_table_stats(ownname => 'scott',tabname =>'a');exe 阅读全文