NAV: SLTechnology News&Howtos > Database >

• 

  Linux disk Management Advanced

  Linux disk Management Advanced dd commands SWAP and removable Media disk quotas RAIDdd commands dd-convert and copy a fileCopy a file, converting and formatti

  2022-06-01 10:34:56 Views: 206
• 

  Users in oracle cannot be deleted, prompting "cannot delete currently connected users"

  Option 1: shut down the database and restart it. Scheme 2:alter user XXX account lock;SELECT * FROM V$SESSION WHERE USERNAME='LGDB';alter

  2022-06-01 10:34:56 Views: 265
• 

  Description of organizational structure construction

  In the metrics rapid development platform, in the organization maintenance, there are several organization-related functions such as department post setting, personnel registration and personnel placement. The table of these function operation should have the sa_dept_dict,sa_staff_info,sa_staff_ table.

  2022-06-01 10:34:56 Views: 220
• 

  A series of zabbix monitoring services-NO1yum installation

  Yum installation, everything to facilitate Red Hat Enterprise Linux / CentOSInstall the repository configuration package. This pack

  2022-06-01 10:34:55 Views: 251
• 

  Rsync+inotify

  Description of rsybc+inotify enterprise case environment: real-time synchronization of data from a mongod to a remote host server address assignment: backup 172.16.1.88 (rsync server) backup source 172.16.1.89

  2022-06-01 10:34:55 Views: 220
• 

  Conditions under which PostgreSQL initiates recovery and fails to read checkpoint records

  1. First read the checkpoint2 pointed to by ControlFile- > checkPoint. If the reading fails, slave exits abort directly, and master reads ControlFile- > prevCheckPo again.

  2022-06-01 10:34:55 Views: 209
• 

  Hadoop data store-Hbase

  We all know that Hadoop is a database, but we are actually talking about Hbase. What's the difference between it and the relational database that we usually understand? 1. It is NoSQL, it does not have the interface of SQL, has its own set of API. two。 Relational database can do summary, you can

  2022-06-01 10:34:49 Views: 229
• 

  Related concepts of oracle

  SQL statement: structured query language: Structured Query Languageoracle database has a three-level structure: relational schema, called "basic table" storage schema (internal schema), called "storage file" subschema, called view.

  2022-06-01 10:34:45 Views: 255
• 

  Reduce connections to the database and improve request efficiency

  Man-hour system code optimization record: when viewing the details of man-hours, we need to show individual man-hour items once a month. There are 12 months in a year, and one person has multiple projects. The initial code is just for functionality, so the loop operation in the code, that is, each project goes to the database every month.

  2022-06-01 10:34:45 Views: 231
• 

  Mysql5.7 source code installation database deployment

  * * mysql5.7.20 source deployment author: MJ Bacon (mjboy) * * 1) install the basic package yum install-y gcc gcc-c++ automake autoconf git makeyum-y

  2022-06-01 10:34:45 Views: 280
• 

  MySQL error handling-1146 error

  A 1146 error occurred during master-slave replication of MySQL. The error reason for the prompt is that the specified table cannot be found in the default data. Show slave status\ G; actual synchronization status. Slave_IO_Running: YESSl

  2022-06-01 10:34:45 Views: 268
• 

  PT of mysql slow query analysis tool

  1. Introduction to tools pt-query-digest is a tool for analyzing mysql slow queries. It can analyze binlog, General log, slowlog, SHOWPROCESSLIST or tcp

  2022-06-01 10:34:41 Views: 267
• 

  Python analyzes the ip,url,status of nginx logs

  The Python script is as follows: #! / usr/bin/env python#_*_coding:utf-8 _ * _ author__ = 'lvnianfang accounting account' usrbank bin env python# cod

  2022-06-01 10:34:41 Views: 266
• 

  Backup and recovery of mysqldump+binlog and xtrabackup backup tools

  Data backup types are divided by business: full backup, incremental backup and differential backup. Full backup: is to back up the data and data structure of the entire database, the advantage is very intuitive, easy to understand. Deficiency: because the system is fully backed up every day, there is a large amount of backup data.

  2022-06-01 10:34:41 Views: 253
• 

  TODO: paging for database optimization

  TODO: paging of database optimization the example of this article is based on the MongoDB database, other databases can also be optimized. In MongoDB paging uses a.skip (n) to skip the first n matching documents; b.limit (m) returns m knots

  2022-06-01 10:34:35 Views: 242
• 

  Methods and tips for using Chinese kitchen knives

  It is believed that most webmasters use FTP to manage web space, but FTP is extremely weak compared to kitchen knives. In terms of database management, phpmyadmin and Imperial can only manage mysql databases, and the size of the software is completely incomparable to that of kitchen knives.

  2022-06-01 10:34:35 Views: 217
• 

  Greenplum distributed Cluster (data Warehouse)

  1. Preparation environment 1.1 Cluster introduction system environment: centos6.5 database version: greenplum-db-4.3.3.1-build-1-RHEL5-x86_64.zipgreenplum cluster, the four machines IP are

  2022-06-01 10:34:05 Views: 250
• 

  Mysql views the database from the command line

  1. Grammar: SHOW DATABASES;2. Syntax parsing: SHOW DATABASES: displays all database information on the currently connected database server 3. Example: SHOW DATABASES;4. Screenshot of the running result:

  2022-06-01 10:33:58 Views: 237
• 

  Update and exit of D3 data connection

  Abstract: in yesterday's push, we described the entry stage of data connection. In this article, we learn about its update and exit mechanism. This article is selected from "Picture D3: sharp tools for data Visualization from entry to Advanced". Let's go back to the previous "freak" Frank and take a fresh look at his

  2022-06-01 10:33:55 Views: 293
• 

  Common Management applications of MySQL Database (1)

  Common MySQL database management applications 1. Create a database create a database solinmysql > create database solin; create a GBK character set called solin_gbk mysql > create da

  2022-06-01 10:33:55 Views: 262