Database Administrator

MHA configuration file sample description Similar to most Linux applications, the correct use of MHA depends on a reasonable configuration file. MHA configuration file and mysql my. the cnf file configuration is similar. The configuration file is

CentOS MySQL user and database management manual 1. Maintenance of the root user password: After MySQL is installed, MySQL automatically provides a root user without a password. To ensure security, set the password for the root user: # Mysqladmin-u

Oracle Database Bad blocks-Physical Bad blocks Overview ------------- The types of Bad blocks in the database can be divided into Bad blocks of user data, Bad blocks of Data Dictionary, Undo Bad blocks, and bad blocks of control files according to

How can I lose weight for your database transaction logs? In most SQL Server work environments, especially in OLTP environments, when the transaction log performance of the database encounters a bottleneck, it usually takes more time to complete

Simple Steps for migrating from MySQL to MariaDB on Linux Hello everyone! This is a tutorial on how to migrate from MySQL to MariaDB on a server or PC. You may ask why we want to migrate database management from MySQL to MariaDB. Let's look at why

12 C ORA-27106 error handling process, 12cora-27106   Two days ago, the customer Exadata 12c Environment reported an error due to memory allocation. The following is the processing process.   An error is reported when the node is restarted, but

MYSQL binary installation + XFS, mysqlxfs1. Prepare partitionsYum install xfsprogs[Root @ ycdatadbsupport yum. repos. d] # mkfs. xfs-f-I attr = 2-l lazy-count = 1, sectsize = 4096-B size = 4096-d sectsize = 4096-L data/dev/sdbMeta-data =/dev/sdb

The difference between the database trigger deleted and inserted data: deletedinserted Differences between deleted and inserted dataInsertedStore data after insert and update operationsDeletedStore data before the delete and update operationsNote:

SQL statement learning, SQL statements Exercise for one table 1. Create a table create table student(name Char(20),curriculum Char(20),score Char(20)); Insert data: Insert into student (name, curriculum, score) VALUES ('wang wu', 'mat', '123 ');

Ubuntu PostgreSQL User Guide, ubuntupostgresqlInstall sudo apt-get install postgresql postgresql-contribapt-cache search postgresServer Settings After installation, you must first change the postgres user password and first enter the postgres

Oracle Installation check if the DISPLAY variable is set error, oraclevariable Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held

Database Tuning tutorial (5) Roles of indexes and types of indexes, tuning IndexesIii. Index In the previous chapter, we learned how to use explain to generate a query execution plan (QEP), so as to discover problems with the statement. Three

LeetCode Second Highest Salary, leetcodehighest Write a SQL query to get the second highest salary fromEmployeeTable. + ---- + -------- + | Id | Salary | + ---- + -------- + | 1 | 100 | 2 | 200 | 3 | 300 | + ---- + -------- + For example, given

Database optimization tutorial (7) cost and cost of INDEX OPTIMIZATIONIii. Index 4. index costThe previous sections introduced the power of indexes in improving performance and how to use indexes. However, indexes also have overhead. 1) disk space

Mysql installation, start mysql service, connect local database and remote database, mysql remote I have taken a company project and I have to use mysql. Let's take a look ~! 1. Install mysql Download one from Baidu mysql.Pay attention to the

Database optimization tutorial (12) Optimize SQL statements and optimize SQL statements5. Optimize SQL statements The previous chapter describes how to design a good table. A good table naturally requires a good SQL statement to operate on it. This

Use yum in centos to install mysql and centosyum to install mysqlReference Article address: http://www.cnblogs.com/xiaoluo501395377/archive/2013/04/07/3003278.html Speaking of databases, we mostly think of relational databases, such as mysql, oracle,

Connect java to mysql database and javamysql Database 1. First download the mysql installation package, download the link mysql, and then install. 2. Enter the username and password for installation to connect to the database. 3. Install the mysq

Examples of importing and exporting Oracle databases in common/Data Pump Mode in Windows/Linux environments, oraclelinux1 Linux normal export/import1.1 terminal ExportExp naricom/naricom@10.185.3.100/SGTMS owner = '('MW _ app, mw_sys, statdba,

Unused database indexes found To ensure quick access to data, like other relational database systems, SQL Server uses indexes to quickly search for data, SQL Server can create different types of indexes, such as clustered index, non-clustered index,