Databases Reference
In-Depth Information
Session-Based SQL History
This feature collects, as session data, all the successful SQL queries we execute and
modifies the Query window to make them available. This default type of history is
temporary, because
$cfg['QueryHistoryDB']
is set to
FALSE
by default.
Database-Based SQL History (Permanent)
Because we installed the linked-tables infrastructure (see Chapter 11), a
more powerful history mechanism is available and is triggered by setting
$cfg['QueryHistoryDB']
to
TRUE
.
After we try some queries from one of the query boxes, a history is built; this history
is visible only from the query window:
We see (in the reverse order) the last successful queries, and the database on which
they were made. Only the queries typed from the query box are kept in this history,
not queries generated by phpMyAdmin itself (for example, by clicking on
Browse
).
They are clickable for immediate execution, and the
Edit
icon is available to insert a
recorded query into the query box for editing.
The number of queries that will be kept is controlled by
$cfg['QueryHistoryMax']
,
which is set to
25
by default. This limit is not kept for performance reasons but as
a practical limit, so as to achieve a visually unencumbered view. Extra queries are
eliminated at login time in a process traditionally called
garbage collection
. The
queries are stored in the table configured in
$cfg['Servers'][$i]['history']
.
Search WWH ::
Custom Search