mysql> set profiling=1;
Query OK, 0 rows affected (0.00 sec)

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2011-01-04 12:12:06 |
+---------------------+
1 row in set (0.00 sec)

mysql> show profile source for query 1;
+----------------------+----------+-----------------------+----------------------+-------------+
| Status               | Duration | Source_function       | Source_file          | Source_line |
+----------------------+----------+-----------------------+----------------------+-------------+
| starting             | 0.000028 | NULL                  | NULL                 |        NULL |
| checking permissions | 0.000005 | check_access          | /export/home/pb2/bui |        4613 |
| Opening tables       | 0.000006 | open_tables           | /export/home/pb2/bui |        4732 |
| init                 | 0.000027 | mysql_select          | /export/home/pb2/bui |        2545 |
| optimizing           | 0.000009 | optimize              | /export/home/pb2/bui |         858 |
| executing            | 0.000013 | exec                  | /export/home/pb2/bui |        1818 |
| end                  | 0.000006 | mysql_select          | /export/home/pb2/bui |        2581 |
| query end            | 0.000003 | mysql_execute_command | /export/home/pb2/bui |        4310 |
| closing tables       | 0.000003 | mysql_execute_command | /export/home/pb2/bui |        4362 |
| freeing items        | 0.000020 | mysql_parse           | /export/home/pb2/bui |        5509 |
| logging slow query   | 0.000003 | log_slow_statement    | /export/home/pb2/bui |        1444 |
| cleaning up          | 0.000003 | dispatch_command      | /export/home/pb2/bui |        1400 |
+----------------------+----------+-----------------------+----------------------+-------------+
12 rows in set (0.00 sec)

mysql>
mysql>
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.5.8     |
+-----------+
1 row in set (0.00 sec)

mysql>



------------------------------------------------------------------
------------------------------------------------------------------

mysql> set profiling=1;
Query OK, 0 rows affected (0.03 sec)

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2011-01-04 12:17:36 |
+---------------------+
1 row in set (0.00 sec)

mysql> show profile source for query 1;
+----------------------+----------+------------------+---------------+-------------+
| Status               | Duration | Source_function  | Source_file   | Source_line |
+----------------------+----------+------------------+---------------+-------------+
| starting             | 0.000048 | NULL             | NULL          |        NULL |
| checking permissions | 0.000005 | unknown function | sql_parse.cc  |        5291 |
| Opening tables       | 0.000008 | unknown function | sql_base.cc   |        4515 |
| init                 | 0.000035 | unknown function | sql_select.cc |        2519 |
| optimizing           | 0.000007 | unknown function | sql_select.cc |         828 |
| executing            | 0.000014 | unknown function | sql_select.cc |        1775 |
| end                  | 0.000003 | unknown function | sql_select.cc |        2565 |
| query end            | 0.000003 | unknown function | sql_parse.cc  |        5055 |
| freeing items        | 0.000021 | unknown function | sql_parse.cc  |        6086 |
| logging slow query   | 0.000003 | unknown function | sql_parse.cc  |        1709 |
| cleaning up          | 0.000003 | unknown function | sql_parse.cc  |        1677 |
+----------------------+----------+------------------+---------------+-------------+
11 rows in set (0.02 sec)

mysql> select version();
+--------------------------------+
| version()                      |
+--------------------------------+
| 5.1.54-enterprise-gpl-advanced |
+--------------------------------+
1 row in set (0.00 sec)

mysql>