Mysql locates next key lock in one minute. You need a few minutes
Connections and threads
View the connection information show processlist
+----+------+------------------+------+---------+------+----------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+------------------+------+---------+------+----------+------------------+
| 3 | root ...
Posted by bigbstanley on Tue, 28 Jan 2020 04:38:47 -0800
SQL statement instance application
Operation of database
Linked database
mysql -u root -proot -- Direct display of password is not recommended
mysql -uroot -p
Exit database
exit/quit
The sql statement needs a semicolon at the end; the end
Show database version
select version();
Display time
select now();
View all databases ...
Posted by akumakeenta on Mon, 27 Jan 2020 02:17:50 -0800
Distributed lock -- realizing distributed lock based on Database
In the last blog, I simply said what is distributed lock, and built a basic environment (very simple). This blog needs to start to experience distributed lock formally. Because it is developed on a single machine, there is no cluster, but the specific implementation of the code method is no different fr ...
Posted by soulrazer on Sun, 26 Jan 2020 02:06:59 -0800
Spring Boot Integrates MyBatis to Connect to Oracle Database
1. Spring Boot project adds MyBatis dependencies and Oracle drivers:
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>com.oracle</groupId>
<a ...
Posted by mtimdog on Sat, 25 Jan 2020 08:22:24 -0800
Lesson 101 predefined super global array ① - principle analysis
Interface:
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="Generator" content="EditPlus®">
<meta name="Author" content="">
<meta name="Keywords" content="">
<meta name="Description" content="">
<title>Document</title>
</he ...
Posted by mart on Sat, 25 Jan 2020 07:17:17 -0800
Server upgrade to centos8 site configuration - PHP and mysql upgrade from 5.6 to php7 and msyql8
linux centos8 installs php7 nginx1.4 mysql8, runs PHP website, configures each module from scratch
Choice between CentOS7 and centOS8
At present, the default centos system version of major cloud servers in China is still 7. Currently, there is no centos supporting system. The default of foreign cloud server manufacturers is 8, such as vultr.
P ...
Posted by matrixd on Fri, 24 Jan 2020 22:18:17 -0800
NOW() function in PHP
Is there a PHP function that returns the date and time in the same format as MySQL function NOW()?
I know how to do this with date(), but I asked if there was a function for this only.
For example, return:
2009-12-01 00:00:00
#1 building
Use this feature:
function getDatetimeNow() {
$tz_object = new DateTimeZone('Brazil/Eas ...
Posted by gray8110 on Thu, 23 Jan 2020 06:14:37 -0800
MySQL - UPDATE query based on SELECT query
I need to check (from the same table) whether there is an association between two events based on date and time.
One set of data will contain the end date time of some events, and the other set of data will contain the start date time of other events.
If the first event completes before the second, then I want to link them.
So far, I ...
Posted by coppercoins on Wed, 22 Jan 2020 07:36:43 -0800
Implementation of mariadb galera cluster based on docker
Environment configuration:
Node name
IP address
node01
192.168.10.207
node02
192.168.10.167
Basic environment configuration:
Remove firewalld
yum remove firewalld -y
Turn off selinux
sudo vim /etc/selinux/config
Modify the following:
SELINUX=disabled
Install iptables services and ...
Posted by versatilewt on Wed, 22 Jan 2020 01:00:27 -0800
Continue my login module development I
1. In the module in django, create the user
class UserInfo(models.Model):
name = models.CharField(max_length=20)
email = models.CharField(max_length=50)
power = models.IntegerField()
phone = models.CharField(max_length=20)
country = models.CharField(max_length=10)
city = models.C ...
Posted by MathewByrne on Wed, 22 Jan 2020 00:57:09 -0800