Tag

Version Differences

0 views collected around this technical thread.

Aikesheng Open Source Community

Nov 22, 2023 · Databases

MySQL DELETE Statement Alias Support Differences Between 5.7 and 8.0

This article explains why a DELETE statement with a table alias fails in MySQL 5.7, shows the correct syntax without alias, compares the DELETE syntax of MySQL 5.7 and 8.0, and concludes that alias support in single‑table DELETE was added starting with version 8.0.16.

DELETEDatabaseSQL

0 likes · 5 min read

MySQL DELETE Statement Alias Support Differences Between 5.7 and 8.0

Aikesheng Open Source Community

Mar 19, 2020 · Databases

Analyzing High CPU Usage of lock_number_of_rows_locked in MySQL 5.6 Large Transactions

The article examines why a 100 GB MySQL 5.6 transaction causes high CPU usage during lock_number_of_rows_locked calculation, compares the lock‑counting implementations of MySQL 5.6 and 5.7, and offers diagnostic steps and version‑upgrade recommendations to mitigate the bottleneck.

CPU BottleneckInnoDBPerformance

0 likes · 9 min read

Analyzing High CPU Usage of lock_number_of_rows_locked in MySQL 5.6 Large Transactions