Use redis to record a large number of file lists

demand Now there is a file list. If you query directly in the text, the efficiency is very low and slow. Now you want to import it into redis and then use it later. How do you deal with this operation functional requirement The following functions need to be implemented Importergodicdelete To query, you can directly get the key, so here i ...

Added by manalnor on Thu, 25 Nov 2021 06:29:33 +0200

Basic concepts of Oracle Database

Author: threedaymanSource: Hang Seng LIGHT cloud communityBasic conceptsdatabaseoracle database is the physical storage of data. Including data file ORA or DBF, control file, online file, log file and parameter file. oracle has only one database, which is managed by users. The process of creating a database in mysql database is to create a data ...

Added by AnthonyArde on Thu, 25 Nov 2021 05:41:39 +0200

Caused by: java.sql.SQLSyntaxErrorException: Expression #1 of ORDER BY

preface       Is the mysql version upgraded or the problem after installing mysql added to mysql after mysql 5.7.5_ Node verification. Many functions may not be standardized and cannot be used. 1. Mode I     Simple rough method set @@global.sql_mode =''; -- Directly in mysql The console sets the check ...

Added by MrXander on Wed, 24 Nov 2021 16:12:37 +0200

redis source code learning allocated memory

1. Overview of redis In terms of memory allocation, Redis simply encapsulates the malloc/free of the system, and then adds the exception handling function and memory statistics function. Its implementation is mainly in zmalloc.c and zmalloc.h files 2. Function function void *zmalloc(size_t size); // Call the zmalloc function to apply for spa ...

Added by glassroof on Wed, 24 Nov 2021 06:44:23 +0200

Six steps of jdbc connection to database and handwritten implementation of simple database connection pool

We may often use Hibernate, Mybatis, jpa and other frameworks in our study and work. These frameworks have a good encapsulation of the database connection pool and may ignore the underlying implementation of the database. Today, let's take a look at how to write a simple database connection pool. Before that, let's recall the steps of ja ...

Added by venradio on Wed, 24 Nov 2021 01:48:05 +0200

Principle and optimization of Redis replication

1.1 Redis stand-alone problems 1.1.1 machine failure When a Redis node is deployed on a server, if the mainboard and hard disk of the machine are damaged and cannot be repaired in a short time, the Redis operation cannot be handled. This is the possible problem of a single machine Similarly, the server runs normally, but the main Redis proce ...

Added by david4u on Wed, 24 Nov 2021 01:13:18 +0200

Mysql review notes - Basics 6 [Database basics]

System environment MAC OS 10.10MySQL version, 5.7.9 Installing mysql on Mac is very simple. Download the installation package from the official website and double-click the installation. There are several places to pay attention to When installing mysql with DMG package on Mac, a root password will be randomly assigned in the last step after ...

Added by Bodhies on Tue, 23 Nov 2021 18:32:21 +0200

Oracle 11g Linux centros7 installation

Oracle 11g Linux centros7 installation Oracle 11g graphical installation requires the installation of xmmanager or vnc, which is troublesome and error prone in the intermediate process. The following describes the silent installation. preparation 1.1 modify the host name and configure the host file vim /etc/hosts 127.0.0.1 orcl-db ...

Added by TanyaTR on Tue, 23 Nov 2021 08:50:55 +0200

Data analysis project - stock data analysis

tushare financial data interface package pip install tushareFunction: provide relevant specified financial dataRelated documents: Tushare - financial data interface package Demand: stock analysis Use the tushare package to obtain the historical quotation data of a stock. tushare financial data interface package, based on which historical tra ...

Added by HektoR on Tue, 23 Nov 2021 07:16:03 +0200

MySQL date and time functions

namedescribeADDDATE()Add time value (interval) to date valueADDTIME()OvertimeCONVERT_TZ()Transition from one time zone to anotherCURDATE()Returns the current dateCURRENT_DATE(), CURRENT_DATESynonym for CURDATE()CURRENT_TIME(), CURRENT_TIMEA synonym for CURTIME()CURRENT_TIMESTAMP(), CURRENT_TIMESTAMPSynonyms for the presentCURTIME()Returns the c ...

Added by fat creative on Mon, 22 Nov 2021 08:33:20 +0200