NAV: SLTechnology News&Howtos > Database >

• 

  Python_mongodb calculation increases deletion speed

  #! / user/bin/env pythonfrom pymongo import Connectiondb = Connection (). Foocollection = db.barfor II

  2022-06-01 21:10:13 Views: 211
• 

  Use Zabbix to monitor the usability of websites in bulk

  An application scenario describes the usability monitoring of a website is an important task for operation and maintenance. Website monitoring is mainly concerned with several key points: domain name resolution time, domain name response time, domain name access response code, domain name access speed and so on. The domain name here should be a URL specially used for website monitoring and detection.

  2022-06-01 21:10:13 Views: 274
• 

  Mysql determines whether the field is null

  There is an ISNULL method in SQL, which is described as follows: ISNULL replaces NULL with the specified replacement value. Syntax ISNULL (check_expression, replacement_value) parameter check_ex

  2022-06-01 21:10:13 Views: 220
• 

  Using Python to store json type data in a MySQL database

  0. It shows that because of the needs of personal projects, the data obtained are of json type, and all have to be stored in MySQL database. Because json type data is not like ordinary text data, there are many problems that need to be paid attention to when storing MySQL. I found a lot of methods on the Internet.

  2022-06-01 21:10:12 Views: 214
• 

  Mysql full backup and incremental backup

  1. Full backup simply means backing up all databases or a library. two。 An incremental backup is called an incremental backup from the last full backup to the next full backup. The mysql,binlong log is mysql data, and the backup of binlong is

  2022-06-01 21:10:10 Views: 279
• 

  Centos installation mongodb3.4 and user Management

  1. Download the installation package wget https://fastdl.mongodb.org/linux/mongodb-linux-x86_64-3.4.0.tgz2 and extract the installation configuration cd / opttar zxvf m

  2022-06-01 21:10:10 Views: 235
• 

  The solution of controlling File damage by oracle

  The control file of oracle is corrupted due to abnormal shutdown. The following error was reported when starting the instance: ORA-00205: error in identifying control file, check alert log for

  2022-06-01 21:10:07 Views: 255
• 

  Php operates hbase through thrift

  Environment configuration operating system centos 5. 8 hadoop version cloudera cdh4u3 hbase version hbase-0.90.4-cdh4u3 php version 5. 21. Download and compile thrift# wget

  2022-06-01 21:10:07 Views: 214
• 

  Sql optimization

  Relational database optimization: 1. To optimize the data structure, simplify the structure, data structure and redundant fields through business logic. Optimize through T-sql statements, including optimizing sql statements, establishing indexes, standardizing the writing of sql statements (according to the execution principle of sql code) 3. Gold

  2022-06-01 21:10:06 Views: 221
• 

  Recovery of physically deleted oracle data files

  Test in archive mode: (normal file system): physically delete data files in open, restore if not closed: SQL > select file_name from dba_data_files;FILE_NAME-

  2022-06-01 21:10:06 Views: 206
• 

  Deploy and install Oracle12c on CentOS7.3

  Preparation: a CentOS7.3Oracle12c installation package had better be set to dual-core, 4 G memory, 8 G virtual memory NAT mode installation process: 1. Turn off firewall self-startup and related functions and enhanced security features systemctl disable f

  2022-06-01 21:09:36 Views: 226
• 

  Sql group query the first record of each group

  Select student name, min (student grade) from table name group by student name

  2022-06-01 21:09:32 Views: 200
• 

  PostgresSQL master-slave building

  Due to the needs of work, recently began to contact a variety of databases, and try a variety of database products with high availability solutions. What we share today is the master-slave configuration of postgresSQL, which is actually quite simple. Follow the steps in this article to ensure that the master-slave configuration of PG can be realized. 1. Installation environment 192.

  2022-06-01 21:09:32 Views: 213
• 

  Set disk quota in 5.Linux

  Summary of setting disk quotas executes in the kernel on a file system basis enabling different groups or users with different policies based on blocks or nodes perform soft limits (soft limit) hard limits (hard limit) initialize partition mount options: usrquota, g

  2022-06-01 21:09:32 Views: 300
• 

  [OCM] Exam Souvenir 20140929

  At a time when the dean of Enmo College is participating in the OOW in the United States, the students of @ Enmo College did not stop to catch up, still enthusiastically sprinkling their enthusiasm for Oracle in the OCM examination room, standing out from the crowd.

  2022-06-01 21:09:32 Views: 237
• 

  DB2 tuning (1) Monitoring slow SQL execution

  In the process of DB2 tuning, we often want to obtain the slow sql in the current production environment, which can be precisely tuned for a specific slow sql. The following scripts are available, but the operation is still tedious and needs to be run manually. Db2 connect to tablen

  2022-06-01 21:09:31 Views: 206
• 

  Postgresql-- date-time function

  Date and time functions: date and time functions are mainly used to deal with date and time values. In addition to using parameters of type date, general date functions can also use types of datetime or timestamp, but ignore the time portion of these values. Same as time type

  2022-06-01 21:09:31 Views: 204
• 

  Common problems and Solutions of mysql in the Development process

  In this article, we will take a look at common problems and solutions to mysql during development. There is a certain reference value, friends in need can refer to, hope to help you. Remote connection problem mysql default connection can only be given locally (localhost or 127.

  2022-06-01 21:09:25 Views: 201
• 

  Oracle Linux 7.1installs oracle 12c RAC

  OS environment: [root@rac12c1 ~] # uname-aLinux rac12c1 3.8.13-55.1.6.el7uek.x86_64 # 2 SMP Wed Feb 11 14:18:22

  2022-06-01 21:09:25 Views: 288
• 

  RMAN deletes the archive log without releasing the problem

  Today, my colleague asked a question: a set of Oracle 11g databases on his side cannot delete old archives using RMAN, resulting in high disk utilization. Oracle@ps251n2s: [/ opt/oracle/archive/db] ls

  2022-06-01 21:09:24 Views: 284