First we get information about the elapsed running time and the
startup time, and then we get the total and average values for traffic and connections
(where ?? means average):
Next, the statistics about queries are displayed (shown partially here). The average
number of queries per hour, minute, and second give a good indication of the
server load.
Chapter 19
[ 293 ]
This is followed by statistics about each MySQL command, the absolute number of
times, hour average, and the number of times as a percentage of the total.
Depending on the MySQL version, many other sections containing server
information are displayed.
InnoDB Status
On servers supporting InnoDB, a link appears at the end of the InnoDB section.
When this link is clicked, information about the InnoDB subsystem is displayed,
including information about the last InnoDB error that occurred:
MySQL Server Administration
[ 294 ]
Server Variables
The Variables sub-page displays various settings of the MySQL server, which can be
defined in, say, the my.cnf MySQL configuration file. These values can't be changed
from within phpMyAdmin:
Server Processes
The Processes sub-page is available to superusers and normal users. A normal user
would see only the processes belonging to him or her, whereas a superuser sees all
the processes.
This page lists all active processes on the server, and a Kill link that allows us to
terminate a specific process.
Pages:
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266