Database Administrator

Redis 2.8.18 installation error, redis2.8.18 Error zmalloc.h:50:31: error: jemalloc/jemalloc.h: No such file or directoryzmalloc.h:55:2: error: #error "Newer version of jemalloc required"make[1]: *** [adlist.o] Error 1make[1]: Leaving directory

Redis goes deep into memory recovery and object sharing, and redis goes deep into object recycling Memory reclaim The C language does not have the automatic memory recovery function. Redis builds a memory recovery mechanism based on the reference

SQL server accumulation, SQL server1. The column in the selected list is invalid because it is not included in the aggregate function or group by clause. A: When group by is specified, all columns in any non-aggregate expression in the selection

Mysql High Performance Memcached (1), mysqlmemcachedThis article describes how to install and use Memcached.What is Memcached?Free & open source, high-performance, distributed memory object caching system, generic in nature, but intended for use in

Use the doscommand to import an SQL file to mysql. To sum up the method of using the doscommand to operate the mysql database. I did not pay attention to it before. It is found that this method is fast. Especially when there is no image management

[Translated from mos] Does Block Recovery Use Incremental backup ?, MosrecoveryDoes Block Recovery Use Incremental backup?Translated from:Does Block Recovery use Incremental Backups ?? (Docid 727706.1)Applicable:Oracle Database-Enterprise

Object of Redis depth, redis depth Redis Object System We have introduced all the major data structures used by Redis, such as simple dynamic strings (SDS), double-ended linked lists, dictionaries, compressed lists, and integer sets. Redis does not

Database software runInstaller cannot see the handling methods of all rac nodes. runinstallerrac Recently encountered a problem: Installing rac of 11.2.0.4 in rhel5.5. The GI installation is complete. However, when database software runInstaller is

Keepalived + Lvs + Mysql master-master replication, keepalivedlvs 1 Introduction Keepalived + lvs + mysql master/Master replication is a common Mysql high-availability solution. lvs provides read load balancing and Keepalived implements automatic

SQL server char nchar nvarchar varchar region, nchar Char stores a fixed-length string with a maximum length of 8000 bytes. Varchar stores variable-length strings with a maximum length of 8000 bytes. Nchar stores Unicode strings of a fixed length.

THP Transparent HugePages Recently, we encountered a case where the LINUX system memory was relatively large and HugePages was not enabled, and the number of ORACLE connections increased dramatically to thousands due to service changes. PageTables

Oracle-force stop job, oracle-force jobI. gentle approach:1. view all jobs;Select * from dba_jobs;2. view the running job;Select * from dba_jobs_running;3. Find the corresponding session based on the sid;Select SID, SERIAL # from V $ Session where

DB query analyzer 6.03, the best database client tool on any Windows operating system, db6.03   Database Query analyzer 6.03, the best database client tool on any Windows Operating System    Ma genfeng (CSDN interview with Ma genfeng: massive data

How to Use RMAN to restore some tablespaces and rman spaces on different machines During the routine maintenance and use of the oracle database, data may be accidentally deleted (drop, delete, truncate). When we use conventional means (flashback

[Redis] redis overview, redis Overview Redis isOpen Source,Supported networks,Memory-based, persistentOfLog-type and key-value pairs, Which is written in ansi c. It also provides APIs in multiple languages.Fast feature Redis uses standard C to write

Linux SQL statement concise tutorial --- SUBSTRING, linux concise tutorial The substring function in SQL is used to capture part of a column. The function names are not exactly the same in different databases: MySQL: SUBSTR (), SUBSTRING ()

Considerations and key points for optimizing mysql execution efficiency 1. The principle of SQL optimization is to minimize the number of blocks to be read by an operation, that is, to reach the maximum data throughput in the shortest time. You can

A concise tutorial on SQL statements in linux --- AND OR, a concise tutorial --- and In the previous page, we can seeWHERECommands can be used to select data conditionally in the table. This condition may be simple (like the previous page example)

Summary about the deletion of delayed blocks, the snapshot is old, and the read is consistent. We hope to combine these three knowledge points to summarize the summary of the delayed part clearing, the snapshot being old, And the read consistency.

DB system alert contact API and db alert api Author: SkateTime: 2014/12/16   Database System Alert contact API   When we maintain the system, we need to transmit the system's alarm information to the corresponding students in real time. If we