The database is fully functional — it can store data, run SQL, use indexes, and survive crashes. But it’s missing three things that make a database a database: Transactions: grouping multiple...

When I was younger, the culture war (in my bubble) was about transactional versus non-transactional engines, Postgres versus MySQL (MyISAM). Surely, I preferred the transactional concept. Data...

The world of online transactions has developed dramatically, but few industries navigate payment processing challenges fairly like grownup leisure platforms. Escort web sites face distinctive...

Discover how to use transactions in MySQL to keep your data safe and organized—just like a diligent librarian! This beginner-friendly post explains what transactions are, why they matter, and how...

Logical replication in PostgreSQL has steadily evolved since its introduction in version 10. In a previous blog post, I discussed how PostgreSQL 14 introduced streaming of large transactions....

本研究探讨了移动支付环境中反洗钱检测的效率，提出了一种结合深度学习和账户画像的创新框架，以提高在数据有限情况下的欺诈检测能力，旨在提升反洗钱检测的实时性和准确性。

Keeping top talent in the fold and engaged before, during, and after a large deal closes is critical for creating value from transactions. Here’s how to address their needs throughout the M&A phases.

Yup, you read it right. Idle transactions can cause massive table bloat that the vacuum process may not be able to address. Bloat causes degradation in performance and can keep encroaching disk...

BSE leverages MySQL Enterprise Edition for processing 150 million trades and 5 billion orders per day.

恒星共识协议（SCP）被恒星网络用于安全可靠的交易。它通过小组投票来确保共识，平衡安全性和活跃性。随着网络的增长，SCP需要处理更多的交易，并且正在努力增强其安全性。SCP扩展了区块链技术在支付之外的可能性。

In managed services, we get requests to migrate from traditional to GTID-based replication. However, the customer does not want to first enable the GTID on the source node (production). Before...

MySQL Community Advent Calendar 2022 - In this blog post, we will discuss how to display long transactions in MySQL 8.0.

As the last Postgres release, carrying the number 15, seemed kind of an “anniversary” release to me, I thought it would be fun / useful to run a series of tests to try to gauge the scale of...

This is one of the exciting troubleshooting related to XA transactions let’s dive in. Let me provide a few backgrounds. For one of our clients, when we try to drop a table, it is waiting for...

Recently, somebody asked me how he can find the long running transactions in MySQL. I already have one MySQL Shell plugin that allows you to find the current transactions sorted by time. The...

The MySQL Performance Schema is a gold mine of valuable data. Among the many nuggets you can extract from it is an historical report of transactions: how long a transaction took to execute, what...

Consuming data from a remote foreign database into our local database just like another local table is a great feature that adds an excellent level of flexibility to the design of a database...

我们知道，在关系型数据库中，比如mysql，如果要使用事务，首先向数据库服务器发送BEGIN，然后执行各个相互一致的写操作和读操作，最后，用户可以选择发送COMMIT来确认之前所做的修改，或者发送ROLLBACK来放弃那些修改。同样，Redis中也有简单的方法处理一连串相互一致的读操作和写操作。首先是以MULTI命令开始事务，后续跟着一连串命令，最后以EXEC结束事务或者以DISCARD命令...