NAV: SLTechnology News&Howtos > Database >

• 

  MySQL 5.6 multiple instances of the same physical host configuration

  1. Plan directory to create a software directory. Multiple instances share a software directory [root@localhost ~] # mkdir / mysql_software_56 single instance source code installation process can refer to MySQL 5.6 source code compilation and installation process

  2022-06-01 06:10:02 Views: 221
• 

  Oradebug command usage of oracle

  0 > oradebug use step 1) start sql*plus and log in as sysdba 2) connect to a process 3) set an event or perform a diagnostic dump 4) retrieve the trc file name 5) disconnect from the connected process 1 > what is available for oradebug

  2022-06-01 06:10:02 Views: 283
• 

  Point-in-time based recovery

  1. Copy the binlog of the old library to the recovery library (be careful not to overwrite the log of the new library) 2. Parse the binlog to find out the time point of at: mysqlbinlog-vv mysql-bin.000001:# at 353501605

  2022-06-01 06:10:02 Views: 229
• 

  ORA-39001: invalid argument value data pump import report error due to inconsistent version

  Because the dmp file is exported from 11g oracle and imported into 10g oracle. Caused by inconsistencies in the version of oracle. [oracle@oracle-test ~] $impdp oracle/oracl

  2022-06-01 06:10:02 Views: 218
• 

  Use python to operate mysql database (code classification)

  Index.py, just assume a simulated login #-*-coding: utf-8-*-"" Created on Sun Nov 27 18:54:29 2016 this is the main program file @ author: to

  2022-06-01 06:09:59 Views: 269
• 

  PostgreSQL DBA (60)-zedstore for determinant storage

  This section briefly introduces the installation and use of Greenplum open source column storage zedstore. Download the source code from Github. Like ordinary PG, you can compile and install [root@localhost postgres-zedstore].

  2022-06-01 06:09:57 Views: 276
• 

  SQL Performance Analyzer practical operation

  1. What is SPA (SQL Performance Analyzer)? SPA (SQL Performance Analyzer) is Oracle's SQL performance optimization analyzer. Oracle Database

  2022-06-01 06:09:57 Views: 294
• 

  Empower data-the cutting edge technology of Tencent TDSQL distributed financial-level database

  6 Thank you for the establishment of the project in Tencent, and the research content and implementation process have been participated and supported by the key Laboratory of data Engineering and knowledge Engineering of the Ministry of Education of Renmin University of China and Tencent, especially to the participants and supporters of the project. To contribute to the project from the perspectives of thinking, concept, technology, etc.

  2022-06-01 06:09:56 Views: 231
• 

  Alink,Blink, the first mass stream integrated machine learning platform in the world, has all the functions contributed to Flink.

  Since January 2019, Alibaba has gradually returned the internally maintained Blink to the Flink open source community, and has contributed more than 1 million lines of code. Domestic including Tencent, Baidu, Byte Jump and other companies, foreign companies including Uber, Lyft,

  2022-06-01 06:09:56 Views: 242
• 

  PostgreSQL DBA-pgAdmin (pg_dumpall vs pg_dump)

  This section describes the logical backup tools pg_dumpall and pg_dump in PostgreSQL. Pg_dumpall and pg_dump are both logical backup tools provided by PG. As the name implies, pg_dumpall can dump all

  2022-06-01 06:09:56 Views: 295
• 

  Optimizer cost record table | all-round understanding of mysql system library

  In the last issue of "Statistical record Table | Omni-directional understanding of mysql system Library", we introduced in detail the statistical information record table in mysql system library. In this issue, we will bring you the fifth article in the series "Optimizer cost record Table | Comprehensive understanding of mysql system Library". Please

  2022-06-01 06:09:56 Views: 281
• 

  Summary of some New Features of ORACLE 12C Optimizer (2)

  The Oracle 12c database does make a lot of progress in terms of optimizer. Among the many features of Oracle 12c database, adaptive query optimization is a big change. It enables the optimizer to adjust the execution plan in real time. When the available statistics are not enough to produce

  2022-06-01 06:09:48 Views: 241
• 

  Three difficult problems in microservice business development-split, transaction, query (part I)

  Micro-service architecture is becoming more and more popular. It is a method of modularization. It splits a whole application into services. It allows teams to deliver high-quality software faster when developing large and complex applications. Team members can easily accept the new technology because they can use the latest and recommended

  2022-06-01 06:09:44 Views: 223
• 

  Set up mysql cluster under Centenos7.4-mysql master and master backup each other, and keepalived is highly available

  Build mysql + keepalived environment 1. Environment preparation system: Centenos7.4mysql version mysql-5.7.26-linux-glibc2.12-x86_64.tar.gzkeepaliv

  2022-06-01 06:09:44 Views: 257
• 

  Research on modifying character set to AL32UTF8 by Oracle 12C

  There is a question: can the PDB character set be changed from ZHS16GBK to AL32UTF8? Answer: because CDB is ZHS16GBK, PDB cannot be modified. Make a study on this problem and write it down. 1. The method of migrating and converting character set: 12C:

  2022-06-01 06:09:44 Views: 215
• 

  A bloody case caused by a long transaction-- the handling of blocking failure caused by the rollback failure of Informix long transaction

  Note: to increase the logic log, be sure to read the following command clearly, do not increase according to inertia! Onparams-a-d llogdbs-s 500000-I original text http://www.cnblogs.com/haoxiaobo/

  2022-06-01 06:09:43 Views: 204
• 

  MySQL read-write separation amoeba&mysql-proxy

  -master-slave synchronous introduction to refencen https://www.cnblogs.com/lin3615/p/5684891.html1. There are two ways to separate reading and writing here, one is to use mysql-proxy, one

  2022-06-01 06:09:38 Views: 291
• 

  SQLServer queries all database sizes

  With fsas (select database_id, type, size * 8.0 / 1024 sizefrom sys.master_files) selectname, (select c

  2022-06-01 06:09:37 Views: 219
• 

  From sorting principle to sorting method in MYSQL

  This article refers to the MYSQL official documents, algorithm books, part of my own point of view may be wrong, if there is a mistake, please point out the joint discussion reprint, please explain the source, thank you! 1. Sorting algorithms that may be used in MYSQL sorting MYSQL uses BUFF from the interface between MYSQL official documents and source code

  2022-06-01 06:09:33 Views: 285
• 

  Data recovery Analysis of Common faults in oracle Database

  1. Oracle cannot work after startup or the database cannot be started. Once the database fails to start, you first need to check whether the system table is in an uncorrupted state. Generally speaking, if the system table is not corrupted, it is easy to recover the data. If syste

  2022-06-01 06:09:32 Views: 274