NAV: SLTechnology News&Howtos > Database >

• 

  Overview of Innodb Storage engine Index

  An overview of Innodb storage engine indexes this storage engine supports two common indexes: B+ index and Hash index. Hash index the Hash index supported by the Innodb storage engine is adaptive, and the engine will automatically generate Hash index according to the usage of the table, without human intervention.

  2022-06-01 18:24:10 Views: 268
• 

  Simple operation and suggestion of DBeaver (a magical database operation software)

  Let's talk about a concept first-what is metadata? It starts with data storage. If you are interested, you can take a look at: the storage of https://blog.51cto.com/12042068/1898605 data is divided into two parts: one is the data structure.

  2022-06-01 18:24:00 Views: 262
• 

  Common Hint in Oracle (1)

  Hint in Oracle can be used to adjust the execution plan of SQL and improve the efficiency of SQL execution. The following categories describe the Hint that is common in Oracle databases. The versions of common Hint,Oracle databases in Oracle11gR2 are described here.

  2022-06-01 18:24:00 Views: 286
• 

  The database that receives data when exporting the database using the Darth SQL database repair software, such as

  Clearing table data, preserving views, stored procedures, functions, and retaining table constraints, triggers, etc., can reserve a good shell for the failed database and import bad database data into this shell. Sometimes good results can be achieved in the recovery of databases such as user friends and Kingdee. There are two ways to clear table data: one is to use de

  2022-06-01 18:24:00 Views: 265
• 

  [MySQL] A brief introduction to MGR Cluster

  About 1.MGR MySQL Group Replication (MGR) is a highly available and highly extensible database solution officially introduced by MySQL in version 5.7.17 and is provided as a plug-in. MGR is based on distributed paxos protocol and implements groups.

  2022-06-01 18:23:59 Views: 238
• 

  Construction of mysql master-slave replication environment

  Mysql master from the first time I used a different version of mysql to do something out of sync. It is recommended to use the same version of mysql to start log-bin=mysql-bin from the master my.cnf file (192.168.1.64) mysqld module.

  2022-06-01 18:23:59 Views: 274
• 

  How to view and modify the maximum number of connections in MySQL database

  1. Check the maximum number of connections mysql > show variables like "% max_connections%"; ±- ±- + | Varia

  2022-06-01 18:23:59 Views: 222
• 

  Installation and configuration record of Redis under CentOS 6.6

  Redis was introduced in the previous article, and the following is a record of installing Redis on CentOS. For later improvement. 1. The first thing to do before installing Redis is to install Unix's Tcl tools. If not, it will be done later.

  2022-06-01 18:23:55 Views: 297
• 

  Mysql trigger (trigger)

  The function of the trigger listens to the change of the data in order to realize the associated operation when the data changes, but it feels useless. The function of the trigger will be more formal if it is controlled by code logic. After all, the rest of the team will not necessarily see the trigger you define, but they will definitely see your code. That's for

  2022-06-01 18:23:55 Views: 286
• 

  Several common inheritance methods of javascript and the construction of credit tray platform

  1. Prototype chain inheritance (simplest) core (implementation idea): credit tray platform construction [Penguin 21717-93408] use the instance of the parent class as the subclass prototype object function Person (name) {this.name = name;th

  2022-06-01 18:23:54 Views: 203
• 

  Manipulate data tables using T-SQL statements-insert data

  Insert data (insert) syntax: insert [into] < table name > [column name] values < value list > explanation: insert: is a grammatical name, the meaning of insertion into: is optional, can be omitted. Table name is required, where do you need to add it

  2022-06-01 18:23:40 Views: 253
• 

  Mysql Base events (scheduled tasks)

  1. Ordinary events: directly execute the statement: DROP EVENT IF EXISTS job_insertgood;DELIMITER $$CREATE EVENT job_insertgoodON SCHEDULE

  2022-06-01 18:23:39 Views: 279
• 

  SQL and NoSQL

  First, relational database (RDB), as a traditional database, supports complete ACID attributes, in which the declarative SQL syntax shields the underlying implementation details, and the relational data model also conforms to people's normal thinking logic, so relational databases dominate all kinds of applications.

  2022-06-01 18:23:36 Views: 271
• 

  Online mysql database backup

  #! / bin/bash#====# FileName:

  2022-06-01 18:23:36 Views: 202
• 

  Oracle metalink Chinese document list-Oracle EBS

  List of Chinese documents-Oracle EBS (Enterprise Business Suite) (document ID 1553829.1) https://support.oracle.com/epmos/fa

  2022-06-01 18:23:36 Views: 226
• 

  Handle series: (1) use Benchmarksql to test the performance of Oracle database

  Os environment: Oracle linux / Oracle 12C RAC (see here for building rac cluster), oracle12c database downloads Benchmarksql 5.0: http from sourceforge

  2022-06-01 18:23:35 Views: 279
• 

  SQL Server-the difference between heap tables and index tables

  Concept: 1. The storage location of heap table data is random when it is inserted, which is mainly determined by the idle condition of the internal blocks of the database. The data obtained is calculated according to the hit rate, and the data that is not necessarily inserted first can be found when scanning the table. two。 Index table (iot) data storage is to put the

  2022-06-01 18:23:32 Views: 284
• 

  Linux silent installation Oracle 11g tutorial

  Get ready to work and download linux.x64_11gR2_database_1of2.zip and linux.x64_11gR2_database_2of2.zip http://download.orac from your computer

  2022-06-01 18:23:32 Views: 308
• 

  Show blocking SPIDS and SQL

  -- show blocking SPIDS and SQLSELECT Blocked.Session_ID AS Blocked_Session_ID, B

  2022-06-01 18:23:31 Views: 234
• 

  The growth path of DBA-the Foundation of mysql Database Service (1)

  Mysql database service # main configuration file / etc/my.cnf # View service status systemctl status mysqld# database directory / var/lib/mysql # database process name [root@my

  2022-06-01 18:23:31 Views: 270