自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+

msdnchina的专栏@JiNan,ShanDong

感谢枯荣长老对本人的大力帮助

原创 [转自统信工程师]红帽系统与UOS命令对比

红帽系统与UOS命令对比注:本文转自统信工程师在微信群里发的文章。由于csdn博客的转发类型需要写网址,而本文是没有网址的,因此设置为原创文章1 软件包管理系统目前在各 Linux 发行版中, 比较著名的软件包管理系统有如下两种:RPM: Red Hat/Fedora,Suse,Mandriva 使用的是这类管理系统。DPKG: Debian,ubuntu使用的是这类管理系统。UOS是基于Debian发行版本,因此UOS使用的是DPKG包管理机制。Redhat的rpm软件包管理相

2020-07-29 14:31:11 81

原创 linux的C 函数fflush()的相关说明

相关参考链接:https://blog.csdn.net/msdnchina/article/details/99205560在linux命令行中执行manfflush即可。我的本意是想弄明白fflush()函数是数据的写入目的地是哪里,如下是manfflush结果:NOTES Note that fflush() only flushes the user-space buffers provided by the C library. To ensure tha...

2020-07-17 11:58:28 46

转载 PostgreSQL查找行锁等待

第一个session:postgres=# begin;BEGINpostgres=# update t10 set id=1 where id=111;UPDATE 1postgres=# select pg_backend_pid(); pg_backend_pid ---------------- 28120(1 row)postgres=# update t100 set id=222 where id=2;UPDATE 1postgres=# .

2020-07-13 17:42:09 56

转载 【转】统计pg_wal目录下的wal文件个数的sql语句

来源于:https://pgdash.io/blog/postgres-monitor-wal-files.htmlpostgres=# SELECT COUNT(*) FROM pg_ls_dir('pg_wal') WHERE pg_ls_dir ~ '^[0-9A-F]{24}';count------- 64(1 row)postgres=#

2020-07-08 19:21:37 67

原创 确定PostgreSQL数据库超级用户的方法

场景描述:现有一个采用源码编译方式安装的原生PostgreSQL数据库,linux操作系统,并且该操作系统下有1000个操作系统用户,请问怎么能最快速的确定这个原生PostgreSQL数据库initdb时指定的超级用户是哪个?答案:linux命令行执行如下命令即可strings $PGDATA/global/1260...

2020-06-30 20:11:53 119

原创 RHEL操作系统内置的用户

[root@rhel78 setup-2.8.71]# cat /usr/share/doc/setup-*/uidgidNAME UID GID HOME SHELL PACKAGESroot 0 0 /root /bin/bash setupbin 1 1 /bin /sbin/nologin setupdaemon 2 2 /sbin /sbin/nologin setup...

2020-05-01 16:31:21 214

原创 RHEL 8.2于2020年4月底发布了

在该链接中有一个sha-256的截图,该截图取自redhat.com网站。下载链接:https://pan.baidu.com/s/1hHGYoRtckYrKFozzbhlvzw提取码:dvkf注意:rhel 8.2的发布日期可能是2020.04.29,截止本文写成时,https://access.redhat.com/articles/3078这个文章(Red Hat Enterpr...

2020-05-01 06:51:00 2406

原创 RHEL7.8 x86-64bit 已发布

该下载链接中包括一个截图,截图中有SHA-256值下载链接:https://pan.baidu.com/s/1ShW1vZWhqbphqdXNWGIshQ提取码:fb03

2020-04-02 07:34:10 1391 1

转载 enable-case-insensitive-string-comparison-in-oracle-12c

By default, Oracle checks content as well as casing, while comparing the two strings in "where" or "like" or "case" statements.For example, the statement given below will return 0.SELECTCASEWH...

2020-03-08 18:25:24 130

原创 rhel8中可以用yum install 安装bcc-tools包,bcc-tools包内有execsnoop等工具

[root@rhel8server1 ~]# cat /etc/redhat-release Red Hat Enterprise Linux release 8.0 (Ootpa)[root@rhel8server1 ~]# mount /dev/cdrom /mnt/cdrommount: /mnt/cdrom: WARNING: device write-protected, mou...

2020-02-27 22:17:01 313

转载 RHEL5中系统定义的user

https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/5/html/deployment_guide/s1-users-groups-standard-users

2020-02-02 18:23:02 108

转载 Oracle transaction isolation levels

Our technologist isolates transactions safely.By Tom KyteNovember/December 2005Isolation LevelsI've read theOracle Database Conceptsmanual, Chapter 20, "Data Concurrency and Consistency," b...

2020-01-30 08:23:40 225

转载 Should I enable large page support for Java?

Should I enable large page support for Java?SOLUTION 已验证- 已更新2016年二月3日23:45-English环境Java问题Should I enable large page support for Java?决议Enabling large page support can provide per...

2019-12-19 21:16:23 73

转载 How do I enable large page support on Windows?

How do I enable large page support on Windows?SOLUTION 已验证- 已更新2014年九月5日10:06-English环境Windows Java JDK问题 I want toenable large page support for Java, and I must enable it on my Wi...

2019-12-19 20:44:41 203

转载 How do I enable large page support for Java?

How do I enable large page support for Java?SOLUTION 已验证- 已更新2015年六月24日22:32-English环境Sun JDK OpenJDK IBM JDK JRockit JDK问题How do I enable Java large page support?决议First, large...

2019-12-19 20:43:53 51

转载 RHEL 8.1 Support for Data Integrity Field/Data Integrity Extension (DIF/DIX)

4.9.File systems and storageSupport for Data Integrity Field/Data Integrity Extension (DIF/DIX)DIF/DIX is supported on configurations where the hardware vendor has qualified it and provides full ...

2019-11-17 09:52:00 332

转载 Setting up NIC Teaming for Windows Server 2012*/2012 R2*/2016*/2019*

To create a NIC Team:In Server Manager, clickLocal Server. In the Properties pane locate NIC Teaming, and then click the linkDisabledto the right. The NIC Teaming dialog box opens. In Adapt...

2019-11-15 23:31:36 83

转载 ss doesn't allow AND or OR expressions with parenthesis in RHEL 8

ss doesn't allow AND or OR expressions with parenthesis in RHEL 8SOLUTION 已验证- 已更新2019年十一月6日15:37-English环境Red Hat Enterprise Linux (RHEL) 8 iproute问题 In RHEL 8 its been observed th...

2019-11-14 22:04:47 49

转载 【转载】PG的两种集群技术:Pgpool-II与Postgres-XL

转自:https://segmentfault.com/a/1190000007012082最近研究了PG的两种集群方案,分别是Pgpool-II和Postgres-XL,在这里总结一下二者的机制、结构、优劣、测试结果等。1、 Pgpool-II和Postgres-XL简介据我目前的了解,Pgpool-II和Postgres-XL是PG集群开源实现中比较成功的两个项目,互联网上相关的介绍...

2019-11-06 22:12:13 86

转载 How to force xfs filesystem to shutdown?

How to force xfs filesystem to shutdown?SOLUTION UNVERIFIED- 已更新2019年四月8日10:47-English环境Red Hat Enterprise Linux 7 XFX filesystem问题Unmounting an xfs filesystem failed with EBUSY.Raw...

2019-11-04 01:01:55 111

转载 XFS filesystem shuts down due to I/O errors from loss of paths

XFS filesystem shuts down due to I/O errors from loss of pathsSOLUTION UNVERIFIED- 已更新2015年一月22日09:47-English环境Red Hat Enterprise Linux 6.5 multipath XFS问题We are copying(rsync) data...

2019-11-04 01:01:19 88

转载 XFS filesystem shutdown when deleting millions of files on RHEL

XFS filesystem shutdown when deleting millions of files on RHELSOLUTION UNVERIFIED- 已更新2019年三月8日20:43-English环境Red Hat Enterprise Linux 7问题XFS file system shut down when deleting 50 ~...

2019-11-04 00:59:15 299

转载 XFS filesystem shutdown when filesystem is close to full

XFS filesystem shutdown when filesystem is close to fullSOLUTION 已验证- 已更新2019年九月27日10:09-English环境Red Hat Enterprise Linux 7.5 kernel-3.10.0-862.2.3.el7 XFS Filesystems with V4 superbl...

2019-11-04 00:57:47 149

转载 How to extract a metadata dump from a XFS filesystem?

问题How to extract a metadata dump from a XFS filesystem?环境Red Hat Enterprise Linux (RHEL) 5 Red Hat Enterprise Linux (RHEL) 6 Red Hat Enterprise Linux (RHEL) 7 xfsprogs决议Umount the filesy...

2019-11-03 17:56:18 53

转载 postgresql安装启动服务器以及uuid插件安装

postgresql安装目录:/opt/postgresql/9.6postgresql数据库目录:/data/postgresql/准备包:postgresql:https://www.postgresql.org/ftp/source/ postgresql-9.6.2.tar.gzuuid-ossp:https://launchpad.net/ubuntu/+source/ossp...

2019-11-01 21:24:58 113

转载 为 PostgreSQL 添加 OSSP UUID 支持

PostgreSQL 依赖OSSP UUID产生 UUID 值,需要在 configure 时加入--with-ossp-uuid参数。学习过程中发现了两种 OSSP UUID 包的安装方式,记录下来方便以后查阅。第一种方法到 OSSP UUID 官网下载源码安装包,目前最新是uuid-1.6.2.tar.gz,解压后./configure && make &...

2019-11-01 21:23:57 66

转载 How to reproduce a condition which invokes the OOM-Killer ?

How to reproduce a condition which invokes the OOM-Killer ?SOLUTION UNVERIFIED- 已更新2016年四月29日23:47-English环境Red Hat Enterprise Linux 5 Red Hat Enterprise Linux 6问题How to reproduce a ...

2019-10-17 22:48:25 96

转载 How does the OOM-Killer select a task to kill?

How does the OOM-Killer select a task to kill?SOLUTION 已验证- 已更新2017年二月28日16:41-English环境Red Hat Enterprise Linux ( All version)问题How does the OOM-Killer select a task to kill?决议...

2019-10-17 22:40:07 107

转载 What is the recommended swap size for Red Hat platforms?

What is the recommended swap size for Red Hat platforms?SOLUTION 已验证- 已更新2016年八月30日12:29-English环境Red Hat Enterprise Linux 7 Red Hat Enterprise Linux 6 Red Hat Enterprise Linux 5 R...

2019-10-17 22:38:10 50

转载 Monitoring performance of Linux automatic memory migration between NUMA nodes

Monitoring performance of Linux automatic memory migration between NUMA nodesUpdated2018年四月6日04:08-EnglishNon-Uniform Memory Access (NUMA) is used on larger computer system to allow the m...

2019-10-17 22:33:14 74

转载 Automatic NUMA balancing in RHEL7

Automatic NUMA balancing in RHEL7SOLUTION 已验证- 已更新2019年五月14日20:53-English环境Red Hat Enterprise Linux 7问题In which version, the automatic NUMA balancing for processes/memory available...

2019-10-17 22:24:04 123

转载 How to determine if NUMA configuration is enabled or disabled?

How to determine if NUMA configuration is enabled or disabled?SOLUTION 已验证- 已更新2017年二月20日19:10-English环境Red Hat Enterprise Linux 4 Red Hat Enterprise Linux 5 Red Hat Enterprise Linux 6...

2019-10-17 22:22:08 54

转载 How to disable NUMA in Red Hat Enterprise Linux system?

How to disable NUMA in Red Hat Enterprise Linux system?SOLUTION 已验证- 已更新2019年七月11日19:29-English环境Red Hat Enterprise Linux 4 Red Hat Enterprise Linux 5 Red Hat Enterprise Linux 6 Re...

2019-10-17 22:20:46 115

转载 Which signal does the oom killer send to kill the process?

Which signal does the oom killer send to kill the process?SOLUTION 已验证- 已更新2015年十二月22日22:06-English环境Red Hat Enterprise Linux 5 Red Hat Enterprise Linux 6 Red Hat Enterprise Linux 7...

2019-10-17 22:05:23 60

转载 How to prevent a process to be a target of oom-killer?

How to prevent a process to be a target of oom-killer?SOLUTION 已验证- 已更新2015年七月21日14:38-English环境Red Hat Enterprise Linux 5 Red Hat Enterprise Linux 6 Red Hat Enterprise Linux 7问题...

2019-10-17 22:04:06 67

转载 How to safely remove swap partition in Red Hat Enterprise Linux?

How to safely remove swap partition in Red Hat Enterprise Linux?SOLUTION 已验证- 已更新2019年八月21日17:51-English环境Red Hat Enterprise Linux 5 Red Hat Enterprise Linux 6 Red Hat Enterprise Li...

2019-10-17 22:01:02 33

转载 【转】How long will a 64 bit Transaction-ID last in PostgreSQL?

from the following website:https://andreas.scherbaum.la/blog/archives/970-How-long-will-a-64-bit-Transaction-ID-last-in-PostgreSQL.htmlHow long will a 64 bit Transaction-ID last in PostgreSQL?A...

2019-10-10 23:11:46 56

转载 THREE REASONS WHY VACUUM WON’T REMOVE DEAD ROWS FROM A TABLE

WhyVACUUM?© xkcd.xom (Randall Munroe) under theCreative Commons Attribution-NonCommercial 2.5 LicenseWhenever rows in a PostgreSQL table are updated or deleted,dead rowsare left behind....

2019-10-10 13:06:58 39

转载 How do I test connection to a ntp server?

How do I test connection to a ntp server?SOLUTION IN PROGRESS- 已更新2015年十一月3日01:52-English环境Red Hat Enterprise Linux ntp问题How do I test connection to a ntp server without changing ...

2019-10-05 19:27:54 48

转载 100x faster Postgres performance by changing 1 line

A simple but non-obvious one-line change (ANY(ARRAY[...])toANY(VALUES(...))) in a (bad) PostgreSQL 9.0 query cuts query time from 20s to 0.2s. Starting with low-level metrics we make our way to y...

2019-10-04 19:08:24 44

提示
确定要删除当前文章?
取消 删除