NAV: SLTechnology News&Howtos > Database >

• 

  PostgreSQL Source Code interpretation (234)-query # 127 (NOT IN implementation # 5)

  This section briefly explains the implementation of writing temporary tablespaces to PostgreSQL NOT IN at execution time. The test data are as follows: [local]: 5432 pg12@testdb=# select count (*) from tbl; c

  2022-06-01 06:45:35 Views: 223
• 

  SQL programming practice-using SQL*Plus

  Use SQL*Plus1, view the table structure SQL > desc regions_copyName Null? Type-

  2022-06-01 06:45:34 Views: 279
• 

  Initialization of 2011-11-8 packet variables

  What will appear on my screen after the following statements are executed in the http://www.itpub.net/thread-1499223-12-1.html119 building? CREATE OR REPLACE PACKAGE plch_

  2022-06-01 06:45:34 Views: 261
• 

  Data query of MongoDB (data sorting)

  In MongoDB, the data sorting operation uses the "sort ()" function, which can be sorted in two orders: ascending (1) and descending (- 1). Example: data sort > db.emp.find (). Sort ({"sal":-1}). P

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

  JDBC read data Optimization-fetch size

  Recently, due to business requirements, the data from an old table structure needs to be extracted. According to the rules, the data from an old table structure is imported into a new table structure. The developer wrote a tool to implement the transformation of the old and new structure. The logic is simple, that is, to use jdbc to read numbers from table A.

  2022-06-01 06:45:26 Views: 248
• 

  Must-see database specification

  About the library: [mandatory] the name of the library must be limited to 32 characters, all lowercase English. [mandatory] Library name format: business system name _ subsystem name. It is not recommended to use the shulan prefix. [mandatory] Library names can only use letters, numbers, underscores and begin with the English letter.

  2022-06-01 06:45:26 Views: 244
• 

  Live broadcast Review? practice of TBase multi-center, multi-activity and high availability program

  Tencent Cloud Database [domestic Database topic online Technology Salon] is in full swing. Chen Aisheng's sharing has ended on April 28. For those who have not had time to participate, don't worry. The following is a live video and text review. Follow the official account of "Tencent Cloud Database" and reply "0428 Chen Aisheng"

  2022-06-01 06:45:26 Views: 291
• 

  GoldenGate OGG-01004 ORA-01400 Cannot insert null into...

  OGG failed, ORA-01400, cannot insert null into "TEST". The "TEST" destination side replication process uses the configuration HANDLECOLLISIONS, which is updated when the destination side is updated if

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

  The latest question bank and answer arrangement of OCP certification 052 exam

  65 、 Which three structures can span multiple data files?A. Chained rowsB. SegmentsC. Temporary segmen

  2022-06-01 06:45:25 Views: 216
• 

  [giant sequoia database Sequoiadb] failed to install SequoiaDB report cannot execute binary file on Mac os

  [problem description] failed to install SequoiaDB on Mac os. Error cannot execute binary file. Why? [solution] SequoiaDB does not support Mac os operating system. Concrete

  2022-06-01 06:45:25 Views: 228
• 

  MyCat sub-library sub-table-- actual combat 03muri-global table

  Project environment: 192.168.8.30 mycat192.168.8.31 node1192.168.8.32 node2192.168.8.33 node3 three nodes MySQL are all single instance 1. Configure schem

  2022-06-01 06:45:25 Views: 236
• 

  Innobackup incremental backup script

  Refer to the script in smear mysql, and make the following improvement [mysql@mysql01 scripts] $cat mysqlflowers fullbacks backupwards.

  2022-06-01 06:45:25 Views: 273
• 

  Improvement of GTID replication in MySQL5.7

  1. Support the creation of temporary table MySQL5.7 version can support create temporary table, drop temporary table commands. 2. Enable GTID replication mode, but not log_slave_upda.

  2022-06-01 06:45:24 Views: 251
• 

  REPLICATION SLAVE and REPLICATION CLIENT permissions

  The version tested is the user right that 5.6.30REPLICATION SLAVE is commonly used to establish replication, that is, slave server must be authorized by master server to have this permission before it can be replicated by that user.

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

  The Optimization process of mysql Log Table with large amount of data

  We know that many websites have log tables about recording site searches, which are used to record members' basic login information for post-data analysis or anti-attack use. now we have a table logs, which produces about 600000 of the data every day. Environment introduction: 10.0.21-MariaD

  2022-06-01 06:45:22 Views: 282
• 

  Restore restore test

  (1) all applications need to be closed before database backup, and database checkpoint and crchive log current operations need to be carried out. The database is complete without external program links to ensure database consistency. The detailed steps for backup and recovery are as follows:

  2022-06-01 06:45:17 Views: 268
• 

  Introduction to MySQL 5.5 mysqlimport

  Common parameters of mysqlimport:-- user=user_name,-u user name connected to the Mysql server-- password [= password],-p password-- host=hostname,-h

  2022-06-01 06:45:17 Views: 227
• 

  MySQL Server Enterprise practice one

  Introduction to the usage scenario of 1.MySQL database at present, the mainstream architectures of Web are LAMP (Linux+Apache+Mysql+PHP) and LNMP (Linux+Nginx+Mysql+PHP), and Mysql has been obtained by IT operation and maintenance staff.

  2022-06-01 06:45:17 Views: 210
• 

  [RAC] RAC build step Linux7.2+11G (based on Vmware+Openfile)

  First, planning 21. Network planning 22. Disk planning 23. Host hardware configuration 3 2, clear thinking 3 3, preparation work 31. Network card preparation (rac1&rac2) 32. Turn off the firewall and SElinux (rac1&r

  2022-06-01 06:45:17 Views: 309
• 

  Performance Optimization of Primary Night dimensional SQL

  Recently, the unit moved from the National Convention Center to the clean-air Houshayu in Shunyi. Before the relocation, we encountered some thorny problems and some places worth using for reference. This is an optimization of the night dimension program. The purpose of this night dimension is to delete 30 + tables of historical data every day.

  2022-06-01 06:45:13 Views: 244