Stored Procedures for MySQL

Stored procedures are an important feature of database storage. Stored procedures were not supported by MySQL prior to version 5.0. Stored procedures can greatly improve the processing speed of the database and the flexibility of database programming.1. What is a stored procedure?Stored procedures are a collection of SQL statements that are de ...

Posted by sm on Sun, 10 May 2020 10:17:41 -0700

Docker installs JIRA and Confluence (cracked version)

1. Description 1.1 Material This paper uses the following materials: Docker Mirror Github Link Crack Tool Gitee Link With these tools, you can theoretically crack almost all versions. 1.2 Database If you choose an external database, you can create it as follows: # Create jira database and users CREATE DATABASE jiradb CHARACTER SET utf8mb4 ...

Posted by stiphu on Sun, 10 May 2020 10:14:43 -0700

mariadb Source Installation

Dead work Because MariaDB's binary package mirroring source is at a foreign address, the package is downloaded in advance to the local physical machine and uploaded to the virtual machine/usr/local/src directory for installation using the lrzsz tool. The physical address is (click to download directly to the ph ...

Posted by abo28 on Sun, 10 May 2020 09:09:17 -0700

15. Chapter 15 of spring cloud Alibaba, upgrade, distributed transaction solution, Seata

Chapter 14 of SpringCloud Alibaba, upgrade, distributed transaction solution, Seata 1, Overview of distributed transactions 1. What is distributed transaction With the rapid development of the Internet, the software system has changed from the original single application to the distributed application. The distributed system will split an appli ...

Posted by fatmcgav on Sat, 09 May 2020 02:57:10 -0700

Java automation test framework - 04 - Test Method of TestNG

From: https://www.cnblogs.com/du-hong/p/11718894.html brief introduction According to the plan in the previous article, this one will share the test method with the kids. 1, Set parameters Test methods can have Parameters. Each test method can have any number of Parameters, and you can pass the correct Parameters to the method by using Te ...

Posted by Okami on Sat, 09 May 2020 01:06:00 -0700

lnmp build (Nginx1.12.1; MySQL 5.7.20; php7.2.0)

Install dependent packages: #yum install gcc bison bison-devel zlib-devel libmcrypt-devel mcrypt mhash-devel openssl-devel libxml2-devel libcurl-devel bzip2-devel readline-devel libedit-devel sqlite-devel libpng-devel libjpeg-devel freetype freetype-devel Create a WW user: #groupadd www #useradd -g www -s /sbin/nolo ...

Posted by ChrisDarl on Fri, 08 May 2020 11:18:51 -0700

Quick upgrade of ZABBIX version 5.0

Zabbix 5.0 has added many new functions, such as vertical menu, hidden menu, test items in user interface, limit agent check, find and replace preprocessing step ES7 support, etc.. Let's deploy and experience Zabbix 5.0     Upgrade Notice     Upgrade requirements PHP version PHP version has been upgraded from minimum 5.4.0 to 7.2.0 Database ver ...

Posted by dmcentire on Thu, 07 May 2020 23:02:03 -0700

The jam caused by the setting of [MySQL] time zone

Author: Tian Jie It's not uncommon for a long query execution time to cause an application aware "jam" in the daily support and use of the database, but the SQL execution "jam" caused by the time zone setting is still an interesting phenomenon, which has not been specifically concerned before. This customer's meticulous and ...

Posted by WowAddict on Thu, 07 May 2020 03:57:46 -0700

Explanation of MySQL skip name resolve

mysql connection is slow. Log in to the server to view mysql logs:IP address 'XX.XX.XX.XX' has been resolved to the host name 'XX.XX.XX.XX.ro.ovo.sc', which resembles IPv4-address itself.The reason is that mysql performs DNS reverse resolution on the connected client.There are two solutions:1. Write the ip address of the client in the / etc/ ...

Posted by lohmk on Wed, 06 May 2020 22:54:02 -0700

Python+Flask build a movie download website

1. Words written in the front I still want to learn Python well. I have learned the basic grammar part for a long time. With a little penetration of the application part, I can go to data analysis, crawler, web, machine learning and other aspects, and have a long way to go.OK, no more nonsense, start programming. 2. Build project structure F ...

Posted by iffy on Wed, 06 May 2020 08:35:30 -0700