Database Administrator

Install, configure, and test the MySQL source code package in Linux (this test is feasible) Write down this MySQL note, which will be useful in the future! RedHat Linux 6 uses the CentOS yum source to describe how to install and configure mysql

Oracle DBLink creation and maintenance and ORA-02085 Solutions Today's business needs to query Oracle data across databases, so we thought of dblink. Let's take a closer look at Oracle DBLink. First, Oracle DBLink is divided into the following three

Redis-explore Redis and learn basic usage of Redis. Author: Gigi Sayfan time: 2018.8.28Advertisement Redis is a key-value database in the memory. It is free and open-source. It is implemented in C language and runs very fast. Redis is already a

Make a little progress every day-mysql -- Percona XtraBackup (innobackupex), perconaxtrabackupI. Introduction Percona XtraBackup is an open-source and free MySQL Database Hot Backup Software. It can back up InnoDB and XtraDB storage engine databases

Oracle data types, functions and stored procedures, and oracle Data TypesString typeFixed Length: char nchar n indicates Unicode encodingVariable Length: varchar2 nvarchar2Number Type: number (P, S) P: integer digits, S decimal

Mysql Master/Slave configuration for read/write splitting and mysql Master/Slave read/write splitting In order to solve a large number of concurrent accesses to large websites, distributed load balancing is far from enough. At the data service layer

Redis expiration key deletion policy and redis expiration key policy We have learned that Redis is a memory database, and data in Redis is stored in the memory in the form of key-value, which is maintained and managed by the Redis server, memory is

Oracle Solaris, pci dss, and solarisdss   Today on the Oracle official website to search for pci dss, unintentional search for Oracle Solaris information about pci dss (see the following url:

MEAN framework learning notes, mean learning notesMEAN framework learning notes There is very little information about the MEAN development framework. The main information is from the introduction on the learn. mean. io website. Therefore, with a

MySQL Optimization-triggers and mysql triggers Reprinted please indicate the source: http://blog.csdn.net/l1028386804/article/details/46763665 A trigger is a special stored procedure. The difference is that the stored procedure must be called by

Oracle442 application scenarios ---------- database instances and access Database Application Instances The Application Scenario 1-7 is the installation process of Oracle. Here, I will explain a lot about it. There are a lot of materials on the

Redis service deployment and redis deployment Web programmer blog: http://blog.csdn.net/thinkercode Install Redis 1. Install Redis [root@localhost ~]# wget http://download.redis.io/releases/redis-3.0.2.tar.gz[root@localhost ~]# tar xzf redis-3.0

Data cleansing Note: sorts strings to dates (A Date Field is processed in multiple formats ), Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. You must specify the source when you repost them. Otherwise, you have

MYSQL user creation, database creation, table creation, authorization, mysql database creation1. Create a user// Log on to MYSQL@> Mysql-u root-p@> Password// Create a userMysql> insert into mysql. user (Host, User, Password) values ('localhost',

Redis configuration file details, redis configuration file# Redis configuration file# When the memory size needs to be configured in the configuration, you can use 1 k, 5 GB, 4 M and other similar formats, the conversion method is as follows (Case

One of the practical skills that can greatly improve the performance of SQL TUNING optimization. When we perform SQL optimization, we often encounter the need to sort a large number of datasets and then retrieve the first part of the results from

Basic PostgreSQL commands and PostgreSQL commands 1. Change the table name Alter table name rename to new table name 2. Change the field name Alter table name rename field name to new field name 3. Change the field type. For example, the original

ORA-00257: archiver error. Connect internal only. until freed, ora-00257freed1. plsq logon Error ORA-00257: archiver error. Connect internalonly. until freed  2. the alert Log in the background reports the following error: [Oracle @ powerlong4 ~] $

Oracle -- SQL syntax summary and oraclesql syntax Summary -- Statement block declare v_name varchar2 (30): = 'jack' -- defines the variable begin select v_name from dual; exception when others then dbms_output.put_line ('exception occurred '); end;

MySQL database update sub-query, mysql database update For example: UPDATE test. tb_vobileSet a. name = '20140901'WHEREA. id = (select max (id) id from test. tb_vobile) Error: [SQL] UPDATE test. tb_vobileSet a. name = '20140901'WHEREA. id =