NAV: SLTechnology News&Howtos > Database >

• 

  Error occurred in PGSQL query data: ERROR: could not read block 0 in fil

  Reason: when the application accesses the PGSQL master-slave database, it makes a high-availability implementation, and repeatedly cuts the master-slave in the implementation process, resulting in the loss of the index of the table, so the query data failed to report an error. Solution: create an index of the table corresponding to the data

  2022-06-01 15:27:14 Views: 232
• 

  Mycat Learning practice-basic functions of Mycat

  Mycat learning practice-Mycat basic functions learning mycat mysqlMycat learning practices-Mycat basic functions 1. Mycat high availability-read-write separation 1.1 read-write separation configuration parameters 1.2 heartbeat configuration parameters 2. Mycat high availability

  2022-06-01 15:27:07 Views: 249
• 

  Service operation description of oracle under windows

  Specially tested, oracle 11g under windows 2008 R2, database service in service manager, oracleservice+sid service: start service = startup; stop service = shutdown immed

  2022-06-01 15:27:07 Views: 218
• 

  Basic Operation of Oracle (2)

  Basic operation of oracle database; create tablespace plug database create user create data table (transaction) index view sequence synonym one, create tablespace example; create tablespace school / / create tablespace school2 data

  2022-06-01 15:26:37 Views: 249
• 

  Installation and uninstallation of oracle 11g (1)

  First, grid installation usually precedes database installation so that database 1. 1 can be identified and monitored after installation. Extract the software and perform installation 2. Install the package trusted by the product yum install oracle-rdbms* will resolve ora after installing this package

  2022-06-01 15:26:36 Views: 254
• 

  MySql Learning Notes (5): operation types of explain- data read operations

  The explain command is as follows: mysql > explain select * from tweets.

  2022-06-01 15:26:36 Views: 241
• 

  Oracle database is composed of server and client.

  Database: basic concept: database management system (Database Management System,DBMS): a software system for managing (storage + operation (CRUD)) data relational database management system (RDBMS): database (Dat)

  2022-06-01 15:26:36 Views: 207
• 

  How can the database in the virtual machine be extracted when it is lost?

  This paper introduces many data recovery cases of server class. Today, from the point of view of virtual machine data recovery, the editor introduces a successful data recovery case in which the virtual machine cannot be started due to abnormal power outage. It involves not only virtual machine data recovery, but also server data recovery, database repair and other technologies.

  2022-06-01 15:26:33 Views: 292
• 

  [basic] mysqldump creates a slave library based on GTID

  For small databases, we can directly use the mysqldump full library export import to create a slave library. Test environment: CentOS6.8 x86_64MySQL5.6.34 community rpm master library: node0 192.168.2.10 slave library

  2022-06-01 15:26:32 Views: 245
• 

  Redis Learning Notes (1) Concepts, data types, keys

  Full name REmote DIctionary Server official definition Redis is an open source (BSD license), in-memory data structure storage system that can be used as database, cache and messaging middleware

  2022-06-01 15:26:32 Views: 292
• 

  Python calls http interface, writes data to mysql database and downloads recording file.

  Writing a script completes a total of three things: first, python calls the http interface, second, writes the called data to the mysql database, and third, python calls the wsdl interface to get the recording file, import timeimport jsoni

  2022-06-01 15:26:31 Views: 259
• 

  Memory Table in PLSQL-- Index By Table

  In fact, a memory table is a bit like an array in java, but it is more powerful than an array. 1. First of all, let's briefly introduce the function of memory tables: using fields of index primary keys made up of BINARY_INTEGER types or fields of user-defined types as specific arrays.

  2022-06-01 15:26:09 Views: 269
• 

  Install and deploy Oracle 12c based on CentOS7

  Install and deploy Oracle 12c based on CentOS7 introduction Oracle Database, also known as Oracle RDBMS, or Oracle for short. It is a relational database management system of Oracle. Is currently the most popular client / server (

  2022-06-01 15:26:09 Views: 267
• 

  Detailed tutorial on installing Oracle 11g based on RHEL6.5 (2) & mdash;— installing RHEL6.5

  2 install RHEL 6.51) as shown in the following figure, select the Oracle virtual machine, right-click on the Oracle virtual machine, and then select Power-turn on the power (or use the Ctrl+B key combination). 2) as shown in the following figure, right-click on the Oracle virtual machine and select

  2022-06-01 15:25:45 Views: 220
• 

  Oracle SQL statement

  1. Create the tablespace create tablespace abc datafile'/ u01ActionActionoradataUniverse TestDB11max catalog.dbf' Custom data file location and name

  2022-06-01 15:25:45 Views: 291
• 

  Install Discuz under Centos!

  [root@ajing ~] # mkdir / data/www [root@ajing ~] # cd / data/www [root@ajing www] # wget http://download.co

  2022-06-01 15:25:37 Views: 231
• 

  Deploy Zabbix Server with one click every minute

  In order to facilitate the process of installing Zabbix into an automated one-click deployment script, if you are interested, you can refer to some basic commands: #! / bin/bash#Zabbix one-click deployment script # install zabbix3.0.4, relying on php-5.6.25sr

  2022-06-01 15:25:34 Views: 234
• 

  Oracle user password policy

  Today, when I changed a user's password in the oracle database, I found the following rule: 1 the password is only composed of letters, which has been successfully created SQL > alter user ics identified by password;User chang.

  2022-06-01 15:25:33 Views: 227
• 

  SqlServer Series Notes-Index

  What is an internal table structure used by the index SQL Server, which provides fast access to the table based on the values of one or more columns in the table? full table scans: full table scans are the least efficient to retrieve data (select), that is, looking for indexes one by one

  2022-06-01 15:25:33 Views: 230
• 

  Mariadb audit plug-in installation, opening and setting

  Mariadb audit (mariadb server_audit.so installation) oracle, mysql, mariadb, and sql server will all have related audit requirements in the databases that we often contact, but they

  2022-06-01 15:25:30 Views: 279