CN110990381B - Processing method and device of server, storage medium and electronic device - Google Patents
Processing method and device of server, storage medium and electronic device Download PDFInfo
- Publication number
- CN110990381B CN110990381B CN201911216255.0A CN201911216255A CN110990381B CN 110990381 B CN110990381 B CN 110990381B CN 201911216255 A CN201911216255 A CN 201911216255A CN 110990381 B CN110990381 B CN 110990381B
- Authority
- CN
- China
- Prior art keywords
- time consumption
- database
- middleware
- command
- preset time
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/217—Database tuning
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- 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)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application provides a processing method and device of a server, a storage medium and an electronic device, wherein the method comprises the following steps: in an architecture consisting of middleware and a database cluster related to a first programming language, sending a generated Structured Query Language (SQL) command to each database in the middleware and the database cluster; obtaining time consumption for processing commands with the database and/or the middleware from the logs of the middleware and the logs of the database; comparing the time consumption with preset time consumption, and adjusting the server according to the comparison result. The application solves the problem that the architecture of the mycat middleware and the database cluster needs to be subjected to complicated test before formally putting into the related technology.
Description
Technical Field
The present application relates to the field of computers, and in particular, to a processing method and apparatus for a server, a storage medium, and an electronic apparatus.
Background
In the prior art, for an architecture using mycat middleware and a database cluster, certain optimization needs to be performed on the configuration of a server before the architecture is formally put into use. Before tuning, it is necessary to determine which server needs tuning, and the conclusion can be obtained by comparing the efficiency of data concurrent processing of each server, that is, the server needs to be formally used after complicated test.
There is currently no effective solution to the above-described problems in the related art.
Disclosure of Invention
The embodiment of the application provides a processing method and device of a server, a storage medium and an electronic device, which at least solve the problem that in the related art, complicated tests are required to be carried out on the architecture of a mycat middleware and a database cluster before formal input.
According to an embodiment of the present application, there is provided a processing method of a server, including: in an architecture consisting of middleware and a database cluster related to a first programming language, sending a generated Structured Query Language (SQL) command to each database in the middleware and the database cluster; obtaining time consumption for processing commands with the database and/or the middleware from the logs of the middleware and the logs of the database; comparing the time consumption with preset time consumption, and adjusting the server according to the comparison result.
According to another embodiment of the present application, there is provided a processing apparatus of a server including: the sending module is used for sending the generated Structured Query Language (SQL) command to each database in the middleware and the database cluster in the architecture formed by the middleware and the database cluster related to the first programming language; the acquisition module is used for acquiring the time consumption of processing the command with the database and/or the middleware from the logs of the middleware and the logs of the database; and the processing module is used for comparing the time consumption with preset time consumption and adjusting the server according to the comparison result.
According to a further embodiment of the application, there is also provided a storage medium having stored therein a computer program, wherein the computer program is arranged to perform the steps of any of the method embodiments described above when run.
According to a further embodiment of the application, there is also provided an electronic device comprising a memory having stored therein a computer program and a processor arranged to run the computer program to perform the steps of any of the method embodiments described above.
According to the application, in the architecture formed by the middleware and the database cluster related to the first programming language, the generated structured query language SQL command is sent to each database in the middleware and the database cluster, so that the time consumption of processing the command with the database and/or the middleware is obtained from the logs of the middleware and the logs of the database, the time consumption is compared with the preset time consumption, and the server is adjusted according to the comparison result; that is, the server which needs to be optimized can be rapidly positioned and determined through the consumption of the processing command, so that the problem that complicated tests are required to be carried out on the architecture of the mycat middleware and the database cluster before formal input in the related technology is solved, and the efficiency of optimizing the server is improved.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this specification, illustrate embodiments of the application and together with the description serve to explain the application and do not constitute a limitation on the application. In the drawings:
fig. 1 is a block diagram of a hardware configuration of a terminal of a processing method of a server according to an embodiment of the present application;
FIG. 2 is a flow chart of a processing method of a server according to an embodiment of the present application;
FIG. 3 is a schematic diagram of the architecture of a mycat+ database cluster architecture, according to an embodiment of the application;
fig. 4 is a schematic structural diagram of a processing device of a server according to an embodiment of the present application.
Detailed Description
The application will be described in detail hereinafter with reference to the drawings in conjunction with embodiments. It should be noted that, without conflict, the embodiments of the present application and features of the embodiments may be combined with each other.
It should be noted that the terms "first," "second," and the like in the description and the claims of the present application and the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order.
Example 1
The method according to the first embodiment of the present application may be implemented in a terminal, a computer terminal or a similar computing device. Taking the operation on the terminal as an example, fig. 1 is a block diagram of the hardware structure of the terminal of a processing method of a server according to an embodiment of the present application. As shown in fig. 1, the terminal 10 may include one or more (only one is shown in fig. 1) processors 102 (the processor 102 may include, but is not limited to, a microprocessor MCU or a processing device such as a programmable logic device FPGA) and a memory 104 for storing data, and optionally a transmission device 106 for communication functions and an input-output device 108. It will be appreciated by those skilled in the art that the structure shown in fig. 1 is merely illustrative and not limiting on the structure of the terminal described above. For example, the terminal 10 may also include more or fewer components than shown in FIG. 1, or have a different configuration than shown in FIG. 1.
The memory 104 may be used to store a computer program, for example, a software program of application software and a module, such as a computer program corresponding to a processing method of a server in an embodiment of the present application, and the processor 102 executes the computer program stored in the memory 104 to perform various functional applications and data processing, that is, implement the above-mentioned method. Memory 104 may include high-speed random access memory, and may also include non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, the memory 104 may further include memory located remotely from the processor 102, which may be connected to the terminal 10 via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The transmission device 106 is used to receive or transmit data via a network. The specific examples of the network described above may include a wireless network provided by a communication provider of the terminal 10. In one example, the transmission device 106 includes a network adapter (Network Interface Controller, simply referred to as NIC) that can connect to other network devices through a base station to communicate with the internet. In one example, the transmission device 106 may be a Radio Frequency (RF) module, which is configured to communicate with the internet wirelessly.
In this embodiment, a processing method of a server running on the terminal is provided, fig. 2 is a flowchart of a processing method of a server according to an embodiment of the present application, and as shown in fig. 2, the flowchart includes the following steps:
step S202, in the architecture formed by the middleware and the database cluster related to the first programming language, sending the generated structured query language SQL command to each database in the middleware and the database cluster;
step S204, time consumption for processing commands with the database and/or the middleware is acquired from the logs of the middleware and the logs of the database;
step S206, comparing the time consumption with the preset time consumption, and adjusting the server according to the comparison result.
Through the steps S202 to S206, in the architecture formed by the middleware and the database cluster related to the first programming language, the generated structured query language SQL command is sent to each database in the middleware and the database cluster, so that the time consumption of processing the command with the database and/or the middleware is obtained from the logs of the middleware and the logs of the database, the time consumption is compared with the preset time consumption, and the server is adjusted according to the comparison result; that is, the server which needs to be optimized can be rapidly positioned and determined through the consumption of the processing command, so that the problem that the architecture of the mycat middleware and the database cluster needs to be subjected to complicated test before being formally put into service is solved, and the efficiency of optimizing the server is improved.
In an alternative implementation of the present embodiment, for the manner of obtaining the time consumed for processing the command with the database and/or the middleware from the log of the middleware and the log of the database involved in step S204, further may include:
step S204-11, obtaining a first time consumption of a database processing command from a log of a database;
step S204-12, obtaining the second time consumption of the database reprocessing command after the middleware processing and the third time consumption of the middleware executing command from the log of the middleware.
For the middleware involved in the step S204, the mycat middleware may be in a specific application scenario, so the time consumed in the step S204 may be: the time for obtaining the database processing command from the database slow query log is consumed; acquiring the total time consumption of reprocessing the database after mycat processing in a mycat log; and thus the time spent by mycat executing the command = the total time spent by the database reprocessing after mycat processing-the time spent by the database processing the command. Because various command execution records are stored in the log, the time consumption for processing the command is convenient and accurate.
In another optional implementation manner of this embodiment, for the manner of comparing the time consumption with the preset time consumption in step S206 and sending the comparison result to the user, the method may further include:
step S206-11, comparing the first time consumption with a first preset time consumption, comparing the second time consumption with a second preset time consumption, and comparing the third time consumption with a third time consumption;
step S206-12, in the case that at least one of the following is included in the comparison result, the comparison result is sent to the user: the first time consumption is greater than the first preset time consumption, the second time consumption is greater than the second preset time consumption, and the third time consumption is greater than the third preset time consumption; the comparison result also comprises an identification of the server corresponding to the time consumption greater than the preset time consumption.
Through the steps S206-11 and S206-11, it is able to know which servers do not reach the expected time by comparing the preset time consumption with the actual time consumption, that is, the actual time consumption is greater than the preset time consumption, and if there are multiple servers to adjust, the servers are sorted according to the difference between the actual time consumption and the preset time consumption, and the servers with larger difference are adjusted first. Through the comparison of the actual time consumption and the preset time consumption, the server which is not required to be adjusted can be known, so that each server is prevented from being tested, and the server adjustment efficiency is improved.
In another optional implementation manner of this embodiment, for the manner of sending the generated SQL command to each database in the middleware and the database cluster in step S202, it may further be that:
step S202-11, deconstructing all tables in a database, and generating data insertion/query commands matched with the types of the reserved fields according to the table structure, wherein each insertion/query command carries corresponding identification information;
step S202-12, sending the insert/query command to the middleware and each database in the database cluster.
It should be noted that, the foregoing carrying the corresponding identification information in each insert/query command is to determine a single record in the slow query log and the mycat log of the database for comparison and calculation.
Note that, the first programming language involved in this embodiment is Java.
The application is illustrated below in connection with alternative implementations of the present example;
the optional implementation manner provides a method for automatically testing a to-be-tuned optimal server of a mycat+ database cluster architecture, and as shown in fig. 3, the mycat+ database cluster architecture comprises a java scheduler, an sql generation and sending micro-service, a time comparison micro-service, a configuration information acquisition micro-service, a mycat middleware and a database cluster. The java scheduler, the sql generation, the sending of the micro-service, the time comparison of the micro-service and the acquisition of server configuration information are carried out on a server; mycat is on one server; the database cluster is distributed over several servers.
The mycat opens the log, all database servers open the slow query log, and ensure that all query records are recorded in the log.
In addition, the java scheduler is responsible for deploying three micro services, and the specific process is as follows:
the Sql generator is used for sending a micro-service, acquiring deconstructment of all tables of the database, and automatically generating data insertion and query commands with storage field type matching according to the table structure; wherein, each inserted sentence field value is randomly generated, thereby ensuring that the inserted sentences of the same table are not identical. Meanwhile, necessary annotation information is generated for the time comparison micro-service to determine only one record to compare and calculate in the database slow query log and the mycat log; the generated sql is then sent to the mycat, which is distributed to the various databases.
Setting expected values for expected time consumption of each insert and query command in the time comparison micro service, wherein the expected values comprise expected time consumption values of a mycat processing command, expected time consumption values of a database processing command and total expected time consumption values of reprocessing of a database after mycat processing; corresponding values are constantly obtained from the mycat and the various servers of the database cluster. The time for obtaining the database processing command from the database slow query log is consumed; acquiring the total time consumption of reprocessing the database after mycat processing in a mycat log; and thus the time spent by mycat executing the command = the total time spent by the database reprocessing after mycat processing-the time spent by the database processing the command.
And the time comparison micro service is used for comparing the three time consumption with the expected time consumption, if one or more servers with longer time consumption than the expected time consumption exist, marking the servers with longer time consumption, and returning the marked servers and the three time consumption points to the java scheduler.
And after the java dispatcher receives the marked database server returned by the time comparison micro-service, calling the micro-service for acquiring the server configuration information, and returning the configuration information of the server to be optimized by the micro-service for acquiring the server configuration information. And the java dispatcher packages the three time-consuming servers and the related configuration information to be optimized, and sends the comparison result to the user, and the user can perform optimization on the servers to be optimized according to the information.
From the description of the above embodiments, it will be clear to a person skilled in the art that the method according to the above embodiments may be implemented by means of software plus the necessary general hardware platform, but of course also by means of hardware, but in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art in the form of a software product stored in a storage medium (e.g. ROM/RAM, magnetic disk, optical disk) comprising instructions for causing a terminal device (which may be a mobile phone, a computer, a server, or a network device, etc.) to perform the method according to the embodiments of the present application.
Example 2
The embodiment also provides a processing device of the server, which is used for implementing the foregoing embodiments and preferred embodiments, and the description is omitted herein. As used below, the term "module" may be a combination of software and/or hardware that implements a predetermined function. While the means described in the following embodiments are preferably implemented in software, implementation in hardware, or a combination of software and hardware, is also possible and contemplated.
Fig. 4 is a block diagram of a processing apparatus of a server according to an embodiment of the present application, as shown in fig. 4, the apparatus including: a sending module 42, configured to send the generated structured query language SQL command to each database in the middleware and the database cluster in the architecture that is composed of the middleware and the database cluster related to the first programming language; an acquisition module 44 for acquiring time consumption for processing the command with the database and/or the middleware from the log of the middleware and the log of the database; the processing module 46 is configured to compare the time consumption with a preset time consumption, and send a comparison result to the user; the comparison result is used for indicating the user to adjust the server.
Optionally, the acquiring module 44 related to this embodiment may further include: a first obtaining unit, configured to obtain a first time consumption of a database processing command from a log of a database; and the second acquisition unit is used for acquiring second time consumption of the database reprocessing command after the middleware processing and third time consumption of the middleware executing command from the log of the middleware.
Optionally, the processing module 46 in this embodiment may further include: a comparison unit for comparing the first time consumption with a first preset time consumption, comparing the second time consumption with a second preset time consumption, and comparing the third time consumption with a third time consumption; a sending module, configured to send the comparison result to the user when at least one of the following is included in the comparison result: the first time consumption is greater than the first preset time consumption, the second time consumption is greater than the second preset time consumption, and the third time consumption is greater than the third preset time consumption; the comparison result also comprises an identification of the server corresponding to the time consumption greater than the preset time consumption.
Optionally, the sending module 42 in this embodiment may further include: the processing unit is used for deconstructing all tables in the database and generating data insertion/query commands matched with the types of the reserved fields according to the table structure, wherein each insertion/query command carries corresponding identification information; and the sending unit is used for sending the insertion/query command to each database in the middleware and the database cluster.
Optionally, the first programming language involved in this embodiment is Java.
It should be noted that each of the above modules may be implemented by software or hardware, and for the latter, it may be implemented by, but not limited to: the modules are all located in the same processor; alternatively, the above modules may be located in different processors in any combination.
Example 3
An embodiment of the application also provides a storage medium having a computer program stored therein, wherein the computer program is arranged to perform the steps of any of the method embodiments described above when run.
Alternatively, in the present embodiment, the above-described storage medium may be configured to store a computer program for performing the steps of:
s1, in an architecture formed by middleware and a database cluster related to a first programming language, sending a generated Structured Query Language (SQL) command to each database in the middleware and the database cluster;
s2, acquiring time consumption for processing commands with the database and/or the middleware from the logs of the middleware and the logs of the database;
s3, comparing the time consumption with preset time consumption, and adjusting the server according to the comparison result.
Alternatively, in the present embodiment, the storage medium may include, but is not limited to: a usb disk, a Read-Only Memory (ROM), a random access Memory (Random Access Memory, RAM), a removable hard disk, a magnetic disk, or an optical disk, or other various media capable of storing a computer program.
An embodiment of the application also provides an electronic device comprising a memory having stored therein a computer program and a processor arranged to run the computer program to perform the steps of any of the method embodiments described above.
Optionally, the electronic apparatus may further include a transmission device and an input/output device, where the transmission device is connected to the processor, and the input/output device is connected to the processor.
Alternatively, in the present embodiment, the above-described processor may be configured to execute the following steps by a computer program:
s1, in an architecture formed by middleware and a database cluster related to a first programming language, sending a generated Structured Query Language (SQL) command to each database in the middleware and the database cluster;
s2, acquiring time consumption for processing commands with the database and/or the middleware from the logs of the middleware and the logs of the database;
s3, comparing the time consumption with preset time consumption, and adjusting the server according to the comparison result.
Alternatively, specific examples in this embodiment may refer to examples described in the foregoing embodiments and optional implementations, and this embodiment is not described herein.
It will be appreciated by those skilled in the art that the modules or steps of the application described above may be implemented in a general purpose computing device, they may be concentrated on a single computing device, or distributed across a network of computing devices, they may alternatively be implemented in program code executable by computing devices, so that they may be stored in a memory device for execution by computing devices, and in some cases, the steps shown or described may be performed in a different order than that shown or described, or they may be separately fabricated into individual integrated circuit modules, or multiple modules or steps within them may be fabricated into a single integrated circuit module for implementation. Thus, the present application is not limited to any specific combination of hardware and software.
The above description is only of the preferred embodiments of the present application and is not intended to limit the present application, but various modifications and variations can be made to the present application by those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the principle of the present application should be included in the protection scope of the present application.
Claims (6)
1. A method for processing a server, comprising:
in an architecture consisting of middleware and a database cluster related to a first programming language, sending a generated Structured Query Language (SQL) command to each database in the middleware and the database cluster;
obtaining time consuming processing commands with the database and/or the middleware from the log of the middleware and the log of the database comprises: obtaining a first time consuming of the database processing command from a log of the database; acquiring second time consumption of the database reprocessing command after the middleware processing and third time consumption of the middleware executing command from the log of the middleware;
comparing the time consumption with preset time consumption, and adjusting the server according to a comparison result;
comparing the time consumption with a preset time consumption comprises:
comparing the first time consumption with a first preset time consumption, comparing the second time consumption with a second preset time consumption, and comparing the third time consumption with a third preset time consumption;
transmitting the comparison result to a user in the case that at least one of the following is included in the comparison result: the first time consumption is greater than the first preset time consumption, the second time consumption is greater than the second preset time consumption, and the third time consumption is greater than the third preset time consumption; the comparison result further comprises an identification of a server corresponding to the time consumption greater than the preset time consumption.
2. The method of claim 1, wherein said sending the generated SQL command to each database in the middleware and database cluster comprises:
deconstructing all tables in the database, and generating data insertion/query commands matched with the types of the reserved fields according to the table structure, wherein each insertion/query command carries corresponding identification information;
the insert/query command is sent to the middleware and to each database in the database cluster.
3. The method according to any one of claims 1 to 2, wherein the first programming language is Java.
4. A processing apparatus of a server, comprising:
the sending module is used for sending the generated Structured Query Language (SQL) command to each database in the middleware and the database cluster in the architecture formed by the middleware and the database cluster related to the first programming language;
the acquisition module is used for acquiring the time consumption of processing the command with the database and/or the middleware from the logs of the middleware and the logs of the database;
the processing module is used for comparing the time consumption with preset time consumption and adjusting the server according to the comparison result;
the acquisition module comprises:
a first obtaining unit, configured to obtain a first time consumption of the database processing command from a log of the database;
a second obtaining unit, configured to obtain, from the log of the middleware, a second time consumption of the database reprocessing command after the middleware processing and a third time consumption of the middleware execution command;
the processing module comprises:
a comparison unit for comparing the first time consumption with a first preset time consumption, comparing the second time consumption with a second preset time consumption, and comparing the third time consumption with a third preset time consumption;
a transmitting unit configured to transmit a comparison result to a user in a case where at least one of the following is included in the comparison result: the first time consumption is greater than the first preset time consumption, the second time consumption is greater than the second preset time consumption, and the third time consumption is greater than the third preset time consumption; the comparison result further comprises an identification of a server corresponding to the time consumption greater than the preset time consumption.
5. A computer-readable storage medium, characterized in that the storage medium has stored therein a computer program, wherein the computer program is arranged to perform the method of any of claims 1 to 3 when run.
6. An electronic device comprising a memory and a processor, characterized in that the memory has stored therein a computer program, the processor being arranged to run the computer program to perform the method of any of the claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911216255.0A CN110990381B (en) | 2019-12-02 | 2019-12-02 | Processing method and device of server, storage medium and electronic device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911216255.0A CN110990381B (en) | 2019-12-02 | 2019-12-02 | Processing method and device of server, storage medium and electronic device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110990381A CN110990381A (en) | 2020-04-10 |
| CN110990381B true CN110990381B (en) | 2023-08-15 |
Family
ID=70089582
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911216255.0A Active CN110990381B (en) | 2019-12-02 | 2019-12-02 | Processing method and device of server, storage medium and electronic device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110990381B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112416917A (en) * | 2020-11-19 | 2021-02-26 | 珠海格力电器股份有限公司 | Method, device and system for processing abnormal data in real time |
| CN112559492B (en) * | 2020-12-22 | 2024-03-19 | 珠海格力电器股份有限公司 | Database using method capable of improving efficiency |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106157129A (en) * | 2015-04-17 | 2016-11-23 | 阿里巴巴集团控股有限公司 | One realizes distributed system across time domain coherence method and device |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6898609B2 (en) * | 2002-05-10 | 2005-05-24 | Douglas W. Kerwin | Database scattering system |
| US20060117091A1 (en) * | 2004-11-30 | 2006-06-01 | Justin Antony M | Data logging to a database |
| US8903801B2 (en) * | 2007-09-14 | 2014-12-02 | Oracle International Corporation | Fully automated SQL tuning |
| US20090182707A1 (en) * | 2008-01-10 | 2009-07-16 | Dbix Corporation | Database changeset management system and method |
| GB2569678A (en) * | 2017-12-22 | 2019-06-26 | Warevalley Co Ltd | Automation of SQL tuning method and system using statistic SQL pattern analysis |
-
2019
- 2019-12-02 CN CN201911216255.0A patent/CN110990381B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106157129A (en) * | 2015-04-17 | 2016-11-23 | 阿里巴巴集团控股有限公司 | One realizes distributed system across time domain coherence method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110990381A (en) | 2020-04-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108268372B (en) | Mock test processing method and device, storage medium and computer equipment | |
| CN110990381B (en) | Processing method and device of server, storage medium and electronic device | |
| CN107689982A (en) | Multi-data source method of data synchronization, application server and computer-readable recording medium | |
| CN109388552B (en) | Method and device for determining duration of starting application program and storage medium | |
| CN110569129A (en) | Resource allocation method and device, storage medium and electronic device | |
| US11985029B2 (en) | Pico-base station configuration method and apparatus, storage medium and electronic apparatus | |
| CN112965912A (en) | Interface test case generation method and device and electronic equipment | |
| CN112579604A (en) | Test system number making method, device, equipment and storage medium | |
| CN111008220A (en) | Dynamic identification method and device of data source, storage medium and electronic device | |
| CN109684196B (en) | Test method and device | |
| CN112420019B (en) | Equipment testing method and device | |
| CN112650815B (en) | Method and device for synchronizing environment data, storage medium and electronic device | |
| CN115442266A (en) | Gateway performance testing method and device, storage medium and electronic device | |
| CN114281503A (en) | Thread pool core parameter real-time dynamic adjustment method and device and electronic equipment | |
| CN113900937A (en) | Script calling method and device, electronic device and storage medium | |
| CN110347683B (en) | Data table merging processing method and device | |
| CN110188490B (en) | Method and device for improving data simulation efficiency, storage medium and electronic device | |
| CN110580172B (en) | Configuration rule verification method and device, storage medium and electronic device | |
| CN113934552A (en) | Method and device for determining function code, storage medium and electronic device | |
| CN113110991A (en) | Page element positioning method and device, storage medium and electronic device | |
| CN113110982A (en) | Data access layer verification method and device, storage medium and electronic device | |
| CN113852919B (en) | Method and device for generating early warning message, storage medium and electronic device | |
| CN111737136A (en) | Object testing method and device based on Internet of things platform | |
| CN110362575A (en) | A kind of method and device for the global index generating data | |
| CN117573730B (en) | Data processing method, apparatus, device, readable storage medium, and program product |
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 |