NAV: SLTechnology News&Howtos > Database >

• 

  Realization of currentOp timing acquisition by MongoDB

  Problem description: when analyzing performance problems in a production environment, it is often impossible to start because there is no real-time basis. Then the author captures db.currentOp () to the file and serves as a scheduled task for subsequent analysis. Solution: step 1: Shell script records db.

  2022-06-01 18:40:23 Views: 210
• 

  To export a mysql using the navicat tool

  First, select the table 2 that needs to be exported. Right-click "Export Wizard" in the selected table and select the saved file format as needed. 3. Click next to save the files one by one to the specified location 4. Click "next" and "start".

  2022-06-01 18:40:21 Views: 281
• 

  Pit for subquery update operation

  I believe most people have written the sub-query, but I encountered a relatively bad problem yesterday. Due to the better backup, I recovered the misoperated data in a very short time, but this problem is worth sharing. First, set up the following test table: CREATE TABLE course (studen

  2022-06-01 18:40:19 Views: 226
• 

  Zabbix configuration deployment

  Zabbix experimental environment: server: 192.168.36.131 client: 192.168.36.129iptables and selinux disabled I. Server configuration 1. Install # rpm-ivh ht

  2022-06-01 18:40:07 Views: 260
• 

  Zabbix detects the master-slave synchronization of Mysql database

  Zabbix detects master-slave synchronization of Mysql database in highly concurrent website architecture, master-slave synchronization of MySQL database is indispensable, but it often occurs due to network reasons or operational errors, MySQL master-slave often occurs out of synchronization, so how to monitor MySQ

  2022-06-01 18:40:02 Views: 226
• 

  Etcd cluster backup and recovery

  Backup this backup method is to make a backup with the snapshot function of etcd. If necessary, you can roll back the etcd cluster to a specific backup point. This backup is based on etcd api version 3. If the data is written in api version 2, then api

  2022-06-01 18:40:00 Views: 266
• 

  Database Application-mysql statement

  MySQL (Relational Database Management system) MySQL is a relational database management system, developed by the Swedish company MySQL AB, and currently belongs to the products of Oracle. MySQL's most popular relational database management system, on the WEB application side

  2022-06-01 18:40:00 Views: 277
• 

  SQL table-valued function

  1. Multi-statement table-valued function-- =-- Author:-- Create date:-- De

  2022-06-01 18:39:59 Views: 206
• 

  SQL Union and SQL Union All usage

  SQL Union usage SQL Union and SQL Union All usage the SQL UNION operator UNION operator is used to merge the result sets of two or more SELECT statements. Please note that the SELE inside UNION

  2022-06-01 18:39:59 Views: 288
• 

  ORA-31617 error occurred in data pump export

  Export: Release 11.2.0.4.0-Production on Sat Jun 11 01:00:02 2016Copyright (c) 1982, 2011, Oracle

  2022-06-01 18:39:58 Views: 230
• 

  DBID, an important parameter of Oracle recovery management

  * * DBID**DBID, an important parameter of Oracle recovery management, is the database identifier. Each database has a number called the database identifier (DBID). The number is automatically generated when the database is created, and Oracle does not guarantee that two databases with the same name

  2022-06-01 18:39:58 Views: 224
• 

  MySQL Master-Slave Construction and configuration

  MySQL master-slave (MySQL replication) is mainly used for real-time backup or read-write separation of MySQL. Do some preparatory work before configuration. Configure two MySQL servers. If your machine cannot run two Linux virtual machines at the same time, you can

  2022-06-01 18:39:58 Views: 256
• 

  Oracle error point resolution

  There are two errors in the test environment after the successful installation. In fact, there is only one reason. Record it first and expand this article irregularly in the future: [oracle@oatest ~] $sqlplus'/ as sysdba'-bash: sqlplu

  2022-06-01 18:39:57 Views: 284
• 

  Cleaning of zabbix historical data and excessive processing of libdata1 files

  A historical data cleanup stops related services to avoid writing data / etc/init.d/zabbix-server stop/etc/init.d/httpd stop emptying historical data mysql-uroot-puse za

  2022-06-01 18:39:57 Views: 238
• 

  Index module of database

  In addition to being one of the most important modules in the database, the index module is also the most frequently asked in interviews. The common questions about the index module are as follows: why use indexes? what information can be used as indexes? the difference between dense indexes and sparse indexes? why use indexes: minimum storage in the database.

  2022-06-01 18:39:50 Views: 248
• 

  Do not install Oracle and use cx_Oracle

  The environment of using Python to connect to Oracle database is very troublesome, especially in the configuration under window, Oracle database needs to be installed by default. For users who do not want to install Oracle on the machine, there will be various problems in the installation process. The most common

  2022-06-01 18:39:49 Views: 295
• 

  Installation of Mysql

  1 install the mysql-related package yum install-y mysql mysql-devel mysql-server2 launch mysqlservice mysqld start3 to log in to mysql- u

  2022-06-01 18:39:48 Views: 271
• 

  [Nodejs development] Chapter 1 describes how to build the environment

  Please follow my small site: http://oideas.herokuapp.com/1. Why do you have to tell yourself? Well, let's talk about something first. first of all, I'm not a big god, just a single guy who just got out of a single life (graduated in 2013 and left in 2014).

  2022-06-01 18:39:45 Views: 229
• 

  ORACLE JET Basic Table Sortable Columns

  Basic Table example: Basic Table

  2022-06-01 18:39:43 Views: 282
• 

  Rac startup and shutdown

  In the Oracle 10g era, we envy those DBA who understand Oracle9i, and unwittingly passed the Oracle11g and welcomed the 12c era, but there are still many DBA accustomed to the management thinking of Oracle 10g, especially in management or security.

  2022-06-01 18:39:33 Views: 219