MySQL

memUsage.sh
#!/bin/sh mysql -u root -p  -e "show variables; show status" | awk ' { VAR[$1]=$2 } END { MAX_CONN = VAR["max_connections"] M...
Tue, 23 Jun, 2020 at 1:42 PM
MySQL Enterprise Monitor - SSL Certificate Renewal
The following procedure is used to renew the certificates on the MySQL Enterprise Monitor # cd /opt/mysql/enterprise/monitor/apache-tomcat/conf/ # cp k...
Fri, 13 Nov, 2020 at 3:58 PM
Amazon RDS for MySQL 5.5 EOL Date is Approaching – Act Now!
As mentioned in the AWS discussion forum back in October, Amazon has started the end of life (EOL) process for RDS MySQL version 5.5. What this means is: ...
Mon, 21 Dec, 2020 at 4:40 PM
MySQL : how to purge binary logs when you have no space left on device
When you need to purge binary logs on a MySQL server, you just need to connect to your server and use the PURGE BINARY LOGS command like this : mysql>...
Mon, 3 Jan, 2022 at 4:10 AM