Database Administrator

Phpmyadmin: no score. Download it now! Http://download.csdn.net/detail/u011986449/7429799 1. find/libraries/config. default. PHP file (config. default. copy php to the phpmyadmin directory and rename it config. inc. php), the file has the following

This is the third article on MySQL SQL optimization. A company's business system frequently throws a problematic SQL statement. We have made fundamental statistics on such SQL statements: These SQL statements have been executed for 12 times

Using Oracle PL/SQL code encryption to protect the business logic is very useful in some scenarios. The following is a simple arrangement: 1. Use the Wrap command to encrypt 2. Use the dbms_ddl package for encryption Iii. Oracle encryption

1. knowledge required in advance1. Every database in redis is stored in a redisDb structure. Here, redisDb. id stores the numbers represented by integers in the redis database. RedisDb. dict stores all key-value pairs of the database. RedisDb.

ScenarioA module on machine A connects to MySQL on machine B and works normally in the lab network environment. Similarly, A and B are two machines, the network environment is switched to A small LAN environment isolated from the outside world. The

MariaDB is installed on CentOS 6.5 By chszs, which must be noted in the reprint. Blog homepage: http://blog.csdn.net/chszs1. software environment: CentOS 6.5x64MariaDB 5.5.362. Installation Process 1) Create the MariaDB. repo file in the/etc/yum.

PowerDNS A DNS server that supports PHP Web Page Management and allows you to add DNS address records directly to the database, which is flexible and convenient.   See Information Host Name Host Name recorded in PDNS Local ip Address

Too many OER 7451 in Load Indicator: Error Code = OSD-04500 troubleshooting Task Description: Database fault, unable to expand space Detailed Task:The check space is automatically extended, but an error is reported in the background.OER 7451 in

I. unreasonable index design---- For example, a table with 620000 rows of record and rows with different indexes has the following SQL statements:---- 1. A non-cluster index is created on date.Select count (*) from record where date>'20140901' and

ASM concepts 1. what is Automatic Storage Management (ASM, it is a disk management tool that can implement strip, image data files, recovery files, and other files among multiple physical devices. The distribution unit is AUs (allocation units) the

Oracle provides the scott user's re-creation script, and the 11G uses the script to create scott. The simple operation is as follows: SQL> select * from dba_users where username = 'Scott '; ------ SCOTT has been manually deleted. No rows selectedSQL>

In April this year, IBM released the latest DB2 database, which added the BLU accelerator (BLU Acceleration) feature. On the surface, the BLU accelerator is similar to columnar storage + memory computing, but there are some technical details worth

Just a year later, I found that zabbix's mysql backup file was unusually large during routine checks on server backup data, considering that zabbix regularly sends alerts and SQL records stored during monitoring during routine monitoring of server

OSwatcher is a script tool recommended by Oracle for OS-level running status detection. Exadata is installed by default. But how does Exadata automatically start OSwatcher after the system starts? How can we modify OSwatcher parameters to adjust

Anyone familiar with MySQL may know that MySQL has an "insert ignore" syntax to ignore existing records. PostgreSQL does not currently provide such syntax, but it can be replaced by other methods. The following shows the sample table structure and

1. Prepare files1. Copy the linux.x64_11gR2_database_1of2.zip file.Linux.x64_11gr2_database204 f2.zip to the/Oracle directory; 2. decompress the package (you can right-click to decompress the package, or use the password, cd/oracle)[Root @ jyrac1/] #

Tip For the principle and implementation of master-slave replication, see MySQL master-slave replication. I. Questions about Replication 1. asynchronous replication solves those problems The basic problem solved by replication is that data on one

Background When installing the Oracle database software, we have a flash recovery area option. If we do not select this option, it means that the quick recovery area is not enabled. We can enable or disable it after the database is installed. To

Oracle Data Guard is an important component of the Oracle HA Architecture system and a key technical solution for Maximum Availability Architecture. With the Switchover and Failover features of Data Guard, we can achieve high availability

This method is extremely useful for the following applications: Write-intensive high-speed cache placed before a slow RDBMS System Embedded System PCI compatible systems without persistent data Unit testing, which requires a lightweight database and