NAV: SLTechnology News&Howtos > Database >

• 

  Parsing of SQL-Server2008 Operation Command

  Create-- create datebase-- Database table-- Table create datebase xxxxxxx-- create xxxxxx database create table xxxx (. )--

  2022-06-01 19:34:43 Views: 278
• 

  Linux configure mysql remote access

  Today, using lnmp to install the package, install the php integrated environment, and then configure mysql remote encountered a problem, remote account% and other configuration of all the configuration, but can not be connected, and finally found the problem. It turns out that the server turned on iptables.

  2022-06-01 19:34:43 Views: 205
• 

  MySQL database optimization

  Chapter 1 hardware optimization 1.1 Database physical machine procurement (*) CPU (operation): 64-bit CPU, a machine 2-16 CPU, at least 2-4, the bigger the L2, the better. Memory: 96G-256G (Baidu), 3-4 instances. 32-64g

  2022-06-01 19:34:43 Views: 242
• 

  Hot standby for part of MySQL database with mydumper

  At present, there are two DB servers, which are used for A service and B service respectively. Among them, A service is more important, and a DB (TaeOss) of A service is needed for hot backup. There is about 40 GB of data, and the DB server of business B is used as the standby machine. The server distribution is as follows: 10.137.143

  2022-06-01 19:34:39 Views: 239
• 

  Introduction and installation of MySQL

  1. Introduction of the database (1) related concepts of the database:    data: symbols that describe things, often expressed with text, pictures, audio and video.    database: a warehouse in which data is stored in a certain format.    database management system: how to organize and store data scientifically and how to

  2022-06-01 19:34:16 Views: 233
• 

  Django from entry to abandonment. Preliminary study

  Environment: in order to enable the server to develop multiple applications, the environment version does not affect each other, using virtualenv to create an independent and isolated environment for development and use. # install virtualenv: [root @ vps django] # pip3 inst

  2022-06-01 19:33:55 Views: 213
• 

  Introduction of MySQL query Optimization tool explain

  The following mainly brings you the MySQL query optimization tool explain. I hope these contents can bring you practical use, which is also the main purpose of my editing this article. All right, don't talk too much nonsense, let's just look at the following MySQL query optimization tool explain. On a daily basis

  2022-06-01 19:33:44 Views: 270
• 

  Mysql data batch deletion and table defragmentation method

  This article mainly introduces the method of mysql data batch deletion and table fragmentation. 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. Let's learn about mysql data batch deletion and sorting table fragments together with the author.

  2022-06-01 19:33:42 Views: 208
• 

  Configuration and adding method of mysql slow query Log

  Let's learn about the configuration and adding method of mysql slow query log. I believe you will benefit a lot after reading it. The text is not much in essence. I hope this short article of mysql slow query log configuration is what you want. Vim / etc/my.cnfslow-qu

  2022-06-01 19:33:39 Views: 289
• 

  Simply understand the basic knowledge of MySQL database

  Let's talk about the basics of MySQL database. The secret of the text is that it is close to the topic. So, no gossip, let's go straight to the following, I believe you will benefit from reading this article on the basics of MySQL database. Sql statement practice-table join (multi-table query)

  2022-06-01 19:33:30 Views: 258
• 

  Solution to failure of client connection to mysql

  This article mainly gives you a brief introduction to the solution to the failure of client connection mysql. You can check 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 solution to the failure of client connection mysql can give you

  2022-06-01 19:33:30 Views: 200
• 

  How to install and configure mysql-5.7.21

  The following mainly brings you the methods of installing and configuring mysql-5.7.21. I hope these contents can bring you practical use, which is also the main purpose of this article. All right, don't talk too much nonsense, let's just read the following.

  2022-06-01 19:33:15 Views: 222
• 

  SQL Server 2016 Snapshot Agent process

  This article mainly introduces the method of SQL Server 2016 snapshot agent process in detail, the detailed explanation of picture and text is easy to learn, and the effect of reading and understanding with the code is better, which is very suitable for beginners. Interested friends can refer to it. An overview of the schema in which the snapshot agent prepares published tables

  2022-06-01 19:32:48 Views: 305
• 

  The difference between DELETE and DROP

  What is the difference between DELETE and DROP in SQL? This article uses the example code to show, the code is very detailed, which can be used for reference by interested friends. I hope it will be helpful to you. A brief introduction to the DELETE command DELETE is a data manipulation language (DDL

  2022-06-01 19:32:45 Views: 267
• 

  A simple method of extracting SQL based on time points using mysqlbinlog

  This article mainly introduces a simple method of using mysqlbinlog to extract SQL according to the point in time. The content of the article is carefully selected and edited by the author. It has certain pertinence and is of great significance to everyone's reference. Let's learn about the use of mysqlbinlo with the author.

  2022-06-01 19:32:41 Views: 282
• 

  Dovecot+mysql configuration and the method of building mail cloud server

  Let's learn about dovecot+mysql configuration and how to build an email cloud server. I'm sure you will benefit a lot after reading it. I hope you want this short article about dovecot+mysql configuration and how to build an email cloud server. Dove

  2022-06-01 19:32:24 Views: 290
• 

  Centos7 configuration yum Source installation mysql simple tutorial

  The following is about centos7 configuration yum source installation mysql simple tutorial, the secret of the text is close to the topic. So, let's not talk about gossip. let's just read the following. I'm sure you will after reading the simple tutorial of centos7 configuration yum source installation mysql.

  2022-06-01 19:32:21 Views: 297
• 

  The detailed method of using xtrabackup tool to realize MySQL Database backup

  This article mainly gives you a brief introduction to the detailed methods of using xtrabackup tools to achieve MySQL database backup. You can check 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 and hope to make use of xtrabacku.

  2022-06-01 19:32:16 Views: 218
• 

  Ubuntu mysql5.6 occupies too much CPU so that the machine is stuck. How to deal with it?

  The following mainly brings you how to deal with the fact that the ubuntu mysql5.6 occupies too much CPU so that the machine is stuck. I hope this content can bring you practical usefulness. This is also how I edit the ubuntu mysql5.6 that occupies too much CPU so that the machine is stuck.

  2022-06-01 19:31:58 Views: 238
• 

  What are the specific differences between sqlserver and mysql

  Next, let's learn about the specific differences between sqlserver and mysql. I believe you will benefit a lot after reading it. There are not many words in the text. What are the specific differences between sqlserver and mysql? what do you want to be MySQL? My

  2022-06-01 19:31:55 Views: 226