- 博客(9)
- 资源 (3)
- 收藏
- 关注
原创 等待事件:enq: HW - contention
Top 10 Foreground Events by Total Wait TimeEventWaitsTotal Wait Time (sec)Wait Avg(ms)% DB timeWait Classenq: HW - contention54177.5K143220
2017-09-22 23:16:35 826
原创 syslogd
21:$Message from syslogd@test21 at Sep 19 16:30:02 ... kernel:Uhhuh. NMI received for unknown reason 00 on CPU 128.Message from syslogd@test21 at Sep 19 16:30:02 ... kernel:Do you have a s
2017-09-20 10:21:37 933
原创 xtts 检查和日志记录
sql>select tp.PLATFORM_ID platformid,d.platform_name, endian_format from v$transportable_platform tp, v$database d where tp.platform_name = d.platform_name;old:PLATFORMID PLATFORM_NAME
2017-09-18 14:40:39 440
原创 关闭 oracle dblink 功能
alter system set open_links=0 sid ='*' scope=spfile;System altered.alter system set open_links_per_instance=0 sid ='*' scope=spfile;System altered.重启数据库SELECT id FROM tb@db_lin
2017-09-15 17:15:32 2761 1
原创 MySQL 5.7 (5 tpcc-mysql 安装、 测试)
https://github.com/Percona-Lab/tpcc-mysqlMySQL中文网便捷下载地址:http://imysql.com/wp-content/uploads/2014/09/tpcc-mysql-src.tgz下载到本地后,先执行 gunzip 解压缩文件,再执行 tar xf 解包,直接 tar zxf 可能会报告异常。tpcc-mys
2017-09-06 00:25:12 790
原创 MySQL 5.7 (4sysbench安装和性能测试)
sysbench安装和性能测试下载地址http://sourceforge.net/projects/sysbench https://dev.mysql.com/downloads/benchmarks.htmlhttps://github.com/akopytov/sysbenchsysbench-0.4.12.14.tar.gztar zxf
2017-09-06 00:21:38 809
原创 MySQL 5.7 (3复制)
mysql 5.5 开始出现半同步复制(semi_sync_replication)mysql 5.6 出现GTID, delay replication, 基于库的并行复制mysql 5.6 开始支持多源复制,用的较多,基于GTIDmysql 5.7 lossless replication, multli-source replication, group comm
2017-09-04 22:35:27 237
原创 MySQL 5.7 (2GTID,binlog)
MySQL 5.6.10之后完善了GTID,5.6.2开始支持GTID复制5.7支持GTID在线切换,5.6不支持该功能root@localhost [(none)]>show global variables like "%direct%";+-----------------------------------------+-------+| Variable_name
2017-09-04 11:55:47 799
原创 MySQL 5.7 (1启动方式)
加载配置文件顺序:/etc/my.cnf---->/etc/mysql/my.cnf----->/usr/local/mysql/etc/my.cnf---->~/.my.cnf后面配置文件会覆盖前面配置文件设置的参数如果/etc/my.cnf配置文件定义了innodb_buffer_pool_size=100M 而/etc/mysql/my.cnf配置文件定义了innodb_buffer
2017-09-04 10:38:48 5739
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人