CN112491617A - Link tracking method, device, electronic equipment and medium - Google Patents
Link tracking method, device, electronic equipment and medium Download PDFInfo
- Publication number
- CN112491617A CN112491617A CN202011360128.0A CN202011360128A CN112491617A CN 112491617 A CN112491617 A CN 112491617A CN 202011360128 A CN202011360128 A CN 202011360128A CN 112491617 A CN112491617 A CN 112491617A
- Authority
- CN
- China
- Prior art keywords
- request instruction
- link tracking
- link
- identifier
- determining
- 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
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L41/00—Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks
- H04L41/06—Management of faults, events, alarms or notifications
- H04L41/0677—Localisation of faults
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L41/00—Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks
- H04L41/06—Management of faults, events, alarms or notifications
- H04L41/0631—Management of faults, events, alarms or notifications using root cause analysis; using analysis of correlation between notifications, alarms or events based on decision criteria, e.g. hierarchy, tree or time analysis
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/10—Protocols in which an application is distributed across nodes in the network
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/50—Network services
- H04L67/51—Discovery or management thereof, e.g. service location protocol [SLP] or web services
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Debugging And Monitoring (AREA)
Abstract
The embodiment of the invention discloses a link tracking method, a link tracking device, electronic equipment and a medium. The link tracking method comprises the following steps: acquiring request instruction information of execution overtime; wherein the request instruction is a structured query language; determining a link tracking identifier associated with a request instruction according to the request instruction information; wherein the link tracking identifier is a unique identifier constructed in the request instruction generation process; and determining a link tracking result of the request instruction according to the link tracking identifier. According to the embodiment of the invention, the link tracking identifier is added in the request instruction, the link tracking of the request instruction is realized according to the link tracking identifier, and the speed, the accuracy and the abnormal processing efficiency of specific services causing the abnormality in the distributed system positioning are improved.
Description
Technical Field
The embodiment of the invention relates to the technical field of computer data processing, in particular to a link tracking method, a link tracking device, electronic equipment and a link tracking medium.
Background
With the continuous development of computer technology, the service capability of distributed systems such as microservices, distributed databases and distributed caches is greatly improved. Along with the improvement of the service capability of the distributed system, the distributed system is larger and larger in scale and the structure is more and more complex, so that once a request passes through a plurality of services, the condition of response timeout occurs, and the positioning of the specific service causing the abnormity becomes very difficult, and the positioning and processing efficiency of the system abnormity is low.
Disclosure of Invention
The embodiment of the invention provides a link tracking method, a link tracking device, electronic equipment and a medium, which are used for achieving the purpose of performing link tracking on a request instruction.
In a first aspect, an embodiment of the present invention provides a link tracking method, including:
acquiring request instruction information of execution overtime; wherein the request instruction is a structured query language;
determining a link tracking identifier associated with a request instruction according to the request instruction information; wherein the link tracking identifier is a unique identifier constructed in the request instruction generation process;
and determining a link tracking result of the request instruction according to the link tracking identifier.
In a second aspect, an embodiment of the present invention further provides a link tracking apparatus, including:
the request instruction information acquisition module is used for acquiring request instruction information of execution overtime; wherein the request instruction is a structured query language;
the link tracking identification determining module is used for determining a link tracking identification associated with the request instruction according to the request instruction information; wherein the link tracking identifier is a unique identifier constructed in the request instruction generation process;
and the link tracking result determining module is used for determining the link tracking result of the request instruction according to the link tracking identifier.
In a third aspect, an embodiment of the present invention further provides an electronic device, including:
one or more processors;
a memory for storing one or more programs,
when executed by the one or more processors, cause the one or more processors to implement a link tracking method according to any embodiment of the invention.
In a fourth aspect, the present invention further provides a non-transitory computer-readable storage medium storing computer instructions for causing a computer to execute a link tracking method according to any one of the embodiments.
According to the technical scheme provided by the embodiment of the invention, request instruction information of execution overtime is acquired; wherein the request instruction is a structured query language; determining a link tracking identifier associated with a request instruction according to the request instruction information; wherein the link tracking identifier is a unique identifier constructed in the request instruction generation process; and determining a link tracking result of the request instruction according to the link tracking identifier. According to the technical scheme provided by the embodiment of the invention, the link tracking identifier can be added in the request instruction, and the link tracking of the request instruction is realized according to the link tracking identifier, so that the speed and the accuracy of specific services which cause abnormity in the positioning of a distributed system are improved, and the abnormity processing efficiency of the system is further improved.
Drawings
FIG. 1 is a flow chart of a link tracking method according to a first embodiment of the present invention;
FIG. 2 is a flowchart of a link tracking method according to a second embodiment of the present invention;
fig. 3 is a schematic structural diagram of a link tracking apparatus according to a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of an electronic device to which the link tracking method in the embodiment of the present invention is applied.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
Example one
Fig. 1 is a flowchart of a link tracing method according to a first embodiment of the present invention, which is applicable to a case of performing link tracing on a request instruction. It should be noted that, in the embodiment of the present invention, the link tracing refers to restoring the call link of the request instruction, and collectively displaying the call condition of the request instruction. The link tracking method provided by the embodiment of the invention can be executed by a link tracking device, the device can be realized in a software and/or hardware mode, and can be configured in electronic equipment, and the electronic equipment can be electronic equipment with communication and computing capabilities, such as a server and the like. As shown in fig. 1, the method specifically includes:
s110, acquiring request instruction information for executing overtime; wherein the request instruction is a structured query language.
The request instruction is a structured query language, and some services such as data query and data storage can be realized. Structured Query language (sql), a special purpose programming language, is a database Query and programming language for accessing data and querying, updating, and managing a relational database system.
The request instruction with the execution time-out refers to a request instruction with the execution time exceeding a set threshold value. Specifically, the request instruction for executing timeout is a slow SQL statement. The set threshold is an empirical value set by a person skilled in the art according to an actual service scenario, and is not limited herein, and is determined according to an actual situation. In the database, the default value is generally 10 seconds, that is, the SQL statement whose execution time exceeds 10 seconds is slow SQL. Wherein the request instruction information for executing the timeout is a record provided by a party executing the request instruction about the request instruction for executing the timeout, and the request instruction information includes: a request instruction that executed a timeout, an execution time of the request instruction, and a current database executing the request instruction.
And acquiring request instruction information of execution timeout, specifically acquiring slow SQL information from a slow log of the database. The slow log is a log record provided by a database, and SQL statements with response time exceeding a threshold value in the database are recorded in the slow log.
S120, determining a link tracking identifier associated with the request instruction according to the request instruction information; wherein the link tracking identifier is a unique identifier constructed in the request instruction generation process.
The link tracking identification is a unique identification constructed in the process of generating the request instruction, the link tracking identification is associated with the request instruction, and the other party information can be determined under the condition that the link tracking identification or the request instruction is known.
S130, determining a link tracking result of the request instruction according to the link tracking identifier.
The link tracking refers to restoring the call link of the request instruction and displaying the call condition of the request instruction in a centralized manner. The calling condition comprises the time consumption of the request instruction on each consumer, the specific server to which the request instruction arrives, the request state of each consumer and other information. The link tracking result refers to the calling condition of centralized display.
After the request command is processed by the consumption end, the consumption end can generate the execution condition of the request command, the link tracking identifier of the request command and the record of the information of the sender of the request command, so that the link result of the request command identified by the link tracking identifier can be determined by inquiring the record of the consumption end according to the link identifier.
According to the technical scheme provided by the embodiment of the invention, request instruction information of execution overtime is acquired; wherein the request instruction is a structured query language; determining a link tracking identifier associated with a request instruction according to the request instruction information; wherein the link tracking identifier is a unique identifier constructed in the request instruction generation process; and determining a link tracking result of the request instruction according to the link tracking identifier. According to the technical scheme provided by the embodiment of the invention, the link tracking identifier can be added in the request instruction, and the link tracking of the request instruction is realized according to the link tracking identifier, so that the speed and the accuracy of specific services which cause abnormity in the positioning of a distributed system are improved, and the abnormity processing efficiency of the system is further improved.
Example two
Fig. 2 is a flowchart of a link tracking method in the second embodiment of the present invention, and the present embodiment further optimizes, specifically optimizes, on the basis of the foregoing embodiment: before determining the link tracking identifier associated with the request instruction according to the request instruction information, the method further comprises: acquiring a request instruction generated by an application terminal and the link tracking identifier; establishing an incidence relation between the request instruction and the link tracking identifier; and sending the request instruction to the consumption end through the application end, so that the consumption end prints an execution log of the request instruction after executing the request instruction and uploads the execution log to a cloud end.
As shown in fig. 2, the method includes:
s210, acquiring a request instruction generated by an application end and the link tracking identification.
The request instruction and the link tracking identifier are both generated by the application terminal, and specifically, the link tracking identifier is generated in the process of generating the request instruction by the application terminal. The request instruction and the link tracking identifier generated by the application terminal can be obtained from the application terminal log.
S220, establishing an association relation between the request instruction and the link tracking identifier.
And establishing a one-to-one incidence relation between the request instruction and the link tracking identifier, wherein one request instruction only has one link tracking identifier, and the link tracking identifiers of the request instructions are different from one another.
Optionally, a mapping table of correspondence between the request instruction and the link tracking identifier is established according to the request instruction and the link tracking identifier, and the mapping table is stored in the cloud.
In an optional embodiment, establishing an association relationship between the request instruction and the link tracking identifier includes: and adding the link tracking identifier to the request instruction through the application end.
The link tracking identifier may be a randomly generated character string, and the application adds the link tracking identifier to the request instruction in the process of generating the request instruction. The link tracking identification is added into the request instruction, and when the request instruction is executed and the execution of the request instruction is overtime, the application end generating the request instruction can be quickly determined, so that the speed of positioning the abnormity is improved.
S230, the request instruction is sent to the consumption end through the application end, so that the consumption end can print an execution log of the request instruction after executing the request instruction, and the execution log is uploaded to a cloud end.
The consumption end is a service unit for executing the request instruction, the application end sends the request instruction to the consumption end, and the consumption end prints a log describing the execution condition of the request instruction after executing the request instruction. The number of consumers is typically many. The execution log is one or more log files automatically created and maintained by the consumption end, and the log files contain lists of executed request instructions for the operation state of the consumption end. After the consumer prints the log, the execution log is uploaded to the cloud.
S240, acquiring request instruction information of execution overtime; wherein the request instruction is a structured query language.
S250, determining a link tracking identifier associated with the request instruction according to the request instruction information; wherein the link tracking identifier is a unique identifier constructed in the request instruction generation process.
And S260, determining a link tracking result of the request instruction according to the link tracking identifier.
In an optional embodiment, determining the link trace result of the request instruction according to the link trace identifier includes: acquiring an execution log of the request instruction printed by the consumption end; wherein the execution log comprises: the request instruction execution condition record and the link tracking identification record of the request instruction; and acquiring the link tracking result of the request instruction from the execution log according to the link tracking identifier.
The obtaining of the execution log of the request instruction printed by the consumer is specifically obtaining the execution log of the request instruction printed by the consumer from the cloud. The execution log includes: request instruction execution condition record and request instruction link tracking identification record, the request instruction execution condition includes: the execution time of the request command, the upstream and downstream request relationship of the request command, and the like.
And acquiring a link tracking result of the request instruction, namely the calling condition of the request instruction from the execution log of each consumer according to the link tracking identifier.
In an optional embodiment, after determining the link tracking result of the request instruction according to the link tracking identifier, the method further includes: determining to generate application end information of the request instruction according to a link tracking result of the request instruction; and sending the application terminal information to a client terminal so that a user can analyze the overtime reason of the request instruction.
The link tracking result is the centralized display of the calling condition of the request instruction, the link tracking result comprises the information of each consumption end of the request instruction and the information of the application end for generating the request instruction, and the information of the application end for generating the request instruction can be determined after the link tracking result of the request instruction is obtained.
The application terminal information includes identification information of the application terminal and information such as time for the application terminal to send the request instruction. And sending the application end information to the client, and analyzing the overtime reason of the request instruction by the user according to the application end information. The user refers to a developer who develops the application end generating the request command.
For example, when the request instruction is to query all historical billing data of the client, the developer may implement the method to query all historical bills of the client at one time through the SQL script "select from user historical bill table user ═ 88888". In the case where the customer bill reaches ten thousand levels, the program performance becomes poor. Through the slow SQL analysis tool of the database, the script "select from user history bill table where user 88888" is slow SQL can be analyzed. In order to locate the specific application end service of the slow SQL, the link tracking identifier of the slow SQL can be obtained by executing an SQL script "select from user history bill table user 88888and link tracking identifier", then the application end generating the slow SQL is located from the execution log printed by the consumption end according to the link tracking identifier, then the developer of the application end is determined, and the developer optimizes the SQL script.
According to the embodiment of the invention, the information of the application terminal generating the request instruction is determined to be positioned to the application terminal developer through the link tracking result, and the developer optimizes the overtime request instruction, so that the exception handling efficiency of the system is improved.
According to the technical scheme provided by the embodiment of the invention, a request instruction generated by an application end and the link tracking identification are obtained; establishing an incidence relation between the request instruction and the link tracking identifier; sending the request instruction to the consumption end through the application end, so that the consumption end prints an execution log of the request instruction after executing the request instruction and uploads the execution log to a cloud end; acquiring request instruction information of execution overtime; wherein the request instruction is a structured query language; determining a link tracking identifier associated with a request instruction according to the request instruction information; wherein the link tracking identifier is a unique identifier constructed in the request instruction generation process; determining a link tracking result of the request instruction according to the link tracking identifier; according to the embodiment of the invention, the link tracking identification associated with the request instruction is determined according to the request instruction information by acquiring the request instruction information with overtime execution, and then the link tracking result of the request instruction is acquired from the execution log of the request instruction printed by the consumption end according to the link tracking identification, so that the link tracking process of the request instruction is simplified, and the speed and the accuracy of specific services causing abnormity in the positioning of a distributed system are improved.
EXAMPLE III
Fig. 3 is a schematic structural diagram of a link tracking apparatus in a fifth embodiment of the present invention, which is applicable to a case of performing link tracking on a request instruction. The apparatus may be implemented by software and/or hardware, and may be configured in an electronic device.
As shown in fig. 3, the apparatus may include: a request instruction information acquisition module 310, a link trace identification determination module 320, and a link trace result determination module 330.
A request instruction information obtaining module 310, configured to obtain request instruction information with execution timeout; wherein the request instruction is a structured query language;
a link tracking identifier determining module 320, configured to determine, according to the request instruction information, a link tracking identifier associated with the request instruction; wherein the link tracking identifier is a unique identifier constructed in the request instruction generation process;
and the link tracking result determining module 330 is configured to determine a link tracking result of the request instruction according to the link tracking identifier.
According to the technical scheme provided by the embodiment of the invention, request instruction information of execution overtime is acquired; wherein the request instruction is a structured query language; determining a link tracking identifier associated with a request instruction according to the request instruction information; wherein the link tracking identifier is a unique identifier constructed in the request instruction generation process; and determining a link tracking result of the request instruction according to the link tracking identifier. According to the technical scheme provided by the embodiment of the invention, the link tracking identifier can be added in the request instruction, and the link tracking of the request instruction is realized according to the link tracking identifier, so that the speed and the accuracy of specific services which cause abnormity in the positioning of a distributed system are improved, and the abnormity processing efficiency of the system is further improved.
Optionally, the apparatus further comprises: the application end data acquisition module is used for acquiring the request instruction and the link tracking identifier generated by the application end before determining the link tracking identifier associated with the request instruction according to the request instruction information; an association relation establishing module, configured to establish an association relation between the request instruction and the link tracking identifier; and the request instruction sending module is used for sending the request instruction to the consumption end through the application end so that the consumption end can print an execution log of the request instruction after executing the request instruction and upload the execution log to a cloud end.
Optionally, the association relationship establishing module is specifically configured to add the link tracking identifier to the request instruction through the application terminal.
Optionally, the link tracking result determining module 330 includes: the execution log obtaining submodule is used for obtaining the execution log of the request instruction printed by the consumption end; wherein the execution log comprises: the request instruction execution condition record and the link tracking identification record of the request instruction; and the link tracking result acquisition submodule is used for acquiring the link tracking result of the request instruction from the execution log according to the link tracking identifier.
Optionally, the apparatus further comprises: an application terminal information determining module, configured to determine, according to the link tracking result of the request instruction, application terminal information for generating the request instruction after determining the link tracking result of the request instruction according to the link tracking identifier; and the application terminal information sending module is used for sending the application terminal information to a client terminal so as to analyze the overtime reason of the request instruction for a user.
The link tracking device provided by the embodiment of the invention can execute the link tracking method provided by any embodiment of the invention, and has corresponding functional modules and beneficial effects for executing the link tracking method.
Example four
The invention also provides an electronic device and a readable storage medium according to the embodiment of the invention.
Fig. 4 is a schematic structural diagram of an electronic device implementing the link tracking method according to the embodiment of the present invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The electronic device may also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable electronic devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of embodiments of the inventions described and/or claimed herein.
As shown in fig. 4, the electronic apparatus includes: one or more processors 410, memory 420, and interfaces for connecting the various components, including a high-speed interface and a low-speed interface. The various components are interconnected using different buses and may be mounted on a common motherboard or in other manners as desired. The processor may process instructions for execution within the electronic device, including instructions stored in or on the memory to display graphical information of a GUI on an external input/output device (such as a display electronic device coupled to the interface). In other embodiments, multiple processors and/or multiple buses may be used, along with multiple memories and multiple memories, as desired. Also, multiple electronic devices may be connected, with each electronic device providing portions of the necessary operations (e.g., as an array of electronic devices, a set of blade-like electronic devices, or a multi-processor system). One processor 410 is illustrated in fig. 4.
The memory 420 is a non-transitory computer readable storage medium provided by the embodiments of the present invention. The memory stores instructions executable by the at least one processor to cause the at least one processor to perform the link tracking method provided by the embodiments of the present invention. The non-transitory computer-readable storage medium of an embodiment of the present invention stores computer instructions for causing a computer to perform the link tracking method provided by an embodiment of the present invention.
The memory 420, which is a non-transitory computer readable storage medium, may be used to store non-transitory software programs, non-transitory computer executable programs, and modules, such as program instructions/modules corresponding to the link tracking method in the embodiment of the present invention (for example, the information acquisition module 310, the link tracking identifier determination module 320, and the link tracking result determination module 330 shown in fig. 3). The processor 410 executes various functional applications and data processing of the electronic device by executing non-transitory software programs, instructions and modules stored in the memory 420, that is, implements the link tracking method in the above-described method embodiments.
The memory 420 may include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function; the storage data area may store data created by use of the electronic device implementing the link tracking method, and the like. Further, the memory 420 may include high speed random access memory, and may also include non-transitory memory, such as at least one magnetic disk storage device, flash memory device, or other non-transitory solid state storage device. In some embodiments, memory 420 may optionally include memory located remotely from processor 410, which may be connected over a network to an electronic device that performs the link tracking method. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The electronic device performing the link tracking method may further include: an input device 430 and an output device 440. The processor 410, the memory 420, the input device 430, and the output device 440 may be connected by a bus or other means, such as the bus connection in fig. 4.
The input device 430 may receive input numeric or character information and generate key signal inputs related to user settings and function control of an electronic apparatus performing the link tracking method, such as an input device of a touch screen, a keypad, a mouse, a track pad, a touch pad, a pointing stick, one or more mouse buttons, a track ball, a joystick, or the like. Output devices 440 may include display electronics, auxiliary lighting devices (e.g., LEDs), tactile feedback devices (e.g., vibrating motors), and the like. The display electronics may include, but are not limited to, Liquid Crystal Displays (LCDs), Light Emitting Diode (LED) displays, and plasma displays. In some implementations, the display electronics can be a touch screen.
Various implementations of the systems and techniques described here can be realized in digital electronic circuitry, integrated circuitry, application specific ASICs (application specific integrated circuits), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs that are executable and/or interpretable on a programmable system including at least one programmable processor, which may be special or general purpose, receiving data and instructions from, and transmitting data and instructions to, a storage system, at least one input device, and at least one output device.
These computer programs (also known as programs, software applications, or code) include machine instructions for a programmable processor, and may be implemented using high-level procedural and/or object-oriented programming languages, and/or assembly/machine languages. As used herein, the terms "machine-readable medium" and "computer-readable medium" refer to any computer program product, electronic device, and/or apparatus (e.g., magnetic discs, optical disks, memory, Programmable Logic Devices (PLDs)) used to provide machine instructions and/or data to a programmable processor, including a machine-readable medium that receives machine instructions as a machine-readable signal. The term "machine-readable signal" refers to any signal used to provide machine instructions and/or data to a programmable processor.
To provide for interaction with a user, the systems and techniques described here can be implemented on a computer having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) by which a user can provide input to the computer. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic, speech, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a back-end component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back-end, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), Wide Area Networks (WANs), the internet, and blockchain networks.
The computer system may include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other.
It should be understood that various forms of the flows shown above may be used, with steps reordered, added, or deleted. For example, the steps described in the embodiments of the present invention may be executed in parallel, may be executed sequentially, or may be executed in different orders, so long as the desired results of the technical solutions disclosed in the embodiments of the present invention can be achieved, which is not limited herein.
The above detailed description does not limit the scope of the embodiments of the present invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may be made in accordance with design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the embodiments of the present invention should be included in the scope of the embodiments of the present invention.
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (10)
1. A method of link tracing, the method comprising:
acquiring request instruction information of execution overtime; wherein the request instruction is a structured query language;
determining a link tracking identifier associated with a request instruction according to the request instruction information; wherein the link tracking identifier is a unique identifier constructed in the request instruction generation process;
and determining a link tracking result of the request instruction according to the link tracking identifier.
2. The method of claim 1, further comprising, prior to said determining a link trace identification associated with a requested instruction from said requested instruction information:
acquiring a request instruction generated by an application terminal and the link tracking identifier;
establishing an incidence relation between the request instruction and the link tracking identifier;
and sending the request instruction to the consumption end through the application end, so that the consumption end prints an execution log of the request instruction after executing the request instruction and uploads the execution log to a cloud end.
3. The method of claim 2, wherein the establishing the association between the request command and the link tracking identifier comprises:
and adding the link tracking identifier to the request instruction through the application end.
4. The method of claim 1, wherein determining the link trace result of the requested instruction according to the link trace identifier comprises:
acquiring an execution log of the request instruction printed by the consumption end; wherein the execution log comprises: the request instruction execution condition record and the link tracking identification record of the request instruction;
and acquiring the link tracking result of the request instruction from the execution log according to the link tracking identifier.
5. The method of claim 1, after determining the link trace result of the requested instruction according to the link trace identity, further comprising:
determining to generate application end information of the request instruction according to a link tracking result of the request instruction;
and sending the application terminal information to a client terminal so that a user can analyze the overtime reason of the request instruction.
6. A link tracking apparatus, the apparatus comprising:
the request instruction information acquisition module is used for acquiring request instruction information of execution overtime; wherein the request instruction is a structured query language;
the link tracking identification determining module is used for determining a link tracking identification associated with the request instruction according to the request instruction information; wherein the link tracking identifier is a unique identifier constructed in the request instruction generation process;
and the link tracking result determining module is used for determining the link tracking result of the request instruction according to the link tracking identifier.
7. The apparatus of claim 6, further comprising:
the application end data acquisition module is used for acquiring the request instruction and the link tracking identifier generated by the application end before determining the link tracking identifier associated with the request instruction according to the request instruction information;
an association relation establishing module, configured to establish an association relation between the request instruction and the link tracking identifier;
and the request instruction sending module is used for sending the request instruction to the consumption end through the application end so that the consumption end can print an execution log of the request instruction after executing the request instruction and upload the execution log to a cloud end.
8. The apparatus according to claim 7, wherein the association relationship establishing module is specifically configured to add the link tracking identifier to the request instruction through the application terminal.
9. An electronic device, characterized in that the electronic device comprises:
one or more processors;
a memory for storing one or more programs;
when executed by the one or more processors, cause the one or more processors to implement the link tracing method as recited in any of claims 1-5.
10. A non-transitory computer readable storage medium having stored thereon computer instructions for causing a computer to perform the link tracking method of any one of claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011360128.0A CN112491617B (en) | 2020-11-27 | 2020-11-27 | Link tracking method, device, electronic equipment and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011360128.0A CN112491617B (en) | 2020-11-27 | 2020-11-27 | Link tracking method, device, electronic equipment and medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112491617A true CN112491617A (en) | 2021-03-12 |
| CN112491617B CN112491617B (en) | 2023-06-09 |
Family
ID=74936132
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011360128.0A Active CN112491617B (en) | 2020-11-27 | 2020-11-27 | Link tracking method, device, electronic equipment and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112491617B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113468218A (en) * | 2021-06-30 | 2021-10-01 | 建信金融科技有限责任公司 | Method and device for monitoring and managing database slow SQL |
| CN113760647A (en) * | 2021-04-15 | 2021-12-07 | 北京京东乾石科技有限公司 | SQL tracking method, device, equipment, system and storage medium |
| CN113778736A (en) * | 2021-09-14 | 2021-12-10 | 北京房江湖科技有限公司 | Method and device for positioning error information |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109831351A (en) * | 2018-12-29 | 2019-05-31 | 深圳云天励飞技术有限公司 | Link trace method, apparatus, terminal and storage medium |
| CN111078504A (en) * | 2019-12-25 | 2020-04-28 | 深圳前海环融联易信息科技服务有限公司 | Distributed call chain tracking method and device, computer equipment and storage medium |
| CN111241125A (en) * | 2020-01-08 | 2020-06-05 | 成都嗨学洛子教育科技有限公司 | Method and device for recording operation log, electronic equipment and storage medium |
-
2020
- 2020-11-27 CN CN202011360128.0A patent/CN112491617B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109831351A (en) * | 2018-12-29 | 2019-05-31 | 深圳云天励飞技术有限公司 | Link trace method, apparatus, terminal and storage medium |
| CN111078504A (en) * | 2019-12-25 | 2020-04-28 | 深圳前海环融联易信息科技服务有限公司 | Distributed call chain tracking method and device, computer equipment and storage medium |
| CN111241125A (en) * | 2020-01-08 | 2020-06-05 | 成都嗨学洛子教育科技有限公司 | Method and device for recording operation log, electronic equipment and storage medium |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113760647A (en) * | 2021-04-15 | 2021-12-07 | 北京京东乾石科技有限公司 | SQL tracking method, device, equipment, system and storage medium |
| CN113468218A (en) * | 2021-06-30 | 2021-10-01 | 建信金融科技有限责任公司 | Method and device for monitoring and managing database slow SQL |
| CN113778736A (en) * | 2021-09-14 | 2021-12-10 | 北京房江湖科技有限公司 | Method and device for positioning error information |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112491617B (en) | 2023-06-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111831420B (en) | Method for task scheduling, related device and computer program product | |
| CN107451109B (en) | Report generation method and system | |
| CN112491617B (en) | Link tracking method, device, electronic equipment and medium | |
| EP3859533A2 (en) | Method and apparatus for testing map service, electronic device, storage medium and computer program product | |
| CN110765024B (en) | Simulation test method, simulation test device, electronic equipment and computer readable storage medium | |
| EP4006731A1 (en) | Method, apparatus, device, storage medium and computer program product for testing code | |
| CN111639027B (en) | Test method and device and electronic equipment | |
| CN111831512B (en) | Method and device for detecting operation and maintenance abnormality, electronic equipment and storage medium | |
| CN111666280B (en) | Comment ordering method, comment ordering device, comment ordering equipment and computer storage medium | |
| CN111752843A (en) | Method, device, electronic equipment and readable storage medium for determining influence surface | |
| CN112561332B (en) | Model management method, device, electronic equipment, storage medium and program product | |
| CN112269706B (en) | Interface parameter verification method, device, electronic equipment and computer readable medium | |
| CN111241396B (en) | Information pushing method and device, electronic equipment and storage medium | |
| CN112395333A (en) | Method and device for checking data exception, electronic equipment and storage medium | |
| CN112527620A (en) | Database performance analysis method and device, electronic equipment, medium and product | |
| CN112667795A (en) | Dialog tree construction method and device, dialog tree operation method, device and system | |
| CN115905322A (en) | Service processing method and device, electronic equipment and storage medium | |
| CN111694686B (en) | Processing method and device for abnormal service, electronic equipment and storage medium | |
| CN114661274A (en) | Method and device for generating intelligent contract | |
| CN112015623B (en) | Report data processing method, device, equipment and readable storage medium | |
| CN111581049B (en) | Distributed system running state monitoring method, device, equipment and storage medium | |
| CN111597026B (en) | Method and device for acquiring information | |
| CN112735601B (en) | Test method, device and equipment for determining infectious disease close-contact population by using Bluetooth | |
| CN111726402B (en) | User behavior data processing method and device, electronic equipment and storage medium | |
| CN115840604B (en) | Data processing method, device, electronic equipment and computer readable 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 |