Programmer Group

1. mysql 5.7 full text index the following parameters (configuration file / etc/my.cnf)#Controls the minimum length of segmentation in innodb full-text retrieval. If it is set to 2, a Chinese character and a letter will not be found.ngram_token_size=1#The minimum word length stored in the FULLTEXT index of InnoDB. After NGram token size is use ...

shallow A kind of ove Installing MariaDB cd /usr/lcoal/src wget https://downloads.mariadb.com/MariaDB/mariadb-10.2.6/bintar-linux-glibc_214-x86_64/mariadb-10.2.6-linux-glibc_214-x86_64.tar.gz tar zxvf mariadb-10.2.6-linux-glibc_214-x86_64.tar.gz mv mariadb-10.2.6-linux-glibc_214-x86_64 /usr/local/mariadb cd /usr/local/mariadb ./scripts/mys ...

I haven't used the native database connection method for a long time, and I almost forget it. I'll take notes for this article. Later, we use some advanced frameworks to operate the database, such as dbutil + c3p0, hibernate, JDBC template, etc. the advanced framework is also built on the basis of the bottom layer. So ...

1. Download the image of mysql5.6 from the docker hub docker pull mysql:5.6 2. Use mysql 5.6 image to run 4 mysql services, and distinguish by port number Preparatory work # Four directories are created on the local machine to store the data, logs and configuration files of four mysql services. mkdir /data/mysql cd /data/mysql mkdir mysq ...

I. environmental preparation Main: 192.168.132.121 From: 192.168.132.122 There is data on the main database, and it is still being written. mysql> select * from darren.test; +------+ | id | +------+ | 1 | | 2 | | 3 | | 4 | | 5 | | 6 | +------+ mysql> grant replication slave on *.* to 'replication'@'192 ...

How to restore MySQL database password Stop Mysql server Skip authorization table to start MySQL service program Reset root password (update user table record) Restart MySQL service program in normal way Password recovery instance Example 1: reset MySQL management password Stop the running MySQL service program first [root@host50 ~]# system ...

Original: Guan Changlong   We have introduced six common segmentation algorithms of DBLE and MyCat through the previous six articles, so let's make a summary! DBLE and MyCat corresponding algorithm name and similarities and differences The seventh DBLE fragmentation algorithm jumpStringHash In addition to the above six common sharding ...

This article introduces how to install dependency on Kepler cloud platform. What is Kplcloud? kplcloud is a lightweight PaaS platform based on Kubernetes. It manages the application through a visual interface, reduces the degree of application containerization, and reduces the time cost of application containerization. Kplcloud has been serving ...

Original link: http://www.cnblogs.com/sql4me/p/3254134.html Using Log4Net's output log to MySQL The operation steps are as follows: 1. Add reference Log4Net.dll, mysql.data.dll to the project note: the version of mysql.data.dll should b ...

On the JDBC operation of Mysql database The general way of JAVA operating database 1. Loading drive The purpose of loading driver is to make Java have the ability to link the specified database. Java load driver only needs one line of code //1. Loading drive Class.forName("com.mysql.jdbc.Driver"); ...