NAV: SLTechnology News&Howtos > Database >

• 

  MySQL Master-Slave synchronous error reporting Fault processing record

  In the preface, the problem often encountered after failover is synchronous error reporting. Here is the error information collected recently. Record deletion failed to delete a record on master, but Last_SQL_Error: Could not execu was not found on slave

  2022-06-01 08:41:40 Views: 274
• 

  Oracle tablespaces and user creation

  -create tablespaces and user create temporary tablespaces CREATE TEMPORARY TABLESPACE test_temp TEMPFILE'/ u01/oracle/

  2022-06-01 08:41:22 Views: 335
• 

  MySQL session temporary tablespace

  1. Physical file [root@roidb1 data] # cd\ # innodb_temp/ [root @ roidb1 # innodb_temp] # ls-lhtotal 160K Murray RW Murray. one

  2022-06-01 08:41:22 Views: 247
• 

  MGR client failover scenario

  In 2020, we will comprehensively promote the use of MGR in the business system. At present, there is a very important problem, that is, how to solve the problem of client redirection when the master node of MGR is abnormal: 1. Use the official co.

  2022-06-01 08:41:22 Views: 291
• 

  Process m000 died, see its trace file

  The database is 11g physical DGstandby database error Process M000died, see its trace file. Now the error of online search is that the resource is exhausted and cannot be connected, but the database is still alive. this

  2022-06-01 08:41:03 Views: 239
• 

  Master these optimization skills of MySQL database, get twice the result with half the effort!

  A mature database architecture is not designed with high availability, high scalability and other characteristics, it is with the increase in the number of users, the infrastructure is gradually improved. This article mainly talks about the problems and optimization schemes faced by MySQL database in the development cycle, leaving aside the front-end applications.

  2022-06-01 08:41:03 Views: 220
• 

  Backup commands and strategies commonly used in mysql

  MySQL common backup commands mysqldump backup common methods: 1. Export a database mysqldump-u user name-p password database name > exported file name such as # mysqldump-hhostname-ur

  2022-06-01 08:41:00 Views: 222
• 

  MySQL fundamentals (03): summary of system and custom functions, detailed use of triggers

  The source code of this article: GitHub click here | | GitEE point here 1. System encapsulation function MySQL has many built-in functions that can quickly solve some business requirements in development, including flow control functions, numeric functions, string functions, date-time functions, and clustering.

  2022-06-01 08:41:00 Views: 254
• 

  Compile and install MySQL 5.6.14 under CentOS 6.5

  Install MySQL1. Uninstall the old version and use the following command to check whether MySQL Server is installed. The result we found is this: [root@localhost ~] # rpm-qa | grep mysqlmysql-li

  2022-06-01 08:41:00 Views: 269
• 

  A preliminary glimpse of Python (1)-- connecting MongoDB with pymongo

  Python can use the pymongo library to easily manipulate MongoDB. By the way, MongoDB is different from the three-tier structure of relational structure-- database-- > table-- > record, which has a level of d.

  2022-06-01 08:40:59 Views: 227
• 

  Mongodb sharding cluster on CentOS7

  About CentOS7's mongodb sharding Cluster A database application with high data volume and throughput will cause great pressure on the performance of the stand-alone machine, a large amount of query will exhaust the CPU of the single machine, and a large amount of data will cause greater pressure on the storage of the single machine, which will eventually deplete the memory of the system and transfer the pressure to the magnetic field.

  2022-06-01 08:40:29 Views: 207
• 

  Redis data manipulation-the difference between string and hash key

  | if string keys can do what hash keys can do, why don't we just use string keys? | | benefits of hashing-putting data in the same place # Hash allows us to store some relevant information in the same place instead of directly distributing it. |

  2022-06-01 08:40:29 Views: 269
• 

  Terminating the instance due to error 119

  Everything is normal during the RAC installation process. After shutdown and restart, the GI starts normally and the instance does not start. [root@rac1 network-scripts] # crsctl stat res-tmuri-

  2022-06-01 08:40:29 Views: 299
• 

  Oracle temporary table space occupies disk space

  Create a new temporary tablespace tmpacreate temporary tablespace TEMPA TEMPFILE'/ oracle/tmp/tempa01.dbf 'SIZE 8192 M REUS

  2022-06-01 08:40:29 Views: 297
• 

  Reminder about the risk of database file damage

  Preface small y recently dealt with several cases of Oracle database file damage case, because some Bug risk, so do not dare to have the slightest snub, hurry up to share! Hope to help friends in need! Risk hint! As shown in the figure above, a known on the Linux 5amp 6

  2022-06-01 08:40:17 Views: 210
• 

  MongoDB fragmentation

  Introduction: sharding refers to the process of splitting a database and distributing it on different machines. By distributing the data to different machines, you don't need a powerful server to store more data and handle larger loads. The basic idea is to cut the set into small pieces, and these blocks

  2022-06-01 08:40:14 Views: 268
• 

  Solaris 10 (x86) to build Oracle 10g RAC-- install Oracle software

  Solaris 10 (x86) build Oracle 10g RAC-install Oracle software system environment: operating system: Solaris 10 (x86-64) Cluster: Oracle CRS 10.2.0.1

  2022-06-01 08:39:47 Views: 288
• 

  MongoDB Foundation

  An overview of 1.1.1.The concept of MongoDB MongoDB is written by C++ language and is an open source database system based on distributed file storage. In the case of high load, adding more nodes can ensure server performance. MongoDB is designed to be used for WEB

  2022-06-01 08:39:29 Views: 262
• 

  Oracle Study-- Oracle TimeZone upgrade

  Oracle Study-- Oracle TimeZone upgrade http://tiany.blog.51cto.com/513694/1411882Oracle 10gR2 to Oracle 11gR

  2022-06-01 08:39:29 Views: 272
• 

  The problem of capitalization in postgresql

  Today encountered a strange problem (actually a very basic problem), record a description of the problem: a sequence, named: SV_INFO_SEQ_id in PGAdmin to see the existence, query information_schema.seq

  2022-06-01 08:39:19 Views: 214