Like the table cache, there is also a cache for threads.
与表的缓存类似,对于线程来说也有一个缓存。
It then closes all open tables (the FLUSH part) and expels them from the table cache.
然后,它关闭所有打开的表(冲洗表)并且从表中的高速缓存刷出。
When a work table is dropped, two pages may remain allocated and they are returned to the work table cache.
工作表被删除后,这两页可能会保持分配状态并返回到工作表缓存中。
When you create a table space, you can associate it with a specific buffer pool (database cache) as well as to specific containers.
当创建表空间时,可以将它与特定的缓冲区池(数据库缓存)关联起来,并关联到特定的容器。
We cannot pay attention to read cache hit rate since we have been sequentially scanning a huge table over and over.
由于我们一遍又一遍地顺序扫描一个巨大的表,这样我们就无法关注读缓存命中率。
It is important to note that file system caching was disabled by specifying the no file system CACHE clause when each table space in the database was created.
重要的是,要注意当每一个数据库表空间创建时,文件系统缓存已经通过指定NOFILESYSTEM cache子句并被禁用。
Instead, use an in memory hash table to cache the data and just keep a key to the data in the session.
相反地,应该使用内存中的哈希表来缓存数据,并且在会话中保存一个对此数据进行引用的键。
With this command, you can dump the cache contents to a file, display statistics of cache usage, flush the cache table, and change the logging level of the daemon.
使用这个命令,您可以将缓存的内容转储到文件中、显示缓存使用情况的统计信息、刷新缓存表,以及更改该守护进程的日志级别。
The catalog cache is used to store table descriptor information that is used when the tables, views, or alias have been referenced in previous statements.
目录缓存器用于存储表描述符信息,而在先前的语句中引用表、视图或别名时将使用该信息。
The login module can also use an existing TGT from a credentials cache or an existing secret key from a key table.
登录模块还可以使用一个来自凭证高速缓存的已存在的TGT或是来自密钥表的已存在的密钥。
Although looking one line higher at the size of the engine in memory (118,812 KB), we aren't working with a lot of memory, Let's keep cache on the table.
虽然在第一行中,针对引擎的大小来对内存做了考虑(118,812KB),但是,我们没有使用很多内存,我们为表保持缓存。
Where multiple credentials are available, for example, from a credentials cache or a key table, the choice of default credentials can be based on a number of factors.
在多个凭证可用的场合,例如,在一个凭证高速缓存或一个密钥表,对缺省的凭证的选择可取决于很多因素。
It can be argued that the most recent addition to a key table or a credential cache is the most reasonable choice as a default; it is certainly one of the simplest choices.
这表明最经常添加到密钥表或凭证高速缓存的凭证是最合理的缺省选项;这当然是最简单的一种选择。
Cache tables are similar to MQTs with the restriction that a cache table supports only non-aggregate queries over a single table.
缓存表类似于具有以下限制的MQT,即缓存表只支持单个表上的非聚集查询。
DB2 USES buffer pools to cache the table and index data as they are being read or written to the hard disk drive.
当从硬盘驱动器读写表和索引数据时,DB 2使用缓冲池来缓存它们。
Since MQTs are local tables that cache the results of a query, the same considerations for creating an index on a local table apply to creating indexes on MQTs.
因为MQT是缓存查询结果的本地表,所以在本地表上创建索引的相同步骤也可应用于在 MQT 上创建索引。
The cache types are described in Table 3 according to the tag name used in the solrconfig.xml file.
solr提供了四种不同的缓存类型,所有四种类型都可在solrconfig. xml的部分中配置。
This is because Oracle uses a lot of virtual memory, particularly with respect to its System Global Area (SGA), which is used to cache table data, among other things.
这是因为Oracle使用大量的虚拟内存,特别是对于其系统全局区域(SGA),这个区域用于缓存表数据和其他东西。
The cache table facility in the Control Center, which lets you set up local caches of nicknames using replication as the refresh mechanism.
ControlCenter中的缓存表功能,它使您可以使用复制作为刷新机制来建立昵称的本地缓存。
If a guideline is updated, or deleted from the table, then it is necessary to refresh the cache by issuing the FLUSH OPTIMIZATION PROFILE cache statement, so it can be used.
如果从这个表中更新或删除一个指南,那么需要通过发出FLUSHOPTIMIZATIONPROFILEcache语句更新缓存,使之可以被使用。
The table below shows the range of cache clearing available.
下表显示了可以使用的缓存清除范围。
The profiling table provides the percentage and number of samples collected for specified processor events such as the number of cache line misses, Transition Lookaside Buffer (TLB) misses, and so on.
评测表提供为特定的处理器事件收集的采样的百分数或数量,比如高速缓存线路故障的数量、传输后备缓存(TLB)故障的数量,等等。
The dentry cache is built using a hash table and is hashed by the name of the object.
使用散列表创建dentry缓存,并且根据对象名分配缓存。
A Web page displays the data, such as table-cache usage, key efficiency, connected clients, and temporary-table usage.
有一个Web页面会显示这些数据,例如表缓存的使用情况、关键字效率、连接上的客户机以及临时表的使用情况。
Based on the comments to my question and further testing, I ended up using an Azure Table to cache my results.
基于我的问题和进一步的测试的评论,我结束了使用表格来缓存结果。
When a work table is cached, the table is truncated and nine pages remain in the cache for reuse.
缓存工作表时,该表会截断,并且缓存中保留九页以便重用。
Will Postgres automatically cache "active" records from a large table?
将数据库自动缓存”从一个大的表活动”的记录?
Example 2: you have a "last_login" field in your table. It updates every time a user logs in to the website. But every update on a table causes the query cache for that table to be flushed.
例2:一家包括“最后登录”字段的用户表,用户每登录网站都会要更新,而每次对表的更新都会导致这个表的查询缓存要刷新。
Example 2: you have a "last_login" field in your table. It updates every time a user logs in to the website. But every update on a table causes the query cache for that table to be flushed.
例2:一家包括“最后登录”字段的用户表,用户每登录网站都会要更新,而每次对表的更新都会导致这个表的查询缓存要刷新。
应用推荐