说明哪些表空间使用哪些缓冲池。
其他表空间使用默认的表空间选择算法。
The remaining table Spaces use a default table space selection algorithm.
下面的查询清单1说明了哪些表空间使用哪些缓冲池。
The following query Listing 1 shows which table Spaces use which buffer pools.
一个缓冲池是与单个数据库相关联的,可以被多个表空间使用。
A buffer pool is associated with a single database, and can be used by more than one table space.
如果可能,最好对DB2事务日志和DB 2表空间使用不同的磁盘控制器。
If possible, it's even better if you are able to use different disk controllers for DB2 transaction logs and DB2 table Spaces.
通常,建议对DB2事务日志适用一组专用磁盘,而对DB 2表空间使用另一组专用磁盘。
Typically, it's recommended that you use a set of dedicated disks for DB2 transaction logs and use another set of dedicated disks for DB2 table Spaces.
图1中的试验对DB 2表空间使用了nofilesystemcaching选项。
The experiments in Figure 1 used the no file system caching option for the DB2 table space.
另外,用户可以为某些表空间指定特定的映射,而对其他表空间使用默认的表空间选择算法。
In addition, the user can specify specific mappings for some tablespaces, and the default tablespace selection algorithm for the remaining.
在这样的数据库中,您可以接着创建称作自动存储表空间(它们仅仅可以作为DMSfile表空间使用)的东西。
Within such a database, you can then create what are known as automatic storage table Spaces (they are available as DMS FILE table Spaces only).
记住,可以对表空间使用自动调整选项以及详细的监控配置,如果某个表空间已满并需要调整大小,系统会及时通知您。
Keep in mind that auto-sizing options are available for database table Spaces as well as detailed monitoring configurations that notify you if specific table Spaces are full and need resizing.
来自表空间userspace1的对象被复制到表空间V9_USERSPACE1中,其他表空间使用默认的表空间选择算法。
Objects from tablespace USERSPACE1 are copied to tablespace V9_USERSPACE1, the remaining table Spaces use a default table space selection algorithm.
如果为索引表空间使用较大的缓冲池,并且尽可能地将不同 insert排序,以便键值是排好序的,而不是随机的,就可以帮助加快索引维护。
You can help speed up index maintenance by using a large buffer pool for the index tablespace, and, if possible, ordering the inserts so that the key values are ordered, not random.
TABLESPACE_MAP用户可以指定在复制期间使用的表空间名映射,而不使用来自源数据库的表空间。
TABLESPACE_MAP the user may specify tablespace name mappings to be used instead of the tablespaces from the source system during a copy.
如果你大量地使用MyISAM表,那么你也可以增加操作系统的缓存空间使得MySQL也能用得着。
If you're using MyISAM seriously you can also add the size of Operation System cache you would like MySQL to use for your table.
如果你大量地使用MyISAM表,那么你也可以增加操作系统的缓存空间使得MySQL也能用得着。
If you're using MyISAM seriously you can also add the size of Operation System cache you would like MySQL to use for your table.
应用推荐