Online Slave reports 1062 Cases

Online Slave reports 1062 Cases Recently, the online Slave often reported a 1062 error. It broke the ground. Fortunately, Slave has not been used in the business for the time being. That is to say, there is no read/write splitting, so Slave has

Regularly Delete MySQL binary log files

Regularly Delete MySQL binary log files All updates (add, delete, and modify) to the MySQL database are saved to the binary log file of MySQL. With this binary file, we can roll back the database and restore the database. At the same time, the

Two ways to export a table (DMP file) from Oracle

Two ways to export a table (DMP file) from Oracle Oracle exports tables (DMP files) in two ways: Method 1: export using PL/SQL Developer:Menu Bar ----> Tools ----> Export Tables, for example, you can set relevant parameters: Method 2: Use the cmd

MySQL-5.6.x binary version installation record

MySQL-5.6.x binary version installation record I. Operating System installation environment 1. Operating System: CentOS 6.7 x86_64. the preparation process of the basic operating system environment is skipped.2. Binary MySQL version:

How to configure MySQL5.6 Master-Slave in Linux

How to configure MySQL5.6 Master-Slave in Linux The installation of MySQL is very simple compared with that of Oracle. I personally think it is closer to the installation configuration of TimesTen, and the configuration of the Master-Slave or Master-

Use Grid Control to quickly deploy Oracle physical Data Guard

Use Grid Control to quickly deploy Oracle physical Data Guard Grid Control (GC in this article) is a good helper for monitoring and managing databases, and also a double-edged sword. If you are proficient in applications, You can greatly improve the

MySQL views the number of connections and status information

MySQL views the number of connections and status information I. Problem Description Today, I was asked by my O & M colleagues that the number of connections to two MYSQL databases has exceeded the monitoring threshold (700). Of course, their

Solution to Oracle 11gR2 listener startup error in CentOS7

Solution to Oracle 11gR2 listener startup error in CentOS7 An error occurred while starting the Oracle listener: [Oracle @ localhost ~] $ Lsnrctl start LSNRCTL for Linux: Version 11.2.0.1.0-Production on 12-APR-2016 00:27:54 Copyright (c) 1991,200 9,

[PL/SQL series] use dynamic SQL for Oracle stored procedures

[PL/SQL series] use dynamic SQL for Oracle stored procedures I believe everyone knows about the Oracle stored procedure. The following describes how to use dynamic SQL in the Oracle stored procedure. I hope this will help you. Create or replace

Synchronize table data between Oracle and SQL Server

Synchronize table data between Oracle and SQL Server Synchronize some tables in SQLServer2008 to the Oracle database. We can use the linked server and SQLAgent to synchronize data between different database types. Instance 1:SQLServer2008 has a

Profiling oerr commands in Oracle

Profiling oerr commands in Oracle The commands in Oralce are very rich. The oerr command is a good auxiliary tool. Many error codes that do not seem to have an eyebrow purpose can help DBAs quickly identify the cause of the problem, we don't need to

MySQL pressure test tool-mydbtest

MySQL pressure test tool-mydbtest PrefaceThis article introduces mydbtest (mydbtest_linux64.bin, compiled by Lou Fang Xin Da Niu), a tool for database stress testing without installation ). this stress testing software is different from common

Automatic parallelism in Oracle 11gR2

Automatic parallelism in Oracle 11gR2 In Oracle 11.2.0.2, automatic parallelism can be used only when I/O statistics are collected. When parallel_degree_policy is set to auto, the Oracle database determines whether to use Parallelism Based on the

MySQL slow query methods

MySQL slow query methods For troubleshooting and identifying performance bottlenecks, the most common problems are slow queries in MySQL and queries that do not have to use indexes. ========================================================== =========

Oracle password expired the password has expired Solution

Oracle password expired the password has expired Solution Oracle encountered the password has expired problem. Today, it suddenly found that the project could not be accessed. If it could not be used, it could not be accessed. This problem was

Install Redis in CentOS6.4

Install Redis in CentOS6.4 First, we will introduce the Redis database. Redis is a memory database for "key/value" pairs of data types, which can meet our needs for reading and writing massive data.1) redis keys can only be strings; 2) redis values

Virtual indexes for Oracle Performance Optimization

Virtual indexes for Oracle Performance Optimization A virtual index is a pseudo index defined in the data dictionary, but there is no relevant index segment. The purpose of a virtual index is to simulate the storage of indexes, instead of creating a

MySQL force operation and order by usage

MySQL force operation and order by usage We use hint commonly used in MySQL for detailed parsing. If you use Oracle frequently, you may know that Oracle has many hincvt features and provides many methods to optimize SQL statements. Similarly,

Use RMAN Incremental backup to update the transmitted tablespace

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

MySQL5.5.32 compilation and Installation

MySQL5.5.32 compilation and Installation MySQL IntroductionMySQL is a relational database management system developed by MySQL AB in Sweden. It is currently a subsidiary of Oracle. MySQL is the most popular Relational Database Management System. In

Total Pages: 1013 1 .... 61 62 63 64 65 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.