NAV: SLTechnology News&Howtos > Database >

• 

  An example of installing and deploying Zabbix3.0 version and fast basic configuration on CentOS7 at one time

  The installation, deployment and configuration of Zabbix3.0 must be based on LAMP environment or LNMP environment. For simple and quick construction of the LAMP environment, see blog: http://afterdawn.blog.51cto.com/7503144/1

  2022-06-01 16:27:37 Views: 203
• 

  Improve Defaults

  SQL > create table t_test1 (id number,phone varchar2 (20) default null); Table created.SQL > CREATE SEQUE

  2022-06-01 16:27:36 Views: 224
• 

  An Analysis of seconds_behind_master problem

  1. Alarm content: [seconds_behind_master] [INSERT LOW_PRIORITY IGNORE INT] 2, log in to the database show slave status\ G; it is found that the slave delay has been 0.

  2022-06-01 16:27:36 Views: 205
• 

  Metrics rapid development platform grid check row (identify row), multi-select row acquisition method

  Both checked rows and multi-selected rows can be used in the grid part of the metrics rapid development platform. The method of obtaining and using the selected rows is listed in our wizard, but it is not listed in the current function wizard. Check the row acquisition, you can directly intelligent wizard "get identification line" dim rows

  2022-06-01 16:27:33 Views: 253
• 

  The experiment of MySQL5.7 multi-source replication

  Experimental node1 of MySQL5.7 multi-source replication: 192.168.2.171 master1node2: 192.168.2.172 slavenode3: 192.168.2.170 master2nod

  2022-06-01 16:27:33 Views: 232
• 

  Match_recognize

  Similar to the function of the analysis function, the matching can be judged and calculated between lines. The new pattern matching statement in SQL is "match_recognize". CREATE TABLE Ticker (SYMBOL VARCHAR2 (10

  2022-06-01 16:27:30 Views: 211
• 

  Install JDK_Tomcat

  # JDK installation # here the version is selected as jdk-6u33-linux-x64.bin1. Upload the installation file to the default path 2. Grant execute permission to the installation file chmod + x jdk-6u33-linux-x64.bi

  2022-06-01 16:27:30 Views: 222
• 

  The use and principle of InnoDB undo tablespace

  Preface Undo log is an important part of the transaction characteristics of InnoDB MVCC. When a record is changed, it will produce undo records, which are stored in the system table space by default, but from 5.6 onwards, an independent undo table space can be used. Undo records store

  2022-06-01 16:27:24 Views: 230
• 

  Oracle date format

  Select to_date ('2005-12-25 Person13-25-5-5-5-5) from dual

  2022-06-01 16:27:24 Views: 226
• 

  MongoDB basic operation, backup and restore and user management

  Today, taking advantage of the weekend, I will make the following arrangements for the commands commonly used in the MongoDB database that I have been learning recently, so as to facilitate the viewing of the logical structure of MongoDB at work, which is mainly composed of documents, collections and databases. Document is the core concept of MongoDB, and it is MongoDB logic.

  2022-06-01 16:27:24 Views: 236
• 

  New parameter innodb_numa_interleave supported by mysql5.7.9+

  As you all know, the in-memory numa feature of linux systems is strongly recommended to turn off on servers running mysql services. Because of this feature, it is easy to cause memory leaks: it is found that there is still physical memory left, but the system is already using swap memory. Within numa

  2022-06-01 16:27:23 Views: 293
• 

  Unattended installation of SQL Server 2017 on Linux

  You can perform an unattended installation by adding a database and installing SQL Server. When you run mssql-conf setup, set the environment variable and use the-n option (not prompted). #! / bin/bash-e # Use the f

  2022-06-01 16:26:53 Views: 206
• 

  Postgres 11.4 pg_basebackup P

  Screenshot: pg_basebackup: could not get write-ahead log end position from server: ERROR: could not open fi

  2022-06-01 16:26:53 Views: 298
• 

  Glance Series 1: glance Foundation

  1 what is glance 2 Why should there be glance 3 glance function 4 glance two versions 5 mirrors data storage 6 mirrors access 7 mirrors and various states of tasks 8 glance contains components 9 glance and o

  2022-06-01 16:26:42 Views: 292
• 

  Data types and table structure of MySQL

  Data type and table structure of MySQL DB,DataBase- database: a collection of data organized according to a data model and stored in storage. DNMS,DataBase Management System- database management system: used to manipulate and

  2022-06-01 16:26:42 Views: 217
• 

  Creation of oracle package

  Composition of a package 1) package: the header part declares data types, constants, variables, cursors, subroutines, and exception error handling in the package, which are the public elements of the package. 2) package body: the package body is the concrete implementation of the package definition part.

  2022-06-01 16:26:41 Views: 245
• 

  Oracle database SQL audit

  In our daily work, some databases with high security requirements need to increase audit operations, which user did what at what time. 1. Open the audit alter system set audit_sys_operations=TRUE for the database

  2022-06-01 16:26:41 Views: 227
• 

  ORACLE common views and table collation

  V$ beginning v$database database information v$datafile data file information v$controlfile control file information v$logfile redo log information v$instance database instance information v$log log group

  2022-06-01 16:26:41 Views: 277
• 

  Oracle 11g dataguard main library bad block repair

  The ideal situation is to enable real-time transmission of redo logs. You can use the standby library to repair the bad blocks of the main database: check DG mode: alter database recover managed standby database using curre

  2022-06-01 16:26:41 Views: 243
• 

  MySQL UNION operator

  MySQL UNION operator this tutorial introduces the syntax and examples of the MySQL UNION operator. The description MySQL UNION operator is used to concatenate the results of more than two SELECT statements into one result set. Multiple S

  2022-06-01 16:26:32 Views: 215