Table of Contents
Slow query log
What is SLOW LOG?
Setting and viewing SLOWLOG
Clear the log
Home Database Redis How to use Redis slow query log

How to use Redis slow query log

May 28, 2023 pm 03:37 PM
redis

Slow query log

What is SLOW LOG?

Slow log is a log system used by Redis to record command requests that take longer than a given time to execute a query. Query execution time refers to the time spent executing a query command, excluding IO operations such as client response (talking) and sending replies. In addition, the slow log is stored in the memory and the read and write speed is very fast, so you can use it with confidence and don't have to worry about damaging the speed of Redis by turning on the slow log.

How to use Redis slow query log
Setting and viewing SLOWLOG

The server configuration has two options related to the slow query log:

slowlog-log-slower- than: option specifies that command requests whose execution time exceeds how many microseconds (1 second is equal to 1,000,000 microseconds) will be recorded in the log. For example, if the value of this option is 100, then commands that take more than 100 microseconds to execute will be recorded in the slow query log; if the value of this option is 500, then commands that take more than 500 microseconds to execute will be logged. Logging to the slow query log; and so on.

The option slowlog-max-len is used to determine the maximum number of slow query logs retained by the server. The server uses a first-in, first-out method to save multiple slow query logs: When the number of slow query logs stored by the server is equal to the value of the slowlog-max-len option, the server will first add the oldest slow query log before adding a new slow query log. A slow query log is deleted. For example, if the value of slowlog-max-len of the server is 100, and assuming that the server has stored 100 slow query logs, then if the server intends to add a new log, it must first delete the oldest one currently saved. logs, and then add new logs.

Let us look at an example of the slow query log function. First, use the CONFIG_SET command to set the value of the slowlog-log-slower-than option to 0 microseconds, so that any command executed by the Redis server will be recorded. In the slow query log, then set the value of the slowlog-max-len option to 5, so that the server can only save up to 5 slow query logs:

redis> CONFIG SET slowlog-log-slower-than 0
OK

redis> CONFIG SET slowlog-max-len 5
OK
Copy after login

Next, we use the client to send several command requests:

redis> SET msg "hello world"OK

redis> SET number 10086
OK

redis> SET database "Redis"OK
Copy after login

Then use the SLOWLOG GET command to view the slow query log saved by the server:

redis> SLOWLOG GET
1) 1) (integer) 4               #日志的唯一标识符(uid);  2) (integer) 1378781447      #命令执行时的UNIX时间戳;  3) (integer) 13              #命令执行的时长,以微秒计算;  4) 1) "SET"                  #命令以及命令参数;     2) "database"     3) "Redis"2) 1) (integer) 3
  2) (integer) 1378781439
  3) (integer) 10
  4) 1) "SET"     2) "number"     3) "10086"3) 1) (integer) 2
  2) (integer) 1378781436
  3) (integer) 18
  4) 1) "SET"     2) "msg"     3) "hello world"4) 1) (integer) 1
  2) (integer) 1378781425
  3) (integer) 11
  4) 1) "CONFIG"  2) "SET"  3) "slowlog-max-len"  4) "5"5) 1) (integer) 0
  2) (integer) 1378781415
  3) (integer) 53
  4) 1) "CONFIG"     2) "SET"     3) "slowlog-log-slower-than"     4) "0"
Copy after login

If we execute another SLOWLOG GET 1 command at this time, we will see that the last executed SLOWLOG GET The command has been recorded in the slow query log, and the oldest slow query log numbered 0 has been deleted. The number of slow query logs on the server is still 5:

redis> SLOWLOG GET 1
1) 1) (integer) 5
  2) (integer) 1378781521
  3) (integer) 61
  4) 1) "SLOWLOG"     2) "GET"
Copy after login

The unique ID of the log is only in It will only be reset when the Redis server is restarted, which can avoid repeated processing of logs (for example, you may want to send an email to notify you every time a new slow query is discovered).

Use the command SLOWLOG LEN to view the current number of logs.

Please note the difference between this value and slower-max-len. One of them is the number of current logs, and the other is the maximum number of logs allowed to be recorded.

redis> SLOWLOG LEN
(integer) 5
Copy after login
Clear the log

Use the command SLOWLOG RESET to clear the slow log.

redis> SLOWLOG RESET
OK
Copy after login

The above is the detailed content of How to use Redis slow query log. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Solution to 0x80242008 error when installing Windows 11 10.0.22000.100 Solution to 0x80242008 error when installing Windows 11 10.0.22000.100 May 08, 2024 pm 03:50 PM

1. Start the [Start] menu, enter [cmd], right-click [Command Prompt], and select Run as [Administrator]. 2. Enter the following commands in sequence (copy and paste carefully): SCconfigwuauservstart=auto, press Enter SCconfigbitsstart=auto, press Enter SCconfigcryptsvcstart=auto, press Enter SCconfigtrustedinstallerstart=auto, press Enter SCconfigwuauservtype=share, press Enter netstopwuauserv , press enter netstopcryptS

Analyze PHP function bottlenecks and improve execution efficiency Analyze PHP function bottlenecks and improve execution efficiency Apr 23, 2024 pm 03:42 PM

PHP function bottlenecks lead to low performance, which can be solved through the following steps: locate the bottleneck function and use performance analysis tools. Caching results to reduce recalculations. Process tasks in parallel to improve execution efficiency. Optimize string concatenation, use built-in functions instead. Use built-in functions instead of custom functions.

Golang API caching strategy and optimization Golang API caching strategy and optimization May 07, 2024 pm 02:12 PM

The caching strategy in GolangAPI can improve performance and reduce server load. Commonly used strategies are: LRU, LFU, FIFO and TTL. Optimization techniques include selecting appropriate cache storage, hierarchical caching, invalidation management, and monitoring and tuning. In the practical case, the LRU cache is used to optimize the API for obtaining user information from the database. The data can be quickly retrieved from the cache. Otherwise, the cache can be updated after obtaining it from the database.

Which one has better performance, erlang or golang? Which one has better performance, erlang or golang? Apr 21, 2024 am 03:24 AM

There are performance differences between Erlang and Go. Erlang excels at concurrency, while Go has higher throughput and faster network performance. Erlang is suitable for systems that require high concurrency, while Go is suitable for systems that require high throughput and low latency.

Caching mechanism and application practice in PHP development Caching mechanism and application practice in PHP development May 09, 2024 pm 01:30 PM

In PHP development, the caching mechanism improves performance by temporarily storing frequently accessed data in memory or disk, thereby reducing the number of database accesses. Cache types mainly include memory, file and database cache. Caching can be implemented in PHP using built-in functions or third-party libraries, such as cache_get() and Memcache. Common practical applications include caching database query results to optimize query performance and caching page output to speed up rendering. The caching mechanism effectively improves website response speed, enhances user experience and reduces server load.

How to use Redis cache in PHP array pagination? How to use Redis cache in PHP array pagination? May 01, 2024 am 10:48 AM

Using Redis cache can greatly optimize the performance of PHP array paging. This can be achieved through the following steps: Install the Redis client. Connect to the Redis server. Create cache data and store each page of data into a Redis hash with the key "page:{page_number}". Get data from cache and avoid expensive operations on large arrays.

How to upgrade Win11 English 21996 to Simplified Chinese 22000_How to upgrade Win11 English 21996 to Simplified Chinese 22000 How to upgrade Win11 English 21996 to Simplified Chinese 22000_How to upgrade Win11 English 21996 to Simplified Chinese 22000 May 08, 2024 pm 05:10 PM

First you need to set the system language to Simplified Chinese display and restart. Of course, if you have changed the display language to Simplified Chinese before, you can just skip this step. Next, start operating the registry, regedit.exe, directly navigate to HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlNlsLanguage in the left navigation bar or the upper address bar, and then modify the InstallLanguage key value and Default key value to 0804 (if you want to change it to English en-us, you need First set the system display language to en-us, restart the system and then change everything to 0409) You must restart the system at this point.

Can navicat connect to redis? Can navicat connect to redis? Apr 23, 2024 pm 05:12 PM

Yes, Navicat can connect to Redis, which allows users to manage keys, view values, execute commands, monitor activity, and diagnose problems. To connect to Redis, select the "Redis" connection type in Navicat and enter the server details.

See all articles