Differences

This shows you the differences between two versions of the page.

--- development:database:mysql [2024/10/24 08:04] – [1.5. Một số lệnh khác] tungnt
+++ development:database:mysql [2025/03/19 04:14] (current) – [Kiểm tra thư mục dữ liệu] tungnt
@@ Line 194: / Line 194: @@
 <code sql>
 SHOW VARIABLES LIKE 'datadir';
+</code>
+==== Kiểm tra dung lượng bảng đã đánh partition ====
+<code sql>
+SELECT TABLE_NAME, PARTITION_NAME, SUBPARTITION_NAME, ROUND(DATA_LENGTH / (1024 * 1024 * 1024), 2) AS Size_GB FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_NAME = 'user_transactions' AND PARTITION_NAME = 'year2025'
 </code>
 ====== 2. Tạo tài khoản và phân quyền MySQL ======
@@ Line 227: / Line 233: @@
 <file sql>
-mysql> CREATE USER 'blue001'@'localhost' IDENTIFIED BY 'TungNT123312##';
+mysql> CREATE USER 'blue001'@'localhost' IDENTIFIED BY '***';
 Query OK, 0 rows affected (0.10 sec)