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

Profiling


We have previously seen the Profiling checkbox appear in query results:

When this box is checked, phpMyAdmin goes in a mode where every query (including the current one) is being analyzed and a report about each MySQL internal operation's execution time is displayed.

Although the profiling system can report additional information about operations (like the CPU time and even the internal server's function names involved), phpMyAdmin currently displays only the name of the operation and its duration.

At time of press, MySQL version 5.1.22 does not have this feature, although it is present since 5.0.37. However, for administrators who are confident about compiling their own MySQL server, Jeremy Cole, this feature's author, maintains patches applicable to a 5.1 server on http://jcole.us/patches/mysql/5.1.