NAV: SLTechnology News&Howtos > Database >

• 

  Secondary finishing of Linux_MySQL (1)

  MariaDB or MySQL: inexact description: data is stored as a data stream on the hard disk. When a file is read, the file is first loaded into memory, and then the required fields are found in memory. When the file is very large, the file cannot be put into memory, and a field is searched.

  2022-06-01 10:49:05 Views: 262
• 

  PostgreSQL Learning (1)

  PostgreSQL Learning (1), the special features of PostgreSQL and the reasons for choosing (1) PostgreSQL supports programming procedures and functions in multiple programming languages (2) PostgreSQL supports very powerful user-defined data types

  2022-06-01 10:48:48 Views: 281
• 

  CentOS6.9 installation mysql5.7.21 tutorial

  CentOS6.9 installs mysql5.7.21 tutorial above. Successful installation: Step1: check whether the system has its own installation mysqlyum list installed | grep mysqlStep2: delete the one that comes with the system.

  2022-06-01 10:48:48 Views: 290
• 

  MySQL Optimization (Super complete version) (2)

  7. MySQL sub-library sub-table (1) introduction to the concept of    MySQL sub-library split table has two ways: vertical split and horizontal split.    vertical split: vertical split is to divide tables into different database tables by module (of course, the principle is not to break the third normal form), this split

  2022-06-01 10:48:47 Views: 213
• 

  First-party data definition, collection and processing

  Data is everywhere-we create more than 2.5 exabytes (exabytes) of data per day, and researchers predict that there will be 163zettabytes (zettabytes) of data by 2025. In addition, there are many kinds of data related to enterprises. We have the first party and the third party.

  2022-06-01 10:48:44 Views: 269
• 

  A preliminary understanding of MariaDB 6-semi-synchronous replication

  1. Background introduction: MySQL master-slave replication can solve a certain single point of failure, but its asynchronous working characteristics have some hidden dangers, such as the master node has not been written into binlog after the transaction is committed, and when the master node fails, the master node thinks that the transaction has been committed, and the slave node cannot obtain the transaction from the master node.

  2022-06-01 10:48:35 Views: 216
• 

  First acquaintance of mysql Index

  The article is sorted out according to his own understanding after learning teacher Lin Xiaobin's "mysql 45 lectures" at geek time. What is an index? When we use a Chinese dictionary to look up a word, we will first look up the page number of the word through the pinyin directory, and then turn directly to the page of the dictionary

  2022-06-01 10:48:25 Views: 297
• 

  Yum install MongoDB

  An introduction to MongoDB packages that provide official support in its own repository. This repository contains the following packages: (1) mongodb-org: one metapackage, the following four component packages will be installed automatically. (2) mongodb-org-server: package

  2022-06-01 10:48:25 Views: 295
• 

  ORA-00221 ORA-00206 ORA-00202 ORA-27041 error

  SUSE Linux 11+oracle 11.2.0.3 environment, / oradata mounted on storage, tonight stores a controller failure restart, but the server has done a dual path, storage controller restart does not affect the operating system to identify storage on / oradata

  2022-06-01 10:48:25 Views: 271
• 

  Sqlloader external table

  Once you create a directory, create $cd / home/oracle$ mkdir dir$ cd dir$ pwd under the system and then create it in sqlplus, so that oracle knows the directory SQL > createdirectory.

  2022-06-01 10:48:25 Views: 205
• 

  Query whether the union of the Astroke B field in the table is unique.

  SELECT column_a,column_b,COUNT (*) as num FROM TABLE GROUP BY column_a,column_b;SELECT column_a,colum

  2022-06-01 10:48:24 Views: 255
• 

  Brief introduction of Relational Database and non-Relational Database

  Relational database is a database based on relational model. So what is a relational model? The model of storing data in rows and columns as a two-dimensional table is a relational database. For example: mysql and oracle non-relational databases (NoSQL is Not-Only S)

  2022-06-01 10:48:18 Views: 283
• 

  Error report of data loading in oracle

  We often use SQL Loader when bulk loading data. But there are often misreports. When I was in batch processing, there was also a 500 error, indicating that the file could not be opened. I also struggled for a long time, and repeatedly proofread the control documents and verified my orders. But engage in lifting

  2022-06-01 10:48:18 Views: 210
• 

  SQL Server create trigger

  -- TABLE INSERTVAL UPDATEVALif (object_id ('DATA_SYNC_FH_DJ','TR') is not null) drop trigger DATA_

  2022-06-01 10:48:18 Views: 203
• 

  Yum install lamp+discuz

  First install the httpd-related software package yum install httpd httpd-devel httpd-manual httpd-tools-y to start the httpd service service httpd resta

  2022-06-01 10:48:15 Views: 237
• 

  ORACLE 10GR2 DATAGUARD ON RHEL 6

  1. OS install Red Hat Enterprise Linux Server release 6.4 (Santiago) 64-bit IP:10.56.1.204 10.55.1.2042, install oracle

  2022-06-01 10:48:15 Views: 223
• 

  Centos7.3,mysql5.7 environment, data storage space to increase the adjustment scheme.

  Centos7.3Mysql 5.7Partition information is as follows df-hFilesystem Size Used Avail Use% Mounted on/dev/mapper/cl_g

  2022-06-01 10:48:14 Views: 260
• 

  OGG Operation and maintenance Optimization script (2)-Information Modification Class-batch Table addition

  Now let's introduce the script. All scripts must be annotated in the prm configuration file before they can be used successfully. Please refer to the script deployment to prepare the actual operation and maintenance process. During the actual operation and maintenance process, our OGG programs are uniformly deployed under the $home/ggserver path. Add the table file name: ins.

  2022-06-01 10:48:14 Views: 301
• 

  5. Nginx to build WordPress blog system

  1. Brief introduction WordPress is a blog platform developed in PHP language. Users can set up their own websites on servers that support PHP and MySQL databases. You can also use WordPress as a content management system (CMS). Wo

  2022-06-01 10:48:08 Views: 246
• 

  Add new nodes dynamically to HADOOP/HBase

  1. Check that the JDK version is the same and copy the JDK, and configure the JAVA_HOME and CLASSPATH properties of the / etc/profile file 2. 0. Configuration / etc/hosts file, add the computer name of the newly added machine, including the old machine and the new machine

  2022-06-01 10:48:08 Views: 260