Posgresql uses auto_explain lain for targeted optimization

os: centos 7.4 postgresql: 10.4 auto_explain: Auto_explainlain is a feature added after postgresql 8.4 that provides a way to automatically record execution plans for slow statements without having to run EXPLAIN manually. This is very important in the real world. install auto_explain is automatically installed using ma ...

Posted on Wed, 22 Jan 2020 11:16:53 -0500 by Alicia

Transformation of Apache Flink DataStream API (Chapter 3)

DataStream data conversion General operators // order zhangsan TV,GAME val env = StreamExecutionEnvironment.createLocalEnvironment() val props = new Properties() props.setProperty(ConsumerConfig.BOOTSTRAP_SERVERS_CONFIG, "CentOS:9092,CentOS:9093,CentOS:9094") props.setProperty(Cons ...

Posted on Sun, 19 Jan 2020 02:31:15 -0500 by Rayne

Architecture Overview of Apache Spark (Chapter 1)

Background introduction Spark is a lightning fast unified analysis engine (Computing Framework) for large-scale data set processing. Spark is doing batch computing of data, and its computing performance is about 10-100 times that of Hadoop MapReduce. Because spark uses advanced DAG based task scheduli ...

Posted on Sun, 19 Jan 2020 02:17:34 -0500 by varsha

centos7 installation process and host configuration

This article records the whole process of CentOS 7 64 bit installation on the virtual machine, which I downloaded for my future installation and use Download address: http://mirrors.aliyun.com/centos/7/isos/x86_64/ Download centos-7-x86_-dvd-1908.iso Configure the network environment For the next st ...

Posted on Sat, 18 Jan 2020 04:05:19 -0500 by hanji

MySQL Master-Slave Synchronization-Principle-Practice

What is mysql's master-slave replication? MySQL master-slave replication refers to the replication of data from one MySQL database server master node to one or more slave nodes.MySQL replicates asynchronously by default, so that the master server is not always accessed by the slave node to update its own data, which can be updated over a remote ...

Posted on Wed, 15 Jan 2020 20:55:58 -0500 by Cinquecento

Linux Installation and management program

Bowen catalogue 1, RPM package management tools 2, Install, upgrade, and uninstall RPM software 3, Linux Application Foundation 4, Source code compilation and installation 1, RPM package management tools RPM Pachage Manager is proposed by Red Hat and adopted by many Linux distributions. Establish a unified database file, record the change in ...

Posted on Sun, 12 Jan 2020 22:11:04 -0500 by aznkidzx

Docker - Cgroup Resource Limitation

Docker Cgroup Resource Configuration Method Cgroup is a mechanism provided by the Linux kernel to limit, record, and isolate the physical resources used by process groups Docker uses Cgroup to control the resource quotas used by containers, including cpu, memory, and disk. Docker basically covers common resource quotas and usage control Cgroup ...

Posted on Thu, 09 Jan 2020 20:50:18 -0500 by brax23

CentOS 7 viewing system version and number of digits

Identification standard First of all, we need to know what kind of identity is 32-bit and 64 bit. PC server X86 series I386--I686 are all 32 bits X86 ʄ is 64 bit Order is not too much, in order to prevent the obstacles of selectivity, choose the first method unanimously, the latter is only for supplement. Method 1: [roo ...

Posted on Wed, 08 Jan 2020 13:46:56 -0500 by mediamind

CentOS7u4 local yum source configuration

If you use CentOS for local yum source installation, use the image of centos-7-x86_-everything-1708.iso Make the yum source, otherwise 32-bit dependency package will be missing 1. Create the directory / home/CentOS7u4 in the virtual machine, and copy the installation package of CentOS7u4 from the optical drive to the local ...

Posted on Tue, 07 Jan 2020 00:34:38 -0500 by raptorman

centos7 redis boot-up self-start

Last login: Thu Jul 13 15:28:02 2017 from 192.168.1.102 [root@minimal ~]# ps -ef |grep redis redis 1015 1 0 16:09 ? 00:00:00 /usr/bin/redis-server 127.0.0.1:6379 root 2361 2343 0 16:10 pts/0 00:00:00 grep --color=auto redis [root@minimal ~]# ps -ef |grep nginx root 1039 1 0 16:09 ? 00: ...

Posted on Mon, 06 Jan 2020 16:08:08 -0500 by fatmcgav