Database Administrator

PL/SQL smart call stack Analysis PL/SQL smart call stack Analysis The three DBMS_UTILITY functions(DBMS_UTILITY.FORMAT_CALL_STACK, DBMS_UTILITY.FORMAT_ERROR_STACK, and DBMS_UTILITY.FORMAT_ERROR _ BACKTRACE) have been crucial aids in diagnosing and

Use sysbench for MySQL stress testing 1. Background Percona is a multi-threaded system stress testing tool that can evaluate the system performance based on various factors that affect the performance of database servers. For example, it can be used

Case study of MySQL startup failure data recovery Forcing InnoDB Recovery provides six levels of repair mode. Note that when the value is greater than 3, the data file will be permanently damaged and cannot be recovered. The six levels are excerpted

Logrotate implements MySQL slow log Segmentation MySQL slow log? The slow query log of MySQL is a log record provided by MySQL. It is used to record the statements whose response time exceeds the threshold value in MySQL, specifically the SQL

Oracle SQL Tuning Health-Check (SQLHC) The performance of an SQL statement mainly depends on good physical structure, accurate system statistics, accurate object statistics, reasonable query optimizer parameters, and reasonable system parameters.

Install the Oracle client on Ubuntu There are a lot of graphical tools on the Ubuntu Desktop to connect to the Oracle database, such as DBeaver, but sometimes you still need to connect to the remote database through sqlplus, then you need to install

Use RMAN Incremental backup to update the transmitted tablespace To use RMAN Incremental backup to update the transmitted tablespace, you need to understand the Incremental backup of the transmitted tablespace and RMAN. Here we will mainly introduce

How to use scripts to quickly deploy MySQL and deploy one machine and multiple instances MySQL has three versions: binary, source code package, and RPM. The following describes how to install a binary package. : Http://dev.mysql.com/downloads/mysql/

Data Processing-PostgreSQL process Language Learning Some time ago, when the company switched to the new PostgreSQL data mart system, it downloaded the postgresqlAPI PDF file to study the PostgreSQL data mart. I found that using PostgreSQL process

SunlightDB 2017 new blockchain database, sunlightdb2017 What is blockchain? Since last year, the concept of blockchain has been gaining popularity, especially in developed countries. Blockchain has also become the name of a revolution, and has

Application of Go in codoy database middleware and go codoy Middleware Author: Liu Yanyun This article mainly focuses on Go's database middleware application. First, we will talk about the application development requirements. For details, we will

Mainstream database of deep learning | MySQL basics, mainstream mysql Beijing | deep learning and AI Training December 23-24 Review deep learning with the classic course > The body contains 4732 words and 21 images. The expected reading time is 12

Detailed description of SQLite3 binding function family usage and precautions; sqlite3 binding Preface The code displayed in this article is actually how to use the parameterization mechanism of Sqlite3 to insert data or update the data. It depends

Ten Suggestions for improving database speed and Ten Suggestions for database Learning Important information of many websites is stored in the database. Users can obtain user information by submitting and accessing the database. If the database

Easy-to-use PL/SQL Developer settings, pldeveloperSome time before the easy-to-use PL/SQL Developer settings, the company trained pl/SQL related knowledge internally. Here I will share my settings that I think are very convenient. 1. When PL/SQL

Batch update names separated by commas (,) (multiple IDs separated by commas (,) in a department are converted into names separated by commas (,) (mysql) and comma (,) mysqlUpdate dept B, (select group_concat (t. deptId), group_concat (d. deptName

Failed to attach database to server XXX, failed to attach database xxx I recently learned MVC + EF and watched the video for a small demo. EF needs to be connected to the database. The example in the video is quite similar to that in the previous

Fault case: slave latency is high, and slave latency is Case 1: lvm model. After the slave database is created, the qps of the master database is 2 w and the slave database is more than 6 K. The latency increases slowly from a certain point in time

SQL Server Batch processing (Batch Requests/sec) high tracking processing, batchrequests Recent observations showed that the number of Batch processing Requests per second (Batch Requests/sec) of a database often increased for a long time, several

MySQL Optimization-permission management and mysql permission management Reprinted please indicate the source: http://blog.csdn.net/l1028386804/article/details/46763767 In the mysql database, the mysql_install_db script initialization permission