NAV: SLTechnology News&Howtos > Database >

• 

  How to implement Multi-level caching in redis

  According to the granularity from coarse to fine: take the product details page as an example, page-level cache (sometimes called url-level cache), manually render the page to the redis (key= merchandise id,val= "commodity details page"). When you request this page again, get it from redis and go straight forward.

  2022-06-01 19:02:00 Views: 248
• 

  What are the characteristics of transactions in MySQL?

  1. Four characteristics of transaction: atomicity (Atomicity): after the start of a transaction, all operations are either done or not done, so it is impossible to stay in the middle link. When an error occurs during the execution of the transaction, it is rolled back to the state before the start of the transaction, and all operations are as if they had not occurred. Consistency (C

  2022-06-01 19:02:00 Views: 256
• 

  Detailed introduction of the redis info command

  The redis info command returns various information and statistical values about the Redis server in a format that is easy to interpret (parse) and easy to read. Given the optional parameter section, you can make the command return only a certain part of the information: 1. Ser

  2022-06-01 19:01:56 Views: 266
• 

  What are the popular database management software? What are the characteristics?

  Common database software introduction: first, MySQLMySQL is the most popular open source SQL database management system, which is developed, released and supported by MySQL AB. MySQL is a fast, multithreaded, multi-user, robust SQL database server. MySQL

  2022-06-01 19:01:53 Views: 299
• 

  The difference between VARCHAR and CHAR in MySQL string types

  The aforementioned VARCHAR and CHAR are the two main string types. Unfortunately, it is difficult to explain exactly how these values are stored on disk and memory, because this is related to the specific implementation of the storage engine. The following description assumes that the storage engine used is InnoDB and / or MyI

  2022-06-01 19:01:47 Views: 203
• 

  What are the special relational operations that can be implemented by RDBMS

  The special relational operations that can be realized by relational database management system include selection, projection and connection. The special relational operation of relational database management system includes selection operation, projection operation and connection operation. Related introduction: relational database management system (Relational Database Ma

  2022-06-01 19:01:44 Views: 272
• 

  What if redis memory exceeds maxmemory?

  Redis memory is full of solutions: 1, increase memory; 2, use memory elimination strategy. 3Grammer Redis cluster. Let's focus on the second and third solutions: the second: we know that redis sets the maxmemory parameter of the configuration file, which can be controlled.

  2022-06-01 19:01:37 Views: 242
• 

  What is the process of generating PHP array files from mysql data?

  In fact, php writes the array to a text file or stores it with the suffix .php, which is called directly when you use it. Ignore the step of fetching mysql data (1) use serialize to serialize the array and store it as a text file, and then use it when calling

  2022-06-01 19:01:37 Views: 266
• 

  What is the lock in MySQL?

  Lock, in real life, is a tool we want to hide from the outside world. In a computer, it is a mechanism for coordinating multiple processes or county towns to access a resource concurrently. In the database, in addition to the contention of traditional computing resources (CPU, RAM, Imax O, etc.), data is also a

  2022-06-01 19:01:07 Views: 218
• 

  What are the reasons for the high concurrency and speed of Redis?

  The high concurrency and fast reason of Redis 1.Redis is based on memory, and the read and write speed of memory is very fast; 2.Redis is single-threaded, which saves a lot of time for context switching threads; 3.Redis uses multiplexing technology to handle concurrent connections. Non-blocking IO

  2022-06-01 19:01:01 Views: 299
• 

  What is the B+Tree index principle of Mysql?

  First of all, the correct creation of the appropriate index is the basis to improve the performance of database query. What is the index? An index is a decentralized data structure created to speed up the retrieval of data rows in a table. How does the index work? As in the figure above, if you now have a sql statement sele

  2022-06-01 19:00:52 Views: 252
• 

  How to modify the ip address in redis

  In many cases, the default IP address of our redis is 127.0.0.1, which means that we can only accept local access, so when we want to access this redis on other machines, we need to modify the access of the ip address. Step 1: enter our redis configuration

  2022-06-01 19:00:41 Views: 294
• 

  What are the aspects of database system security? What are the characteristics?

  Database security includes two aspects: system operation security and system information security. Database security protection technologies include: database encryption (core data storage encryption), database firewall (anti-loophole, anti-attack), data desensitization (sensitive data anonymization) and so on. Database security has two meanings.

  2022-06-01 19:00:38 Views: 213
• 

  The usage of Update Update statement in mysql Database

  Update update statement, usually used in conjunction with WHERE, specifies the condition of the piece of data to be changed, and uses the SET of UPDATE to modify the specified field to the specified value. The syntax is as follows: for example: to modify the LastName equals Wils in the Person data table

  2022-06-01 19:00:29 Views: 269
• 

  Steps to configure Redis as a system in CentOS

  Create redis.servicecd / usr/lib/systemd/systemtouch redis.service edit content [Unit] Description=Redis ServerAfte

  2022-06-01 19:00:25 Views: 203
• 

  Shake function of making Wechat with Redis

  Redis provides geographic location information (GEO) function, with which you can complete the nearby people, shake and other functions. First of all, introduce the related API of GEO. GEO API add address location information geoadd key longitude latitu

  2022-06-01 19:00:25 Views: 242
• 

  How do I start the mysql database with the docker container?

  Docker download image docker pull mysqldocker images create container docker run-d-e MYSQL_ROOT_PASSWORD=root-- name mysql57

  2022-06-01 19:00:25 Views: 213
• 

  How does mysql view and modify the time zone?

  Method "check time zone show variables like"% time_zone% "; set global time_zone ='+ 8 mysql 0000"; # # modify the global time zone of mysql to Beijing time, that is, the east where we are located

  2022-06-01 19:00:22 Views: 227
• 

  What you should pay attention to when installing oracle

  After Oracle is installed, you need to set the environment variable in the Oracle user: if ORACLE_HOEORACLE_SID=ora11g does not set ORACLE_SID, login fails and "ORA-12162:TNS:net" is displayed.

  2022-06-01 19:00:22 Views: 224
• 

  MySQL InnoDB transaction

  Definition of transaction transaction: the smallest unit of work of a database operation is a series of operations performed as a single logical unit of work; a transaction is a set of operations (working logical units) that can no longer be divided. Typical transaction usage scenario: transfer MySQL to open transaction: MySQL is enabled by default

  2022-06-01 19:00:09 Views: 297