flyinweb's blog

如何清理hung住的分布式事务 

[清理两阶段提交不能完成的事务]

环境:

IDS 分布式数据库，遵循两阶段提交协议

问题描述:

重启IDS后仍然不能清理一些XA事务

 在informix 11.50中，tmp/online.log日志中出现如下错误信息：

09:15:01  SCHAPI: Error -206 The specified table (mon_syssqltrace) is not in the database.
09:15:01  SCHAPI: Type: SENSOR, Name: Save SQL Trace, Location: NULL.
09:15:01  SCHAPI: Error -111 ISAM error:  no record found.
09:15:01  SCHAPI: Type: SENSOR, Name: Save SQL Trace, Location: NULL.

 简介

任何稍微了解 SQL（结构化查询语言）的人都知道如何在数据库中创建表和索引。但是就系统和数据库性能而言，如何才能更高效地创建表和索引呢？以下是在创建表和索引之前需要考虑的事项：

• 数据库空间（Dbspace）
• 区段大小（Extent size）
• 锁模式
• 约束键字

本文将仔细研究所有这些考虑事项，并通过工作环境中收集的实际例子进行说明。

Xtrabackup是percona开发的产品，可以看做是InnoDB Hotbackup的免费替代品。

Percona XtraBackup is the world's only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB, XtraDB, and MyISAM databases⁰. It makes MySQL hot backups for all versions of Percona Server, MySQL, and MariaDB. It performs streaming, compressed, and incremental MySQL backups.

What are the features of Percona XtraBackup?

Here is a short list of XtraBackup features. See the documentation for more.

• Create hot InnoDB backups without pausing your database
• Make incremental backups of MySQL
• Stream compressed MySQL backups to another server
• Move tables between MySQL servers online
• Create new MySQL replication slaves easily
• Backup MySQL without adding load to the server

先看看如何安装Xtrabackup，下载最新的版本，最简单的安装方式无疑是使用RPM包，不过如果你想使用源代码方式安装的话，则会发现其安装方式有点古怪，这是因为它采用的在MySQL源代码上打补丁构建的方式。

Introduction

This page shows some common autotools configuration options and how they map to CMake equivalents. It supplements the CMake page that describes how to build MySQL with CMake.

Berkeley db管理

1. 打开数据库
首先必须调用db_create()函数初始化DB句柄，然后就可以使用open()方法打开数据库了。默认情况下，如果数据库不存在，DB不会创建。为了覆盖缺省行为，可以在open()调用中指定DB_CREATE标记。

 为什么 MySQL的 binlog-do-db 选项是危险的.

I see a lot of people filtering replication with binlog-do-db, binlog-ignore-db, replicate-do-db, and replicate-ignore-db. Although there are uses for these, they are dangerous and in my opinion, they are overused. For many cases, there's a safer alternative.


我发现很多人通过 binlog-do-db, binlog-ignore-db, replicate-do-db 和 replicate-ignore-db 来过滤复制(某些数据库), 尽管有些使用, 但是,在我看来,他们是危险的,并且他们被滥用了. 对于很多的实例,有更安全的替换方案.

    IIS Database Manager allows you to easily manage your local and remote databases from within IIS Manager. IIS Database Manager automatically discovers databases based on the Web server or application configuration and also provides the ability to connect to any database on the network. Once connected, IIS Database Manager provides a full array of administrative functionalities including managing tables, views, stored procedures and data as well as running ad hoc queries. IIS Database Manager provides support for Microsoft SQL Server and MySQL. In addition, because IIS Database Manager is an extension of IIS Manager, administrators can securely delegate the management of databases to authorized local or remote users, without having to open additional management ports on the server.

Administer local and remote databases through IIS Manager