PageHelper paging plug-in

<dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper</artifactId> <version>5.1.8</version> </dependency> <dependency> <groupId>com.github.pagehelper</groupId> <artifactId ...

Posted on Sun, 17 May 2020 11:27:42 -0400 by Bismark12

Visual data analysis of MySQL kettle superset E-commerce

1. Project overview demand Analyze the data of users, commodities and orders in e-commerce business, and observe the operation framework Business database: Mysql: store the most original data ETL: Kettle Data warehouse: Mysql: store data to be analyzed Analysis processing: SQL/Kettle Visualization: Superset   2. Preparations sys ...

Posted on Sun, 17 May 2020 02:56:29 -0400 by kevdotbadger

Search interface optimization scheme -- basic use of elastic search distributed search engine

preface: In general, there is a search function in development projects. If it is a search function for the C end, it often tests the performance. For example, the commodity search in the general mall system or the website search of some resources. Perhaps the previous approach is to do a fuzzy query by name or product description on the prod ...

Posted on Sun, 17 May 2020 02:26:17 -0400 by Dasndan

Docker data management and network communication, port mapping

Bibliography: 1. Data management of docker 1. Data Volume 2. Data Volume Container 2. Network communication of docker 1. Port Mapping 2. Container interconnection 3. Deploy and publish MySQL services in containers IV. Deploy and publish Apache services in containers 1. Data management of docker In docker, to view the data generated in a cont ...

Posted on Sat, 16 May 2020 22:16:59 -0400 by shadowk

User and Rights Management for MySQL

In MySQL 5.7.24, information about users and user permissions is stored in the user table of mysql library, which can be roughly divided into user column, permission column, security column and resource control column. 1. User ColumnsThe user column of the user table includes Host, User, and password, representing the host name, user name, and ...

Posted on Sat, 16 May 2020 15:40:18 -0400 by sspoke

MySQL query duplicate data

Suppose there is a user table, user. The data is as follows: 1. Duplicate uid data in query table SELECT id, uid, name FROM USER WHERE uid IN (SELECT uid FROM USER GROUP BY uid HAVING COUNT(uid) > 1); 2. Duplicate data in the query table, excluding the minimum id SELECT id, uid, name FROM user WHERE uid IN (SELECT ...

Posted on Sat, 16 May 2020 11:25:22 -0400 by dyconsulting

Implementation of lamp architecture and unified log management

1. Deploy the separated LAMP to two servers, and php loads the xcache module 1) Install httpd, PHP, PHP MySQL on c2 server [root@c2 ~]# yum install httpd php php-mysql -y 2) Installing the database mariadb server on the mariadb server [root@mariadb ~]# yum install mariadb-server -y 3) Start service [root@c2 ~]# systemctl start httpd [root@mari ...

Posted on Sat, 16 May 2020 03:29:12 -0400 by BuzzStPoint

MySQL date plus minus

1. addtime() is the date plus the specified number of seconds select addtime(now(),1); -- Plus 1 second 2. adddate() can be used in two ways. The second parameter is to add the specified number of days to the date, and the second parameter is to add the specified interval time to the date select adddate(now(),1); -- Plus 1 day select adddate ...

Posted on Fri, 15 May 2020 10:26:49 -0400 by jwrightnisha

View linux Log in web interface

rsyslog+mariadb+loganalyzer An architecture that can use web pages to view logs Environment preparation: just like the centralized log server architecture mentioned in the previous course, this architecture is built on the server, that is, the host with IP address of 192.168.1.55 Environment preparation and setting of server side Packages requ ...

Posted on Thu, 14 May 2020 10:39:32 -0400 by lunny

The difference between [MySQL] char and varchar

CHAR and VARCHAR types are similar, but they are saved and retrieved in different ways. Their maximum length and whether trailing spaces are preserved are also different. There is no case conversion during storage or retrieval. Char 0-255 byte fixed length string VARCHAR 0-65535 byte variable length string Create test table mysql> c ...

Posted on Tue, 12 May 2020 11:29:46 -0400 by cyberdwarf