4.6.6 Redacted PAR URLs in Exported Log Files

The pre-authenticated request (PAR) URL is hidden in the log file for security reasons.

The following example exports the query results as a CSV file to the object storge location represented as a PAR URL. It also displays the latest query results from the query text from the performance_schema.rpd_query_stats table and retrieves all the MySQL statments currently being executed in all MySQL active connections on the network.

The output displays with the redacted PAR URL.

mysql> SELECT * INTO OUTFILE URL 
"https://mybucket.objectstorage.myregion.oci.customer-oci.com/p/CAN_BE_DISPLAYED_PAR_ID/n/myNamespace/b/MyParBucket/o/"
FORMAT CSV
FROM  LINEITEM;

# Performance schema logs
mysql> SELECT QUERY_TEXT FROM performance_schema.rpd_query_stats ORDER BY QUERY_ID DESC LIMIT 1;
+----------------------------------------------------------------------------------------------------------+
| QUERY_TEXT                                                                                               |
+----------------------------------------------------------------------------------------------------------+
| SELECT * INTO OUTFILE URL                                                                                |
| "https://mybucket.objectstorage.myregion.oci.customer-oci.com/p/<redacted>/n/       |
|  myNamespace/b/MyParBucket/o/"                                                                           |
| FORMAT CSV                                                                                               |
| FROM  LINEITEM ;                                                                                          |
+----------------------------------------------------------------------------------------------------------+

# In the process list
mysql> SELECT info FROM INFORMATION_SCHEMA.PROCESSLIST;
+----------------------------------------------------------------------------------------------------------+
| info                                                                                                     |
+----------------------------------------------------------------------------------------------------------+
| NULL                                                                                                     |  
| SELECT * INTO OUTFILE URL                                                                                |
| "https://mybucket.objectstorage.myregion.oci.customer-oci.com/p/<redacted>/n/       |
|  myNamespace/b/MyParBucket/o/"                                                                           |
| FORMAT CSV                                                                                               |
| FROM  LINEITEM;                                                                                           |
| SELECT info FROM INFORMATION_SCHEMA.PROCESSLIST                                                          |
+----------------------------------------------------------------------------------------------------------+