Install MySQL 5.7 under CentOS 7.3
1. Download
Download address: https://dev.mysql.com/downloads/mysql/
Select the version you need to install, where my computer is CentOS7.3 64 bit
Then download RPM Bundle, a collection of several programs.
Then start downloading...
2. Unzip the installation package
Unzip mysql-5.7.20-1.el7.x86_64.rpm-bundle ...
Posted by cdwhalley.com on Thu, 09 Jul 2020 18:16:54 +0200
Chapter 7 Data Regulation: Cleanup, Conversion, Merge, Reshaping (4)
Chapter 7 Data Regulation: Cleanup, Conversion, Merge, Reshaping (4)
The source of ldata is not given in this chapter and is availableMacrodata.csvTurn out available data.
import pandas as pd
import numpy as np
import datetime ###Time processing later
from pandas import Series,DataFrame
###Read inMacrodata.csvfil ...
Posted by quicknik on Tue, 07 Jul 2020 17:44:07 +0200
Java Exercise--Generics (12)
1. Write a Book class that has at least two properties, name and price.This class implements the Comparable interface by specifying that the size relationship between two Book class instances is the size relationship of the price attribute of the two Book class instances in the compareTo() method of the interface.In the main function, select t ...
Posted by arjay_comsci on Mon, 06 Jul 2020 16:49:39 +0200
An example of ASM disk not found in DBCA Library
Environmental Information
red hat linux64
gi 11.2.0.4
oracle 11.2.0.4
Problem Phenomena
After installing gi software and oralce database software, the database is built through the dbca user interface. It is found that the database can be built normally on node1, not on node2. The dbca library building process errors on node2.
Figur ...
Posted by scottrad on Sun, 05 Jul 2020 17:42:16 +0200
Use of SQL Statement - Database Operation
[select] SQL statement query
join(left/right) two-table join/multi-table join
//Multi-table Joint Survey:
$sql = 'SELECT * FROM news LEFT JOIN (news_type, news_photo)ON (news_photo.n_id=news.n_id AND n_type=news_type.id)';
//Joint investigation of two tables:
$sql = 'SELECT * FROM s LEFT JOIN sc ON s.sno=sc.sno';
Three Tables Joint Ch ...
Posted by gawrrell on Sun, 05 Jul 2020 17:37:13 +0200
[source code analysis] Oozie history submission task
0x00 summary
Oozie is an open source framework based on workflow engine contributed by Cloudera company to Apache. It is an open source workflow scheduling engine of Hadoop platform, which is used to manage Hadoop jobs. This article, the first in a series, introduces oozie's task submission phase.
0x01 problem
We deduce the implementation f ...
Posted by cowboy_x on Tue, 30 Jun 2020 05:26:29 +0200
Singleton singleton mode
Singleton mode is one of the creation modes. In our software development process, there are many classes that are only created once globally, such as app framework class, global management class, configuration file, log, database, etc. Using singleton mode can make our code elegant.
The UML class diagram and C++ sample code are given below:
...
Posted by mightymaster on Mon, 29 Jun 2020 18:15:58 +0200
Backup private key for MAC decentralized wallet development
1, Private key
in this lesson, we will continue to register the Token, which is to backup the private key. Each public chain will have a private key, but it is different. There are four private keys in MAC. namely
Wallet Key
Wallet key is one of the necessary information to open MAC wallet. ...
Posted by doodmon on Mon, 29 Jun 2020 10:36:56 +0200
Chapter 13: concurrent deadlock and enterprise solutions (deadlock, livelock, starvation)
1. What is a deadlock? What's the harm?
1.1 what is deadlock?
Occurs in concurrency
[mutually exclusive]: when two (or more) threads (or processes) hold each other's resources required by each other, but do not actively release them, all of them can't move forward, resulting in endless blocking o ...
Posted by ollmorris on Mon, 29 Jun 2020 08:23:19 +0200
Hand in hand to teach you to customize a Druid Filter to record sql, and combine Nacos to realize dynamic switch and judge threshold adjustment
1, Background
Durid is a widely used database connection pool, which has superior performance, powerful monitoring mechanism, and also supports expansion through the mechanism of filter.
Druid has a StatFilter for slow sql recording, but I found some shortcomings in using it:
The print log of this Fi ...
Posted by jonsof on Mon, 29 Jun 2020 04:13:38 +0200