CN108563744A - Slow querying method, device and terminal device based on Redis databases - Google Patents
Slow querying method, device and terminal device based on Redis databases Download PDFInfo
- Publication number
- CN108563744A CN108563744A CN201810327855.3A CN201810327855A CN108563744A CN 108563744 A CN108563744 A CN 108563744A CN 201810327855 A CN201810327855 A CN 201810327855A CN 108563744 A CN108563744 A CN 108563744A
- Authority
- CN
- China
- Prior art keywords
- record
- slow
- redis databases
- mysql database
- slow inquiry
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Abstract
The present invention relates to Internet technical fields, and in particular to a kind of slow querying method, device and terminal device based on Redis databases, the Redis databases are connect with the MySQL database being stored in storage device.The slow querying method based on Redis databases includes:It detects and stores whether the list length that slow inquiry records reaches predetermined length in the Redis databases, if reaching, then by all slow inquiry record storages in MySQL database, the html page paging built in advance is called to show all slow inquiry records stored in MySQL database in turn, and user can search corresponding slow inquiry record according to the search strategy of input in MySQL database, and be shown in html page.It can be seen that in the present solution, by the way that all slow inquiry record timing in Redis databases to be stored in MySQL database, and user is showed in by html page so that user easily can be inquired and used by search strategy.
Description
Technical field
The present invention relates to Internet technical fields, in particular to a kind of slow issuer based on Redis databases
Method, device and terminal device.
Background technology
For the Redis databases for storing slow inquiry record, the method for current Redis databases inquired slowly is to give
One time threshold of Redis data lab setting, and then data of the Redis databases by discarding more than the time threshold, with
Vacating space retains new slow inquiry record, and thus user can not inquire data earlier;On the other hand, if user thinks
Redis data base queryings record, and need to generally the inquiry instruction of Redis databases be used to go in Redis databases to be searched, and
Only the talent of specified permission can search.The data in Redis databases for a user, are searched and using not as a result,
It is convenient.
Invention content
The purpose of the present invention is to provide a kind of slow querying method based on Redis databases, to facilitate user to search and
It uses.
Another object of the present invention is to provide a kind of slow inquiry units based on Redis databases, to facilitate user to look into
It looks for and uses.
Another object of the present invention is to provide a kind of terminal devices, to facilitate user to search and use.
To achieve the goals above, technical solution used in the embodiment of the present invention is as follows:
In a first aspect, an embodiment of the present invention provides a kind of slow querying method based on Redis databases, the Redis
Database is connect with the MySQL database being stored in storage device, the method includes:It detects in the Redis databases
Whether the list length of the slow inquiry record of storage reaches predetermined length, if reaching, by all slow inquiry record storages in described
In MySQL database;The html page paging built in advance is called to show all slow inquiries stored in the MySQL database
Record;It responds search strategy input by user and searches corresponding slow inquiry record in the MySQL database, and be shown in institute
State html page.
Second aspect, the embodiment of the present invention additionally provides a kind of slow inquiry unit based on Redis databases, described
Redis databases are connect with the MySQL database being stored in storage device, and described device includes:Detection module, for detecting
Whether the list length that slow inquiry record is stored in the Redis databases reaches predetermined length, if reaching, is looked into all slowly
Consultation record is stored in the MySQL database;Display module, for calling described in the html page paging built in advance displaying
All slow inquiry records stored in MySQL database;Searching module, for responding search strategy input by user described
Corresponding slow inquiry record is searched in MySQL database, and is shown in the html page.
The third aspect, the embodiment of the present invention additionally provide a kind of terminal device, and the terminal device includes memory and place
Device is managed, the memory is stored in for executing in the memory for storing computer program code, the processor
Computer program code is to realize the slow querying method based on Redis databases.
A kind of slow querying method, device and terminal device based on Redis databases provided in an embodiment of the present invention, should
Redis databases are connect with the MySQL database being stored in storage device.The slow querying method based on Redis databases
Including:It detects and stores whether the list length that slow inquiry records reaches predetermined length in the Redis databases, it, will if reaching
All slow inquiry record storages call the html page paging displaying MySQL data built in advance in MySQL database
All slow inquiries records stored in library, and user can be searched in MySQL database according to the search strategy of input it is corresponding
Slow inquiry record, and be shown in html page.It can be seen that in the present solution, by being looked into all in Redis databases slowly
Consultation record timing is stored in MySQL database, and is showed in user by html page so that user can be by retrieving plan
Slightly easily is inquired and used.
Description of the drawings
In order to illustrate the technical solution of the embodiments of the present invention more clearly, below will be to needed in the embodiment attached
Figure is briefly described.
Fig. 1 shows a kind of structural schematic diagram of terminal device provided in an embodiment of the present invention.
Fig. 2 shows a kind of flow signals of the slow querying method based on Redis databases provided in an embodiment of the present invention
Figure.
Fig. 3 shows that the flow of another slow querying method based on Redis databases provided in an embodiment of the present invention is shown
It is intended to.
Fig. 4 shows a kind of function module of slow inquiry unit based on Redis databases provided in an embodiment of the present invention
Schematic diagram.
Diagram:100- terminal devices;Slow inquiry units of the 110- based on Redis databases;120- memories;130- is stored
Controller;140- processors;150- Peripheral Interfaces;160- input-output units;170- audio units;180- display units;
111- configuration modules;112- detection modules;113- empties module;114- display modules;115- searching modules.
Specific implementation mode
Below in conjunction with attached drawing in the embodiment of the present invention, technical solution in the embodiment of the present invention carries out clear, complete
Ground describes, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.
It should be noted that:Similar label and letter indicate similar terms in following attached drawing, therefore, once a certain Xiang Yi
It is defined, then it further need not be defined and explained in subsequent attached drawing in a attached drawing.Meanwhile the present invention's
In description, term " first ", " second " etc. are only used for distinguishing description, are not understood to indicate or imply relative importance.
The Redis databases are an a whole set of caching system, are mainly used for caching slow inquiry record.To Redis numbers
The process that searching data is carried out according to library is referred to as to inquire, and it is exactly to look into slowly which, which is slowed down,
It askes, in other words, slow inquiry is also a kind of mode of data query, but its used time is longer compared with the common inquiry used time.It should
Slow inquiry is recorded as data caused by slow query process, is to quickly respond user as user has initiated an order
The order is added in message queue system, and actually the message queue is stored in Redis databases this cachings, and then will
The order information is referred to as a slow inquiry record.
In the prior art, after the multiple slow inquiry records of the Redis database purchases, automatic time limit cover time is more early
Record so that user be not easy to search early stage record.Meanwhile the personnel of only specified permission could pass through Redis orders
In Redis database lookup relative recordings, using very inconvenient.The embodiment of the present invention provides a kind of based on Redis as a result,
The slow querying method of database facilitates user to search and use to realize by providing visual interface.
The slow querying method based on Redis databases is applied in terminal device, which can be, but unlimited
In the intelligent electronic devices such as computer, tablet computer.Fig. 1 is please referred to, is a kind of terminal device 100 provided in an embodiment of the present invention
Structural schematic diagram, which includes slow inquiry unit 110 based on Redis databases, memory 120, storage control
Device 130, processor 140, Peripheral Interface 150, input-output unit 160, audio unit 170 and display unit 180 processed.
The memory 120, storage control 130, processor 140, Peripheral Interface 150, input-output unit 160, sound
Frequency unit 170,180 each element of display unit are directly or indirectly electrically connected between each other, to realize the transmission or friendship of data
Mutually.It is electrically connected for example, these elements can be realized between each other by one or more communication bus or signal wire.It is described to be based on
The slow inquiry unit 110 of Redis databases can be stored in institute including at least one in the form of software or firmware (firmware)
State in memory 120 or be solidificated in the software work(in the operating system (operating system, OS) of the terminal device 100
It can module.The processor 140 is used to execute the executable module stored in memory 120, such as described based on Redis data
The software function module or computer program that the slow inquiry unit 110 in library includes.
Wherein, memory 120 may be, but not limited to, random access memory (Random Access Memory,
RAM), read-only memory (Read Only Memory, ROM), programmable read only memory (Programmable Read-Only
Memory, PROM), erasable read-only memory (Erasable Programmable Read-Only Memory, EPROM),
Electricallyerasable ROM (EEROM) (Electric Erasable Programmable Read-Only Memory, EEPROM) etc..
Wherein, memory 120 is for storing program, and the processor 140 executes described program, this hair after receiving and executing instruction
The method performed by terminal device 100 that the stream process that bright embodiment any embodiment discloses defines can be applied to processor
In 140, or realized by processor 140.
Processor 140 may be a kind of IC chip, the processing capacity with signal.Above-mentioned processor 140 can
To be general processor, including central processing unit (Central Processing Unit, abbreviation CPU), network processing unit
(Network Processor, abbreviation NP) etc.;Can also be digital signal processor (DSP), application-specific integrated circuit (ASIC),
Field programmable gate array (FPGA) either other programmable logic device, discrete gate or transistor logic, discrete hard
Part component.It may be implemented or execute disclosed each method, step and the logic diagram in the embodiment of the present invention.General processor
Can be microprocessor or the processor 140 can also be any conventional processor 140 etc..
The Peripheral Interface 150 couples various input/output devices to processor 140 and memory 120.At some
In embodiment, Peripheral Interface 150, processor 140 and storage control 130 can be realized in one single chip.Other one
In a little examples, they can be realized by independent chip respectively.
The interaction that input-output unit 160 is used to that user input data to be supplied to realize user and the terminal device 100.
The input-output unit 160 may be, but not limited to, mouse and keyboard etc..
Audio unit 170 provides a user audio interface, may include that one or more microphones, one or more raises
Sound device and voicefrequency circuit.
Display unit 180 provides an interactive interface (such as user interface) between terminal device 100 and user
Or it is referred to user for display image data.In the present embodiment, the display unit 180 can be liquid crystal display or touch
Control display.Can be that the capacitance type touch control screen or resistance-type of single-point and multi-point touch operation is supported to touch if touch control display
Control screen etc..Single-point and multi-point touch operation is supported to refer to touch control display and can sense on the touch control display one or more
The touch control operation generated simultaneously at a position, and transfer to processor 140 to be calculated and handled the touch control operation that this is sensed.
Fig. 2 is please referred to, is that a kind of flow of slow querying method based on Redis databases provided in an embodiment of the present invention is shown
It is intended to, this method includes:
Step S110 is detected and is stored whether the list length that slow inquiry records reaches pre- fixed length in the Redis databases
Degree, if reaching, by all slow inquiry record storages in the MySQL database.
It is stored specifically, being detected in Redis databases by slowlog len orders using slow inquiry record check function
Whether the list length of slow inquiry record reaches predetermined length, which can customize setting, as the predetermined length can be with
It is 1024.If reaching this predetermined length, show that current Redis database purchases have been expired, then by institute in Redis databases
After some inquires record search out slowly, it is stored in relational database MySQL database.Further, Django- is called
Celery task scheduling function timer-triggered schedulers inquire record check function slowly, go to detect in the Redis databases and store slow inquiry
Whether the list length of record reaches predetermined length, and such as scheduling in every five minutes is primary so that Redis databases are unlikely to data mistake
It is full, influence response speed.
It should be noted that the Redis databases are a caching system, it is generally the case that remember the slow inquiry of user
It records and is stored in Redis databases, in order to carry out quick response to the operation of user.The MySQL database is to be stored in
Relational database in storage device (such as hard disk) needs the data of long-term preservation commonly used in storage, in order to the inquiry of data.This
Outside, it is in the format of MySQL database by slow inquiry record storage:By pre-defined tables of data in the MySQL database, each
Data type will be defined in tables of data, if the data type includes character string type ip, numeric type port, date type
Query_time, numeric type execute_time, character string type query, date type create_time etc..Wherein, word
Symbol string type ip is used to store the addresses ip of Redis databases, and numeric type port is used to store the port of Redis databases,
Date type query_time is used to store the time that slow inquiry occurs, and numeric type execute_time is used to store slow inquiry
The time span of operation, unit are microsecond, and character string type query is used to store the specific sentence inquired slowly, date type
Create_time is used to store the time for being specifically inserted into this record.
Step S120, call the html page paging that builds in advance show stored in the MySQL database it is all slow
Inquiry record.
Specifically, in order to enable user is stored in slow inquiry in MySQL database convenient for inquiry records, therefore utilization
Django frames build html page in advance, show that all slow inquiries stored in MySQL database are recorded with paging, and provide
The screening function of various condition dimensions such as passes through character string type ip, numeric type port, date type query_time, number
Word type execute_time etc. is screened to inquiring record slowly.In other words, user can choose phase according to the demand of oneself
The keyword answered is inquired target record and is screened slowly.
Step S130 responds search strategy input by user and searches corresponding slow inquiry note in the MySQL database
Record, and it is shown in the html page.
Specifically, the search strategy is the retrieval type for meeting sql like language of user's structure, to be existed by the retrieval type
Corresponding slow inquiry record is searched in MySQL database, while the slow inquiry record that inquiry obtains will show in HTML page in real time
Face.The retrieving is specially:The condition latitude that user is chosen in the html page of front end, is transmitted to by ajax post
Rear end recycles the pymysql modules of Python to connect the MySQL database of rear end storage database, corresponding inquiring
Data are packaged into the format of json with the json modules of Python, are shown back to front end page.
It can be seen that the slow querying method provided in an embodiment of the present invention based on Redis databases, may make that user is direct
The slow inquiry record being stored in for a long time in MySQL database is accessed by web page, accesses and inquiry is convenient, avoid use
The security risk that family directly generates Redis by Redis command access Redis databases.Meanwhile in the MySQL database
Slow inquiry record can long-term preservation, user can be found according to the demand of oneself early stage slow inquiry record, all is slow
Inquiry record can persistence, it is not easy to lose.
Fig. 3 is please referred to, is the flow of another slow querying method based on Redis databases provided in an embodiment of the present invention
Schematic diagram, this method include:
Step S210, configuring record queries time in the Redis databases is more than the predetermined time and is recorded as inquiring slowly
Record.
I other words opening slow query configuration for each Redis database, both sides configuration is specifically included, on the one hand
For configure the predetermined time, when record query time be more than the predetermined time, then assert this be recorded as slowly inquire record, another party
Face is configuration record strip number, when the slow inquiry record in Redis databases is more than this record strip number, then by Redis data
All slow inquiry record storages enter in MySQL database in library.Specifically configuration mode is:config set slowlog-
1024 this sentences of log-slower-than 20000config set slowlog-max-len are configured with Redis databases
Most multipotency records 1024, and when queried between to be more than the inquiry of 20000 microseconds be slow inquiry.
Step S220, calling task scheduling function timer-triggered scheduler inquire record check function slowly, check the Redis data
Whether the list length that slow inquiry record is stored in library reaches predetermined length, if reaching, by all slow inquiry record storages in
In the MySQL database.
It is stored specifically, being detected in Redis databases by slowlog len orders using slow inquiry record check function
Whether the list length of slow inquiry record reaches predetermined length, which can customize setting, as the predetermined length can be with
It is 1024.If reaching this predetermined length, show that current Redis database purchases have been expired, then by institute in Redis databases
After some inquires record search out slowly, it is stored in relational database MySQL database.Further, Django- is called
Celery task scheduling function timer-triggered schedulers inquire record check function slowly, go to detect in the Redis databases and store slow inquiry
Whether the list length of record reaches predetermined length, and such as scheduling in every five minutes is primary so that Redis databases are unlikely to data mistake
It is full, influence response speed.
Step S230 empties current Redis databases, in order to which the Redis databases can continue to store newly slow
Inquiry record.
I other words slow inquiry record search all in current Redis databases is come out, it is stored in relational database
After in MySQL database, current Redis databases need to be emptied using slowlog reset, in order to which Redis databases can be after
Renew the new slow inquiry record of storage.
Step S240, call the html page paging that builds in advance show stored in the MySQL database it is all slow
Inquiry record.
Specifically, in order to enable user is stored in slow inquiry in MySQL database convenient for inquiry records, therefore utilization
Django frames build html page in advance, show that all slow inquiries stored in MySQL database are recorded with paging, and provide
The screening function of various condition dimensions such as passes through character string type ip, numeric type port, date type query_time, number
Word type execute_time etc. is screened to inquiring record slowly.In other words, user can choose phase according to the demand of oneself
The keyword answered is inquired target record and is screened slowly.
Step S250 responds search strategy input by user and searches corresponding slow inquiry note in the MySQL database
Record, and it is shown in the html page.
Specifically, the search strategy is the retrieval type for meeting sql like language of user's structure, to be existed by the retrieval type
Corresponding slow inquiry record is searched in MySQL database, while the slow inquiry record that inquiry obtains will show in HTML page in real time
Face.The retrieving is specially:The condition latitude that user is chosen in the html page of front end, is transmitted to by ajax post
Rear end recycles the pymysql modules of Python to connect the MySQL database of rear end storage database, corresponding inquiring
Data are packaged into the format of json with the json modules of Python, are shown back to front end page
Fig. 4 is please referred to, is a kind of work(of slow inquiry unit 110 based on Redis databases provided in an embodiment of the present invention
Can module diagram, which includes configuration module 111, detection module 112, empty module 113, display module 114 and is looked into
Look for module 115.
Configuration module 111 is more than being recorded as predetermined time for configuring the record queries time in the Redis databases
Slow inquiry record.
In embodiments of the present invention, step S210 can be executed by configuration module 111.
Detection module 112 stores whether the list length that slow inquiry records reaches for detecting in the Redis databases
Predetermined length, if reaching, by all slow inquiry record storages in the MySQL database.
In embodiments of the present invention, step S110 and step S220 can be executed by detection module 112.
Module 113 is emptied, for emptying current Redis databases, in order to which the Redis databases can continue to store
New slow inquiry record.
In embodiments of the present invention, step S230 can be executed by emptying module 113.
Display module 114 is stored for calling the html page paging that builds in advance to show in the MySQL database
All slow inquiry records.
In embodiments of the present invention, step S120 and step S240 can be executed by display module 114.
Searching module 115 is searched for responding search strategy input by user in the MySQL database corresponding slow
Inquiry record, and it is shown in the html page.
In embodiments of the present invention, step S130 and step S250 can be executed by searching module 115.
Due to being had been described in the slow querying method based on Redis databases, details are not described herein.
In conclusion a kind of slow querying method, device and terminal based on Redis databases provided in an embodiment of the present invention
Equipment, the Redis databases are connect with the MySQL database being stored in storage device.The looking into slowly based on Redis databases
Inquiry method includes:It detects and stores whether the list length that slow inquiry records reaches predetermined length in the Redis databases, if reaching
It arrives, then by all slow inquiry record storages in MySQL database, and then calls the html page paging displaying built in advance
All slow inquiry records stored in MySQL database, and user can look into according to the search strategy of input in MySQL database
Corresponding slow inquiry record is looked for, and is shown in html page.It can be seen that in the present solution, by by institute in Redis databases
The slow inquiry record timing of some is stored in MySQL database, and is showed in user by html page so that user Ke Tong
Search strategy is crossed easily to be inquired and used.
In several embodiments provided herein, it should be understood that disclosed device and method can also pass through
Other modes are realized.The apparatus embodiments described above are merely exemplary, for example, the flow chart in attached drawing and block diagram
Show the device of multiple embodiments according to the present invention, the architectural framework in the cards of method and computer program product,
Function and operation.In this regard, each box in flowchart or block diagram can represent the one of a module, section or code
Part, a part for the module, section or code, which includes that one or more is for implementing the specified logical function, to be held
Row instruction.It should also be noted that at some as in the realization method replaced, the function of being marked in box can also be to be different from
The sequence marked in attached drawing occurs.For example, two continuous boxes can essentially be basically executed in parallel, they are sometimes
It can execute in the opposite order, this is depended on the functions involved.It is also noted that every in block diagram and or flow chart
The combination of box in a box and block diagram and or flow chart can use function or the dedicated base of action as defined in executing
It realizes, or can be realized using a combination of dedicated hardware and computer instructions in the system of hardware.
In addition, each function module in each embodiment of the present invention can integrate to form an independent portion
Point, can also be modules individualism, can also two or more modules be integrated to form an independent part.
It, can be with if the function is realized and when sold or used as an independent product in the form of software function module
It is stored in a computer read/write memory medium.Based on this understanding, technical scheme of the present invention is substantially in other words
The part of the part that contributes to existing technology or the technical solution can be expressed in the form of software products, the meter
Calculation machine software product is stored in a storage medium, including some instructions are used so that a computer equipment (can be
People's computer, server or network equipment etc.) it performs all or part of the steps of the method described in the various embodiments of the present invention.
And storage medium above-mentioned includes:USB flash disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), arbitrary access are deposited
The various media that can store program code such as reservoir (RAM, Random Access Memory), magnetic disc or CD.It needs
Illustrate, herein, relational terms such as first and second and the like be used merely to by an entity or operation with
Another entity or operation distinguish, and without necessarily requiring or implying between these entities or operation, there are any this realities
The relationship or sequence on border.
The above description is merely a specific embodiment, but scope of protection of the present invention is not limited thereto, any
Those familiar with the art in the technical scope disclosed by the present invention, can easily think of the change or the replacement, and should all contain
Lid is within protection scope of the present invention.
Claims (10)
1. a kind of slow querying method based on Redis databases, the Redis databases and it is stored in storage device
MySQL database connects, which is characterized in that the method includes:
It detects and stores whether the list length that slow inquiry records reaches predetermined length in the Redis databases, it, will if reaching
All slow inquiry record storages are in the MySQL database;
The html page paging built in advance is called to show all slow inquiry records stored in the MySQL database;
It responds search strategy input by user and searches corresponding slow inquiry record in the MySQL database, and be shown in institute
State html page.
2. the method as described in claim 1, which is characterized in that store slow inquiry note in the detection Redis databases
The step of whether list length of record reaches predetermined length include:
Calling task scheduling function timer-triggered scheduler inquires record check function slowly, checks that storage is looked into slowly in the Redis databases
Whether the list length of consultation record reaches predetermined length.
3. the method as described in claim 1, which is characterized in that store slow inquiry note in the detection Redis databases
Whether the list length of record reaches predetermined length, if reaching, by all slow inquiry record storages in the MySQL database
Further include step later:
Current Redis databases are emptied, in order to which the Redis databases can continue the new slow inquiry record of storage.
4. the method as described in claim 1, which is characterized in that store slow inquiry note in the detection Redis databases
The list length of record further includes step before whether reaching predetermined length:
Be recorded as slowly inquiry of the record queries time more than the predetermined time in the Redis databases is configured to record.
5. the method as described in claim 1, which is characterized in that the search strategy is the inspection that user is built by sql like language
Rope strategy.
6. a kind of slow inquiry unit based on Redis databases, the Redis databases and it is stored in storage device
MySQL database connects, which is characterized in that described device includes:
Detection module stores whether the list length that slow inquiry records reaches pre- fixed length for detecting in the Redis databases
Degree, if reaching, by all slow inquiry record storages in the MySQL database;
Display module, for call the html page paging built in advance show stored in the MySQL database it is all slow
Inquiry record;
Searching module searches corresponding slow inquiry note for responding search strategy input by user in the MySQL database
Record, and it is shown in the html page.
7. device as claimed in claim 6, which is characterized in that the detection module is specifically used for:Calling task scheduling function
Timer-triggered scheduler inquires record check function slowly, checks the slow list length for inquiring record is stored in the Redis databases whether
Reach predetermined length.
8. device as claimed in claim 6, which is characterized in that described device further includes:
Module is emptied, for emptying current Redis databases, in order to which the Redis databases can continue to store newly slow
Inquiry record.
9. device as claimed in claim 6, which is characterized in that described device further includes:
Configuration module is recorded as inquiring slowly for configuring the record queries time in the Redis databases more than the predetermined time
Record.
10. a kind of terminal device, which is characterized in that the terminal device includes memory and processor, and the memory is used for
Computer program code is stored, the processor is for executing the computer program code being stored in the memory to realize
The slow querying method based on Redis databases as described in any one of claim 1-5.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810327855.3A CN108563744B (en) | 2018-04-12 | 2018-04-12 | Slow query method and device based on Redis database and terminal equipment |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810327855.3A CN108563744B (en) | 2018-04-12 | 2018-04-12 | Slow query method and device based on Redis database and terminal equipment |
Publications (2)
Publication Number | Publication Date |
---|---|
CN108563744A true CN108563744A (en) | 2018-09-21 |
CN108563744B CN108563744B (en) | 2021-07-23 |
Family
ID=63534822
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810327855.3A Active CN108563744B (en) | 2018-04-12 | 2018-04-12 | Slow query method and device based on Redis database and terminal equipment |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108563744B (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109656959A (en) * | 2018-12-24 | 2019-04-19 | 拉扎斯网络科技(上海)有限公司 | A kind of data query method, apparatus, electronic equipment and storage medium |
CN111258973A (en) * | 2020-01-17 | 2020-06-09 | 广州虎牙科技有限公司 | Storage and display method, device, equipment and medium of Redis slow log |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103838867A (en) * | 2014-03-20 | 2014-06-04 | 网宿科技股份有限公司 | Log processing method and device |
CN105243147A (en) * | 2015-10-22 | 2016-01-13 | 浪潮(北京)电子信息产业有限公司 | Slow query log management method and system of MySQL database |
CN105446893A (en) * | 2014-07-14 | 2016-03-30 | 阿里巴巴集团控股有限公司 | Data storage method and device |
CN107220304A (en) * | 2017-05-10 | 2017-09-29 | 杭州铭师堂教育科技发展有限公司 | The slow Log Administration Systems of magnanimity mongodb based on salt |
WO2017166898A1 (en) * | 2016-03-28 | 2017-10-05 | 北京京东尚科信息技术有限公司 | Method and system for matching multi-dimensional data units in electronic information system |
-
2018
- 2018-04-12 CN CN201810327855.3A patent/CN108563744B/en active Active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103838867A (en) * | 2014-03-20 | 2014-06-04 | 网宿科技股份有限公司 | Log processing method and device |
CN105446893A (en) * | 2014-07-14 | 2016-03-30 | 阿里巴巴集团控股有限公司 | Data storage method and device |
CN105243147A (en) * | 2015-10-22 | 2016-01-13 | 浪潮(北京)电子信息产业有限公司 | Slow query log management method and system of MySQL database |
WO2017166898A1 (en) * | 2016-03-28 | 2017-10-05 | 北京京东尚科信息技术有限公司 | Method and system for matching multi-dimensional data units in electronic information system |
CN107220304A (en) * | 2017-05-10 | 2017-09-29 | 杭州铭师堂教育科技发展有限公司 | The slow Log Administration Systems of magnanimity mongodb based on salt |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109656959A (en) * | 2018-12-24 | 2019-04-19 | 拉扎斯网络科技(上海)有限公司 | A kind of data query method, apparatus, electronic equipment and storage medium |
CN111258973A (en) * | 2020-01-17 | 2020-06-09 | 广州虎牙科技有限公司 | Storage and display method, device, equipment and medium of Redis slow log |
Also Published As
Publication number | Publication date |
---|---|
CN108563744B (en) | 2021-07-23 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US10504120B2 (en) | Determining a temporary transaction limit | |
US20180232438A1 (en) | Title display method and apparatus | |
CN108874289B (en) | Application history record viewing method and device and electronic equipment | |
CN109840257B (en) | Database query method, database query device, computer device and readable storage medium | |
US10838963B2 (en) | Optimized access for hierarchical low cardinality value synopsis in analytical databases | |
CN111930277B (en) | Method and equipment for providing presence information | |
CN105989082A (en) | Report view generation method and apparatus | |
CN106599017B (en) | Scanning analytic method, device and the mobile terminal of installation kit | |
CN111241387A (en) | Improving relevance of search results | |
CN110889039A (en) | Method and equipment for pushing books in reading application | |
CN109918678B (en) | Method and device for identifying field meaning | |
CN102968418A (en) | Website information search method and system | |
CN109450969A (en) | The method, apparatus and server of data are obtained from third party's data source server | |
CN106528889B (en) | A kind of information search method and terminal | |
CN108563744A (en) | Slow querying method, device and terminal device based on Redis databases | |
EP3437006B1 (en) | Malicious database request identification | |
KR100534493B1 (en) | Method and system for recommending category and computer readable recording medium recording program for implementing the method | |
CN111382206A (en) | Data storage method and device | |
CN106897224B (en) | Method and device for determining software testing range | |
CN110489032B (en) | Dictionary query method for electronic book and electronic equipment | |
CN112329409A (en) | Cell color conversion method and device and electronic equipment | |
CN108762637A (en) | Control method, apparatus and system | |
CN108446150A (en) | Repeated using method, device and the terminal device of object | |
CN110309456A (en) | A kind of page display method and device | |
CN113742378A (en) | Data query and storage method, related equipment and storage medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |