h1. Potential Standard Probes for All Databases
The following table lists probes that may be standardized and the status of their implementation among the various OSDBs.
|| No || Name || Arguments || Description || PostgreSQL || MySQL || MaxDB || Ingres || Firebird ||
| 1 | {{transaction-start}} | (unsigned int) | Probe that fires at the start of a new transaction. arg0 is the transaction id. | (/) (8.2+) | | | | |
| 2 | {{transaction-commit}} | (unsigned int) | Probe that fires when a transaction completes successfully. arg0 is the transaction id.| (/) (8.2+) | | | | |
| 3 | {{transaction-abort}} | (unsigned int) | Probes that fires when a transaction does not complete successfully. arg0 is the transaction id. | (/) (8.2+) | | | | |
| 4 | {{query-parse-start}} | (const char *) | Probe that fires when the parsing of a query is started. arg0 is the query string. | (/) (8.4+)| | | | |
| 5 | {{query-parse-done}} | (const char *) | Probe that fires when the parsing of a query is complete. arg0 is the query string. | (/) (8.4+) | | | | |
| 6 | {{query-rewrite-start}} | (const char *) | Probe that fires when the rewriting of a query is started. arg0 is the query string. | (/) (8.4+)| | | | |
| 7 | {{query-rewrite-done}} | (const char *) | Probe that fires when the rewriting of a query is complete. arg0 is the query string. | (/) (8.4+) | | | | |
| 8 | {{query-plan-start}} | () | Probe that fires when the planning of a query is started. | (/) (8.4+) | | | | |
| 9 | {{query-plan-done}} | () | Probe that fires when the planning of a query is complete. | (/) (8.4+) | | | | |
| 10 | {{query-execute-start}} | () | Probe that fires when the execution of a query is started. | (/) (8.4+) | | | | |
| 11 | {{query-execute-done}} | () | Probe that fires when the execution of a query is complete. | (/) (8.4+) | | | | |
| 12 | {{query-start}} | (const char *) | Probe that fires when the execution of a statement is started. arg0 is the query string.| (/) (8.4+) | | | | |
| 13 | {{query-done}} | (const char *) | Probe that fires when the execution of a statement is complete. arg0 is the query string.| (/) (8.4+) | | | | |
| 14 | {{statement-status}} | (const char *) | Probe that fires anytime an SQL statement is executed on the server. arg0 is the query string. | (/) (8.4+) | | | | |
h1. [PostgreSQL Specific Probes|DBonSolaris:PostgresDTraceProbes]
h1. [MySQL Server Specific Probes|DBonSolaris:MySQLDTraceProbes]
The following table lists probes that may be standardized and the status of their implementation among the various OSDBs.
|| No || Name || Arguments || Description || PostgreSQL || MySQL || MaxDB || Ingres || Firebird ||
| 1 | {{transaction-start}} | (unsigned int) | Probe that fires at the start of a new transaction. arg0 is the transaction id. | (/) (8.2+) | | | | |
| 2 | {{transaction-commit}} | (unsigned int) | Probe that fires when a transaction completes successfully. arg0 is the transaction id.| (/) (8.2+) | | | | |
| 3 | {{transaction-abort}} | (unsigned int) | Probes that fires when a transaction does not complete successfully. arg0 is the transaction id. | (/) (8.2+) | | | | |
| 4 | {{query-parse-start}} | (const char *) | Probe that fires when the parsing of a query is started. arg0 is the query string. | (/) (8.4+)| | | | |
| 5 | {{query-parse-done}} | (const char *) | Probe that fires when the parsing of a query is complete. arg0 is the query string. | (/) (8.4+) | | | | |
| 6 | {{query-rewrite-start}} | (const char *) | Probe that fires when the rewriting of a query is started. arg0 is the query string. | (/) (8.4+)| | | | |
| 7 | {{query-rewrite-done}} | (const char *) | Probe that fires when the rewriting of a query is complete. arg0 is the query string. | (/) (8.4+) | | | | |
| 8 | {{query-plan-start}} | () | Probe that fires when the planning of a query is started. | (/) (8.4+) | | | | |
| 9 | {{query-plan-done}} | () | Probe that fires when the planning of a query is complete. | (/) (8.4+) | | | | |
| 10 | {{query-execute-start}} | () | Probe that fires when the execution of a query is started. | (/) (8.4+) | | | | |
| 11 | {{query-execute-done}} | () | Probe that fires when the execution of a query is complete. | (/) (8.4+) | | | | |
| 12 | {{query-start}} | (const char *) | Probe that fires when the execution of a statement is started. arg0 is the query string.| (/) (8.4+) | | | | |
| 13 | {{query-done}} | (const char *) | Probe that fires when the execution of a statement is complete. arg0 is the query string.| (/) (8.4+) | | | | |
| 14 | {{statement-status}} | (const char *) | Probe that fires anytime an SQL statement is executed on the server. arg0 is the query string. | (/) (8.4+) | | | | |
h1. [PostgreSQL Specific Probes|DBonSolaris:PostgresDTraceProbes]
h1. [MySQL Server Specific Probes|DBonSolaris:MySQLDTraceProbes]