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
1. Virtual machine installation CentOS7
Connecting to CentOS using xshell
2. Install jdk1.8
Decompress and configure environment variables
3. Install mysql5.7
Uninstall the pre installed database
4. I ...
Posted on Sun, 02 Feb 2020 01:40:26 -0800 by ozace
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
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'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
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
Download MySQL 8.0 windows zip package
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
# 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
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
Following the last chapter 2018 swoole 4-asynchronous io reading and writing
This presentation Asynchronous mysql of swoole
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,
`titlle` varchar(255) NOT NULL COM ...
Posted on Fri, 31 Jan 2020 00:22:51 -0800 by Rai_de
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