NAV: SLTechnology News&Howtos > Database >

• 

  MySQL Binlog Technology principle and case study of Business Application

  The introduction MySQL Binlog is used to record the structured query language (Structured Query Language,SQL) statement information of the user's operations to the database. Is the binary log of the MySQL database, and you can use the mysqlbin command

  2022-06-01 07:13:50 Views: 209
• 

  Mycat sub-table and sub-database principle

  Although sub-table and sub-database can solve the pressure of large tables on the database system, it is not omnipotent, and it also has some disadvantages, so the first problem is, regardless of library, which library, what rules, how many pieces. Principle 1: can not be divided, less than 10 million of the table, do not recommend slicing, through the appropriate

  2022-06-01 07:13:50 Views: 237
• 

  SQL optimized statistics and indexes

  In most cases, sql optimization scenarios occur when we want our sql statements to run faster, and we tend to take some "steps" to adjust the execution path of sql so that they can finish faster. When I first joined the dba industry, I often heard what my mentor told me.

  2022-06-01 07:13:45 Views: 293
• 

  The inside story of TiDB technology-computing

  The mapping of relational model to Key-Value model here we simply understand the relational model as Table and SQL statements, so the problem becomes how to save Table on the KV structure and how to run the SQL statement on the KV structure. False

  2022-06-01 07:13:45 Views: 252
• 

  Parsing of PostgreSQL Page page structure (4)-parsing of table footprint when executing DML

  This paper introduces the reason for the "surge" of data table space caused by using pageinspect plug-in to analyze Update data table in the case of long transaction (open transaction, never commit / rollback). 1. Use psql to start the session Session Bt in the test scenario

  2022-06-01 07:13:45 Views: 247
• 

  Ora-04023 and database software disk space

  On March 25, customers reported that the LV space utilization of an Oracle 11.2.0.4 version of the standby database software located on the HPUX host was growing rapidly. At first, I didn't realize how big the problem was. There is a lot of reading business in this repository, and customers are worried

  2022-06-01 07:13:44 Views: 295
• 

  Java inner class, why do you need inner class?

  Why do you need inner classes? Solved the problem of multiple inheritance, inheriting concrete or abstract classes. In general, an inner class inherits from a class or implements an interface, and the code of the inner class operates to create the objects of its outer class. So it can be thought that the inner class provides some kind of window into its outer class. The inner class is the most attractive

  2022-06-01 07:13:36 Views: 209
• 

  Lock module of database

  The difference between MyISAM and InnoDB on locks MyISAM and InnoDB on locks: MyISAM defaults to use table-level locks, but does not support row-level locks InnoDB defaults to row-level locks, and also supports table-level locks InnoDB supports transactions.

  2022-06-01 07:13:36 Views: 234
• 

  Write down the ORA-00600 kdsgrp1 processing

  One day, a bad block appeared in the AWR-related table of tablespace SYSAUX in the customer's database. Through the truncate table (the data is not important), restore the data files from the backup, and repair the bad blocks after recovery. After the database OPEN, an error occurred in the customer business.

  2022-06-01 07:13:31 Views: 255
• 

  MySQL startup error InnoDB: The innodb_system data file & # 039 Tip.Universe ibdata1 error error 039; is of a different

  After MySQL migration, start database error # / data/mysql_57_software/bin/mysqld_safe-- defaults-file=/etc/my3319.cnf-- user=m

  2022-06-01 07:13:31 Views: 230
• 

  Import ORA-39002,ORA-39070,ORA-29283,ORA-06512,ORA-29283 using the data pump

  ORA-39002: invalid operationORA-39070: Unable to open the log file.ORA-29283: inval appeared this morning when using the data pump to import

  2022-06-01 07:13:28 Views: 221
• 

  Mysql5.7 single instance command line installation (in windows environment)

  one。 Download installation package 2. Extract to the installation directory D:\ install_path III. Add the path environment variable path=xxx;D:\ install_path\ bin IV. Create the parameter file D:\ install_path\ bin\

  2022-06-01 07:13:28 Views: 254
• 

  Ogg synchronization kafka OGG-15051 Java or JNI exception:

  2018-08-09 16:02:01 ERROR OGG-15051 Java or JNI exception:oracle.goldengate.util.GGException: Error

  2022-06-01 07:13:28 Views: 294
• 

  The difference between DG and GG in oracle

  Oracle DataGuardOracle GoldenGate principle replicates archived logs or online logs extract data changes in online logs, converts them to GGS custom data formats and stores them in local queues or remote queues. Stability as disaster recovery is extremely stable.

  2022-06-01 07:13:20 Views: 297
• 

  How much do you know about MongoDB replication (with a tutorial on common tasks in replica sets)

  The replica set in MongoDB Manual (Version 4.2) > ReplicationMongoDB is a set of mongod processes that maintain the same data set. Replica sets provide redundancy and high availability, and this is for all production deployments

  2022-06-01 07:13:20 Views: 241
• 

  Redis Labs: a real zero-delay system is expected to be born!

  We often talk about the word "real-time", such as real-time collection, real-time computing, real-time display, and we also know that most enterprise applications can provide real-time response, which usually means a delay of one or two seconds, or even less, which is irrelevant to human perception. However,

  2022-06-01 07:13:17 Views: 250
• 

  The new version of Redis Enterprise optimizes the linear extension, and the performance test is a little good!

  In Redis Enterprise version 5. 0, his team introduced support for the open source (OSS) cluster API, which allows Redis Enterprise clusters to scale linearly by adding shards and nodes. In this paper, the first linear extension basis is given.

  2022-06-01 07:13:09 Views: 280
• 

  Simple use of Dameng Vernier

  1 display cursor create table T1 (sex varchar2 (10), name varchar2 (20)); insert into T1 values ('male','

  2022-06-01 07:13:04 Views: 215
• 

  [MySQL] introduction to mysqlbinlog

  Introduction to binlog: a binary log that records SQL statements that occur or potentially change data and are stored on disk in binary form. Function: MySQL acts like Oracle's archive log and can be used to view the change history of the database (all at a specific point in time)

  2022-06-01 07:13:03 Views: 246
• 

  Analysis of mysqldump principle

  Today, I learned the principle of mysqldump, and the specific conclusions are as follows: 1. When mysqldump backups without any parameters: if you back up a table alone, it will read the lock on the backup table until the end of the backup, unlock, if the backup of the entire library, then at the same time l

  2022-06-01 07:13:03 Views: 218