search
HomeDatabaseMysql TutorialeXtremeDB相关问题解答(1)

这些问题基于eXtremeDB 4.5 1776 1, Ifthe asynchonous event happened 100 times in a short period, would all the 100events would be handled sequentially? 100个异步event同时发生是否都能被处理(即若一个异步事件还在响应中,又来了数个新的异步事

这些问题基于eXtremeDB 4.5 1776

1, Ifthe asynchonous event happened 100 times in a short period, would all the 100events would be handled sequentially?

100个异步event同时发生是否都能被处理(即若一个异步事件还在响应中,又来了数个新的异步事件,后来的事件是否会丢失)

Eventshave a semantics and behavior of a a unix-style signals。如果没有处理,就会丢失,可以考虑TL选项来协同处理。

2,Dothe XML interface have any specific requirements about the data precision? CouldeXtremeDB support the XSD ?

XML的相关数据精度要求,是否支持XSD(导入导出浮点数的方式)

暂时不支持。

3, How is the sniffer recover the dead transaction? What is theprocedure?

发现有hang的事务后,Sniffer怎么恢复事务?

This function inspects the state of allconnections to the database using the

provided user's callback function. Itperforms database recovery if dead

connections were detected. The callbackuser defined function must implement

logic (using OS, timeout, watchdogs,...) todetect dead database connections. If

this callback returns MCO_S_DEAD_CONNECTIONthen recovery of the

database will be performed according to thesniffer policy specified.

The following enum defines sniffer policy(when sniffer should call user's

callback to check status of connection):

typedef enum mco_sniffer_policy {

MCO_SNIFFER_INSPECT_ACTIVE_CONNECTIONS,

MCO_SNIFFER_INSPECT_ACTIVE_TRANSACTIONS,

MCO_SNIFFER_INSPECT_HUNG_TRANSACTIONS

} mco_sniffer_policy;

The following typedef defines the usercallback which detects dead connections:

typedef MCO_RET (*mco_sniffer_callback_t)

(mco_db_h db,

void* context,

mco_trans_counter_t trans_no);

Nothing should be done to affect the inputparameters. These parameters are:

db: database connection handle.

context: user defined connection context.From the eXtremeDB point of view

this is opaque data of size MCO_CFG_CONNECTION_CONEXT_SIZEwhich is filled by

mco_db_connect_ctx() function.

trans_no: number of active transaction (0if there is no active transaction) .

It should return MCO_S_DEAD_CONNECTION toforce database recovery or

MCO_S_OK if the connection is ok; any otherreturn code will cause

mco_db_sniffer() to interrupt and returnthis error code.

如果有MCO_S_DEAD_CONNECTION,就会自动调用mco_db_recover( mco_db_h db,mco_db_h recover_db ); Normally adatabase that was not properly closed (perhaps after a system crash) will berecovered automatically during the mco_db_open_dev(). This function allows anapplication to explicitly recover a database.

详情可参考sniffer的源码。 

4, Kernelveriosn could support vxworks 653?

Kernel是否可以在vx653上运行

不支持,接下来的版本会考虑这个问题。

5, Whatthe steps need to port th1e eXtremeDB from 3.5 to 4.5?

从3.5移植到4.5需要什么步骤,需要注意什么。

3.5到4.5基本没有太多的接口差异问题,可以从编译,链接等基本步骤做起,目前没有什么需要注意的事项。

6, What is the meaning of Mcocomp –f option?

Mcocomp –f 这个参数什么意思?

声明mco文件名称,默认情况下mco的文件名称可以放在最后,用-f后可以放在其他参数中间。

7, Couldthe database created with eXtremeDB 3.5 be opened by runtime of 4.5?

eXtremeDB3.5创建的数据库是否能被4.5打开。

不可以,需要数据导入到xml等方式进行数据的备份恢复。

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
How does MySQL's licensing compare to other database systems?How does MySQL's licensing compare to other database systems?Apr 25, 2025 am 12:26 AM

MySQL uses a GPL license. 1) The GPL license allows the free use, modification and distribution of MySQL, but the modified distribution must comply with GPL. 2) Commercial licenses can avoid public modifications and are suitable for commercial applications that require confidentiality.

When would you choose InnoDB over MyISAM, and vice versa?When would you choose InnoDB over MyISAM, and vice versa?Apr 25, 2025 am 12:22 AM

The situations when choosing InnoDB instead of MyISAM include: 1) transaction support, 2) high concurrency environment, 3) high data consistency; conversely, the situation when choosing MyISAM includes: 1) mainly read operations, 2) no transaction support is required. InnoDB is suitable for applications that require high data consistency and transaction processing, such as e-commerce platforms, while MyISAM is suitable for read-intensive and transaction-free applications such as blog systems.

Explain the purpose of foreign keys in MySQL.Explain the purpose of foreign keys in MySQL.Apr 25, 2025 am 12:17 AM

In MySQL, the function of foreign keys is to establish the relationship between tables and ensure the consistency and integrity of the data. Foreign keys maintain the effectiveness of data through reference integrity checks and cascading operations. Pay attention to performance optimization and avoid common errors when using them.

What are the different types of indexes in MySQL?What are the different types of indexes in MySQL?Apr 25, 2025 am 12:12 AM

There are four main index types in MySQL: B-Tree index, hash index, full-text index and spatial index. 1.B-Tree index is suitable for range query, sorting and grouping, and is suitable for creation on the name column of the employees table. 2. Hash index is suitable for equivalent queries and is suitable for creation on the id column of the hash_table table of the MEMORY storage engine. 3. Full text index is used for text search, suitable for creation on the content column of the articles table. 4. Spatial index is used for geospatial query, suitable for creation on geom columns of locations table.

How do you create an index in MySQL?How do you create an index in MySQL?Apr 25, 2025 am 12:06 AM

TocreateanindexinMySQL,usetheCREATEINDEXstatement.1)Forasinglecolumn,use"CREATEINDEXidx_lastnameONemployees(lastname);"2)Foracompositeindex,use"CREATEINDEXidx_nameONemployees(lastname,firstname);"3)Forauniqueindex,use"CREATEU

How does MySQL differ from SQLite?How does MySQL differ from SQLite?Apr 24, 2025 am 12:12 AM

The main difference between MySQL and SQLite is the design concept and usage scenarios: 1. MySQL is suitable for large applications and enterprise-level solutions, supporting high performance and high concurrency; 2. SQLite is suitable for mobile applications and desktop software, lightweight and easy to embed.

What are indexes in MySQL, and how do they improve performance?What are indexes in MySQL, and how do they improve performance?Apr 24, 2025 am 12:09 AM

Indexes in MySQL are an ordered structure of one or more columns in a database table, used to speed up data retrieval. 1) Indexes improve query speed by reducing the amount of scanned data. 2) B-Tree index uses a balanced tree structure, which is suitable for range query and sorting. 3) Use CREATEINDEX statements to create indexes, such as CREATEINDEXidx_customer_idONorders(customer_id). 4) Composite indexes can optimize multi-column queries, such as CREATEINDEXidx_customer_orderONorders(customer_id,order_date). 5) Use EXPLAIN to analyze query plans and avoid

Explain how to use transactions in MySQL to ensure data consistency.Explain how to use transactions in MySQL to ensure data consistency.Apr 24, 2025 am 12:09 AM

Using transactions in MySQL ensures data consistency. 1) Start the transaction through STARTTRANSACTION, and then execute SQL operations and submit it with COMMIT or ROLLBACK. 2) Use SAVEPOINT to set a save point to allow partial rollback. 3) Performance optimization suggestions include shortening transaction time, avoiding large-scale queries and using isolation levels reasonably.

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment

MantisBT

MantisBT

Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

EditPlus Chinese cracked version

EditPlus Chinese cracked version

Small size, syntax highlighting, does not support code prompt function

Atom editor mac version download

Atom editor mac version download

The most popular open source editor