Failure Detection and Fencing in a Computing System
    1.
    发明申请
    Failure Detection and Fencing in a Computing System 失效
    计算系统中的故障检测与击剑

    公开(公告)号:US20110145635A1

    公开(公告)日:2011-06-16

    申请号:US12635338

    申请日:2009-12-10

    IPC分类号: G06F11/07

    CPC分类号: G06F11/0793 G06F11/0715

    摘要: A method, computer program product, and system for detecting and fencing off a failed entity instance so that failover time in the computing system is reduced. Upon detection of a failed entity, for example a failed process, a signal handler invokes an operating system interface to fence off the failed instance from modifying its persistent state, so that the entity may be re-instantiated prior to termination of the failed instance. This approach reduces failover time and eliminates split-brain problems without compromising access to the failed instance to obtain diagnostic information, core dumps, and the like.

    摘要翻译: 一种用于检测和防范故障实体实例的方法,计算机程序产品和系统,从而减少计算系统中的故障转移时间。 在检测到失败的实体(例如失败的过程)时,信号处理器调用操作系统接口来阻止失败的实例修改其持久状态,使得可以在失败的实例终止之前重新实例化该实体。 这种方法可以减少故障转移时间并消除分裂问题,而不会影响对故障实例的访问,以获取诊断信息,核心转储等。

    Failure detection and fencing in a computing system
    2.
    发明授权
    Failure detection and fencing in a computing system 失效
    计算系统中的故障检测和防护

    公开(公告)号:US08352798B2

    公开(公告)日:2013-01-08

    申请号:US12635338

    申请日:2009-12-10

    IPC分类号: G06F11/00

    CPC分类号: G06F11/0793 G06F11/0715

    摘要: A method, computer program product, and system for detecting and fencing off a failed entity instance so that failover time in the computing system is reduced. Upon detection of a failed entity, for example a failed process, a signal handler invokes an operating system interface to fence off the failed instance from modifying its persistent state, so that the entity may be re-instantiated prior to termination of the failed instance. This approach reduces failover time and eliminates split-brain problems without compromising access to the failed instance to obtain diagnostic information, core dumps, and the like.

    摘要翻译: 一种用于检测和防范故障实体实例的方法,计算机程序产品和系统,从而减少计算系统中的故障转移时间。 在检测到失败的实体(例如失败的过程)时,信号处理器调用操作系统接口来阻止失败的实例修改其持久状态,使得可以在失败的实例终止之前重新实例化该实体。 这种方法可以减少故障转移时间并消除分裂问题,而不会影响对故障实例的访问,以获取诊断信息,核心转储等。

    Systems and methods for self-tuning memory
    3.
    发明授权
    Systems and methods for self-tuning memory 有权
    自调整内存的系统和方法

    公开(公告)号:US07694102B2

    公开(公告)日:2010-04-06

    申请号:US11278130

    申请日:2006-03-30

    IPC分类号: G06F12/02 G06F12/16 G06F13/24

    CPC分类号: G06F12/0646 G06F12/0223

    摘要: There are disclosed systems, computer program products, and methods for self-tuning memory. In an embodiment, a method for self-tuning memory comprises setting a tuning interval and a target range for free memory for a memory pool. If memory consumption falls outside of the set target range for free memory during a tuning interval, a new target size for the memory pool is set based on the target range for free memory. Memory allocation for the memory pool is increased or decreased for the next tuning interval, such that the new target size for the memory pool is reached. A decrement rate may be used to provide a controlled decrease of the memory pool over a plurality of tuning intervals if necessary, until the new target size for the memory pool is reached.

    摘要翻译: 已经公开了系统,计算机程序产品和用于自调整存储器的方法。 在一个实施例中,一种用于自调整存储器的方法包括设置用于存储器池的空闲存储器的调谐间隔和目标范围。 如果内存消耗在调整间隔期间超出了可用内存的设置目标范围,则基于可用内存的目标范围设置内存池的新目标大小。 内存池的内存分配在下一个调整间隔内增加或减少,从而达到内存池的新目标大小。 如果需要,减量率可以用于在多个调谐间隔中提供存储池的受控减少,直到达到存储器池的新目标大小。

    Handling access requests to a page while copying an updated page of data to storage
    6.
    发明授权
    Handling access requests to a page while copying an updated page of data to storage 有权
    在将更新的数据页复制到存储时,处理对页面的访问请求

    公开(公告)号:US08086580B2

    公开(公告)日:2011-12-27

    申请号:US11034518

    申请日:2005-01-11

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30362

    摘要: Provided are a method, system, and program for handling access requests to a page while copying an updated page of data to storage. An update to a page in a memory is received and indication is made that the page has an exclusive lock. The update is applied to the page and an operation is initiated to copy the updated page to a physical log in a storage in response to applying the update to the page. Reads and writes are allowed to proceed against the page while the operation to copy the updated page to the physical log in the storage is occurring.

    摘要翻译: 提供了一种用于在将更新的数据页复制到存储时处理对页面的访问请求的方法,系统和程序。 接收对存储器中的页面的更新,并且指示该页面具有排他锁。 更新应用于页面,并且响应于将更新应用于页面,启动操作以将更新的页面复制到存储器中的物理日志。 允许读取和写入对页面进行操作,而将更新页面复制到存储器中的物理日志的操作正在发生。

    System and method for optimally configuring software systems for a NUMA platform
    7.
    发明授权
    System and method for optimally configuring software systems for a NUMA platform 有权
    用于为NUMA平台优化配置软件系统的系统和方法

    公开(公告)号:US07302533B2

    公开(公告)日:2007-11-27

    申请号:US11077579

    申请日:2005-03-11

    IPC分类号: G06F12/00

    CPC分类号: G06F9/5016 G06F9/5061

    摘要: A method and system for improving memory access patterns of software systems on NUMA systems discovers NUMA system resources where the NUMA system resources comprises a plurality of NUMA nodes; determines a plurality of database threads, processes, and objects for a database configuration; and generates a policy which assigns the plurality of database threads, processes, and objects to the plurality of NUMA nodes, wherein the generating of the policy is performed prior to initialization of the plurality of database threads, processes, and objects. The assignment of the database threads, processes, or objects to NUMA nodes is such that the amount of remote memory accesses is reduced. When the database thread, process, or object initializes, the database server queries the policy for its assigned NUMA node(s). The database thread, process, or object is then bound to the assigned NUMA node(s).

    摘要翻译: 用于改进NUMA系统上的软件系统的存储器访问模式的方法和系统发现NUMA系统资源,其中NUMA系统资源包括多个NUMA节点; 确定数据库配置的多个数据库线程,进程和对象; 并且生成将所述多个数据库线程,进程和对象分配给所述多个NUMA节点的策略,其中在所述多个数据库线程,进程和对象的初始化之前执行所述策略的生成。 将数据库线程,进程或对象分配给NUMA节点使得远程内存访问量减少。 当数据库线程,进程或对象初始化时,数据库服务器向其分配的NUMA节点查询策略。 然后将数据库线程,进程或对象绑定到已分配的NUMA节点。

    Automatic detection and correction of hot pages in a database system
    8.
    发明授权
    Automatic detection and correction of hot pages in a database system 失效
    在数据库系统中自动检测和更正热页

    公开(公告)号:US08250111B2

    公开(公告)日:2012-08-21

    申请号:US12394786

    申请日:2009-02-27

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30306

    摘要: According to one embodiment of the present invention, a method of detecting and correcting hot pages in a database system includes monitoring transactions involving pages in a database and determining if one of the transactions had to wait for access to one of the pages; incrementing a page contention counter each time one of the transactions had to wait for access to one of the pages. The method then determines if the page contention counter exceeds a predetermined threshold and monitors transactions on one of the pages for which the page contention count was exceeded. The method then determines if a row was accessed in the page for which the page contention count was exceeded and increments a reference count for the accessed row. The accessed rows are flagged when the reference count exceeds a second predetermined threshold. The flagged rows are moved to another page in the database.

    摘要翻译: 根据本发明的一个实施例,一种在数据库系统中检测和校正热页面的方法包括监视涉及数据库中的页面的事务,并且确定其中一个事务是否必须等待访问其中一个页面; 每次其中一个事务必须等待访问其中一个页面时,增加页面争用计数器。 该方法然后确定页面争用计数器是否超过预定阈值,并且监视超出页面争用次数的页面之一上的事务。 该方法然后确定在超出页面争用次数的页面中是否访问了一行,并增加访问行的引用计数。 当参考计数超过第二预定阈值时,所访问的行被标记。 标记的行被移动到数据库中的另一个页面。

    ENHANCED RELATIONAL DATABASE MANAGEMENT SYSTEM AND METHOD
    10.
    发明申请
    ENHANCED RELATIONAL DATABASE MANAGEMENT SYSTEM AND METHOD 审中-公开
    增强的关系数据库管理系统和方法

    公开(公告)号:US20080154842A1

    公开(公告)日:2008-06-26

    申请号:US11613773

    申请日:2006-12-20

    IPC分类号: G06F17/30

    摘要: A method to enhance relational database management system resiliency and query operations by minimizing CPU overhead and database page access latency and by facilitating database restoration and query efficiency. The method includes creating a clean database page in a buffer pool of a relational database management system, granting exclusive access to the clean database page within the buffer pool to an application that transitions the clean database page to a dirty database page by altering data store thereon, immediately downgrading exclusive access to the dirty database page to shared access in response to receiving an exclusive access termination request from the application, writing the dirty database page to a physical log, and releasing share access to the dirty database page.

    摘要翻译: 通过最小化CPU开销和数据库页面访问延迟以及促进数据库恢复和查询效率来增强关系数据库管理系统弹性和查询操作的方法。 该方法包括在关系数据库管理系统的缓冲池中创建干净的数据库页面,授予对缓冲池内的干净数据库页面的独占访问权,通过改变其上的数据存储将清理数据库页面转换到脏数据库页面的应用程序 响应于从应用程序接收到独占访问终止请求,将脏数据库页面写入物理日志,并释放对脏数据库页面的共享访问,立即将对脏数据库页面的独占访问权降级到共享访问。