NAV: SLTechnology News&Howtos > Database >

• 

  JIRA problem data extraction

  After using JIRA, the BUG and functional development of all developed systems are recorded in the above process. When we want to make a statistical analysis of these huge amounts of data, such as counting the number of problems in each system, the number of questions submitted by testers each week and month, the number of BUG developers deal with each month, and so on.

  2022-06-01 14:19:39 Views: 208
• 

  The change of Oracle 12C log system

  Check the mode of cluster: crsctl get cluster mode status (standard or flex)-12C to modify the mode of cluster: crsctl set clu

  2022-06-01 14:19:39 Views: 287
• 

  Quickly back up the data of a table in the database, or only back up the table structure

  Backup table structure and data select * into backup table name from source table name only backup table structure select * into backup table name from source table name where 1 < 1 (1 < 1 refers to error condition

  2022-06-01 14:19:39 Views: 239
• 

  Building and testing of MySQL Cluster

  1. Server preparation 1) MySQL Node 1 10.41.1.852) MySQL Node 2 10.41.1.843) ndb Node 1 10.41.1.834) ndb Node 2 10.41.1.825) Management Node 1

  2022-06-01 14:19:38 Views: 255
• 

  ORACLE 12C boot auto start monitor, CDB, PDB

  Linux database instance monitoring self-boot setting August 1, 2018 zhanky test introduction system version: Oracle linux 7.2x64 database version: Oracle Database 12c Enterpris

  2022-06-01 14:19:38 Views: 277
• 

  Experience Summary of Bootstrap Development Framework based on Metronic (4)-- extraction and Utilization of Bootstrap Icon

  1. Menu display and various Bootstrap icons we can see from the following figure that in order to make the menu beautiful, each menu item (here is divided into three levels of menus) has an icon. Although the size is different, we use Bootstrap icons from the Bootstrap icon library.

  2022-06-01 14:19:08 Views: 241
• 

  Date types in Oracle

  1Syndate gets the current system time select SYSDATE from dual; format date: TO_CHAR (SYSDATE,'YY/MM/DD HH24:MI:SS) or TO_DATE (SYS)

  2022-06-01 14:18:56 Views: 293
• 

  Install Mysql5.7 version in Centos7 environment

  Experimental environment: VMware Workstation12 Centos-7-x86_64 system (ip address: 192.168.5.132) (2 GB memory 2 processors) using software: boost_1_59_0, mysql

  2022-06-01 14:18:53 Views: 212
• 

  Listener.ora

  ORACLE_HOME/network/admin/Status: Failure-Test failed: Listener refused the connection with the fo

  2022-06-01 14:18:53 Views: 259
• 

  PinPoint distributed full link monitoring

  PinPoint distributed full link monitoring installation requires all package download path: link: https://pan.baidu.com/s/1sl9dP9r password: jsux introduction: PinPoint is an open source APM ((Appl)

  2022-06-01 14:18:46 Views: 301
• 

  MySQL-MongoDB open source monitoring weapon PMM adds slack newspaper

  Here is an introduction to how to increase the alarm function, it is said that the monitoring without alarm function is not good monitoring! The main monitoring types of pmm are, in fact, it should be said that Grafanaemail # is the most commonly used, but the disadvantage is that there is often a delay on the SMTP server of the service provider, which is regarded as

  2022-06-01 14:17:46 Views: 209
• 

  MySQL addition, deletion, modification and table replication and renaming

  MySQL add, delete, modify, insert table query table record format 1:select field 1. Field N from library name. Table name; format 2:select field 1. Field N from library name. Table name where conditional expression; note

  2022-06-01 14:17:46 Views: 218
• 

  InnoDB index implementation

  For tables from the InnoDB storage engine, records are saved in a certain order by default, or in primary key order if there is a clearly defined primary key. If there is no primary key, but there is a unique index, it is saved in the order of the unique index. If there is neither a primary key nor a unique index, a

  2022-06-01 14:17:42 Views: 265
• 

  MySQL failed to create database

  If you make an error when logging in to the database create database using the root account: MySQL: 1006-Can't create database'*'(errno: 13) or MySQL: 10

  2022-06-01 14:17:36 Views: 239
• 

  What are pessimistic locks and optimistic locks?

  What are pessimistic locks and optimistic locks? Many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something. Optimistic (Optimistic Locking) optimistic

  2022-06-01 14:17:36 Views: 206
• 

  Introduction of access Database Management system

  This article is to share with you about the introduction of the access database management system, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article. Access's full name is Microsof.

  2022-06-01 14:17:36 Views: 292
• 

  The difference between _ OFFLINE_ROLLBACK_SEGMENTS and _ CORRUPTED_ROLLBACK_SEGMENTS

  These two parameters of _ OFFLINE_ROLLBACK_SEGMENTS and _ CORRUPTED_ROLLBACK_SEGMENTS can force the database to be opened, but after open, it is best to export, rebuild the library, and then import. Yeah, these two.

  2022-06-01 14:17:35 Views: 226
• 

  Lesson record of installing MySQL 8.0.16 under MAC

  It took more than two days to solve the problem! Originally, I have used MySQL in several environments, and I am also familiar with several other relational databases, which I thought would cost a little bit of installation time. However, to sum up, there is still too little knowledge about MAC, which leads to a lot of detours. Now

  2022-06-01 14:17:32 Views: 211
• 

  TNS-12545 of oracle for windows snooping issu

  Operating system version: windows server 2012R2 database version: oracle 11.2.0.1 problem description: windows server 2012R2 built on a vmware virtual machine, and then in window

  2022-06-01 14:17:27 Views: 295
• 

  For MySQL database practice testing

  1. Create student and score tables CREATE TABLE student (id INT (10) NOT NULL UNIQUE PRIMARY KEY, name VARCHAR

  2022-06-01 14:17:23 Views: 221