CN107943868B - Method and equipment for supporting database middleware for friendly viewing of system information - Google Patents
Method and equipment for supporting database middleware for friendly viewing of system information Download PDFInfo
- Publication number
- CN107943868B CN107943868B CN201711106717.4A CN201711106717A CN107943868B CN 107943868 B CN107943868 B CN 107943868B CN 201711106717 A CN201711106717 A CN 201711106717A CN 107943868 B CN107943868 B CN 107943868B
- Authority
- CN
- China
- Prior art keywords
- database
- middleware
- database middleware
- standard sql
- sql statement
- 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
-
- 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/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3452—Performance evaluation by statistical analysis
-
- 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
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/80—Database-specific techniques
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Evolutionary Biology (AREA)
- Probability & Statistics with Applications (AREA)
- Computer Hardware Design (AREA)
- Bioinformatics & Computational Biology (AREA)
- Quality & Reliability (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Life Sciences & Earth Sciences (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The method and the device for supporting the database middleware with friendly system information viewing comprise the following steps: s1, query is performed by standard sql statement. The device is used for realizing the method. And a command consisting of standard sql statements is input through the management port for query, so that the method is convenient and practical.
Description
Technical Field
The invention relates to a database middleware, in particular to a method and equipment for supporting the database middleware with friendly system information viewing.
Background
With the rapid development of internet traffic and the rapid increase of data volume, the single MySQL cannot meet the performance requirements of the internet traffic. Meanwhile, the scale-up scheme improves the performance by improving the hardware configuration, is expensive, can only meet the service volume for a period of time, and cannot solve the problem fundamentally.
However, the problem of unfriendly viewing of system information still exists in the process of using MyCat.
Disclosure of Invention
In order to solve the technical problems, the invention provides a method and equipment for supporting database middleware with friendly system information viewing, wherein the technical scheme is as follows:
the method for supporting the database middleware with friendly system information viewing is characterized by comprising the following steps:
s1, query is performed by standard sql statement.
The standard sql statement is input by the management port.
The step S1 includes the steps of:
s11, asynchronously recording the standard sql statements into an H2DB database;
s12, periodically and asynchronously counting the execution condition of the standard sql statement in the step S11.
The step S1 further includes the steps of:
and S13, periodically and asynchronously collecting the middleware information of the database.
An apparatus for supporting system information friendly viewing of database middleware, comprising a computer readable medium having a computer program stored thereon, said program being operative to perform:
s1, query is performed by standard sql statement.
The invention has the beneficial effects that: and a command consisting of standard sql statements is input through the management port for query, so that the method is convenient and practical.
Drawings
Fig. 1 shows a schematic structural diagram of supporting sql friendly viewing system information according to an embodiment of the application.
Detailed Description
In order to better understand the technical solution of the present invention, the present invention is further described with reference to fig. 1.
The method for supporting the database middleware with friendly system information viewing is characterized by comprising the following steps:
s1, query is performed by standard sql statement.
The standard sql statement is input by the management port.
As shown in fig. 1, to support sql friendly viewing system information, a standard sql statement is used as a query statement.
As can be seen from fig. 1, step S1 includes the steps of: 1, inserting asynchronous record SQL into H2DB database:
and starting a thread to asynchronously write SQL passing through MyCat-X into an H2DB database for later statistical analysis and providing data for 9066 port query.
MyCat-X is distributed database middleware supporting friendly viewing of system information. Namely, the new distributed database middleware obtained after the existing MyCat is improved according to the technical scheme of the invention is secondarily developed based on the community MyCat foundation and is renamed as MyCat-X.
2, periodically and asynchronously acquiring MyCat-X information:
and starting a thread to collect MyCat-X running information (including memory use conditions, a connection pool, back-end DB heartbeat information and the like) and write the MyCat-X running information into an H2DB database, and providing data for 9066 port query.
And 3, execution of a periodic asynchronous statistical standard sql statement in MyCat-X:
starting a thread to periodically make statistics based on the SQL recorded in the step 1, such as TOP 10 with the longest SQL execution time and the largest influence result set on the TOP 10SQL execution, TOP 10 with the longest SQL execution times, SQL read-write proportion and the like.
The periodicity in step 2 and step 3 refers to asynchronous collection or asynchronous statistical correlation information within a time period which is set by each. The period followed by the periodicity in step 2 and step 3 is not necessarily the same.
In the operation process of the community MyCat-X, various operation information can be recorded, and the operation information is unfriendly in output form and inconvenient to view through a traditional show @ command at a management port (9066). The method is expected to provide a flexible and friendly method for viewing various kinds of operation information, is inspired by a database, and can well meet the requirements of people through a standard SQL statement query mode, so that the H2DB small-sized embedded database is introduced into MyCAT-X. The information in the running process is directly written or written into the H2DB database at regular time, so that a query command (standard sql statement) is input through a 9066 port and forwarded to the H2DB database query engine, and the H2DB database returns the result to the user. Thus being convenient and practical.
An apparatus for supporting system information friendly viewing of database middleware includes a computer readable medium having a computer program stored thereon, the program being executed to perform the above method.
The above description is only a preferred embodiment of the application and is illustrative of the principles of the technology employed. It will be appreciated by a person skilled in the art that the scope of the invention as referred to in the present application is not limited to the embodiments with a specific combination of the above-mentioned features, but also covers other embodiments with any combination of the above-mentioned features or their equivalents without departing from the inventive concept. For example, the above features may be replaced with (but not limited to) features having similar functions disclosed in the present application.
Claims (3)
1. The method for supporting the database middleware with friendly system information viewing is characterized by comprising the following steps:
s1, querying the running information of the database middleware and/or the execution condition of the standard sql statement in the database middleware through the H2DB database by the standard sql statement;
the step S1 includes the steps of:
s11, asynchronously recording the standard sql statements passing through the database middleware into an H2DB database in the database middleware;
s12, periodically and asynchronously collecting database middleware operation information and recording the database middleware operation information into an H2DB database in the database middleware;
the periodicity refers to asynchronous acquisition or asynchronous statistics of related information in a time period following respective setting;
the standard sql statement is input by the management port.
2. The method for supporting system information friendly viewing database middleware as claimed in claim 1, wherein said step S1 further comprises the steps of:
s13, periodically and asynchronously counting the execution condition of the standard sql statement in the step S11 in the middleware of the database.
3. An apparatus for supporting system information friendly viewing of database middleware, comprising a computer readable medium having a computer program stored thereon, wherein the program is operative to perform:
s1, querying the running information of the database middleware and/or the execution condition of the standard sql statement in the database middleware through the H2DB database by the standard sql statement;
the step S1 includes the steps of:
s11, asynchronously recording the standard sql statements passing through the database middleware into an H2DB database in the database middleware;
s12, periodically and asynchronously collecting database middleware operation information and recording the database middleware operation information into an H2DB database in the database middleware;
the standard sql statement is input by the management port.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711106717.4A CN107943868B (en) | 2017-11-10 | 2017-11-10 | Method and equipment for supporting database middleware for friendly viewing of system information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711106717.4A CN107943868B (en) | 2017-11-10 | 2017-11-10 | Method and equipment for supporting database middleware for friendly viewing of system information |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107943868A CN107943868A (en) | 2018-04-20 |
| CN107943868B true CN107943868B (en) | 2021-12-24 |
Family
ID=61934816
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711106717.4A Active CN107943868B (en) | 2017-11-10 | 2017-11-10 | Method and equipment for supporting database middleware for friendly viewing of system information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107943868B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101183377A (en) * | 2007-12-10 | 2008-05-21 | 华中科技大学 | High availability data-base cluster based on message middleware |
| CN101201842A (en) * | 2007-10-30 | 2008-06-18 | 北京航空航天大学 | Digital museum gridding and construction method thereof |
| CN103793749A (en) * | 2014-02-27 | 2014-05-14 | 四川物联恒安安全技术研究有限公司 | Safety production comprehensive supervisory platform data transmission method |
Family Cites Families (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9183153B2 (en) * | 2012-05-04 | 2015-11-10 | Battelle Memorial Institute | Method and system for managing power grid data |
| US9339201B2 (en) * | 2012-10-08 | 2016-05-17 | Tosense, Inc. | Database and algorithm for evaluating efficacy of an electrophysiology procedure |
| CN104063425B (en) * | 2014-06-04 | 2017-09-19 | 五八同城信息技术有限公司 | The method and database middleware of data are inquired about by database middleware |
| US10277414B2 (en) * | 2014-07-18 | 2019-04-30 | Oracle International Corporation | Communication gateway services in a networked message distribution system |
| CN104598531B (en) * | 2014-12-25 | 2019-05-07 | 广东电子工业研究院有限公司 | Incremental data moving method between a kind of isomeric relationship type database based on trigger |
| CN106686031B (en) * | 2015-11-09 | 2020-02-07 | 广东华邦云计算股份有限公司 | Method and device for upgrading application to SaaS mode |
| US10782987B2 (en) * | 2015-12-04 | 2020-09-22 | Quest Software Inc. | Distributed database driver middleware |
| CN106503087A (en) * | 2016-10-12 | 2017-03-15 | 郑州云海信息技术有限公司 | A kind of database middleware for Distributed Data Visits |
| CN106528293A (en) * | 2016-11-04 | 2017-03-22 | 武汉斗鱼网络科技有限公司 | Database access method and apparatus |
-
2017
- 2017-11-10 CN CN201711106717.4A patent/CN107943868B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101201842A (en) * | 2007-10-30 | 2008-06-18 | 北京航空航天大学 | Digital museum gridding and construction method thereof |
| CN101183377A (en) * | 2007-12-10 | 2008-05-21 | 华中科技大学 | High availability data-base cluster based on message middleware |
| CN103793749A (en) * | 2014-02-27 | 2014-05-14 | 四川物联恒安安全技术研究有限公司 | Safety production comprehensive supervisory platform data transmission method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107943868A (en) | 2018-04-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7032229B1 (en) | Automatic tracking of user progress in a software application | |
| US20060173878A1 (en) | Efficient processing of time series data | |
| US20110113117A1 (en) | Asynchronous Collection and Correlation of Trace and Communications Event Data | |
| WO2020062980A1 (en) | File access tracking method, device, storage medium and terminal | |
| CN105373541B (en) | The processing method and system of the data operation request of database | |
| JP2006508476A5 (en) | ||
| CN109471851B (en) | Data processing method, device, server and storage medium | |
| CN110569214A (en) | Index construction method and device for log file and electronic equipment | |
| CN105493028A (en) | Data consistency and rollback for cloud analytics | |
| CN111930975A (en) | Ship navigation data playback and analysis system and method | |
| CN110505495A (en) | Multimedia resource takes out frame method, device, server and storage medium | |
| CN103514274A (en) | Method for data migration of non-relational database HBase | |
| CN101610303A (en) | Multi-medium data automatic backup method and system | |
| JP2008310634A (en) | Database search device and database search program | |
| CN105550375A (en) | Heterogeneous data integrating method and system | |
| WO2023246638A1 (en) | Information processing method and apparatus, wearable device and electronic device | |
| Wang et al. | Sharkdb: An in-memory storage system for massive trajectory data | |
| CN103799997A (en) | Physiological monitoring parameter recording method and system based on image recognition | |
| WO2017107679A1 (en) | Historical information display method and apparatus | |
| CN102187340B (en) | Breakpoint information management method and breakpoint information manager | |
| CN103152633A (en) | Method and device for identifying key word | |
| US20120317133A1 (en) | Task context recovery | |
| CN107943868B (en) | Method and equipment for supporting database middleware for friendly viewing of system information | |
| CN104156669A (en) | Computer information evidence obtaining system | |
| US20150154103A1 (en) | Method and apparatus for measuring software performance |
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 |