CN108183833B - Response processing method and device and computer readable storage medium - Google Patents
Response processing method and device and computer readable storage medium Download PDFInfo
- Publication number
- CN108183833B CN108183833B CN201711225681.1A CN201711225681A CN108183833B CN 108183833 B CN108183833 B CN 108183833B CN 201711225681 A CN201711225681 A CN 201711225681A CN 108183833 B CN108183833 B CN 108183833B
- Authority
- CN
- China
- Prior art keywords
- time
- response
- database
- overtime
- different
- 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.)
- Active
Links
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L43/00—Arrangements for monitoring or testing data switching networks
- H04L43/08—Monitoring or testing based on specific metrics, e.g. QoS, energy consumption or environmental parameters
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L43/00—Arrangements for monitoring or testing data switching networks
- H04L43/08—Monitoring or testing based on specific metrics, e.g. QoS, energy consumption or environmental parameters
- H04L43/0805—Monitoring or testing based on specific metrics, e.g. QoS, energy consumption or environmental parameters by checking availability
- H04L43/0811—Monitoring or testing based on specific metrics, e.g. QoS, energy consumption or environmental parameters by checking availability by checking connectivity
-
- 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
Abstract
The embodiment of the invention discloses a response processing method, which comprises the following steps: the client sets different durations; and judging whether the response in the different database service processing processes is overtime or not by adopting the set different time lengths. By implementing the scheme, the client side respectively judges whether the response in different database service processing processes is overtime by adopting different set time lengths, so that the corresponding overtime condition in the database connection establishing process is well judged, and the response overtime condition in the database access process is also well judged.
Description
Technical Field
The present invention relates to the field of communications technologies, and in particular, to a response processing method and apparatus, and a computer-readable storage medium.
Background
The interaction between the database MySQL client and the server can be divided into three processes: a handshake authentication process, a database connection establishment process and a database access process.
Both the connection establishment process and the database access process of the database need to determine whether the response time is overtime, and whether the response time is overtime is generally determined according to the parameter socketTimeout.
However, since the average response time of the database connection establishment procedure is much shorter than the response time of the database access procedure, when the socketTimeout is set to be large, it cannot be well determined whether the response in the database connection establishment procedure is overtime, and when the socketTimeout is set to be small, it cannot be well determined whether the response in the database access procedure is overtime.
Disclosure of Invention
The embodiments of the present invention provide a response processing method, an apparatus, and a computer-readable storage medium, which can well determine whether a response in a database connection establishment process is overtime, and also can well determine whether a response in a database access process is overtime.
The response processing method provided by the embodiment of the invention comprises the following steps:
the client sets different durations;
and judging whether the response in the different database service processing processes is overtime or not by adopting the set different time lengths.
The method for judging whether the response in the different database service processing processes is overtime or not by adopting the set different time lengths comprises the following steps:
judging whether the response in the database connection establishing process is overtime or not by adopting the set first time length;
and judging whether the response in the database access process is overtime or not by adopting a set second time length different from the first time length.
The step of judging whether the response in the database connection establishing process is overtime by setting the first time length comprises the following steps:
acquiring time for sending a database connection establishment request to a server as first time;
calculating to obtain a second time according to the first time and the set first time;
and judging whether the response in the database connection establishing process is overtime according to the second time.
The judging whether the response in the database connection establishing process is overtime according to the second time includes:
judging whether the self receives a reply aiming at the database connection establishment request sent by the server before or when the second time arrives;
and if the response to the database connection establishment request sent by the server is not received before and when the second time arrives, determining that the response in the database connection establishment process is overtime.
The step of judging whether the response in the database access process is overtime or not by adopting the set second time length different from the first time length comprises the following steps:
acquiring time for sending a database access request to a server as third time;
calculating to obtain a fourth time according to the third time and a set second duration;
and judging whether the response in the database access process is overtime or not according to the fourth time.
The judging whether the response in the database access process is overtime according to the fourth time includes:
judging whether the self receives a reply aiming at the database access request sent by the server before or when the fourth time arrives;
and if the response to the database access request sent by the server is not received before and when the fourth time arrives, determining that the response in the database access process is overtime.
An embodiment of the present invention further provides a response processing apparatus, including: a processor, a memory, and a communication bus;
the communication bus is used for realizing connection communication between the processor and the memory;
the processor is used for executing the response processing program stored in the memory to realize the following steps:
setting different time lengths;
and judging whether the response in the different database service processing processes is overtime or not by adopting the set different time lengths.
The processor is further configured to execute a response handler stored in the memory to implement the steps of:
judging whether the response in the database connection establishing process is overtime or not by adopting the set first time length;
and judging whether the response in the database access process is overtime or not by adopting a set second time length different from the first time length.
The processor is further configured to execute the response handler to implement the following steps:
acquiring time when a client sends a database connection establishment request to a server as first time;
calculating to obtain a second time according to the first time and the first time length;
and judging whether the response in the database connection establishing process is overtime according to the second time.
An embodiment of the present invention further provides a computer-readable storage medium, where a computer program is stored on the storage medium, and when executed by a processor, the computer program implements the following steps:
setting different time lengths;
and judging whether the response in the different database service processing processes is overtime or not by adopting the set different time lengths.
According to the response processing method, the response processing device and the computer readable storage medium provided by the embodiment of the invention, the client sets different time lengths; and judging whether the response in the different database service processing processes is overtime or not by adopting the set different time lengths. According to the technical scheme provided by the invention, the client side adopts the set different durations to respectively judge whether the response in different database service processing processes is overtime, so that the corresponding overtime condition in the database connection establishing process is well judged, and the response overtime condition in the database access process is also well judged.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention. In the drawings:
fig. 1 is a schematic hardware configuration of a mobile terminal implementing various embodiments of the present invention;
FIG. 2 is a schematic diagram of a communication system supporting communication between mobile terminals in accordance with the present invention;
fig. 3 is a schematic flow chart of a response processing method according to an embodiment of the present invention;
fig. 4 is a schematic flow chart of another response processing method according to an embodiment of the present invention;
fig. 5 is a schematic flow chart of another response processing method according to an embodiment of the present invention;
fig. 6 is a schematic flow chart of another response processing method according to an embodiment of the present invention;
fig. 7 is a schematic interaction diagram of a client and a server according to an embodiment of the present invention;
fig. 8 is a schematic structural diagram of a response processing apparatus according to an embodiment of the present invention.
The implementation, functional features and advantages of the objects of the embodiments of the present invention will be further described with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
In the following description, suffixes such as "module", "component", or "unit" used to denote elements are used only for facilitating the explanation of the present invention, and have no specific meaning in itself. Thus, "module", "component" or "unit" may be used mixedly.
The terminal may be implemented in various forms. For example, the terminal described in the present invention may include a mobile terminal such as a mobile phone, a tablet computer, a notebook computer, a palmtop computer, a Personal Digital Assistant (PDA), a Portable Media Player (PMP), a navigation device, a wearable device, a smart band, a pedometer, and the like, and a fixed terminal such as a Digital TV, a desktop computer, and the like.
The following description will be given by way of example of a mobile terminal, and it will be understood by those skilled in the art that the construction according to the embodiment of the present invention can be applied to a fixed type terminal, in addition to elements particularly used for mobile purposes.
Referring to fig. 1, which is a schematic diagram of a hardware structure of a mobile terminal for implementing various embodiments of the present invention, the mobile terminal 100 may include: RF (Radio Frequency) unit 101, WiFi module 102, audio output unit 103, a/V (audio/video) input unit 104, sensor 105, display unit 106, user input unit 107, interface unit 108, memory 109, processor 110, and power supply 111. Those skilled in the art will appreciate that the mobile terminal architecture shown in fig. 1 is not intended to be limiting of mobile terminals, which may include more or fewer components than those shown, or some components may be combined, or a different arrangement of components.
The following describes each component of the mobile terminal in detail with reference to fig. 1:
the radio frequency unit 101 may be configured to receive and transmit signals during information transmission and reception or during a call, and specifically, receive downlink information of a base station and then process the downlink information to the processor 110; in addition, the uplink data is transmitted to the base station. Typically, radio frequency unit 101 includes, but is not limited to, an antenna, at least one amplifier, a transceiver, a coupler, a low noise amplifier, a duplexer, and the like. In addition, the radio frequency unit 101 can also communicate with a network and other devices through wireless communication. The wireless communication may use any communication standard or protocol, including but not limited to GSM (Global System for Mobile communications), GPRS (General Packet Radio Service), CDMA2000(Code Division Multiple Access 2000), WCDMA (Wideband Code Division Multiple Access), TD-SCDMA (Time Division-Synchronous Code Division Multiple Access), FDD-LTE (Frequency Division duplex Long Term Evolution), and TDD-LTE (Time Division duplex Long Term Evolution).
WiFi belongs to short-distance wireless transmission technology, and the mobile terminal can help a user to receive and send e-mails, browse webpages, access streaming media and the like through the WiFi module 102, and provides wireless broadband internet access for the user. Although fig. 1 shows the WiFi module 102, it is understood that it does not belong to the essential constitution of the mobile terminal, and may be omitted entirely as needed within the scope not changing the essence of the invention.
The audio output unit 103 may convert audio data received by the radio frequency unit 101 or the WiFi module 102 or stored in the memory 109 into an audio signal and output as sound when the mobile terminal 100 is in a call signal reception mode, a call mode, a recording mode, a voice recognition mode, a broadcast reception mode, or the like. Also, the audio output unit 103 may also provide audio output related to a specific function performed by the mobile terminal 100 (e.g., a call signal receiving sound, an information receiving sound, etc.). The audio output unit 103 may include a speaker, a buzzer, and the like.
The a/V input unit 104 is used to receive audio or video signals. The a/V input Unit 104 may include a Graphics Processing Unit (GPU) 1041 and a microphone 1042, the Graphics processor 1041 Processing image data of still pictures or video obtained by an image capturing device (e.g., a camera) in a video capturing mode or an image capturing mode. The processed image frames may be displayed on the display unit 106. The image frames processed by the graphic processor 1041 may be stored in the memory 109 (or other storage medium) or transmitted via the radio frequency unit 101 or the WiFi module 102. The microphone 1042 may receive sounds (audio data) via the microphone 1042 in a phone call mode, a recording mode, a voice recognition mode, or the like, and may be capable of processing such sounds into audio data. The processed audio (voice) data may be converted into a format output transmittable to a mobile communication base station via the radio frequency unit 101 in case of a phone call mode. The microphone 1042 may implement various types of noise cancellation (or suppression) algorithms to cancel (or suppress) noise or interference generated in the course of receiving and transmitting audio signals.
The mobile terminal 100 also includes at least one sensor 105, such as a light sensor, a motion sensor, and other sensors. Specifically, the light sensor includes an ambient light sensor that can adjust the brightness of the display panel 1061 according to the brightness of ambient light, and a proximity sensor that can turn off the display panel 1061 and/or a backlight when the mobile terminal 100 is moved to the ear. As one of the motion sensors, the accelerometer sensor can detect the magnitude of acceleration in each direction (generally, three axes), can detect the magnitude and direction of gravity when stationary, and can be used for applications of recognizing the posture of a mobile phone (such as horizontal and vertical screen switching, related games, magnetometer posture calibration), vibration recognition related functions (such as pedometer and tapping), and the like; as for other sensors such as a fingerprint sensor, a pressure sensor, an iris sensor, a molecular sensor, a gyroscope, a barometer, a hygrometer, a thermometer, and an infrared sensor, which can be configured on the mobile phone, further description is omitted here.
The display unit 106 is used to display information input by a user or information provided to the user. The Display unit 106 may include a Display panel 1061, and the Display panel 1061 may be configured in the form of a Liquid Crystal Display (LCD), an Organic Light-Emitting Diode (OLED), or the like.
The user input unit 107 may be used to receive input numeric or character information and generate key signal inputs related to user settings and function control of the mobile terminal. Specifically, the user input unit 107 may include a touch panel 1071 and other input devices 1072. The touch panel 1071, also referred to as a touch screen, may collect a touch operation performed by a user on or near the touch panel 1071 (e.g., an operation performed by the user on or near the touch panel 1071 using a finger, a stylus, or any other suitable object or accessory), and drive a corresponding connection device according to a predetermined program. The touch panel 1071 may include two parts of a touch detection device and a touch controller. The touch detection device detects the touch direction of a user, detects a signal brought by touch operation and transmits the signal to the touch controller; the touch controller receives touch information from the touch sensing device, converts the touch information into touch point coordinates, sends the touch point coordinates to the processor 110, and can receive and execute commands sent by the processor 110. In addition, the touch panel 1071 may be implemented in various types, such as a resistive type, a capacitive type, an infrared ray, and a surface acoustic wave. In addition to the touch panel 1071, the user input unit 107 may include other input devices 1072. In particular, other input devices 1072 may include, but are not limited to, one or more of a physical keyboard, function keys (e.g., volume control keys, switch keys, etc.), a trackball, a mouse, a joystick, and the like, and are not limited to these specific examples.
Further, the touch panel 1071 may cover the display panel 1061, and when the touch panel 1071 detects a touch operation thereon or nearby, the touch panel 1071 transmits the touch operation to the processor 110 to determine the type of the touch event, and then the processor 110 provides a corresponding visual output on the display panel 1061 according to the type of the touch event. Although the touch panel 1071 and the display panel 1061 are shown in fig. 1 as two separate components to implement the input and output functions of the mobile terminal, in some embodiments, the touch panel 1071 and the display panel 1061 may be integrated to implement the input and output functions of the mobile terminal, and is not limited herein.
The interface unit 108 serves as an interface through which at least one external device is connected to the mobile terminal 100. For example, the external device may include a wired or wireless headset port, an external power supply (or battery charger) port, a wired or wireless data port, a memory card port, a port for connecting a device having an identification module, an audio input/output (I/O) port, a video I/O port, an earphone port, and the like. The interface unit 108 may be used to receive input (e.g., data information, power, etc.) from external devices and transmit the received input to one or more elements within the mobile terminal 100 or may be used to transmit data between the mobile terminal 100 and external devices.
The memory 109 may be used to store software programs as well as various data. The memory 109 may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required by at least one function (such as a sound playing function, an image playing function, etc.), and the like; the storage data area may store data (such as audio data, a phonebook, etc.) created according to the use of the cellular phone, and the like. Further, the memory 109 may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other volatile solid state storage device.
The processor 110 is a control center of the mobile terminal, connects various parts of the entire mobile terminal using various interfaces and lines, and performs various functions of the mobile terminal and processes data by operating or executing software programs and/or modules stored in the memory 109 and calling data stored in the memory 109, thereby performing overall monitoring of the mobile terminal. Processor 110 may include one or more processing units; preferably, the processor 110 may integrate an application processor, which mainly handles operating systems, user interfaces, application programs, etc., and a modem processor, which mainly handles wireless communications. It will be appreciated that the modem processor described above may not be integrated into the processor 110.
The mobile terminal 100 may further include a power supply 111 (e.g., a battery) for supplying power to various components, and preferably, the power supply 111 may be logically connected to the processor 110 via a power management system, so as to manage charging, discharging, and power consumption management functions via the power management system.
Although not shown in fig. 1, the mobile terminal 100 may further include a bluetooth module or the like, which is not described in detail herein.
In order to facilitate understanding of the embodiments of the present invention, a communication network system on which the mobile terminal of the present invention is based is described below.
Referring to fig. 2, fig. 2 is an architecture diagram of a communication Network system according to an embodiment of the present invention, where the communication Network system is an LTE system of a universal mobile telecommunications technology, and the LTE system includes a UE (User Equipment) 201, an E-UTRAN (Evolved UMTS Terrestrial Radio Access Network) 202, an EPC (Evolved Packet Core) 203, and an IP service 204 of an operator, which are in communication connection in sequence.
Specifically, the UE201 may be the terminal 100 described above, and is not described herein again.
The E-UTRAN202 includes eNodeB2021 and other eNodeBs 2022, among others. Among them, the eNodeB2021 may be connected with other eNodeB2022 through backhaul (e.g., X2 interface), the eNodeB2021 is connected to the EPC203, and the eNodeB2021 may provide the UE201 access to the EPC 203.
The EPC203 may include an MME (Mobility Management Entity) 2031, an HSS (Home Subscriber Server) 2032, other MMEs 2033, an SGW (Serving gateway) 2034, a PGW (PDN gateway) 2035, and a PCRF (Policy and Charging Rules Function) 2036, and the like. The MME2031 is a control node that handles signaling between the UE201 and the EPC203, and provides bearer and connection management. HSS2032 is used to provide registers to manage functions such as home location register (not shown) and holds subscriber specific information about service characteristics, data rates, etc. All user data may be sent through SGW2034, PGW2035 may provide IP address assignment for UE201 and other functions, and PCRF2036 is a policy and charging control policy decision point for traffic data flow and IP bearer resources, which selects and provides available policy and charging control decisions for a policy and charging enforcement function (not shown).
The IP services 204 may include the internet, intranets, IMS (IP Multimedia Subsystem), or other IP services, among others.
Although the LTE system is described as an example, it should be understood by those skilled in the art that the present invention is not limited to the LTE system, but may also be applied to other wireless communication systems, such as GSM, CDMA2000, WCDMA, TD-SCDMA, and future new network systems.
Based on the above mobile terminal hardware structure and communication network system, the present invention provides various embodiments of the method.
Fig. 3 is a response processing method according to an embodiment of the present invention, and as shown in fig. 3, the method includes:
It should be noted that the different durations set by the client may be two durations, or may be more than two durations, and if the two durations are two durations, it means that one duration is set and another duration different from the duration is set.
And step 302, judging whether the responses in the different database service processing processes are overtime or not by adopting the set different durations.
Specifically, the client judges whether the response in the database service processing process is overtime by adopting different set time lengths, namely: the client judges whether the response in one service processing process of the database is overtime by adopting one set time length, and judges whether the response in the other service processing process of the database is overtime by adopting the other set time length.
According to the response processing method provided by the embodiment of the invention, the client sets different durations; and judging whether the response in the different database service processing processes is overtime or not by adopting the set different time lengths. According to the technical scheme provided by the invention, the client side adopts the set different durations to respectively judge whether the response in different database service processing processes is overtime, so that the corresponding overtime condition in the database connection establishing process is well judged, and the response overtime condition in the database access process is also well judged.
Fig. 4 is another response processing method provided in the embodiment of the present invention, as shown in fig. 4, the method includes:
And step 402, judging whether the response in the database connection establishment process is overtime or not by adopting the set first time length.
It should be noted that the first duration may be expressed as a parameter of socketTimeout.
Specifically, the database connection establishment process refers to a process of establishing a connection with a database.
And 403, judging whether the response in the database access process is overtime or not by adopting a set second time length different from the first time length.
It should be noted that the second duration may be expressed as an initCommandSocketTimeout parameter.
Specifically, the database access process may include a database record query process, a database record addition process, and a database record deletion process.
According to the response processing method provided by the embodiment of the invention, the client sets different durations; and judging whether the response in the different database service processing processes is overtime or not by adopting the set different time lengths. According to the technical scheme provided by the invention, the client side adopts the set different durations to respectively judge whether the response in different database service processing processes is overtime, so that the corresponding overtime condition in the database connection establishing process is well judged, and the response overtime condition in the database access process is also well judged.
Fig. 5 is a further response processing method according to an embodiment of the present invention, and as shown in fig. 5, the method includes:
And step 503, calculating to obtain a second time according to the first time and the set first time.
Specifically, the second time is calculated by adding the first time to the first time. The response time in the database connection establishment process is short, and is generally in the range of 1S to 3S, so the first time length can be set to 3S.
And step 504, judging whether the response in the database connection establishing process is overtime according to the second time.
And 505, acquiring time for sending the database access request to the server as third time.
Specifically, the statement format of the database access request may be an sql statement.
And step 506, calculating to obtain fourth time according to the third time and the set second duration.
Specifically, the fourth time is calculated by adding the second time to the third time. The response time in the database connection establishment process is long, and is usually in the range of 30S to 60S, so the second time period can be set to 60S.
And step 507, judging whether the response in the database access process is overtime according to the fourth time.
According to the response processing method provided by the embodiment of the invention, the client sets different durations; and judging whether the response in the different database service processing processes is overtime or not by adopting the set different time lengths. According to the technical scheme provided by the invention, the client side adopts the set different durations to respectively judge whether the response in different database service processing processes is overtime, so that the corresponding overtime condition in the database connection establishing process is well judged, and the response overtime condition in the database access process is also well judged.
Fig. 6 is a further response processing method according to an embodiment of the present invention, as shown in fig. 6, including:
And 603, calculating to obtain a second time according to the first time and the set first time.
Specifically, the second time is calculated by adding the first time to the first time. The response time in the database connection establishment process is short, and is generally in the range of 1S to 3S, so the first time length can be set to 3S.
And step 604, judging whether the self receives a reply aiming at the database connection establishment request sent by the server before or when the second time arrives.
And step 605, if the self does not receive the reply aiming at the database connection establishment request sent by the server before and when the second time arrives, determining that the response time-out in the database connection establishment process is over.
Specifically, if the response to the database connection establishment request sent by the server is received before or when the second time arrives, it is determined that the response in the database connection establishment process is not overtime, and normal connection establishment is performed.
Specifically, the statement format of the database access request may be an sql statement.
And step 607, calculating a fourth time according to the third time and the set second duration.
Specifically, the fourth time is calculated by adding the second time to the third time. The response time in the database connection establishment process is long, and is usually in the range of 30S to 60S, so the second time period can be set to 60S.
And step 608, judging whether the self receives a reply aiming at the database access request sent by the server before or when the fourth time arrives.
And step 609, if the response to the database access request sent by the server is not received before and when the fourth time arrives, determining that the response time out in the database access process.
Specifically, if a reply to the database access request sent by the server is received before or when the fourth time arrives, it is determined that the response in the database access process is not timed out.
Specifically, the interaction diagram of the client and the server can be as shown in fig. 7, and the interaction process of the client and the server is divided into the following three steps:
s1, handshake authentication procedure.
And S2, establishing database connection.
And S3, database access process.
Step S1 can be further divided into the following four sub-steps:
and S11, the client initiates a connection request with the server to the server in the handshake authentication process.
And S12, the server receives the request and sends a reply containing the encryption seed and the self-supported attribute to the client.
And S13, the client generates authentication information to the server according to the encryption seeds and the attributes supported by the server, and sends the authentication information to the server.
And S14, the server side authenticates after receiving the authentication packet, and sends verification passing information to the client side after the authentication passes.
Wherein, step S2 can be further divided into the following two sub-steps:
and S21, the client sends a database connection establishment request to the server in the database connection establishment process.
And S22, the server sends a reply containing the database connection establishment information to the client after receiving the data packet, so that the client is connected with the database according to the information in the reply after receiving the reply.
Wherein, step S3 can be further divided into the following two sub-steps:
s31, the client sends an access request to the database in the server side in an sql statement.
And S32, the server receives the access request, executes relevant operation according to the access request to generate an execution result and returns the execution result to the client.
According to the response processing method provided by the embodiment of the invention, the client sets different durations; and judging whether the response in the different database service processing processes is overtime or not by adopting the set different time lengths. According to the technical scheme provided by the invention, the client side adopts the set different durations to respectively judge whether the response in different database service processing processes is overtime, so that the corresponding overtime condition in the database connection establishing process is well judged, and the response overtime condition in the database access process is also well judged.
An embodiment of the present invention further provides a response processing apparatus, as shown in fig. 8, where the response processing apparatus 7 includes: a processor 71, a memory 72, and a communication bus 73;
the communication bus 73 is used to realize connection communication between the processor 71 and the memory 72.
different durations are set.
And judging whether the response in the different database service processing processes is overtime or not by adopting the set different time lengths.
Further, the processor 71 is further configured to execute the response handler to implement the following steps:
and judging whether the response in the database connection establishment process is overtime or not by adopting the set first time length.
And judging whether the response in the database access process is overtime or not by adopting a set second time length different from the first time length.
Further, the processor 71 is also configured to execute a response handler to implement the following steps
And acquiring the time when the client sends the database connection establishment request to the server as first time.
And calculating to obtain a second time according to the first time and the set first time.
And judging whether the response in the database connection establishment process is overtime according to the second time.
Further, the processor 71 is configured to execute a response processing program to implement the following steps:
and judging whether the client receives a reply aiming at the database connection establishment request sent by the server before or when the second time arrives.
And if the client does not receive the reply aiming at the database connection establishment request sent by the server before and when the second time arrives, determining that the response in the database connection establishment process is overtime.
Further, the processor 71 is further configured to execute a response processing program to implement the following steps:
and acquiring the time when the client sends the database access request to the server as third time.
And calculating to obtain fourth time according to the third time and the set second duration.
And judging whether the response in the database access process is overtime or not according to the fourth time.
Further, the processor 71 is configured to execute a response processing program to implement the following steps:
and judging whether the client receives a reply aiming at the database access request sent by the server before or when the fourth time arrives.
And if the client does not receive the reply aiming at the database access request sent by the server before and when the fourth time arrives, determining that the response in the database access process is overtime.
The response processing device provided by the embodiment of the invention sets different time lengths; and judging whether the response in the different database service processing processes is overtime or not by adopting the set different time lengths. According to the technical scheme provided by the invention, the client side adopts the set different durations to respectively judge whether the response in different database service processing processes is overtime, so that the corresponding overtime condition in the database connection establishing process is well judged, and the response overtime condition in the database access process is also well judged.
An embodiment of the present invention further provides a storage medium, where a computer program is stored on the storage medium, and when executed by a processor, the computer program implements the following steps:
setting different time lengths;
and judging whether the response in the different database service processing processes is overtime or not by adopting the set different time lengths.
Further, the computer program when executed by the processor further performs the steps of:
and judging whether the response in the database connection establishment process is overtime or not by adopting the set first time length.
And judging whether the response in the database access process is overtime or not by adopting a set second time length different from the first time length.
Further, the computer program when executed by the processor further embodies the steps of:
and acquiring the time when the client sends the database connection establishment request to the server as first time.
And calculating to obtain a second time according to the first time and the set first time.
And judging whether the response in the database connection establishment process is overtime according to the second time.
Further, the computer program when executed by the processor embodies the steps of:
judging whether the client receives a reply aiming at the database connection establishment request sent by the server before or when the second time arrives;
and if the client does not receive the reply aiming at the database connection establishment request sent by the server before and when the second time arrives, determining that the response in the database connection establishment process is overtime.
Further, the computer program when executed by the processor further embodies the steps of:
and acquiring the time when the client sends the database access request to the server as third time.
And calculating to obtain fourth time according to the third time and the set second duration.
And judging whether the response in the database access process is overtime or not according to the fourth time.
Further, the computer program when executed by the processor further embodies the steps of:
and judging whether the client receives a reply aiming at the database access request sent by the server before or when the fourth time arrives.
And if the client does not receive the reply aiming at the database access request sent by the server before and when the fourth time arrives, determining that the response in the database access process is overtime.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal (such as a mobile phone, a computer, a server, an air conditioner, or a network device) to execute the method according to the embodiments of the present invention.
While the present invention has been described with reference to the embodiments shown in the drawings, the present invention is not limited to the embodiments, which are illustrative and not restrictive, and it will be apparent to those skilled in the art that various changes and modifications can be made therein without departing from the spirit and scope of the invention as defined in the appended claims.
Claims (10)
1. A response processing method, comprising:
the client sets different durations;
judging whether the response in different database service processing processes is overtime or not by adopting different set time lengths;
the database service processing process comprises a database connection establishing process and a database access process in the interaction process of a client and a server of the database.
2. The response processing method according to claim 1, wherein the determining whether the response in the different database service processing processes is overtime by adopting the set different durations includes:
judging whether the response in the database connection establishing process is overtime or not by adopting the set first time length;
and judging whether the response in the database access process is overtime or not by adopting a set second time length different from the first time length.
3. The response processing method according to claim 2, wherein the determining whether the response in the database connection establishment process is overtime by using the set first time duration includes:
acquiring time for sending a database connection establishment request to a server as first time;
calculating to obtain a second time according to the first time and the set first time;
and judging whether the response in the database connection establishing process is overtime according to the second time.
4. The response processing method according to claim 3, wherein the determining whether the response in the database connection establishment process is time-out according to the second time includes:
judging whether the self receives a reply aiming at the database connection establishment request sent by the server before or when the second time arrives;
and if the response to the database connection establishment request sent by the server is not received before and when the second time arrives, determining that the response in the database connection establishment process is overtime.
5. The response processing method according to any one of claims 2 to 4, wherein the determining whether the response in the database access process is overtime by using a second time duration different from the first time duration includes:
acquiring time for sending a database access request to a server as third time;
calculating to obtain a fourth time according to the third time and a set second duration;
and judging whether the response in the database access process is overtime or not according to the fourth time.
6. The response processing method according to claim 5, wherein the determining whether the response in the database access process is time-out according to the fourth time includes:
judging whether the self receives a reply aiming at the database access request sent by the server before or when the fourth time arrives;
and if the response to the database access request sent by the server is not received before and when the fourth time arrives, determining that the response in the database access process is overtime.
7. A response processing apparatus, comprising: a processor, a memory, and a communication bus;
the communication bus is used for realizing connection communication between the processor and the memory;
the processor is used for executing the response processing program stored in the memory to realize the following steps:
setting different time lengths;
judging whether the response in different database service processing processes is overtime or not by adopting different set time lengths;
the database service processing process comprises a database connection establishing process and a database access process in the interaction process of a client and a server of the database.
8. The response processing apparatus of claim 7, wherein the processor is further configured to execute the response handler stored in the memory to implement the steps of:
judging whether the response in the database connection establishing process is overtime or not by adopting the set first time length;
and judging whether the response in the database access process is overtime or not by adopting a set second time length different from the first time length.
9. The response processing apparatus of claim 8, wherein the processor is further configured to execute the response handler to implement the steps of:
acquiring time when a client sends a database connection establishment request to a server as first time;
calculating to obtain a second time according to the first time and the first time length;
and judging whether the response in the database connection establishing process is overtime according to the second time.
10. A computer-readable storage medium, characterized in that the storage medium has stored thereon a computer program which, when executed by a processor, performs the steps of:
setting different time lengths;
judging whether the response in different database service processing processes is overtime or not by adopting different set time lengths;
the database service processing process comprises a database connection establishing process and a database access process in the interaction process of a client and a server of the database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711225681.1A CN108183833B (en) | 2017-11-29 | 2017-11-29 | Response processing method and device and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711225681.1A CN108183833B (en) | 2017-11-29 | 2017-11-29 | Response processing method and device and computer readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108183833A CN108183833A (en) | 2018-06-19 |
| CN108183833B true CN108183833B (en) | 2021-08-10 |
Family
ID=62545493
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711225681.1A Active CN108183833B (en) | 2017-11-29 | 2017-11-29 | Response processing method and device and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108183833B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108901079B (en) * | 2018-06-20 | 2021-03-09 | Oppo（重庆）智能科技有限公司 | Timeout time determination method, device, equipment and storage medium |
| CN108897854B (en) * | 2018-06-29 | 2020-06-05 | 京东数字科技控股有限公司 | Monitoring method and device for overtime task |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101106511A (en) * | 2007-08-24 | 2008-01-16 | 上海可鲁系统软件有限公司 | A secure intercommunication method and device between two independent networks |
| EP2767906A1 (en) * | 2013-02-15 | 2014-08-20 | OMRON Corporation | Controller, information processing apparatus, and program |
| CN104281587A (en) * | 2013-07-03 | 2015-01-14 | 阿里巴巴集团控股有限公司 | Connection establishing method and device |
| CN105025063A (en) * | 2014-04-29 | 2015-11-04 | 刘广威 | Online data transmission method for large-scale terminal equipment |
Family Cites Families (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030105732A1 (en) * | 2000-11-17 | 2003-06-05 | Kagalwala Raxit A. | Database schema for structure query language (SQL) server |
| CN1265309C (en) * | 2002-10-30 | 2006-07-19 | 华为技术有限公司 | Method accessing data bank through protocol agency mode |
| US7340448B2 (en) * | 2003-11-13 | 2008-03-04 | International Business Machines Corporation | Method, apparatus, and computer program product for implementing enhanced query governor functions |
| CN100518127C (en) * | 2007-08-24 | 2009-07-22 | 上海可鲁系统软件有限公司 | Safe intercommunication method and apparatus between two isolated networks |
| CN102915374B (en) * | 2012-11-07 | 2016-04-06 | 北京搜狐新媒体信息技术有限公司 | A kind of method, Apparatus and system of resource access of controlling database |
| CN103970807B (en) * | 2013-02-06 | 2017-04-19 | 阿里巴巴集团控股有限公司 | Method and system for managing database connection |
| CN106412630B (en) * | 2016-09-23 | 2020-01-03 | Tcl集团股份有限公司 | Video list switching control method and device |
| CN106790195B (en) * | 2016-12-30 | 2019-11-19 | 北京神州绿盟信息安全科技股份有限公司 | A kind of SQL injection detection method and device |
-
2017
- 2017-11-29 CN CN201711225681.1A patent/CN108183833B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101106511A (en) * | 2007-08-24 | 2008-01-16 | 上海可鲁系统软件有限公司 | A secure intercommunication method and device between two independent networks |
| EP2767906A1 (en) * | 2013-02-15 | 2014-08-20 | OMRON Corporation | Controller, information processing apparatus, and program |
| CN104281587A (en) * | 2013-07-03 | 2015-01-14 | 阿里巴巴集团控股有限公司 | Connection establishing method and device |
| CN105025063A (en) * | 2014-04-29 | 2015-11-04 | 刘广威 | Online data transmission method for large-scale terminal equipment |
Non-Patent Citations (1)
| Title |
|---|
| "A Reliability Benchmark for Big Data Systems on JointCloud";Yingying Zheng,etc.;《IEEE 37th international conference on distributed computing systems workshop》;20170717;全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108183833A (en) | 2018-06-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107038245B (en) | Page switching method, mobile terminal and storage medium | |
| CN109195143B (en) | Network access method, mobile terminal and readable storage medium | |
| CN109379735B (en) | eSIM card operation method, mobile terminal and eSIM card device | |
| CN107862217B (en) | Position information acquisition method, mobile terminal and computer storage medium | |
| CN107172605B (en) | Emergency call method, mobile terminal and computer readable storage medium | |
| CN110187808B (en) | Dynamic wallpaper setting method and device and computer-readable storage medium | |
| CN110278481B (en) | Picture-in-picture implementation method, terminal and computer readable storage medium | |
| CN108040116B (en) | Message pushing method, router and computer readable storage medium | |
| CN107239208B (en) | Method, apparatus, and computer-readable storage medium for processing screenshot | |
| CN108183833B (en) | Response processing method and device and computer readable storage medium | |
| CN112866685A (en) | Screen projection delay measuring method, mobile terminal and computer readable storage medium | |
| CN112423211A (en) | Multi-audio transmission control method, equipment and computer readable storage medium | |
| CN109462829B (en) | Call transfer method, device and computer readable storage medium | |
| CN109257739B (en) | eSIM card operation method, mobile terminal and eSIM card device | |
| CN111970738A (en) | Network switching control method, equipment and computer readable storage medium | |
| CN109089258B (en) | eSIM card operation method, mobile terminal and eSIM card device | |
| CN109561221B (en) | Call control method, device and computer readable storage medium | |
| CN109219039B (en) | eSIM card operation method, mobile terminal and eSIM card device | |
| CN109062688B (en) | Memory allocation method, server and mobile terminal | |
| CN110955397A (en) | Method for setting frame rate of game terminal, game terminal and storage medium | |
| CN107404568B (en) | Control switch management method and mobile terminal | |
| CN108040330B (en) | WiFi directional transmission method, mobile terminal and readable storage medium | |
| CN107678622B (en) | Application icon display method, terminal and storage medium | |
| CN107222933B (en) | Communication method, terminal and computer readable storage medium | |
| CN109495948B (en) | Communication connection method, 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 |