NAV: SLTechnology News&Howtos > Database >

• 

  Oracle Statistics (1)

  Summary of statistical information Statistical information is mainly a kind of information that describes the size, scale and data distribution of tables and indexes in the database. For example, the number of rows in the table, the number of blocks, the average size of each row, the leaf blocks of the index, the number of rows in the index field, the size of different values, etc., all belong to

  2022-06-01 06:31:01 Views: 298
• 

  PostgreSQL A SQL triggers the system out of memory

  Error description (1) original SQL:select COALESCE (m1.place_id, m2.place_id, m3.place_id) as place_id, concat_w executed by Postgres

  2022-06-01 06:31:00 Views: 296
• 

  Key process of MySQL Group Replication mgr installation

  1. Initialize and start mysql/bin/mysqld-- initialize-insecure-- basedir=/mgr/mysql-- datadir=/mgr/data/s1mysql/bin/

  2022-06-01 06:31:00 Views: 276
• 

  Administration (003): keep administrator passwords synchronized with data dictionaries

  If you change the REMOTE_LOGIN_PASSWORDFILE initialization parameter from none to exclusive or shared, you must ensure that the password stored in the data dictionary and the non-sys administration stored in the password file

  2022-06-01 06:31:00 Views: 270
• 

  [MySQL] deadlock case 3

  Deadlock is actually a very interesting and challenging technical problem, which probably every DBA and some developer friends will encounter in the course of their work. I will continue to write a series of case studies on deadlocks, hoping to be helpful to friends who want to know about deadlocks. II background knowledge 2.1

  2022-06-01 06:30:56 Views: 245
• 

  Technology Life Series the Story of me and the data Center (issue 4)-Parameter reminders that lead to Oracle performance jitter

  Preface unwittingly, the story of me and the data center in the technology life series has come to the fourth issue. Little y to see you again! When you see the following wavy tps curve in the business system stress test, how do you do it? What Xiao y (Zhongyi Technology) wants to share with you today is such a business system pressure.

  2022-06-01 06:30:52 Views: 237
• 

  The phenomenon of garbled codes in mysql and the understanding of character set

  Database version is 5.7.17 phenomenon when 1Navicat Premium imports sqlserver data to mysql, it is found that some tables only import table structure without importing data, some tables import part of data, and some table data import successfully find reasons: 1. Discovery guide

  2022-06-01 06:30:44 Views: 244
• 

  SQLServer2012 adds a mirror database without a witness

  1. Back up the master database and restore it to the standby database (restore mode NORECOVERY) 2, back up the master database log and restore it to the standby database (restore mode NORECOVERY) 3, and add the mirror database to the master database to complete the mirror database configuration.

  2022-06-01 06:30:44 Views: 268
• 

  Common methods of killing conversations in MySQL

  This article mainly introduces four methods to kill MySQL connections in batches. Code examples are given in this paper. Friends who need them can refer to method 1. Generate the connection information that needs to be disposed of through the connection information in the information_ schema.processlist table.

  2022-06-01 06:30:44 Views: 258
• 

  2009-05-31 MySQL 06-02 Learning Notes 04

  1. Database name in the file system, the datastore of MySQL represents the MySQL database as a directory, so the database name must be the same as the directory name. Database names that contain special characters or consist entirely of numbers or reserved words must be quoted with the symbol "`". Mysql > cr

  2022-06-01 06:30:41 Views: 249
• 

  PostgreSQL on Linux installation, deployment and basic use

  ◆◆ PostgreSQL installation and deployment ◆◆ preface: Postgr is used in the project

  2022-06-01 06:30:41 Views: 292
• 

  The use of RMAN (7)

  15. Full recovery in non-archived mode recovery in non-archived mode may be a complete recovery or incomplete recovery. If the online redo log is overwritten, it is more likely that only incomplete recovery can be done. Parameter file is missing 1. Control the recovery of lost files, data files, and online redo log files

  2022-06-01 06:30:41 Views: 265
• 

  [dbms_xplan package] the difference between ALL and ADVANCED + PEEKED_BINDS in comparative tests

  Conclusion: 1. ADVANCED has only one more Outline Data than ALL. 2. ADVANCED + PEEKED_BINDS shows one more Peeked Binds than ADVANCED (identified).

  2022-06-01 06:30:40 Views: 203
• 

  Mysql5.6 single instance installation (binary)

  1. Download the binary installation package mysql-5.6.39-linux-glibc2.12-x86_64.tar.gztar-xvf mysql-5.6.39-linux-glibc2.12-x86_64.tar

  2022-06-01 06:30:40 Views: 267
• 

  MySQL 5.5Creating stored procedures and functions

  CREATE ROUTINE permission is required to execute CREATE PROCEDURE and CREATE FUNCTION statements. View neo user existing permissions authorization mysql > grant create routine on f

  2022-06-01 06:30:36 Views: 289
• 

  Excellent SQL Encoder growth and Advanced Route

  Learning is a process of not advancing or falling behind, not with rhythm, but with facts. For engineers at a higher level, the difficulties they need to overcome, the books they read and the paper they read will deepen step by step. For example, when you are still reading the database implementation, people are already studying the principle and implementation of distributed storage. You said no.

  2022-06-01 06:30:33 Views: 266
• 

  OGG4DB2 for IBM i PURGEOLDEXTRACTS not working

  Set PURGEOLDEXTRACTS in OGG4DB2 for mgr, but does not clean up the corresponding historical trail data. After inspection, it is found that the trail data set by PURGEOLDEXTRACTS

  2022-06-01 06:30:32 Views: 214
• 

  A simple Optimization Analysis of left join SQL

  There is an associated query sql that takes more than 2 seconds, so check it out: SELECT a.id, a.brand_id, a.series_id, a.produc

  2022-06-01 06:30:32 Views: 297
• 

  [giant sequoia database Sequoiadb] is it possible to upgrade the entire sdb cluster as long as you upgrade the machine where sac resides?

  [problem description] does a multi-node upgrade require an upgrade on each machine, or only the machine on which SAC is installed? [solution] 1. No, every machine in the cluster needs to be upgraded; 2. V3.2 upgrade command, such as. / sequoiadb-3.2-linux_x

  2022-06-01 06:30:32 Views: 237
• 

  Several methods of executing sql statement in Shell script to operate MySQL Database

  The experiments are as follows: [root@idb1 ~] # more / etc/issueCentOS release 6.5 (Final) Kernel\ r on an\ mmysql > show variables

  2022-06-01 06:30:32 Views: 264