NAV: SLTechnology News&Howtos > Database >

• 

  Change the zabbix database mandatory

  Problem description: zabbix web GUI upgraded from 2.4.5 to 3.2.6. The web interface reported the following error: The frontend does not match Zabbix database. Current da

  2022-06-01 16:53:01 Views: 226
• 

  Changes to hostname Oracle Linux 6.5 & & RHEL 7.0

  Example: change bogon to adelababyOracle Linux 6.5 [root@bogon ~] # hostnamebogon [root@bogon ~] # hostname ade

  2022-06-01 16:53:01 Views: 247
• 

  Continue to decrypt the Oracle backup tool-expdp/impdp

  Continue to decrypt the Oracle backup tool-expdp/impdp in this information age, the growth of data size and data volume is expanding at an explosive rate. Before a few hundred megabytes or gigabytes of data, the amount of data is huge. Nowadays, the space occupied by the test system is dozens or even a hundred times that of this data.

  2022-06-01 16:52:57 Views: 291
• 

  MonGo--- installation and its basic operation

  1. Install Mongo database: the latest version officially provided at the time of release of this article is 1.6.5, and this version will be used in this tutorial if no special announcement is made. Step 1: download the installation package: official download address ← Click here, if it is a win system, note that it is 64

  2022-06-01 16:52:56 Views: 283
• 

  Mongodb2.6 installation

  The operating system environment is as follows: [root@zxl-nginx ~] # cat / etc/issueCentOS release 6.4 (Final) Kernel\ r on an\ m [root@zxl-ngi

  2022-06-01 16:52:56 Views: 245
• 

  How to solve the situation that you do not know the initial password during mysql installation

  Recently, because of the need to use mysql, and then set up some problems according to the environment of the old boy's "learning linux operation and maintenance from the old boy-web cluster practice" to learn mysql. During the preliminary study, it is recommended that you install according to the content step by step (after all, at the initial time.

  2022-06-01 16:52:56 Views: 286
• 

  A simple case of RSA encryption algorithm

  RSA encryption algorithm is the most influential public key encryption algorithm, which can resist most of the known passwords so far. What are the applications of RSA encryption algorithm? The following is an example of database authentication. When using a dataset for authentication, the password exists in the database

  2022-06-01 16:52:56 Views: 283
• 

  Mongodb disassemble library split table script

  Script function: 1. The specified report file is divided into 2. 5% according to the specified field and the strategy of cutting library and table. Import the split files into the corresponding Mongodb 3. 0 concurrently. Generate log file and done identity file user manual:-h print help information and exit;-f need

  2022-06-01 16:52:55 Views: 238
• 

  Two writing methods of executing dynamic SQL in DB2 stored procedure

  Sample code: DROP PROCEDURE QUOTATION.COPY_SAMPLE;CREATE PROCEDURE QUOTATION.COPY_SAMPLE (IN tableNameFr

  2022-06-01 16:52:55 Views: 250
• 

  SELECT list is not in GROUP BY clause and contains

  Query mysql related modeselect @ @ global.sql_mode; to see that ONLY_FULL_GROUP_BY is included in the schema, as long as it is not configured. My Mysql version is 5.7.21, and the default is with

  2022-06-01 16:52:55 Views: 231
• 

  Preliminary RDBMS-mysql

  Rdbms:1, database establishment and deletion 2, form creation, deletion, modification 3, index creation and deletion 4, users and permissions 5, data addition, deletion and modification 6, query DML: data manipulation language INSERT REPLACE DELETE UPDATEDDL:

  2022-06-01 16:52:55 Views: 242
• 

  Case-some pits in optimize table

  For the database of online IM messages, the utilization rate of disk space has reached 96%. For new machines that have not applied for expansion, what cannot be migrated from the database retains all chat records, and none of them are allowed to be deleted in this scenario. In order to reduce space capacity, the table can only be defragmented to free space, optimize.

  2022-06-01 16:52:54 Views: 248
• 

  11.2.0.4 PSU installation operation template

  Patch installation is a normal thing, for 11.2.0.4 PSU patch, collated a standard installation process, the patch version is the quarterly PSU patch and OJVM patch. 26636028 = 26635745 + 26635834

  2022-06-01 16:52:54 Views: 206
• 

  Cancel the automatic allocation function of Exchange database

  In the daily maintenance of Exchange, when creating a mailbox account, Exchange automatically allocates a database if no target database is specified. The general principle of Exchange allocation is that the database with a small number of people will be allocated to that database. In the real world

  2022-06-01 16:52:51 Views: 244
• 

  What is the three paradigms of database?

  The relationship in the relational database needs certain requirements, and there are different paradigms that meet the requirements of different degrees. The paradigm is contained downwards, that is, to satisfy the second paradigm, the first paradigm must be satisfied. The first normal form (1NF): the one that meets the most requirements is called the first normal form. The first paradigm requires all fields to be meaningful and original.

  2022-06-01 16:52:50 Views: 275
• 

  Complete solution of HBase HFile and Prefix Compression-KeyValue format

  1. Introduction HFile(HBaseFile) is an abstraction of a file storage format used by HBase. At present, there are two versions of HFile:HFileV1 and the previous version of HFileV2HBase0.92 only supports HFil

  2022-06-01 16:52:50 Views: 211
• 

  Setting the default character set of Mysql in MacOS

  1. Check the character set mysql > show variables like 'character%';+--+-

  2022-06-01 16:52:44 Views: 277
• 

  Tablespace properties in partitioned tables in Oracle

  The partition table in Oracle is a good feature of Oracle, which can divide the large table into several small tables, thus improving the efficiency of SQL execution for the large table, and each partition is transparent to the application. Each partition in the partition table has independent storage characteristics, including tablespaces, PCT

  2022-06-01 16:52:44 Views: 264
• 

  Transactions / locks in Redis

  Redis supports simple transactions comparison between Redis and mysql transactions Note: the difference between rollback and discard if two statements have been successfully executed, the third statement goes wrong. after rollback, the statement influence of the first two articles disappears. Disc

  2022-06-01 16:52:35 Views: 279
• 

  Oracle Study-- AIX 6.1 install Oracle 10gR2

  Oracle Study-- AIX 6.1 install Oracle 10gR21, system hardware platform # prtconf | moreSystem Model: IBM,9131-52A Machine Serial

  2022-06-01 16:52:27 Views: 300