Quotidien Shaarli

Tous les liens d'un jour sur une page.

December 12, 2022

SQL Diagnostic Manager for MySQL and MariaDB | IDERA

Monitor database performance agentless and cost-effectively

Monitor in real-time for corrective action and issues resolution
Track and compare all changes to MySQL or MariaDB configuration files
Monitor, alert, and kill locked or long-running SQL queries in real-time
Monitor Amazon RDS, MariaDB, or Amazon Aurora including OS and log files
Find top 10 queries across MySQL/MariaDB servers based on execution time
Monitor Amazon RDS, Azure Database, Google Cloud SQL, and Oracle Cloud Service

How To Use Bash Parameter Substitution Like A Pro - nixCraft
Expression What it does
${parameter:-defaultValue} Get default shell variables value
${parameter:=defaultValue} Set default shell variables value
${parameter:?"Error Message"} Display an error message if parameter is not set
${#var} Find the length of the string
${var%pattern} Remove from shortest rear (end) pattern
${var%%pattern} Remove from longest rear (end) pattern
${var:num1:num2} Substring
${var#pattern} Remove from shortest front pattern
${var##pattern} Remove from longest front pattern
${var/pattern/string} Find and replace (only replace first occurrence)
${var//pattern/string} Find and replace all occurrences
${!prefix*} Expands to the names of variables whose names begin with prefix.
${var,}<br>${var,pattern} Convert first character to lowercase.
${var,,}<br>${var,,pattern} Convert all characters to lowercase.
${var^}<br>${var^pattern} Convert first character to uppercase.
${var^^}<br>${var^^pattern} Convert all character to uppercase.