NAV: SLTechnology News&Howtos > Database >

• 

  The difference between delete,truncate and drop

  1. Truncate and delete delete only the data, not the structure (definition) of the table, while the drop statement removes constraints (constrain), triggers (trigger), indexes (index) that depend on the structure of the table; stored procedures that depend on the table

  2022-06-01 19:14:52 Views: 233
• 

  Backup and recovery of MySQL Database based on innobackupex

  Xtrabackup, an open source software developed by percona, is an open source alternative to innodb hot backup tool ibbackup (commercial software for a fee). Xtrabackup consists of two parts: xtrabackup and innob

  2022-06-01 19:14:42 Views: 272
• 

  EntityFramework Core solution concurrent detailed explanation

  The topic (EntityFramework Core concurrency) is no stranger to the topic of concurrency. When there is a large amount of data, we need to consider concurrency, and there are a lot of concurrency involved. In EF Core, we divide concurrency into several.

  2022-06-01 19:14:42 Views: 244
• 

  Mysql Master-Slave replication read-write Separation and High availability configuration

  1. Explain the installation configuration of mysql (and provide one-click installation script), the use of mysql statements and backup to restore mysql data. This time, we will introduce the master-slave replication, read-write separation of mysql; and the highly available MHA; environment is as follows: master:Ce

  2022-06-01 19:14:39 Views: 230
• 

  Mongodb installation and account Management (1)

  1. MongoDB installation 1. Wget http://fastdl.mongodb.org/linux/mongodb-linux-x86_64-2.4.1.tgzwget http://downloa

  2022-06-01 19:14:38 Views: 294
• 

  MySQL+ third-party software backup

  1. Use binlog log binlog log: a kind of binary log MsSQL database service log file. 1. Configure the MsQAL server to ensure that you can log in with password 2, adjust / etc/my.cnf configuration, and restart the service [root@mys

  2022-06-01 19:14:38 Views: 295
• 

  Introduction to MySQL installation, configuration and Management of Linux platform _ MySQL Database Foundation and Project practice 03

  Introduction to Linux platform MySQL installation, configuration and Management _ MySQL Database Foundation and Project practice 03 Video tutorial Learning address http://edu.51cto.com/course/12294.htmlOracle/MySQL Database

  2022-06-01 19:14:35 Views: 254
• 

  Oracle local write wait wait event

  Note 1:TypicallyDBWR has to free up some buffers when you want to read something from the disk.Durin

  2022-06-01 19:14:35 Views: 243
• 

  Find the blocked command through slow query

  How do I find blocked commands through slow queries? To solve this problem, today the editor summarizes this article about redis blocking, hoping to help more students who want to learn redis to find a more simple and easy way. Like Mysql, Redis has slow query records. When the execution of the order

  2022-06-01 19:14:34 Views: 273
• 

  Methods of unauthorized access to redis

  This article mainly introduces the method of unauthorized access to redis for you in detail. It is easy to learn the detailed explanation of picture and text, and the effect of reading and understanding with the code is better. It is very suitable for beginners. Interested friends can refer to it. Redis is a kind of non-relation with key-value as key-value pair.

  2022-06-01 19:14:04 Views: 284
• 

  How to install MySQL5.5.60 using rpm installation package under SuSE11

  The following is mainly about how to install MySQL5.5.60 using rpm installation package under SuSE11. I hope these contents can bring you practical use. This is also the main part of my article on how to use rpm installation package to install MySQL5.5.60 under SuSE11.

  2022-06-01 19:14:04 Views: 208
• 

  A simple way for MySQL to use temporary tables

  This article mainly gives you a brief introduction to the simple method of using temporary tables in MySQL. You can look up the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. I hope this article on the simple method of using temporary tables in MySQL can bring you some.

  2022-06-01 19:14:04 Views: 228
• 

  How to use redis to make raffle function?

  Redis Collection introduction "> this article shares with you a detailed introduction to the raffle function of redis production. I believe most people have not yet learned this skill. In order to make you understand better, I have summed up the following contents for you. Without saying much, let's move on. Redis Collection introduction Red

  2022-06-01 19:14:04 Views: 236
• 

  Several steps of installing mysql by centso7.2 source code

  Here are a few steps to install mysql with centso7.2 source code. The secret of the text lies in being close to the topic. So, let's not talk about gossip. let's just read the following. I'm sure you can read this article on several steps of installing mysql in centso7.2 source code.

  2022-06-01 19:14:03 Views: 252
• 

  Using masterha_master_switch tool to realize automatic switching of MySQL High availability MHA

  This article mainly introduces the use of masterha_master_switch tools to achieve automatic switching of MySQL high-availability MHA. The content of the article is carefully selected and edited by the author, which is of certain pertinence and is of great significance to everyone's reference.

  2022-06-01 19:14:03 Views: 268
• 

  Install the percona-xtrabackup-2.0.8 tool to upgrade MySQL5.1.73 to 5.6.36

  This article is mainly about installing percona-xtrabackup-2.0.8 tools to upgrade MySQL5.1.73 to 5.6.36. You can check the relevant professional terms on the Internet or find some related books to supplement them, so we will not dabble here.

  2022-06-01 19:14:03 Views: 249
• 

  Detailed steps for setting up MySQL disk IO

  Next, let's learn about the detailed steps of setting up MySQL disk IO. I believe you will benefit a lot after reading it. The text is not much in essence. I hope you want to set up detailed steps of MySQL disk IO. 1. Raid card setting turns off reading cache: on raid card

  2022-06-01 19:14:03 Views: 253
• 

  Some frequently used mysql database syntax

  This article mainly introduces some frequently used mysql database syntax, the content of the article is carefully selected and edited by the author, with a certain pertinence, for everyone's reference significance is still relatively great, the following with the author to understand some frequently used mysql database syntax bar. 1) sign in

  2022-06-01 19:14:02 Views: 210
• 

  How to manage mysql logs

  The following is mainly about how to manage mysql logs. I hope these contents can bring you practical use, which is also the main purpose of this article on how to manage mysql logs. All right, don't talk too much nonsense, let's just read the following. Mysql log error log

  2022-06-01 19:14:02 Views: 201
• 

  How to back up and restore mysql data

  Let's learn how to back up and restore mysql data. I believe you will benefit a lot after reading it. There are not many words in it. I hope you want this short article on how to back up and restore mysql data. Different categories of backup: hot backup, warm backup and cold backup hot backup: read

  2022-06-01 19:13:50 Views: 299