Database Administrator

MariaDB beginner management commands Earlier, we learned to install the MariaDB server on CentOS/RHEL 7 (SEE), which is now the default database of RHEL/CentOS 7. Now we will discuss some useful MariaDB management commands. These are some very basic

How to install Oracle 11gR2 in Ubuntu 16.04Overview Ubuntu: ubuntu-16.04.3-desktop-amd64 Oracle: linux. x64_11gR2_database ------------------------------------------ Split line ------------------------------------------ Related File Download

Online MySQL backup script Recently, I am studying database backup and regularly execute the backup task. Here I set the backup script to the crontab command for regular execution. The script content is as follows:[Root @ mysql-db ~] # Cat

The method for connecting to the PostgreSQl database by using Abp. nhib.pdf, You can connect to the PostgreSQl database using the dynamic library of Abp. nhib.pdf. The specific content is as follows: When I first came into contact with the Abp

Simple springboot example and springboot example 1. What is spring boot? Takes an opinionated view of buildingproduction-ready Spring applications. Spring Boot favors convention overconfiguration and is designed to get you up and running as quickly

SQL server permission management and SQL server permission management1. Set a Logon account to view only some databases Refer to tn view any database PermissionsUse sp_addlogin to create a login name-Basic: User Logon account-Basic123456: User Logon

Use SQL scripts to import data to different databases to avoid duplication. Preface I believe everyone has some experience. No matter what language, once you see repetitive code in the code, you want to encapsulate it for reuse. This is also true

• Description of DML and restored data generation • Monitoring and Management of restored data • Description of differences between restored data and redone data • Configuration of restoration retention time • guaranteed restoration retention time •

How to Understand oracle 11g scan ip Before 11.2, the client should use vip when connecting to the database. If your cluster has four nodes, the client's tnsnames. in ora, there should be a connection string of four vip hosts. If a node is added to

'Db file scattered read' is another common wait event. It is generated when Oracle reads multiple blocks from the disk to the non-sequential ("") Cache of the Buffer Cache. The maximum read value is3. because the blocks that use full table scan and

For example, if you have such a requirement, a table named User_Salary contains the UserName of each user) Calculate a result set: the sum of the salaries and accumulated salaries of each person per month, as shown in the following table.

I didn't want to write such a simple article. I searched for my title on Baidu, which is totally in line with the title. However, I have been following these articles for a long time, but I cannot. My environment: MySQL: mysql-essential-5.1.51-win32

I. Solve the Problem of ORA-07445 downtime in Oracle 9.2.0.6 Database Fault symptom: XX network database goes down. view the log and find the following content: Wed Jun 8 20:24:17 2005Errors in file

I. INSERT and REPLACE Both INSERT and REPLACE statements INSERT new data into the table. The syntax of these two statements is similar. The main difference between them is how to process repeated data. 1. General INSERT usage The INSERT statement in

MySQL supports unidirectional and asynchronous replication. One server acts as the master server during the replication process, and one or more other servers act as slave servers. The master server writes updates to the binary log file and

When you create a session with Oracle, a dedicated sorting area is located in the server memory to provide the sorting space for the session. However, this sorting space is limited. If the number of records exceeds this sorting space, disk sorting

BKJIA exclusive Article] WEB developers not only need to solve program efficiency problems, but also need to quickly access the database and respond accordingly. I hope this article will help you master the MySQL optimization skills. 1. Optimize

Deduplication and data compression can greatly reduce data storage performance requirements and reduce data backup by more than 90%. Reducing backup data can reduce hardware and management costs. However, small and medium-sized enterprises and

I. Purpose Previously, in the blog post SQL Server database minimal downtime migration solution, we mentioned that the full backup + differential backup feature has been used to complete database transfer, however, this method is obviously not

This article describes several basic strategies for optimizing the DB2 database. 1. Create an index for the tables used in the future (note that the index is created before data insertion or after data insertion but runstats is required ): Note: if