Database Administrator

The Helper house sorted out several methods circulating on the Internet to crack the mysql root Password: Method 1 Use phpmyadmin, which is the simplest. Modify the user table of the mysql database, but do not forget to use the PASSWORD

1. Oracle has two ways to connect to the database: local or remote. When you log on to the database server, set Oracle_SID, and no longer connect to the database specified in $ sqlplus system in the string, use a local connection. The local

Sometimes the database is damaged due to power loss or other reasons. We can use the MySQL command to quickly fix all databases or specific databases. For example Check to optimize and fix all databases: # Mysqlcheck-A-o-r-pEnter password:Database1

I wrote a script to check whether the SLAVE of MySQL REPLICATION is normal in Linux, which is relatively simple.If you want to run it with CRONTAB, remove the Read part.1. Run the MYSQL Command show status to View Script 1.[Root @ localhost ~] # Cat

The official MySQL 5.1 version has not been released yet. I am waiting for it to wait for its table partition function. With this function, a table will be easily solved because of the large amount of data that seriously affects the speed. Table

To install MySQL in Linux, I only install the SERVER Installation Package and CLIENT installation package. This is sufficient for normal use, but it is necessary to open and release the database in Linux, you also need to install a software package:

As part of Oracle's smart infrastructure, Oracle's 10 Gb automatic load database can work with the automatic database diagnostic monitor to help database administrators diagnose and fix performance problems. In the description of smart

Download and

A one-to-multiple table is usually associated with the primary key of another table. However, there are also some unusual situations, that is, two tables are not joined by the primary key of one of the tables. For example: Create table t_team(Tid

The mysql official website began releasing various versions of the 5.6 series starting in May,. the mysql series versions have been comprehensively refined, the following is a sharing record of the mysql5.6.10 source code installation process

Recently, some netizens are not very clear about the automatic memory management feature of Oracle SGA, probably because the automated management of Oracle 10g SGA translated at that time was quite cool, the following is still a description of this

We know that there are two types of Oracle block clearing: 1: fast commit cleanout ); 2: delayed block cleanout ); There is an overhead space (overhead) at the beginning of the database block, which stores a transaction table for the block. For each

1. Common Database types include SQLServer, MySql, IBM DB2, and Oracle. 2. DBPwAudit database password cracking tool 1) function: Performs brute force password cracking on the target database by attaching a dictionary. Currently, the supported

The first time I configured mysql in Linux is really tortuous, so I would like to recordStep 1: download and install MySQLTerminal input: sudo apt-get install mysql-server mysql-clientStep 2: confirm the address of the MySQL hostTerminal input:

Temporary tables: they are structured like normal tables, but managed differently. Temporary tables store intermediate result sets of transactions or sessions, the data saved in the temporary table is only visible to the current session, and the

The recent data import (IMP) encountered a ORA-01187 ORA-01110 error because the database was restored with hot standby, and the recovery was successful because the database was successfully open, so where are the omissions? If you have a similar

Percona_Toolkit Percona Toolkit Introduction: (from the official introduction) Percona Toolkit for MySQL is a collection for advanced command-line tools userd by Percona MySQL staff to perform a variety of MySQL server and system tasks that are too

Describes the process of installing Oracle10201 on AIX. First, check whether the system meets the database installation requirements: #/Usr/sbin/lsattr-E-l sys0-a realmem Realmem 32604160 Amount of usable physical memory in Kbytes

Environment setup Machine descriptionMaster 190: 192.168.1.190 (enable binlog, server-id = 1)Slave 191: 192.168.1.191Slave 192: 192.168.1.192MySQL 5.5.29 and Percona XtraBackup 2.06 are installed on all the above three machines. Create a new Slave

It's not really good to read the doc carefully. SQL> shutdown immediateThe database has been closed.The database has been detached.The Oracle routine has been disabled.SQL> startup mountThe ORACLE routine has been started. Total System Global Area 10