NAV: SLTechnology News&Howtos > Database >

• 

  Architecture-002-how data changes are written to a file

  Step 1: start the transaction; step 2: find the required data block in buffer cache, and if not, load it into buffer cache from the data file; step 3: the transaction modifies the data block of buffer cache, which is marked as "dirty data"

  2022-06-01 07:17:03 Views: 238
• 

  Several graphical interface tools of MySQL

  A summary of several mysql graphical interface tools, the following is the mysql tool I have used. The official MySQL Workbench, the open source version is completely free MySQL Workbench is an ER/ database modeling tool designed specifically for MySQL

  2022-06-01 07:17:03 Views: 210
• 

  Oracle ORA-22992 problem

  Create / * source only*/ table mingshuo.tmp_ms_19031403 as select * from backupwt.tmp_ms_19031403@dblk

  2022-06-01 07:17:03 Views: 211
• 

  Common sql query statements in postgresql dba

  Reproduced from: http://blog.itpub.net/30126024/viewspace-2655205/ View help Command DB=# help-Total help DB=#\ h-SQL commands level

  2022-06-01 07:17:03 Views: 294
• 

  Research on the consistency of mysqldump-single-transaction

  -- single-transaction means that before starting dump, set the isolation level to RR, and start transaction. By encapsulating the export operation in a transaction (Repeatable Re

  2022-06-01 07:17:03 Views: 238
• 

  [Enmo College] how to understand and correctly use MySql index

  How to understand and correctly use MySql index is a data structure used by storage engine to find records quickly. Through reasonable use of database index, the access performance of the system can be greatly improved. This paper mainly introduces the type of index in MySql database and how to create a more reasonable and efficient.

  2022-06-01 07:16:59 Views: 288
• 

  How is the development of domestic database?

  First, the difficulty of database development. Database research and development is a difficult task comparable to the operating system. The reference is very interested in databases and distribution. what is the learning route? This article talks about a lot of learning processes, and its complexity can be seen academically. However, this is only the beginning of the long march.

  2022-06-01 07:16:59 Views: 272
• 

  ORA-00054 error

  During the daily inspection of oracle, the following alarms are found in the alarm log: first, the reason is that the database lock table is caused by the frequent operation on the table. Because the session is already operating on the target table and has an exclusive lock, it is impossible to operate on the target table now. II.

  2022-06-01 07:16:57 Views: 246
• 

  RAC12C modifies the PDB character set

  12C modify pdb character set (RAC): background: the installed oracle12.2rac character set is AL32UTF8, and there are already other pdb in the environment. The newly built pdb for data import is found to have character set problems that lead to import error (the original library character set is zhs1.

  2022-06-01 07:16:56 Views: 209
• 

  5.6 MySql Master-Slave automatic switching script

  July 17 #! / bin/bash cat < < README # #

  2022-06-01 07:16:53 Views: 219
• 

  From Oracle to MongoDB: why does AWS keep abandoning partners?

  Amazon is getting a lot of attention for breaking up with its business partners, and Amazon is now trying to replace MongoDB with its own "compatible" version of DocumentDB after deciding to abandon its Oracle database and use its own services. Interestingly, AWS announced

  2022-06-01 07:16:53 Views: 218
• 

  [SGA] Best practices and recommendations for more than 100g RAC DB SGA

  Best practices and recommended release notes for RAC DB SGA over 100g: the relevant information in this document applies to any platform Oracle Database Enterprise Edition 11.2.0.3 and above: this article is written for the purpose of providing each instance of RAC (note that rac is available throughout

  2022-06-01 07:16:50 Views: 248
• 

  Analysis of login process of MYSQL connection

  Analysis of MYSQL connection login process in newer MYSQL versions, thread pooling is not enabled by default, and each client connection has its own thread in the server process. When the client (application) connects to the MySQL server, the server authenticates it (Authent

  2022-06-01 07:16:50 Views: 303
• 

  PostgreSQL DBA (151)-pgAdmin (log_XXX parameter:where)

  This section describes the log-related configuration parameter log_XXX. Overview query pg_settings on the database of the new initdb. The parameters that can be queried in PostgreSQL and log include: [test@localhost ~] $psql

  2022-06-01 07:16:50 Views: 219
• 

  ASM Enhancement in Oracle 11g R1

  Http://tech.it168.com/a2008/1120/211/000000211426.shtml this article provides an overview of the enhancements to automatic Storage Management (ASM) in Oracle Database 11g version 1, including:

  2022-06-01 07:16:49 Views: 223
• 

  Overview of ORACLE Control File (Control Files)

  Overview of Control Files < / h3 > The database control file is a small binary file associated with only one

  2022-06-01 07:16:49 Views: 295
• 

  Mysql data Import problem handling (ERROR 1418 (HY000))

  Today, during data import: gunzip < 201708_full.sql.gz | mysql-uroot-- the error message during default-character-set=utf8 import is as follows: ERROR 14

  2022-06-01 07:16:49 Views: 255
• 

  Problems caused by using Online to create index

  In the local test library, there is not enough space. As a result, a table is created with more than 6 million records. I want to create an index. The physical segment has more than 340 M. The temporary segment size is 100m, and as a result, if you want to create an index, you always report an error that the temporary table space is insufficient. [ora11g@

  2022-06-01 07:16:49 Views: 279
• 

  Mongodb user rights

  Mongodb enables user authentication: after mongodb enables user authentication, you need to create an account to log in with a user name and password. The account needs to have grant permission, that is, the authorization permission for account management. Note that the account number follows the library, so specify

  2022-06-01 07:16:49 Views: 245
• 

  Brief introduction of oracle Asynchronous IO

  In synchronous IO, a thread enters a waiting state after initiating an IO request, and does not stop waiting until the end of the IO and processes other requests instead. After the asynchronous IO sends the IO request to the kernel, it doesn't have to wait for the IO operation to complete and deal with something else. Asynchronous IO can be mentioned.

  2022-06-01 07:16:48 Views: 269