Chapter 19
[ 295 ]
This example has only one running process, the process created by the SHOW
PROCESSLIST command itself. This process is not killable because it is no longer
running when we get to see the page. We would normally see more processes
running on a server.
Storage Engines
Information about the various storage engines is available on a two-level format. First,
the Engines tab displays an overview of the possible engines for the current MySQL
version. The names of the engines that are enabled on this server are clickable:
A click on one engine name brings a detailed panel about its settings. Moving the
mouse over the light bulbs reveals even more information about a particular setting.
MySQL Server Administration
[ 296 ]
The Binary Log
If MySQL's binary log is active on our server, the menu in the Server view changes
so that a Binary log tab appears. This tab gives access to an interface to the SHOW
BINLOG EVENTS command. This command produces the list of SQL statements
that have updated data on our servers. This list could be huge and currently
phpMyAdmin does not limit its display, so we should take care.
In the following screen, we choose which binary log we want to examine (unless the
server has only one binary log), and the statements are then displayed:
Summary
In this chapter, we have seen various features available to system administrators,
such as user account management, privileges management, database privileges
checks, and server status verification.
Pages:
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267