Database Administrator

Deletion policy for expired keys in Redis 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 precious. unwanted data or

Description of two Redis persistence Methods Before talking about Redis persistence, you need to understand what is the concept of database status, because persistence is to save the database status in memory to the disk. So what is the database

Oracle uses comment statements to add Table Comments The Oracle comment statement can be used to add remarks to tables, fields, views, and other objects. Syntax:Comment on TABLE table_name IS 'Remarks '; Permission requirements:By default, users can

Collection iterator pickler fetch appears in the execution plan Today, when I used explain plan for to view the SQL Execution plan, the following strange execution plan appeared: SQL> explain plan for select * from test where object_id = 100;

How to handle EM key garbled characters in Oracle 11g Today, I used a Mac to connect to the VMware Fusion virtual machine database. I suddenly wanted to use EM and suddenly found that the buttons were garbled. For example: Analysis: To solve the

Accelerate mydumper and myloader Export and Import Mydumper and myloader are excellent third-party mysql database logical backup and recovery tools that use multi-thread export and import. Makes up for the insufficiency of mysqldump single thread.

Mysql create database specifies UTF-8 encoding, databaseutf-8The following script creates the DATABASE yourdbname and specifies the DEFAULT Character Set utf8CREATE database if not exists yourdbname default charset utf8 COLLATE utf8_general_ci. To

UI 19 database exercises, ui19 database exercises When you click "add to Favorites" for a movie, you can determine whether it is added to the favorites folder.Delete and insert a favorite movie.Create a DataBaseTool # Import # import # import

Change the method from Flash Recovery Area (FRA) to a new path, recoveryfra Change the Flash Recovery Area (FRA) to a new path. Source:How to change Flash Recovery Area to a new location? (Documentation ID 305651.1) Objectives:This article describes

JPA cache and jpa CacheJPA Cache For JPA2.0, cache can be classified into Level 1 cache and level 2 cache (JPA1.0 only supports Level 1 cache ). The second-level cache is usually used to improve the performance of applications. It can avoid

Oracle9i statspack report analysis direct path read wait event, oracle9istatspackDB Name DB Id Instance Inst Num Release Cluster Host-------------------------------------------------------------------------LIXORA 1409317108 LIXORA 1 9.2.0.1.0 NO

[Translated from mos] compatibility between the rman Standard Edition and the Enterprise Edition, mosrman Compatibility between rman Standard Edition and Enterprise Edition Source:RMAN Standard and Enterprise Edition Compatibility (Document ID 730193

Use date type in PL/SQL, plsql date type Use the date type in PL/SQL Previous articles introduced the use of strings and numbers in PL/SQL. There is no doubt that strings and numbers are important, but it can be determined that no application

Common SQL code and SQL codeSome of the most important SQL commandsSELECT-extract data from the database1. select syntaxSelect column_name, column_name drom table_nameOrSelect * from table_name (select all columns)2. select distinct is used to

Set remote login and new users for mysql Simple mysql management commands: Start mysql sudo start mysqlStop mysql sudo stop mysql Remote access settings: Sudo vi/etc/mysql/my. cnf comment out bind-address = 127.0.0.1 Add new users: GRANT ALL

The C language calls the mysql stored procedure and the mysql Stored Procedure This article explains how to call the stored procedure of mysql database in C language. The following is a SC table that stores the course selection records of students,

Redis command details, Redis command details1. set setnx setexset associates the value of the string value with the key. If the key already exists, it overwrites the original one. If it does not exist, it is created. Setnx sets the key value as

Mongodb installation (window) and java connection test, mongodbwindowFirst download and install Download mongodb official website and select window version Step 2: Install Pay attention to the installation directory. My installation directory is D:

Redis maxmemory settings, redismaxmemory The maxmemory parameter of redis is used to control the maximum memory capacity available for redis. If the value of maxmemory is exceeded, the elimination policy is used to process keys in the expaire

Changes in MYSQL source code compilation and MYSQL source code compilation For Mysql installation, the source code compilation method for mysql of different versions is different. 5.6.2 has changed from configure to cmake, related to the new