操作数据库相关的Linux命令——持续更新

不吃辣堡

已于 2024-08-13 10:56:14 修改

阅读量385

点赞数 1

CC 4.0 BY-SA版权

分类专栏： Linux 文章标签：数据库 linux 运维

于 2024-07-30 11:20:36 首次发布

本文链接：https://blog.csdn.net/weixin_41977045/article/details/140771918

Linux 专栏收录该内容

7 篇文章

订阅专栏

1.查看环境信息

lscpu

cat /etc/os-release

[root@csdy7001 ~]# lscpu
Architecture:          x86_64
CPU op-mode(s):        32-bit, 64-bit
Byte Order:            Little Endian
CPU(s):                2
On-line CPU(s) list:   0,1
Thread(s) per core:    1
Core(s) per socket:    2
Socket(s):             1
NUMA node(s):          1
Vendor ID:             GenuineIntel
CPU family:            6
Model:                 85
Model name:            Intel(R) Xeon(R) Gold 6138 CPU @ 2.00GHz
Stepping:              4
CPU MHz:               1995.311
BogoMIPS:              3990.62
Hypervisor vendor:     KVM
Virtualization type:   full
L1d cache:             32K
L1i cache:             32K
L2 cache:              1024K
L3 cache:              28160K
NUMA node0 CPU(s):     0,1
Flags:                 fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx rdtscp lm constant_tsc rep_good nopl xtopology nonstop_tsc eagerfpu pni pclmulqdq ssse3 cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt aes xsave avx rdrand hypervisor lahf_lm abm 3dnowprefetch invpcid_single fsgsbase bmi1 avx2 bmi2 invpcid rdseed clflushopt md_clear flush_l1d arch_capabilities
[root@csdy7001 ~]# cat /etc/os-release
NAME="CentOS Linux"
VERSION="7 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="7"
PRETTY_NAME="CentOS Linux 7 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:7"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"

CENTOS_MANTISBT_PROJECT="CentOS-7"
CENTOS_MANTISBT_PROJECT_VERSION="7"
REDHAT_SUPPORT_PRODUCT="centos"
REDHAT_SUPPORT_PRODUCT_VERSION="7"

2.MAC系统与Linux互传

Last login: Tue Jul 30 10:38:28 on ttys000
dongkeyi@dongkeyideMacBook-Pro ~ % scp /Users/dongkeyi/Desktop/海量数据/G100/vastbase_license root@172.16.55.131:/var/vastbase
root@172.16.55.131's password: 
vastbase_license                              100%  260     8.5KB/s   00:00    
dongkeyi@dongkeyideMacBook-Pro ~ %

Mac系统和Linux之间的文件/文件夹传输_mac linux传递文件-CSDN博客

3.两台服务器之间互传

[root@csdy7002 yum.repos.d]# scp /etc/yum.repos.d/CentOS-Vault.repo root@172.16.55.133:/etc/yum.repos.d/
root@172.16.55.133's password:
CentOS-Vault.repo

两台Linux服务器之间传输文件的四种方法（转载）_linux 如何将文件从一台服务器转移到另一台服务器-CSDN博客

4.数据库用户权限问题

Linux中修改文件权限chmod命令详解_linux shell_脚本之家

5.全盘查找某一文件中的某一值

cat $PGDATA/postgresql.conf | grep listen_addresses

6.netstat -anp的解释

Linux下netstat命令详解&&netstat -anp | grep 讲解-CSDN博客