Database Administrator

Use mysqldump command line tool to create logical backup The mysqldump command creates a logical backup, and the result set has two formats: one is to convert data into standard SQL statements (a bunch of CREATE, DROP, INSERT, and other statements ),

SQL Server database startup and user database Loading Preface This article is a supplement to the previous article. In the previous article, we introduced some problems and solutions encountered during the SQL Server service startup process. Click

Solve the Problem of connecting Qt to PostgreSQL in Ubuntu I encountered a problem yesterday and had not solved it for a day. Today, I suddenly solved it. The problem is: in Windows, you need to manually compile the PostgreSQL driver in the Qt

Oracle GoldenGate ctor configuration Manual 1. Introduction to GoldenGate ctor GoldenGate ctor simplifies the monitoring and management of GoldenGate. You can use a graphical interface or a web browser to conveniently and quickly maintain the

MySQL slow Query The slow query (slow log) helps us locate specific SQL statements for SQL statement optimization. For example, the slow query log records the SQL statements whose execution time exceeds the given value, locate the problem. Enable

Build and install 12C RAC Based on Workstation8 and CentOS6.5 Author: HopToadLocation: Binjiang, HangzhouEmail: appdevzw@163.comjPublic Account: HopToadWelcome from all walks of lifeDecember 20141 preparation condition 1.1 hardware version One home

Database Optimization-create and classify Oracle table partitions When the amount of data in a table increases, the speed of data query slows down, and the performance of applications degrades. In this case, you should consider partitioning the

Getting started with Linux: Installing phpMyAdmin on CentOS Problem: I am running a MySQL/MariaDB service on CentOS, and I want to use phpMyAdmin to manage databases through network interfaces. What is the best method for installing phpMyAdmin on

"You cannot connect to the WMI provider. You do not have the permission or the server cannot access it. ", Wmi cannot be accessed 　　 I recently learned about PowerDesigner and encountered a small problem when I created the PDM model. I thought I was

How to disable the deadlock process in PostgreSQL, postgresql Process The PostgreSQL database used has no information. Google had to proceed. Finally, a solution was found in an English forum. As follows: 1. Retrieve the ID of the deadlock

Redis performance problems and Redis performance problems Redis may cause performance problems and provide corresponding solutions. 1. Blocking of snapshot writing Solution:   2. AOF Problems Solution: 3. Memory bottleneck If the

Linux mysql regular backup and compression, linuxmysql1. Check whether the mysql BACKUP command works. Create a backup directory under the var directory and a mysql directory under the backup Directory to store mysql backup files Cd to

Correct the request for modifying the NLS_LENGTH_SEMANTICS parameter of the database. nlslengthsemantics1. developer error requirements First, let's look at an email that a developer asked a DBA to modify the NLS_LENGTH_SEMANTICS parameter of the

MySQL Workbench query timeout time out (Lost Connection) solution, mysqlworkbench When using MySQL Workbench for query, if the query statement or table is too complex and the query time is too long (generally 600 s), the Lost Connection error is

A Simple and Easy join method for complex multi-data source reports to be computed after join Complex data sources are common issues in report development. For example, join operations are performed on different database tables before filtering and

Navicat for MySQL powerful MySQL management tool in Windows, navicatmysql Author: zhanhailiang Date:Introduction Navicat for MySQL [is a powerful MySQL database management and development tool that provides professional developers with a powerful

[Learning MongoDB step by step]-Brief Introduction to MongoDB (1), brief introduction to mongodb In the previous blog, we spoke about NoSQL. We have a comprehensive understanding of NoSQL. Starting from this blog, we will take everyone into the

Mysql modifies columns, adds columns, deletes common column commands, and mysql commands Alter table: add, modify, and delete TABLE columns, constraints, and other TABLE definitions. View column: desc table name; Alter table t_book rename to

ORA-31693, ORA-02354 and ORA-01555 with Export Datapump (Doc ID 1580798.1), ora-31693datapump The following error is returned from the development email: ORA-31693: Table data object "YCDATA ". "T_MESSAGESYNC_HIS" failed to load/unload and is being

Cloud computing architecture technology and practices: 4.6 database cloud, cloud Database Copyright. Do not repost or forward it without the written permission of Huawei. 2.4.6 database cloud The database cloud solution is based on the overall