Databases Reference
In-Depth Information
Profiling queries
Profiling support has been added in the MySQL versions 5.0.37 and 5.1.28. We have
previously seen the Proiling checkbox appear in query results.
When this box is checked, phpMyAdmin will analyze every query (including
the current one), and a report about the execution time of each MySQL internal
operation is displayed as shown in the following screenshot:
Although the profiling system can report additional information about operations
(such as the CPU time, and even the internal server's function names), phpMyAdmin
currently displays only the name of the operation and its duration.
Creating an additional table
In our (simple) design, we know that we need another table—the author table. The
author table will contain:
• Author identiication
• Full name
• Phone number
 
Search WWH ::




Custom Search