Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Overview of this book

Table of Contents (25 chapters)
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Credits
About the Author
About the Reviewers
Preface

Server Operations


The Status, Variables, and Processes links are available to get information about the MySQL server or to act upon specific processes.

Server Status Verification

These statistics reflect the MySQL server's total activity, including (but not limited to) the activity generated by queries sent from phpMyAdmin.

The General Status Page

Clicking the Status link produces runtime information about the server. The page has several sections. 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.

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...