NAV: SLTechnology News&Howtos > Database >

• 

  Mysql Foundation (3) Storage engine and Lock

  Concept of storage engine: relational database tables are data structures used to store and organize information. Tables can be understood as tables composed of rows and columns. Various, different table structures mean that different types of data are stored, and there are differences in data processing. For mysql, it provides

  2022-06-01 20:01:22 Views: 247
• 

  Collection of oracle basic commands

  Oracle snooping configuration A, snooping (D:\ app\ Administrator\ product\ 11.2.0\ dbhome_1\ NETWORK\ ADMIN\ listener.ora.ora) 1, dynamic registration

  2022-06-01 20:01:16 Views: 260
• 

  Centos7 mysql database installation and configuration

  First, system environment [root@localhost] # cat / etc/redhat-releaseCentOS Linux release 7.6.1810 (Core) II. Mysql installation # yum I

  2022-06-01 20:01:12 Views: 277
• 

  A collection of common commands in oracle rac

  1. Modify the number of sessions to query the number of connections in the current process of the database: select count (*) from vconnections process; modify the maximum number of connections allowed in the database: alter system set processes = 1500 s

  2022-06-01 20:00:42 Views: 218
• 

  Summary of MySQL optimization

  Preface optimization has risks, you need to be careful to get involved! 1. What are the possible problems caused by optimization? Optimization is not always done for a simple environment, but is likely to be a complex system that has been put into production. Optimization methods are inherently risky, but we may not be able to realize and foresee them! Any technology can

  2022-06-01 20:00:42 Views: 224
• 

  Greenplum-data migration (exponentially increased computing power)

  Preface GPDB data migration can be achieved by full recovery. If there are 3 machines with 2 Primary and 2 Mirror on each machine, then you can extend 3 machines to one Primary,1 Mirror on each machine.

  2022-06-01 20:00:42 Views: 271
• 

  Use binlog to reply to mistakenly delete tables and libraries

  There are two common ways to view the contents of a binlog log by using binlog reply mistakenly deleted table and library: 1, # / usr/local/mysql/bin/mysqlbinlog / usr/local/mysql/data/my

  2022-06-01 20:00:42 Views: 219
• 

  How is the Windows10 system mysql 8.0.12 decompressed version installed and configured

  This article mainly gives you a brief introduction to the installation and configuration of the Windows10 system mysql 8.0.12 decompressed version. 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 Window

  2022-06-01 20:00:12 Views: 276
• 

  How ProxySQL helps MySQL implement read-write separation

  This article mainly introduces how ProxySQL helps MySQL implement the separation of reading and writing. 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 with the author how ProxySQL helps MySQ.

  2022-06-01 20:00:08 Views: 296
• 

  How to delete duplicate data method by mysql

  The following mainly brings you mysql how to delete duplicate data method, I hope these words can bring you practical use, this is also the main purpose of this article I edit mysql how to delete duplicate data method. All right, don't talk too much nonsense, let's just read the following. Delete fr

  2022-06-01 20:00:08 Views: 248
• 

  Centos5.7 mongodb installation and testing

  1. First go to http://www.mongodb.org to download the desired mongodb version 2. After downloading, extract the file tar-zxvf file name .tgz3, and start the service. / mongodb25/bin/mongod-

  2022-06-01 20:00:07 Views: 289
• 

  How to set mysql.db database layer permissions

  This article mainly tells you how to set the permissions of the mysql.db database layer. 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 and hope that how to set the permissions of the mysql.db database layer.

  2022-06-01 20:00:07 Views: 234
• 

  Bayaim_linuxRedHat5_install_oracle11gR2

  Bayaim_ sorted out his thoughts:-

  2022-06-01 20:00:06 Views: 301
• 

  The method of getting date by MySQL

  The following mainly brings you the method of getting the date by MySQL. I hope that the method of getting the date by MySQL 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 read the following. Select curdate ();-

  2022-06-01 20:00:03 Views: 258
• 

  What is the operation principle and infrastructure of MySQL

  This article mainly introduces what is the operation principle and infrastructure of MySQL. The content of the article is carefully selected and edited by the author. It has a certain pertinence and is of great significance to everyone. Let's work with the author to understand what the operation principle and infrastructure of MySQL is. 1.

  2022-06-01 19:59:59 Views: 228
• 

  How to view metadata lock blocking statements through MySQL

  The following mainly brings you how to view metadata lock blocking statements through MySQL. I hope that how to view metadata lock blocking statements through MySQL can bring you practical use. This is also the main purpose of my editing this article. All right, don't talk too much nonsense, let's just read the following. Operation step

  2022-06-01 19:59:56 Views: 265
• 

  How to create a Centos Docker image through Dockerfile

  This article mainly tells you how to create a Centos Docker image through Dockerfile. You can check the relevant technical 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 use Docker.

  2022-06-01 19:59:56 Views: 224
• 

  How to solve the problem of master-slave delay in MySQL

  This article mainly introduces how to solve the problem of master-slave delay in MySQL. The content of the article is carefully selected and edited by the author. It has a certain pertinence and is of great significance to everyone's reference. Let's work with the author to understand how to solve the problem of master-slave delay in MySQL. Face to face throw

  2022-06-01 19:59:52 Views: 246
• 

  How to install and query email for dovecot

  This article mainly tells you how to install dovecot and query email. 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 how to install dovecot and query email can be given to you.

  2022-06-01 19:59:31 Views: 297
• 

  What is the principle of MySQL-5.5 master-slave replication and how to configure it

  The following mainly brings you what the principle of MySQL-5.5 master-slave replication is and how to configure it. I hope that what the principle of MySQL-5.5 master-slave replication is and how to configure it can bring you practical use, which is also the main purpose of my editing this article. All right, no more nonsense, let's just take a look at it.

  2022-06-01 19:59:27 Views: 226