Aurora DB Cluster and backtrack feature

Aurora DB Cluster and backtrack

https://aws.amazon.com/blogs/aws/amazon-aurora-backtrack-turn-back-time/

You can backtrack a DB cluster to a specific time, without restoring data from a backup.

Overview of Backtracking Backtracking "rewinds" the DB cluster to the time you specify. Backtracking is not a replacement for backing up your DB cluster so that you can restore it to a point in time.

mysql Server-Side Help

if you provide an argument to the help command, mysql uses it as a search string to access server-side help from the contents of the MySQL Reference Manual.

https://mysqlserverteam.com/getting-help-in-mysql-shell/ https://dev.mysql.com/doc/refman/5.7/en/mysql-server-side-help.html

TSDB Time series database

A Time Series Database (TSDB) is a database optimized for time-stamped or time series data. Time series are simply measurements or events that are tracked, monitored, downsampled, and aggregated over time.

A Time Series Database is built specifically for handling metrics and events or measurements that are time-stamped.

https://www.influxdata.com/time-series-database/

Selects on Aurora Mysql cluster in Waiting for table level lock

Running a load tests, I found some select statements in an weird "Waiting for table level lock" state. I did an investigation and wrote a conclusion on it.

Issue

Waiting for table level lock | SELECT pad FROM sbtest4 WHERE id=50405|

| 3073 | sb_user    | 10.112.17.167:36999 | sbtest               | Query   |    0 | Waiting for table level lock | SELECT pad FROM sbtest4 WHERE id=50405|
| 3074 | sb_user    | 10.112.17.167:36993 | sbtest               | Query   |    0 | Waiting for table level lock | SELECT pad FROM sbtest4 WHERE id=50376|
| 3075 | sb_user    | 10.112.17.167:37000 | sbtest               | Sleep   |    0 | cleaned up                   | NULL