为新的会话表创建数据库迁移。
清单4：创建会话表的sql。
清单4给出了创建会话表的SQL代码。
Listing 4 shows the SQL code that created the sessions table.
我们测试过这种方法，在大会话表中显示了10- 15%的性能提升。
We've benchmarked this approach and it shows 10-15% performance gain on large sessions tables.
在应用程序会话定义已创建的临时表之后，并发运行的会话不需要重新定义它。
After an application session defines a created temporary table, concurrently running sessions do not have to redefine it.
您还可以根据系统需求在不同的级别灵活配置，包括实例、会话和表。
You also have the flexibility to configure Settings at all levels, including instance, session and table, based on the needs of your system.
从本质上说，CGTT将表设置流程移到了会话外部。
CGTT essentially moves the table setup process outside the session.
表定义的持久化特性仅针对该会话。
当表非常大或者大量会话发出这种类型的查询时，性能将会有所下降。
Performance is negatively impacted when the table is large or when many sessions issue this type of query.
创建cgtt表cgttbase1之后，它将持久化到后续所有的会话中。
Once CGTT table cgttbase1 is created, it is persistent to all sessions that follow.
您需要将ActionURL存储到会话的例子是Ajax驱动的分页数据表，它包含ActionURL链接作为数据集的一部分。
An example of when you would want to store Action URLs into the session is an Ajax-driven paging data table that contains Action URL links as part of the data set.
如果这些字符串相匹配，通过logger函数把这个事件记录在另一个mysql表中作为日志，并且生成一个新的会话id。
If these strings match, this event is logged to another MySQL table via the logger function and a new session ID is generated.
IDENTITY返回当前会话的，所有作用域中的任何表最后一个生成的IDENTITY值。
Identity returns the last identity value generated for any table in the current session, across all scopes.
这种行为的一个影响是，即使当前用户没有创建它们的权限，会话也可以操纵它的临时表。
One implication of this behavior is that a session can manipulate its temporary tables even if the current user has no privilege to create them.
表2标出了4个类，分别对应于4种会话作用域。
Table 2 identifies the four class types that correspond to the four session scopes.
表1总结了三类Web服务api定义，包括会话、变更历史和查找操作。
Table 1 summarizes the three types of Web service API definitions, including session, change history and find operations.
在执行创建表空间的操作时，从另一会话执行下列脚本。
While the create table space operations are running, execute the following script from another session.
在执行删除表空间的操作时，从另一会话执行下列脚本。
While the drop table space operations are running, execute the following script from another session.
为更新subscribedfeeds表，我们需要知道登录用户的username，所以我们要从会话中获取该信息。
To update the subscribedfeeds table, you need to know the username for the logged-in user, so you grab that from the session.
它还可用于长时间的会话锁，但需要进行清理以避免表过度增长。
It can also be used for longer-lived session locks, but cleanup needs to be addressed to prevent table growth.
对于这个报告，你需要显示每个用户当前的内存使用情况图，然后在一个表中按照每个会话将内存使用划分。
For this report, you want to display a graph of total memory usage per user and then, in a table, break that memory usage down on a per-session basis.
在删除表或结束会话时，将删除索引。
When the table is dropped or the session ends, the indexes are dropped.
您可以使用PASSTHRU会话直接将CREATEtable语句发送到数据源，并为这个新表创建一个昵称。
You can use the PASSTHRU session to directly send the create table statement to the data source and create a nickname for this new table.
表变量、会话与临时表。
糟糕的数据库性能，因为数据库对数据库表中的该(超)大会话对象执行了数百次更新。
Poor database performance, as the database performed hundreds of updates to the (very) large session objects in database tables.
OpenTables：此会话中打开的表数。
Open tables: Displays the number of the tables opened in that session.
dgttbase1 表对于第二个会话不可见。
Table SESSION.dgttbase1 is not visible to the second session.
图14中的值指定两个进程使用两个会话将数据加载到数据库表中。
The values shown in Figure 14 specify that two processes use two sessions to load data into the database table.
这两种情况下，若在相同会话中企图重新声明临时表将导致如下错误。
In both cases, attempts to re-declare a temporary table within the same session will result in the following error.
这两种情况下，若在相同会话中企图重新声明临时表将导致如下错误。
In both cases, attempts to re-declare a temporary table within the same session will result in the following error.
应用推荐