NAV: SLTechnology News&Howtos > Database >

• 

  Oracle uses materialized views to synchronize table data

  1. Create original table and materialized view log SQL > create table T1 (id int,name varchar2 (30)); Table created.SQL > alter table T1 add co

  2022-06-01 08:46:25 Views: 209
• 

  I. Foundation of MySQL database

  1.1. The database model database consists of an ordered collection of data, which are stored in structured data tables. The data tables are related to each other, reflecting the essential relationship between objective things. Database system provides security control and integrity control of data. The development of database is roughly divided into several stages.

  2022-06-01 08:46:19 Views: 213
• 

  Redis blocking analysis

  Redis is a classic single-threaded architecture, where all read and write operations are done in a single main thread. When redis is in a high concurrency situation, if blocking occurs, even for a very short time, it will be very serious for the application, there will be a large number of timeout problems, application problems. 1. Re

  2022-06-01 08:46:19 Views: 213
• 

  Oracle installation (11g) silent installation

  This blog describes how to install oracle11g silently on a linux system (11.2.4.0). It is mainly used for scenarios where graphical display is not convenient, and it is also suitable for scripted batch deployment. System environment OS: Oracle Linux Server re

  2022-06-01 08:46:18 Views: 300
• 

  MYSQL basic operation command

  MYSQL basic operation: RDBMS function: 1, database creation, delete 2, create table, delete table, modify table 3, index creation, delete 4, user and permissions 5, data add, delete, change 6, query Mysql login command:-u USERNAME # specify user

  2022-06-01 08:46:18 Views: 279
• 

  Error handling of Mydumper installation

  Mydumper official website: https://launchpad.net/mydumperMydumper introduces MySQL's own mysqldump tools that support single-threaded work, exporting multiple tables one by one, without a parallel.

  2022-06-01 08:45:54 Views: 293
• 

  Install MySQL under JEESZ distributed architecture 3--CentOs (environment preparation)

  Disclaimer: because the running environment is based on the Linux system, before doing this framework, we need to do some preliminary environmental preparation work to install many instances of MySQL on the CentOs. Because the later stage of the blog is used as the native tutorial of the framework, detailed installation records are made here, which have been downloaded here.

  2022-06-01 08:45:54 Views: 244
• 

  Upgrade, rollback, and uninstall SQL Server 2017 on Linux

  Upgrade the mssql-server package to the latest version sudo yum update mssql-server this command downloads the latest package and replaces the binaries under / opt/mssql/. User-generated and system databases will not be subject to this operation

  2022-06-01 08:45:53 Views: 246
• 

  Alarm: no existing database

  Metastat: wy2db: there are no existing databases did not do database mirroring. After consulting, I learned that there was no big problem.

  2022-06-01 08:45:53 Views: 219
• 

  Master-slave delayed replication-data recovery test!

  Write in front: imagine that your online environment uses a master-slave replication architecture, and if you accidentally perform updates such as drop database db1, drop table tb1, or delete,update without where conditions, when

  2022-06-01 08:45:53 Views: 231
• 

  An index causes queries to be slow

  First, the environment centos 6.7,11.2, the table according to the date monthly partition 2, test 1, query table existence index ind_1 (org_id,visit_date,visit_no,patient_id) execute query statement

  2022-06-01 08:45:41 Views: 259
• 

  03 redis profile interpretation

  # General configuration daemonize no # whether to run as a daemon. Default is No. Changing it to yes will generate a pid file. Pidfile / var/lib/redis.pid # if backstage

  2022-06-01 08:45:40 Views: 291
• 

  Multi-area OSPF

  1. Backbone area: it plays a role in enabling other non-backbone areas to know the network situation in other areas. In other words, all routing information from non-backbone areas flows through the backbone area. 2. Virtual link: a link from a non-backbone area to a backbone area. Purpose: to connect a non-backbone area

  2022-06-01 08:45:34 Views: 278
• 

  Holer implements external network access to local MariaDB database

  The external network accesses the local MariaDB database. The local MariaDB database is installed locally, which can only be accessed in the local area network. How can the intranet MariaDB database be accessed from the public network? This article describes the specific steps to implement using holer. 1. Prepare for work 1.1 install and start

  2022-06-01 08:45:25 Views: 218
• 

  Mysql stored procedure programming

  Mysql stored procedure Writing template: Create PROCEDURE PROCEDUREName (IN para mint,...) BeginDeclare varname type; statement; En

  2022-06-01 08:45:25 Views: 222
• 

  Rookie Learning Linux 079 Notes mysql backup lvm

  Rookie study Linux 079 Notes mysql backup lvm content Overview the export of the supplementary single table in the previous section is imported into LVM to create a snapshot to achieve database backup the last section is missing a little bit of knowledge when using mysqldump backup and restore, you should temporarily sql_log_bin.

  2022-06-01 08:45:25 Views: 219
• 

  Double quotation marks and identifiers

  When we create a table or query, even if we use lowercase, the results are still larger. If you want to see or store lowercase identifiers in a data dictionary, you have to use double quotes, so identifiers are case-sensitive, include spaces in identifiers, or use reserved words as identifiers.

  2022-06-01 08:45:25 Views: 259
• 

  MongoDB Notes XVI-Mongodb Export

  Open cmd to export data parameters using the mongoexport command description-d database name to export-c the name of the collection to export-o specify the file name to be exported-csv specifies the csv format for export-Q filter export-type export

  2022-06-01 08:45:24 Views: 248
• 

  Simpana usage

  2017-6-17 it should be noted that under the host table linux on the second end, it is best to delete the domain name or change the location by default to identify the previous running oracle backup policy Times error: log storage policy is not assigned to the sub-client. Please specify and try processing again: set the path in the sub-client attribute.

  2022-06-01 08:45:24 Views: 219
• 

  Import, export, backup and recovery of Mongodb data

  When building the test environment, in order to ensure that the online data will not be destroyed, or to avoid misoperation, the database should establish a local database. Make a backup of the online data and restore it to the local test environment. Mainly mongoexport, mongoimport, mongod

  2022-06-01 08:45:24 Views: 271