NAV: SLTechnology News&Howtos > Database >

• 

  Lisenter cannot monitor the service after changing the hostname

  Lisenter cannot listen to the service environment description after changing the hostname. Linux redhat5.4 + oracle 11.2.0.1 hostname: zky.zhan host ip:192.168.214.10 instance SID:zky

  2022-06-01 18:31:47 Views: 206
• 

  The difference between Redis and Memcached

  If you simply compare the difference between Redis and Memcached, most of you will get the following point of view: 1 Redis not only supports simple khaw type data, but also provides storage of data structures such as list,set,hash. 2 Redis support data

  2022-06-01 18:31:46 Views: 264
• 

  The use of manager in linux

  1. Write this script [root@manager scripts] # cat / scripts/master_ip_failover #! / usr/bin/env perluse stri in the manager node

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

  Mysql type conversion

  Syntax: CAST (expr AS type) type: BINARY # binary string CHAR (n) # normal string DATE # date string DA

  2022-06-01 18:31:46 Views: 233
• 

  Add two sql statements executed with shell and output the database name and the added value separated by the tab key

  SELECT SUM (PresentSum) FROM `Lg_ consumeDetail0` WHERE ConsumeDate < '2016-11-01' AND OpId! = 300

  2022-06-01 18:31:45 Views: 299
• 

  Mysql backup and restore database

  Backup database: / usr/local/kkmail/service/mysql/bin/mysqldump-u kkmail-p-- databases kkmail | gzip > 20180309.s

  2022-06-01 18:31:45 Views: 219
• 

  Implement the EF of the .NET Core configuration Provider

  The use of. NET Core configuration is described in detail in "you can learn .NET Core configuration in 10 minutes." in addition, I have also opened up custom configuration ProviderEF configuration Provider and Yaml configuration Provider. In this article, let's talk about EF configuration.

  2022-06-01 18:31:45 Views: 293
• 

  Percona XtraDB Cluster planning and implementation

  # # learn to read logs when setting up a cluster. Logs are very important. Logs are really important. 1.1.The server configuration hostname IP address Pxc01192.168.1.17Pxc02192.168.1.18Pxc03192.168.1

  2022-06-01 18:31:43 Views: 272
• 

  Basic operation and daily maintenance of MongoDB

  The basic operation of MongoDB the basic operation of MongoDB is the operation of database, collection and document, including creating database, deleting database, inserting document, changing document, deleting document, and querying document. Operation description show dbs View the list of databases under the current instance

  2022-06-01 18:31:41 Views: 278
• 

  12C EM express https connection error

  12C EM express https connection error database installation is recommended to install EM to facilitate future management. SQL > show parameter dispatchersNAME TYPE VALUE-

  2022-06-01 18:31:41 Views: 250
• 

  Mongodb Seven-day Summary-Rights Management (2)

  Mongodb rights management version: when Mongodb3.0 talks about database security, we usually consider how to solve the database security problem from the following points. 1. The safest thing is physical isolation: 2. Network isolation: 3. Firewall isolation: 4. User name and password: below

  2022-06-01 18:31:41 Views: 276
• 

  Sqlserver stored procedures generate and send HTML monitoring reports

  Background scheduling tasks process data in the early hours of each day, a process that normally takes about 6-7 hours. Before 9 o'clock every day, you need to make sure that all the data is processed, which is a deadline. If it is not completed, it means that an accident occurred in the operation and maintenance on the same day, which affected the customer. In the early stages

  2022-06-01 18:31:39 Views: 228
• 

  C # connects to sql database and returns dataset classes

  Set up a public class SqlConnct, which will be called every time you connect to the database for query operations, passing in the sql query parameters. Using System;using System.Collections.Generic;u

  2022-06-01 18:31:38 Views: 210
• 

  Sharepoint upgrade series tutorials (1) upgrade from 2007 to 2010

  Recently caught up with the Sharepoint upgrade work, here to share with you my Sharepoint2007 upgrade to Sharepoint 2013 upgrade trip. First of all, introduce the environment, Windows Server 2008R2 +

  2022-06-01 18:31:23 Views: 214
• 

  Delete data by using binlog2sql quick flashback-don't take bean bags for dry food

  Brothers, long time no see! Recently, I have been busy with the creation of new books, so I have no time to update my blog. I don't know how you are doing in this period of time. I hope you can help you by reading my article. Lao Zhang, I also spent a lot of time recording some database video courses, if you

  2022-06-01 18:31:23 Views: 284
• 

  A test on the long_query_time parameter

  Create a test table with the following statement: mysql > show create table test1;+-+-

  2022-06-01 18:31:20 Views: 251
• 

  DB2 performance Optimization-Analysis of slow REORG

  What is REORG? We know that there are many tables in the database, and we may often need to add, delete and modify the table data. after a series of changes, logically continuous data may be on discontiguous physical data pages. especially when many inserts create overflow records

  2022-06-01 18:31:20 Views: 288
• 

  Using SNMP to manage large-scale Network-cacti

  1. Introduction to SNMP the most widely used network management protocol in the network at present is SNMP (Simple Network Management Protocol, simple Network Management Protocol). SNMP is widely accepted and put into use.

  2022-06-01 18:31:09 Views: 286
• 

  11g delete disk group step

  Install customer core production database, disk group name is wrong, need to delete, re-create. The steps to delete a disk group are as follows: su-gridsqlplus / as sysasmSQL > select group_number, name fr

  2022-06-01 18:31:09 Views: 267
• 

  ORA-01031: solution to the insufficient privileges problem

  When you use sqlplus / as sysdba to connect to sqlplus locally under the oracle user, prompt ORA-01031: insufficient privileges to view the operating system version information [ora

  2022-06-01 18:31:08 Views: 253