NAV: SLTechnology News&Howtos > Database >

• 

  The server quit without updating PID file

  Environment: after installing mysql, copy mysql from another machine to restart mysql in the current environment. The solution is as follows: 1. Give all the mysql installation directory to mysql user rights chown-R mysql: / data/mysql2, check the configuration

  2022-06-01 06:39:51 Views: 262
• 

  RA-00054 of oracle: resource busy and acquire with NOWAIT

  1. The truncate table reports ORA-00054, indicating that a transaction is operating the table SQL > truncate table alldm.DM_XQKD_YUJING_D;truncate table alldm

  2022-06-01 06:39:50 Views: 251
• 

  ORA-1400, abandon exp imp data migration.

  Description: customers need to do data migration, migrate from Oralce 10g to 11g RAC environment, use exp direct path export, import to 11g error ORA-1400. It is suggested that after 10g, you can use the data pump to move the database.

  2022-06-01 06:39:46 Views: 292
• 

  Summary of the interview questions: it may be the best MySQL knowledge point in the whole network.

  Author: Snailclimb collation and Editor: SegmentFault this article was originally published in the SegmentFault column JavaGuide, such as invading and deleting. The title is a bit of a party title, but I hope you won't have this idea after reading the article.

  2022-06-01 06:39:46 Views: 240
• 

  Interpretation of PostgreSQL Source Code-MVCC#13 (vacuum procedure-vacuum_set_xid_limits function)

  This section briefly introduces the processing flow of manual vacuum execution by PostgreSQL, and mainly analyzes ExecVacuum- > vacuum- > vacuum_rel- > heap_vacuum_rel- > vacuum_set_xi.

  2022-06-01 06:39:45 Views: 246
• 

  Examples of the principle and setting method of MySQL Batched Key Access (BKA)

  MySQL version 5.6 began to add an algorithm to improve the performance of the table join: a new feature of Batched Key Access (BKA). The principle of BKA algorithm: the row / result set of the outer loop is stored in join buffer, and the number of rows per memory loop

  2022-06-01 06:39:45 Views: 239
• 

  From e-commerce to software market, Ali double 11 war spread

  "Singles Day" in 2019 is not only the 11th year of Ali Tmall's struggle, but also an important milestone for Ali in the e-commerce industry. This year, the whole Ali department is also in a "one heart and one battle" all-round attack. As an important general under Ali, Ali Yun has also joined this shopping spree, bringing a hot shopping atmosphere.

  2022-06-01 06:39:45 Views: 286
• 

  Set Oracle11g to boot automatically

  Set Oracle11g Boot Auto Boot: the setting in Redhat and Centos allows the ORACLE system to start automatically, but is not allowed by default. 1. Modify / etc/oratab file under root account: # vi /

  2022-06-01 06:39:45 Views: 300
• 

  [Mysql] add thread memory monitoring (MySQL Thread Memory Usage Monitor) to MySQL

  Patch, you can view the memory used by each thread! Patch in the source package patch p1 < Patch the effect is like this: patch: 5.6_thread_mem_usage_ver2.patch (5.0KiB, 1172)

  2022-06-01 06:39:40 Views: 256
• 

  Subquery after mysql select

  The subquery after select can only be used as a scalar query # case: query the number of employees in each department SELECT d. Query, (SELECT COUNT (*) FROM employees WHERE empl)

  2022-06-01 06:39:40 Views: 299
• 

  Cassandra two login methods cassandra-cli / csqlsh

  (1) the cassandra-clicassadnra-cli command is discarded in cassandra2.2. You can use cqlsh [tnuser @ sht-sgmhadoopdn-02] to log in to visit cassandra later.

  2022-06-01 06:39:40 Views: 214
• 

  9-mmm High availability Cluster of mysql Series

  Mmm High availability Cluster introduction: master / standby mode, when the master is unable to provide services, the standby host takes over to provide services. This process is transparent to the client. 1. Prepare five linux servers: master (192.168.4.122)

  2022-06-01 06:39:39 Views: 223
• 

  Effect of ORACLE 10g append and nologging insertion on REDO

  Impact of ORACLE 10g append and nologging insertion on REDO / * + append*/1. Append belongs to direct insert, append+table nologgin in archive mode

  2022-06-01 06:39:39 Views: 265
• 

  Oracle scheduling Schedule Features (part V)-schedule, program, job Joint

  After the 10g version of oracle, scheduler divides the attributes of job into multiple parts. What program is responsible for and when schedule is responsible for doing it, job is simple, in one word: do. In the previous articles, we introduced the creation of a management Jo

  2022-06-01 06:39:39 Views: 273
• 

  ORACLE ORA-00600: internal error code, parameters: [kokbcvb1] and merge into

  Recently, a city Oracle database ran a Job error report, the error content is as follows: operating system: windows server 2008R2 database version: oracle 11.2.0.1 error content: Fri Aug 11 11:08:

  2022-06-01 06:39:39 Views: 299
• 

  DM7 uses dminit tools to create databases

  1 functional introduction dminit is a DM database initialization tool. During the installation of DM, users can choose whether or not to create the initial database. If it was not created at that time, you can use the database creation tool dminit to create it after the installation is complete. System administrators can take advantage of d

  2022-06-01 06:39:38 Views: 300
• 

  The number of parallel processes is too large to connect to the database.

  Abstract: the number of processes caused by parallelism is too large to connect to the database to read the original text to improve the reading experience: https://www.modb.pro/db/22961?cyn##### database parallel process exception # # problem describes sudden host ora_p process suddenly

  2022-06-01 06:39:37 Views: 237
• 

  Mysql semi-synchronous replication

  one。 Characteristics of semi-synchronous replication 1. Compared with traditional asynchronous replication, semi-synchronous replication selects one node among multiple Slave nodes for semi-synchronous replication. That is, when Master commits a transaction, the Slave side of the semi-synchronous replication returns a

  2022-06-01 06:39:37 Views: 281
• 

  Buffer pool preheating of new features of innodb

  Background innodb buffer pool is the most important cache of innodb, and its cache hit ratio will directly affect the performance of the database. Therefore, changes occur in the database, such as restart, master / slave switch, instance migration, etc., innodb buffer poo

  2022-06-01 06:39:36 Views: 268
• 

  Oracle DG active / standby startup and shutdown process

  Environment: Oracle 11g RAC and DG shutdown operation flow: RAC node: shut down primary host: SQL > shutdown immediate cannot shutdown immediateSQL > shutdown

  2022-06-01 06:39:36 Views: 235