NAV: SLTechnology News&Howtos > Database >

• 

  Data updates for MongoDB (modifier)

  For MongoDB databases, changes to data will involve changes in content and structure (including arrays). Therefore, there are a series of modifiers available for MongoDB design. The previously used "$set" is a modifier. 1. $inc: master

  2022-06-01 07:44:28 Views: 270
• 

  Common SQL accumulation in sybase database

  Scenario 1:user connection is configured with 1500, and it is found in the database log that the error connection has been used up. You need to locate which machine or user has generated a large number of connection SQL statements: select * from (select b.namemema.h)

  2022-06-01 07:44:28 Views: 268
• 

  The actual combat process of financial-level database with 100 million customers and PB data scale

  Introduction: when WeBank was founded in 2014, she was very forward-looking and established the infrastructure of distributed architecture. At that time, Tencent had a financial-grade distributed database product, TDSQL, and its business scenario and reliability requirements for the database were very similar to the banking scenario. WeBank and Tencent

  2022-06-01 07:44:28 Views: 261
• 

  MySQL case-mysqld got signal 11 (Supplementary)

  -text-

  2022-06-01 07:44:24 Views: 234
• 

  Analysis of hard parsing and soft parsing and soft parsing to obtain shared pool latch mechanism series 5 in oracle 10.2.0.5

  Conclusion 1. The test environment is oracle 10.2.0.52, that is, the number of shared pools is 3. Hard parsing needs to obtain shared pool latch4, and soft parsing needs to obtain shared poo.

  2022-06-01 07:44:21 Views: 263
• 

  Introduction and comparison of OLAP and OLTP

  Introduction to https://www.cnblogs.com/hhandbibi/p/7118740.htmlOLTP and OLAP data processing can be roughly divided into two categories: online transaction processing OLTP (on-line tran)

  2022-06-01 07:44:21 Views: 243
• 

  PostgreSQL Source Code interpretation (242)-plpgsql (CreateFunction-compute_function_attributes)

  This section provides a brief introduction to the process of creating a function in PostgreSQL, whose implementation function is CreateFunction. 1. Data structure Form_pg_languageplpgsql language definition structure / *-

  2022-06-01 07:44:20 Views: 261
• 

  Research on sqlprompt display setting after 12c

  As you know, the current container can be changed through alter session set container=XXX in the new CDB,PDB feature of oracle 12c, and I wonder if there is an intuitive way to use sqlpromp.

  2022-06-01 07:44:20 Views: 294
• 

  Execute srvctl error report: error while loading shared libraries: libpthread.so.0:

  Execute srvctl to report an error error while loading shared libraries: libpthread.so.0: [oracle@rac02 ~] $srvctl / opt/or

  2022-06-01 07:44:20 Views: 286
• 

  OMF management automatically add data file script add_datafile.sh

  Oracle_ray.sh this script can be found in my blog, if you need to find their own changes: 1 in crontab execution does not read the profile file can not find sqlplus. If it is linux, please read the bash_ profile text

  2022-06-01 07:44:20 Views: 235
• 

  Mysql source code compilation adjustment or hidden version number

  The mysql version is updated quickly, and there is a certain bug in each version more or less, which will be scanned by the security manufacturer. We need to correct it. With the inspiration and help of our colleagues, we have done some tests: (1) decompress the source code package and adjust the value in the VERSION file, such as here.

  2022-06-01 07:44:19 Views: 268
• 

  Mysql case-sensitive lower_case_table_names

  In MySQL, the database corresponds to the directory in the data directory. Each table in the database corresponds to at least one file in the database directory (or multiple, depending on the storage engine). Therefore, the case sensitivity of the operating system used determines the case sensitivity of database and table names. In most cases

  2022-06-01 07:44:18 Views: 209
• 

  Two methods of migrating data files to other paths (1)

  (1) method 1: offline tablespace (not related to the library) * * main steps: * * 1, of

  2022-06-01 07:44:18 Views: 235
• 

  LogMinner

  First, the purpose of tracking changes in the database: you can track changes in the database offline without affecting the performance of the online system. Rollback database changes: rollback specific change data to reduce the execution of point-in-time recovery. Optimization and expansion plans: available through analysis

  2022-06-01 07:44:04 Views: 261
• 

  [ASM] basic knowledge of ASM

  [ASM] ASM basic knowledge market share ASM automatic storage management technology has been around for more than 10 years, and has been widely used in database storage solutions in various fields. By 2014, the adoption rate of ASM on RAC was nearly 60%, which was also more than that in a stand-alone environment.

  2022-06-01 07:44:04 Views: 273
• 

  Performance problems caused by mysql character set

  Simple query, return the same, use charge_id to associate, only 0.5s, but if you use order_id, it takes 18s! Why? When using order_id, the execution plan uses Using join buffer (Block N)

  2022-06-01 07:44:04 Views: 250
• 

  InnoDB layer full text Index Dictionary Table | know information_schema in an all-round way

  In the previous article, we introduced the lock, transaction and related statistical information dictionary table of InnoDB layer in detail. In this issue, we will bring you the seventh article of the series "InnoDB layer full-text Index Dictionary Table | Comprehensive understanding of information_schema |

  2022-06-01 07:44:04 Views: 284
• 

  PostgreSQL source code interpretation (42)-query statement # 27 (equivalence class)

  The last section introduced the function query_planner neutron function subfunction build_base_rel_tlists/find_placeholders_in_jointree/find_lateral_refere

  2022-06-01 07:44:00 Views: 260
• 

  Introduction to PostgreSQL DBA (8)-sysbench

  Pgbench is an open source benchmark tool that supports multithreading and multiple databases (including MySQL, PostgreSQL, etc.); CPU, disk IO, memory, POSIX thread performance and database performance of the operating system can be measured by testing. First, install and download s

  2022-06-01 07:44:00 Views: 290
• 

  [ERROR] OPatch failed with error code 73

  First, the problem description is to patch the Oracle database software today. During the operation, an error is reported as "OPatch failed with error code 73". Through the specific error information, we know that it is a libclntsh.so.11.1 file.

  2022-06-01 07:44:00 Views: 221