debugged_routines

NAME

debugged_routines: List routines with rdebug's debugging info

TYPE

View

DESCRIPTION

debugged_routines lists those routines that have been compiled with debug info via rdebug's API.

It also provides with the SQL statement to remove the debug info from the routines.

STRUCTURE

mysql> DESC debugged_routines;
+---------------------+--------------+------+-----+---------+-------+
| Field               | Type         | Null | Key | Default | Extra |
+---------------------+--------------+------+-----+---------+-------+
| ROUTINE_SCHEMA      | varchar(64)  | NO   |     |         |       |
| ROUTINE_NAME        | varchar(64)  | NO   |     |         |       |
| ROUTINE_TYPE        | varchar(9)   | NO   |     |         |       |
| sql_undebug_routine | varchar(332) | YES  |     | NULL    |       |
+---------------------+--------------+------+-----+---------+-------+

SYNOPSIS

  • ROUTINE_SCHEMA: schema of routine
  • ROUTINE_NAME: name of routine with debug info
  • ROUTINE_TYPE: type of routine with debug info ('PROCEDURE' or 'FUNCTION')
  • sql_undebug_routine: SQL statement to invoke for removing debug info from routine.

EXAMPLES

mysql> call rdebug_compile_routine('test', 'analyze_continents', true);

mysql> call rdebug_compile_routine('test', 'analyze_continent_cities', true);

mysql> SELECT * FROM debugged_routines;
+----------------+--------------------------+--------------+----------------------------------------------------------------------------------------+
| ROUTINE_SCHEMA | ROUTINE_NAME             | ROUTINE_TYPE | sql_undebug_routine                                                                    |
+----------------+--------------------------+--------------+----------------------------------------------------------------------------------------+
| test           | analyze_continents       | PROCEDURE    | call `common_schema`.rdebug_compile_routine('test', 'analyze_continents', false)       |
| test           | analyze_continent_cities | PROCEDURE    | call `common_schema`.rdebug_compile_routine('test', 'analyze_continent_cities', false) |
+----------------+--------------------------+--------------+----------------------------------------------------------------------------------------+

ENVIRONMENT

MySQL 5.1 or newer

SEE ALSO

rdebug_compile_routine(), rdebug_show_routine()

AUTHOR

Shlomi Noach
 
common_schema documentation