NAV: SLTechnology News&Howtos > Database >

• 

  Small knowledge points about tablespace offline

  1. Reason Taking Tablespaces OfflineTaking a tablespace offline makes it unavailable for normal of tablespace offline

  2022-06-01 21:43:12 Views: 224
• 

  MySQL Group Replication (MGR) installation

  MySQL Group Replication installation 192.168.10.65192.168.10.66192.168.10.67OS: CentOS 7.4mysql soft: 8.0.12 one

  2022-06-01 21:43:12 Views: 299
• 

  The problems encountered when exporting mysql data are as follows:

  Mysql has permission restrictions on exported directories by default, that is, when using the command line for export, you need to specify a directory to operate; mysql > select * from T1 into outfile'/ tmp/t1_mysql.

  2022-06-01 21:43:12 Views: 263
• 

  Practice of mongodb replication set + sharding production environment

  The operating system environment of the three machines is as follows: [mongodb@node1 ~] $cat / etc/issueRed Hat Enterprise Linux Server release 6.6 (Santiago)

  2022-06-01 21:43:06 Views: 225
• 

  MariaDB 10.3 supports automatic KILL to drop uncommitted empty transactions

  Here is a parameter innodb_kill_idle_transaction (this is the parameter referenced by Percona XtraDB), which means that when a transaction has not been committed for a long time, the connection cannot be closed, memory will not be freed, and the transaction will be issued concurrently.

  2022-06-01 21:43:02 Views: 241
• 

  Mysqldump & binlog do a full backup

  Note: mysqldump backup database experiment (this article has two methods to achieve backup, this experiment uses method 1) step: 1. Complete backup of database with mysqldump method 1 all-databases # mysqldump-- lock

  2022-06-01 21:43:02 Views: 218
• 

  What should be done for Redis cluster deployment

  What should I do with Redis cluster deployment? In order to give you more attributes, the editor starts with the concepts related to redis clusters. Let's take a look down. 1. Redis Cluster related Concepts Redis has supported cluter since version 3.0, using hash slot side

  2022-06-01 21:43:01 Views: 293
• 

  How to make redis persistence better

  What should I do to persist redis? Maybe you are no stranger to redis, or you have never known redis. But don't worry, today the editor will explain the principle of redis persistence with the simplest description. Redis is an advanced key-value data

  2022-06-01 21:42:58 Views: 275
• 

  After processing the deletion of binary logs, show binary logs shows that the File_size is 0

  The server takes up too much hard disk space and finds that there are too many binary log files, so delete mysql's binary log files: [root@iZbp1b36sef813d0zilqd6Z mysql] # rm-rf dbbin.00010*

  2022-06-01 21:42:58 Views: 224
• 

  The Foundation of mysql Database

  UNION distinguishes from UNION ALL and uses the UNION operator to merge the result sets of two or more select statements. Note that select statements within UNION must have the same number of columns. Columns must also have a similar data type, select

  2022-06-01 21:42:58 Views: 273
• 

  Import a file in .csv format into an oracle database

  The first way to import a file in .csv format into an oracle database is 1, the selection tool-text importer 2, and selecting the data selection owner and table to oracle. 3. Choose to open the file and select the text to be imported. 4. Configure the correspondence of the table in field, f

  2022-06-01 21:42:49 Views: 292
• 

  The SQL Foundation of MySQL

  SQL is the abbreviation of Structure Query Language (structured query language). It is the application language of relational database, which was sent by IBM in the 1970s to realize the information retrieval in relational database. In the early 1980s, beauty

  2022-06-01 21:42:48 Views: 298
• 

  SMTP (2)

  SMTP (2) telnet remote link: (anyone can link, there are security risks) telnet: who is prohibited from linking to my host remotely to send mail (no user of my host can be linked) vim / etc/postfix/access172.25

  2022-06-01 21:42:43 Views: 273
• 

  Note the use of mysql in linux, and windows

  MariaDB [mysql] > show databases;// pay attention to the semicolon before execution. DESC [db_name] tb_name looks at the structure of the table use db_name enters the database show tab

  2022-06-01 21:42:43 Views: 243
• 

  How to set the Redis time to Live

  How should Redis lifetime be set? This article mainly introduces in detail how to set the survival time of Redis. The sample code in this article is very detailed and has a certain reference value. Interested friends can refer to it. Redis pair keys provide lifetime, in the

  2022-06-01 21:42:42 Views: 230
• 

  MongoDB Learning Records (1)

  1. Introduction to MongoDB 2, MongoDB Features 3, MongoDB function 4, MongoDB deployment 4.1 MongoDB standalone deployment 4.2 MongoDB Master-Slave deployment 4.3 MongoDB fragmentation deployment Appendix 1: MongoDB

  2022-06-01 21:42:41 Views: 233
• 

  What is the principle of Redis partition implementation? Why zoning?

  What is the principle of Redis partition implementation? Why zoning? Many people don't know much about it. Today, in order to give you a better understanding of the principle of Redis partition implementation, I have summarized the following contents. Let's take a look at Redis Partitioning, or Redis.

  2022-06-01 21:42:29 Views: 212
• 

  On the method of automatically generating a large amount of data by mysql

  What the editor shares today is the method of automatically generating a large amount of data from mysql. Maybe you are no stranger to mysql, or you have never known mysql. But don't worry, today the editor will use the simplest description to explain how mysql automatically generates a large amount of data. Mysq

  2022-06-01 21:42:29 Views: 243
• 

  MongoDB index management-create index, view index, delete index, rebuild

  First insert two records into the users collection, and then use the users collection to demonstrate index management: > user1= {"name": "liming", "age": 20, "gender": "F"} {"name": "limi"

  2022-06-01 21:42:26 Views: 208
• 

  Install the command line under oracle 11gR2 linux

  Write to yourself: linux operation and maintenance road, do it yourself reference: http://www.cnblogs.com/yingsong/p/6031235.html---------------------------- preparation

  2022-06-01 21:42:26 Views: 212