Database Administrator

How to quickly compare the data on two different MySQL instances and find the difference In MySQL O & M, R & D colleagues want to compare the data on two different instances and find out the difference. In addition to the primary key, they also need

Undotbs01.dbf file too large solution Reduce the size of the UNDOTBS01.DBF file in the Oracle directory Log on to Oracle using the sys userMethod 1: reset the tablespace size Run Alter database datafile '/opt/oracle/oradata/res/undotbs01.dbf' RESIZE

The simplest MySQL tutorial in history (40) "database variables 」, Tip: This series of blog posts have been synchronized to GitHub. The address is "mysql-tutorial". Thank you for your interest.Star,Fork, Error correction. Variable In the MySQL

It is unknown that the connection has expired. If a Client requests a connection, providing the Connection to the Client will cause the above exception. 8 hours in idle status.;Set global wait_timeout =; Mysql> show variables like '% timeout % ';+ -

Share a self-written mysql automatic backup script, timed execution settings, and windows automatic FTP. Please advise. Prerequisites: vsftpd is enabled on the mysql database server, and an appropriate account is configured for FTP Step 1: Compile

Generally, MySql database backup can be performed in two ways: Exporting SQL statements directly or SQL storage files in other formats that are easy to import, using SQL statements or some visual clients to export data, this method is very simple

Mathematical functions 1. Absolute Value S: select abs (-1) value O: select abs (-1) value from dual 2. INTEGER (large) S: select ceiling (-1.001) value O: select ceil (-1.001) value from dual 3. Smaller values) S: select floor (-1.001) value O:

BKJIA database channel recommends the Oracle database debugging and performance optimization topic for you to better understand this article. The basic Oracle performance optimization methods include: 1) set up reasonable Oracle performance

Deadlock) refers to the state in which processes are permanently blocked. SQL can detect deadlocks and terminate a transaction to intervene in the deadlock State. A typical example of A deadlock between two processes is: Obtain lock A in process T1

Before OMF (managed files) is available, the database administrator needs to care about two issues when creating data files. The first is what kind of name should be taken for this data file, and the second is to consider whether the newly created

Introduction: After designing your database step by step, I have received some emails and a friend calls me directly to ask why it does not contain the physical design of the database.I will explain it hereThe physical design of databases is closely

Careful use of variables and the storage space it occupies can effectively reduce the resources consumed by an application, while also comprehensively improving its performance. Improper calling of Windows application interfaces may lead to

Oracle Database 10 Gb provides a tool for significant improvement: Automatic workload information library (AWR ). AWR is installed with the database to collect statistics and export metrics. Fast driver testing By running the awrrpt. SQL script in

I. Runtime Environment SQL> select * from v $ version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-ProdPL/SQL Release 10.2.0.1.0-ProductionCORE 10.2.0.1.0

Date and time functions are very useful for creating a site. The website owner is often interested in when data in a table is updated. Using Date and Time Functions, you can track changes to a table in seconds. The DATE and TIME types are DATETIME,

High Availability is a key requirement for important database applications. IBM DB2 9.5 provides many features to meet this requirement. If you are not familiar with DB2 on the distributed platform, or have been using it for a while, you may find

In the Oracle database system, there are two authentication methods for a user to log on to the Oracle database as a privileged user: that is, authentication is performed using the Integrated Identity Authentication with the operating system or

There are many tools for Performance monitoring. First, we will introduce the Performance Monitor provided by Microsoft Windows Server. windows performance monitor is a very useful tool that can check the ways in which running programs affect

MIS Management SystemIt is also a very practical management system, which can put a lot of things in order to facilitate your search. Next we will take the CD and VCD in your family as an example, we will introduce how to establish a MIS Management

Many developers want to be a DBA, and many people first position themselves as a DBA. What knowledge and skills do DBAs need to master? Below are my During DBA work and interviews with DBAs, there were thirty questions about DBAs. Among the thirty