NAV: SLTechnology News&Howtos > Database >

• 

  Set up MySQL one-master and multi-slave environment minute by minute (R12 notes day 31)

  I wrote an article about building a MySQL Group Replication test environment minute by minute. If we want to build a master and multi-slave test environment on a server, how can we do it minute by minute? in fact, it can be done by taking a little time to write a script.

  2022-06-01 06:49:50 Views: 295
• 

  Desensitization of Oracle Database-sharing at the Symposium on Database Technology of South China ORACLE user Group 2018.06

  On June 30th, 2018, I participated in the database technology salon organized by South China ORACLE user Group (CN'SOUG), and shared the topic of desensitization of Oracle database. Sharing includes: 1, the current grim situation of data security 2, a brief overview of data security technology

  2022-06-01 06:49:50 Views: 270
• 

  MySQL Monitoring weapon-Innotop

  Innotop is a very powerful MySQL monitoring tool, written in perl, through the text mode to show the operation of the MysQL server and Innodb. Install innotop download address: https://github.com/inno

  2022-06-01 06:49:45 Views: 264
• 

  MySQL Learning Notes (2): MyISAM Storage engine

  The MyISAM storage engine MyISAM is based on the old (no longer available) ISAM storage engine, but has many useful extensions. Each MyISAM table is stored on disk in three files. These files have names that begin with the table name and are used for directive text

  2022-06-01 06:49:45 Views: 208
• 

  How to use profiling to analyze SQL query statement in MySQL

  Check whether profiling is enabled: mysql > select @ @ profiling;+-+ | @ @ profiling | +-+ | 0 | +-

  2022-06-01 06:49:44 Views: 298
• 

  MySQL Router introduction

  MySQL Router introduces MySQL Router as a lightweight middleware that provides transparent routing between applications and back-end databases. Mysql is used to achieve load balancing and high availability functions. At the same time, router also provides high availability for using fabric.

  2022-06-01 06:49:44 Views: 226
• 

  MSSQL 2000 error 823 data recovery case

  Fault description MSSQL Server 2000 attach database error 823, attach database failed. There is no backup of the database, the database can not be restored through backup, there is an urgent need to restore the data in the database. Second, fault analysis SQL Server database 823 error

  2022-06-01 06:49:30 Views: 255
• 

  Using controlfile trace files to reconstruct control files in oracle

  1. 11g RAC reconstruction control file 1.-- "create controlfile" command is generated into the tracking file: alter database backup controlfile to trace;2,-

  2022-06-01 06:49:30 Views: 223
• 

  Declaration and use of 2011-11-16% ROWTYPE

  Http://www.itpub.net/thread-1499223-15-1.html150 Building I connect to the HR user and run the following statement: CREATE TABLE plch_parts (partnum

  2022-06-01 06:49:14 Views: 265
• 

  Relearning Mysql Database 2: "simple" MySQL and InnoDB

  This article is transferred from the Internet. This series of articles will be sorted out in my "Java interview Guide" warehouse on GitHub. For more wonderful content, please go to my warehouse to check out https://github.com/h3pl/Java-Tutorial if you like.

  2022-06-01 06:49:14 Views: 246
• 

  Redo Transport Compression in a Data Guard Environment (document ID 729551.1)

  Redo Transport Compression in a Data Guard Environment (document ID 729551.1) go to the bottom In this DocumentPurposeSc

  2022-06-01 06:49:13 Views: 252
• 

  MySQL log-binary log (Binlog)

  MySQL has several different log files that can help you find out what's going on inside mysqld: the information type error log (- log-err) in the log file records problems when starting, running, or stopping mysqld. Query log (- log)

  2022-06-01 06:49:13 Views: 250
• 

  Direct path read direct path reading

  The traditional way to read the database is to search in memory first. If the data cannot be found, then read the data from disk to memory, and then PGA gets the data in SGA, so that the data is cached in memory, and the next time you access it again, you can get it directly from SGA.

  2022-06-01 06:49:11 Views: 206
• 

  Show_space improved version, adding table partition index partition automatic recognition

  New_show_space.sql.zipREMREM based on previous show_space script, now it can REM identify all pa

  2022-06-01 06:49:09 Views: 210
• 

  Four ways to modify NLS_DATE_FORMAT

  First, specify (LINUX) in the user environment variable and add two sentences to the user's .bash _ profile: export NLS_LANG=AMERICAN-this sentence must be specified, otherwise the next sentence will not take effect. Export NLS_D

  2022-06-01 06:49:09 Views: 298
• 

  Install 11.2.0.1 database software report [FATAL] [INS-32035] Unable to create

  11.2.0.1 Silent installation database software error: [FATAL] [INS-32035] Unable to create a new central inventory directory: / u01/ap

  2022-06-01 06:49:08 Views: 238
• 

  How to repair MySQL replication after incompatible DDL commands

  MySQL supports replication to a later version of slave, which allows us to easily upgrade MySQL settings to a new version by upgrading the slave and pointing to the application. But if it is not supported or if the application performs better on the older version of MySQL, we need to reduce the

  2022-06-01 06:49:08 Views: 206
• 

  ORA-00600: internal error code. Parameters: [qosdDirRead: dircnt mismatch], [809], [808]

  Problem description: a set of RAC instances frequently alarms in the morning ORA-00600: internal error code, parameters: [qosdDirRead: dircnt mismatch], [809], [808]. After MOS query, it was only found in 12.

  2022-06-01 06:49:08 Views: 262
• 

  Mysql 5.5 Source Code after installation, create user error report & quot;ERROR 1045 (28000): Access denied for user"

  After installing MySQL, root users can set a password to log in, other new users can not log in through a password, can only log in without entering a password, and the authorization for new users is invalid. -- create a library and user mysql > create database fir

  2022-06-01 06:49:07 Views: 291
• 

  The problem of return order of Table data in MYSQL INNODB

  Follow on to the previous article: how http://blog.itpub.net/7728585/viewspace-2126344/ proves that the leaf nodes of the INNODB secondary index have the same key values and are sorted by PRIMARY KEY in the previous article.

  2022-06-01 06:49:07 Views: 276