In my current humble opinion Aurora is a double edged sword.
Aurora looks promising for scalablity, but a lot of stuff is modified
mysql-stuff and in my opinion has a lot of restrictions.
You should be aware, that moving to Aurora might be a tasks
and reverting back even more.
- Refer to: https://ahmedahamid.com/aurora-mysql/
I would like to point you to a performance measurement report here:
ps aux | grep unatt
kill <process-id-von-unattended-upgrades>
https://www.percona.com/doc/percona-toolkit/LATEST/pt-archiver.html
# Some background while doing research.
# Nil performance benefits of defragmentation in index.
https://stackoverflow.com/questions/48569979/mariadb-table-defragmentation-using-optimize
# Optimize table
ALTER TABLE contributions engine = InnoDB
# mariadb has a patch for defragmentation
https://mariadb.org/defragmenting-unused-space-on-innodb-tablespace/
# alter table xyz engine=InnoDB - defragements
# but is also invasive.
# with ibdata1 innodb_file_per_table it lets the size grow
No, this is not possible
No, there is no testing framework with MySQL
- flashback
- Verschlüsselung von Tabellen // mariabackup
- Einige Storage Engine (Aria -> MyISAM - crash-recovery)
- JSON anders implementiert
- galera
- feature: defragementation
MysqL 8 does not:
decode
set profiling (still available but deprecated )
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;
BEGIN ;
SELECT * FROM TABLE_NAME ;
COMMIT ;