Most databases will work well with a single data file and a single transaction log file.
大多数数据库在只有单个数据文件和单个事务日志文件的情况下性能良好。
The time stamp on the source storage group of the last successful copy of a transaction log file.
最后一次成功复制事务日志文件的源存储组上的时间戳。
The time stamp on the target storage group of the last successful inspection of a transaction log file.
最后一次成功检查事务日志文件的目标存储组上的时间戳。
It can happen, however, most often due to faulty hardware or operational mistakes (like deleting a transaction log file).
然而,它的确会发生,大部分原因经常是硬件出错和操作错误(比如日志文件被删)。
Due to the large amount of data in the audit log table, a single INSERT statement will usually fail because the data per transaction exceeds the log file size of the database system.
因为审核日志表格里有大量的数据,单独的insert语句通常会失败,这是因为每个事务的数据超过了数据库系统里的日志文件的容量。
A file system that spans two volumes is allocated for transaction log data.
我们为事务日志数据分配了一个跨越两个卷的文件系统。
You can see the complete transaction process by viewing the file's log file if you need to diagnose any issues.
如果需要诊断任何问题,可以通过查看日志文件了解完整的事务处理过程。
A file system that spanned two volumes was allocated for transaction log data.
一个文件系统横跨两个卷,用于事务日志数据。
A file system, which spans two volumes, is allocated for transaction log data.
一个文件系统横跨两个卷,用于事务记录数据。
The transaction log is stored as a sequential disk file (or sometimes in a raw partition) and will generally only be written to, not read from, except in the case of rollback or recovery.
事务日志存储为连续的磁盘文件(有时存储在原始分区中),并且一般只是用于写入而不用于读取,回滚或恢复的情况例外。
In addition, two file systems on a seventh array were used to hold the transaction log and the journal files.
另外,第7个阵列上的两个文件系统用来存储事务日志和日志文件。
The NameNode uses a transaction log called the EditLog to persistently record every change that occurs to file system metadata.
对于任何对文件元数据产生修改的操作,Namenode都使用一个称为Editlog的事务日志记录下来。
HSQLDB keeps all table and index data in memory, saving all SQL statements issued into a file named database.script, which also ACTS as the transaction log.
HSQLDB将所有表和索引数据放在内存中,将所有发出的sql语句保存到一个名为database .script的文件中,该文件同时也充当着事务日志的角色。
As you can see, simply by adding an additional disk for the log file directory and turning on transaction logging, you can realize an immediate performance improvement!
可以看到,只需要添加一个磁盘用于日志文件并启用事务日志,您就可以立即实现性能改进!
When overwriting the original, a rollback journal or write-ahead log WAL file is used just as it would be for any other database transaction.
当将内容重新写回到原始数据库文件时,一个回滚日志或者写前日志wal文件将会被使用,正如它为其它数据库事务服务一样。
Redo records can also be written to a redo log file before the corresponding transaction is committed.
基本意思如下对于重做记录,在相应的事务被提交之前,也能被写入重做日志文件。
If the redo log buffer fills, or another transaction commits, LGWR flushes all of the redo log entries in the redo log buffer to a redo log file, even though some redo records may not be committed.
例如如果重做日志缓冲满了,或者有其它的事务提交了。LGWR进程会把所有在重做日志缓冲中的重做日志事项写入重做文件,即使是一些重做记录可能还没有提交。
If the redo log buffer fills, or another transaction commits, LGWR flushes all of the redo log entries in the redo log buffer to a redo log file, even though some redo records may not be committed.
例如如果重做日志缓冲满了,或者有其它的事务提交了。LGWR进程会把所有在重做日志缓冲中的重做日志事项写入重做文件,即使是一些重做记录可能还没有提交。
应用推荐