NAV: SLTechnology News&Howtos > Database >

• 

  Sql statements that MySQL developers must master

  The following together to understand the MySQL development should be mastered the sql statement, I believe everyone will benefit a lot after reading, the text in the essence is not much, hope that MySQL development should master the sql statement this short content is what you want. Create a database create databa

  2022-06-01 18:38:07 Views: 241
• 

  How to circularly insert data into a table in Mysql

  This article mainly introduces how to insert data cyclically in the table in Mysql, the contents of the article are carefully selected and edited by the author, with a certain pertinence, and is of great significance to everyone's reference, let's work with the author to understand how to insert data cyclically in the table in Mysql. Look.

  2022-06-01 18:38:07 Views: 241
• 

  How to realize the mutual migration between databases by MySQL5.6

  Let's talk about how MySQL5.6 implements the migration between databases. The secret of the text lies in being close to the topic. So, let's skip the gossip. Let's go straight to the following. I'm sure you'll benefit from reading this article on how MySQL5.6 implements the migration between databases.

  2022-06-01 18:38:06 Views: 243
• 

  How to avoid Master-Slave replication delay in mysql

  Let me tell you a little bit about how mysql tries to avoid master-slave replication delay. Have you ever heard of similar topics before? If you are interested, let's take a look at this article. I believe it will be helpful for everyone to read how to avoid master-slave replication delay as much as possible after reading mysql. If it is delayed

  2022-06-01 18:38:05 Views: 221
• 

  The method of merging the query results of multiple select statements in MySQL

  The following brings you about the method of merging the query results of multiple select statements in MySQL. I believe you must have seen similar articles. What's the difference between what we bring to everyone? Let's take a look at the text. I believe that after reading MySQL, there will be many select languages.

  2022-06-01 18:38:05 Views: 230
• 

  Deployment and testing of MySQL High availability Architecture MHA

  I don't know if you know anything about the deployment and testing of MHA, a MySQL high-availability architecture. Today, I'm here to tell you a little bit about it. If you are interested, let's take a look at the body. I believe you will have some results after watching the deployment and testing of MHA, the MySQL high availability architecture.

  2022-06-01 18:38:05 Views: 209
• 

  How to separate read and write from mysql based on amoeba

  The following brings you about how mysql achieves read-write separation based on amoeba. If you are interested, let's take a look at this article. I believe it will be of some help to you after reading how mysql achieves read-write separation based on amoeba. Environment: host A (huangzp2

  2022-06-01 18:37:34 Views: 300
• 

  How to realize backup and recovery of MySQL Database

  This article is mainly about how to achieve backup and recovery methods in MySQL database. If you are interested, let's take a look at this article. I believe it is of some reference value to you after reading how to achieve backup and recovery methods in MySQL database. Preparation of MySQL Database

  2022-06-01 18:37:34 Views: 287
• 

  What are the common commands for mysqldump in MySQL?

  MySQL mysqldump concise common command guide to export data 1, backup all database data and table structure mysqldump-uroot-ppassword-A > all.sql2, backup table structure only, do not back up data my

  2022-06-01 18:37:33 Views: 255
• 

  Summary of Oracle Archive logs

  Open archive log sqlplus / as sysdbasql > shutdown immediate; sql > startup mount; # Open control file, do not open data file sql >

  2022-06-01 18:37:33 Views: 298
• 

  Common commands and main points of Mysql Index, transaction and View

  Index: a quick positioning technique that is equivalent to the catalog page of a book. Function: quickly query data conditions: data entries are greater than 2000 create index id_index on info (id); / / create general index show inde

  2022-06-01 18:37:33 Views: 292
• 

  Binary is used in select to be case-sensitive

  CREATE TABLE animals (id MEDIUMINT NOT NULL AUTO_INCREMENT,name CHAR 30) NOT NULL,PRIMARY KEY (id))

  2022-06-01 18:37:33 Views: 236
• 

  Orzdba monitoring tool [add remote monitoring]

  The orzdba tool must be used locally by default, which is not very convenient, and remote calls have been added. Usage:. / orzdba_remote-- host=192.168.148.1-- user=admin-- password=

  2022-06-01 18:37:32 Views: 296
• 

  MySQL Learning Notes: a preliminary introduction to MySQL

  1. Install MySQL# yum-y install mysql mysql-server mysql-devel to modify the character set under Linux: / etc/my.conf configuration file vi / etc/my.conf

  2022-06-01 18:37:32 Views: 257
• 

  Mysql Migration error

  Copy and migrate the mysql directory directly. The process is not detailed. The database starts normally, but cannot be used normally. The select lookup table report does not exist, and then the log error is found as follows: InnoDB: Doing recovery: scanned up to

  2022-06-01 18:37:23 Views: 254
• 

  Introduction to the data types and application scenarios of Redis

  Basic operation of 1.string type 1-1 string type data add / modify data: set key value get data: get key delete data: del key add / modify multiple data: mset key val

  2022-06-01 18:37:23 Views: 300
• 

  Log cannot be shrunk

  Dbcc loginfo (NumberSHDAT9154WXADB') checks the log status, Status=2, indicating that the log is active SELECT [name], [database_id], [log_reuse_w]

  2022-06-01 18:37:22 Views: 221
• 

  MongoDB modifies multiple pieces of data information in the collection

  1. View the collection show collections2. View the data in the collection db.runoob.find (). Pretty () 3. Modify multiple pieces of data db.runoob.update ({'title':'demo'}) in the collection

  2022-06-01 18:37:19 Views: 245
• 

  [MySQL] Xtrabackup backup tool is used

  Introduction: Xtrabackup is a mysql database backup tool provided by percona, which supports online hot backup (backup does not affect data read and write). Xtrabackup has two main tools: xtrabackup and innobackupex

  2022-06-01 18:37:18 Views: 288
• 

  OGG Operation and maintenance Optimization script (4)-Information Modification Class-long transaction Skip

  File name: skiptrans.sh skip.sh path: $HOME/ggscript/ggtrandata function: this script is used to restart the extraction process to skip long transactions, automatically identify long transactions for more than 1 hour and skip them in batches, skip

  2022-06-01 18:37:18 Views: 251