Database - index

Database - index MySQL's official definition of Index is: Index is a data structure that helps MySQL obtain data efficiently. There is a big difference between 0.5s for data acquisition and 0.001s for data acquisition! Therefore, it is necessary to study index! The essence of index: index is data stru ...

Posted on Tue, 04 Feb 2020 09:52:53 -0800 by peterj

Virtual machine installation of CentOS7 and jdk1.8, mysql5.7, tomcat9

Article directory 1. Virtual machine installation CentOS7 download install Connecting to CentOS using xshell 2. Install jdk1.8 Uninstall OpenJDK download Decompress and configure environment variables 3. Install mysql5.7 Uninstall the pre installed database download install Important setup 4. I ...

Posted on Sun, 02 Feb 2020 01:40:26 -0800 by ozace

return and job management of SaltStack

Article directory 1. return of saltstack component 1.1 return process 1.2 use mysql as the return storage method 2. job cache 2.1 job cache process 2.2 job management 1. return of saltstack component The return component can be understood as the SaltStack system stores or returns data return ...

Posted on Sat, 01 Feb 2020 21:36:18 -0800 by davidx714

springboot Learning-Configuration of Spring Security

Security is undoubtedly very important in web application development. Choosing Spring Security to protect web applications is a very good choice.Spring Security is one of the security modules in the Spring project, and it is very convenient to seamlessly integrate with the Spring project.Especially ...

Posted on Sat, 01 Feb 2020 21:27:50 -0800 by saf

Zabbix Monitors Mysql, Apache, Nginx Applications

Zabbix's monitoring of third-party application software has two main difficulties: one is to write a custom monitoring script; the other is to write a template and import it into the zabbix web, which is customized to the monitoring requirements, while writing a template file is relatively difficult, but there are already many templates writte ...

Posted on Sat, 01 Feb 2020 13:12:31 -0800 by Keith Scott

Building MySQL Replication cluster high availability architecture based on MMM

MMM introduction MMM is Multi-Master Replication Manager for MySQL It is a multi master replication manager provided by mysql. Its core is a set of scripts written in perl. In fact, mmm is a relatively early and even a little old way to build a highly available MySQL architecture, but because it has certain application scenarios, this article ...

Posted on Sat, 01 Feb 2020 07:59:11 -0800 by filmixt

Install and configure MySQL 5.8 on Windows 10

Download MySQL 8.0 windows zip package Download address Extract to installation directory Add the installation directory / bin to the PATH environment variable Create a new file my.ini in the installation directory and write the basic configuration [mysqld] # Remove leading # and set to the amount of RAM for the most impor ...

Posted on Fri, 31 Jan 2020 09:38:05 -0800 by trystan

Mysql slow query log

Slow query logs mainly record some logs with slow queries. We can view those queries from these logs for a long time, and then optimize the queries. 1, View slow query log status mysql> show variables like '%slow%'; +---------------------------+-----------------------------------------------------+ | Variable_name ...

Posted on Fri, 31 Jan 2020 04:07:46 -0800 by imderek

2018 swoole actual combat 5-asynchronous mysql

Following the last chapter 2018 swoole 4-asynchronous io reading and writing This presentation Asynchronous mysql of swoole Analog data Create a new book table in the local test database and write the simulation data CREATE TABLE `book` `id` int(11) NOT NULL AUTO_INCREMENT, `content` text,( `titlle` varchar(255) NOT NULL COM ...

Posted on Fri, 31 Jan 2020 00:22:51 -0800 by Rai_de

Spring Road (31) - use NamedParameterJdbcTemplate to complete database operation (JavaConfig configuration)

background In the previous article, we completed the instance of database add, delete, modify and query under the JdbcTemplate, in which the configuration of related bean s is realized through xml and annotation. JdbcTemplate transfers parameters according to the placeholder location. In this article, ...

Posted on Wed, 29 Jan 2020 01:07:13 -0800 by jh21236