Database Administrator

MySQL-5.5.38 universal binary Installation 1. System Environment: CentOS 6.5 _ x86 2、mysql-5.5.38-linux2.6-i686.tar.gz The file name format for the MySQL binary distribution is mysql-VERSION-OS.tar.gz, where VERSION is the VERSION number (for

MySQL full-text index avoids like inefficiency Why should we use full-text indexes? In general, the like Statement of SQL is used for database search, and the like statement cannot use indexes. Each query goes from the first to the last one, and

Two solutions to SWAP insufficiency when installing Oracle in Linux The current disk partition and SWAP partition are as follows: [Root @ bys3 ~] # Fdisk-lDisk/dev/sda: 21.4 GB, 21474836480 bytes 255 heads, 63 sectors/track, 2610 cylinders Units =

Oracle alter table space, oracle ALTER TABLE 1. Find out which tables have incorrect tablespaces. select * from dba_tables where tablespace_name='TDB'; 2. Move the tablespace in TDB to TDB2009. Syntax: alter table table_name move tablespace

Use mysqlbinlog tool to recover data based on location or time point.Use mysqlbinlog to restore data based on location or time pointMySQL backup generally uses full backup and log backup. For example, a full backup is performed every day and a

Getting started with Redis configuration and C ++ in Ubuntu, ubunturedis RedisIs a high-performance key-value database. The emergence of Redisedis largely compensates for the shortage of key/value storage such as memcached. In some cases, it can

SQL Server notes, SQL Server notes Question 1: remove the red mark I have never seen any red symbols. I tried to paste these symbols into notepad and found it garbled. I tried to paste it into the SQL query analyzer and found it blank. For such

Chapter 1 Securing Your Server and Network (5): use SSL to encrypt sessions, securingsslSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes. I am not responsible

Custom table ID generated by java and id generated by java The following ID must be

Oracle Database Backup Data is missing Oracle databases have been used in the project. Since I have been focusing more on the ORM ing framework, I have barely paid attention to Oracle features, and I do not know many things, in addition, the

[MySQL] Innodb parameter optimization, mysqlinnodb Innodb_buffer_pool_size The innodb_buffer_pool_size parameter is used to set the Innodb primary Buffer (Innodb_Buffer_Pool), that is, the primary cache space for caching user tables and index data,

Write hive udfs and hiveudfs1. Configure the environment 1. Introduce the jar package: hive-exec-0.8.0.jar and hadoop-core-0.20.2.jar2. Compile udf function 1. extends UDF2. redefine UDF evaluate function. Package com. qunar. hiveudf; import java.

Share the kernel parameters and configuration scripts to be modified when running PostgreSQL in CentOS, centospostgresql When deploying PostgreSQL on CentOS, you need to set some operating system parameters. The official documents list some

[Translated from mos] How to Set or Switch Oracle Homes on Windows (Doc ID 969581.1 ),   Reference Original:How to Set or Switch Oracle Homes on Windows (Doc ID 969581.1) Applicable:Oracle Database-Enterprise Edition-Version 9.2.0.1 to 11.2.0.1.0

MySQL cannot master-slave replication solution. mysql master-slave ******** the slave database cannot be synchronized ******** show slave status to show that slave_ SQL _runing is NO, seconds_behind_master is null. Cause: A: The program may perform

Modify the read checkpoint and write checkpoint of each process in Oracle GoldenGate (ogg ). Note: exercise caution when modifying the Read and Write checkpoints of each process in Oracle GoldenGate (ogg. Make sure that you have mastered the

The script for automatically starting goldengate with OS in aix, aixgoldengateThe script for automatically starting goldengate with OS in aix:1. Create/u01/info.txt with an oracle user. The file content is as follows: sh datestart mgr2. chmod + x

Oracle 11gR2 database flashback function-prevents human logic errors and 11gr2flashback Oracle 11gR2 database crash-Prevention of human logic errors   1. What is the role of Flashback on the dji erp system? For some human operation errors, such as

How to configure oracle 11g complex password verification settings, oracle11gZookeeper ---- View the password-related parameter configuration information in the default profileSQL> SELECT profile, resource_type, resource_name, limit FROM

[Oracle] OGG error while loading shared libraries, sharedlibraries [Oracle @ jp ogg] $./ggsci ./Ggsci: error while loading shared libraries:/u01/app/oracle/ogg/libclntsh. so.11.1: cannot restore segment prot after reloc: Permission denied Disable