Otu esi elele nha nchekwa data MySQL na Linux
N'isiokwu a, m ga-egosi gị otu esi elele nha nke MySQL/MariaDB ọdụ data na tebụl site na MySQL shei. Ị ga-amụta otú e si achọpụta n'ezie nha faịlụ nchekwa data dị na diski yana nha data ọ dị na nchekwa data.
Site na ndabara MySQL/MariaDB na-echekwa data niile dị na sistemụ faịlụ, na nha data dị na ọdụ data nwere ike ịdị iche na nha data Mysql dị na diski anyị ga-ahụ ma emechaa.
Na mgbakwunye, MySQL na-eji information_schema mebere nchekwa data iji chekwaa ozi gbasara ọdụ data gị na ntọala ndị ọzọ. Ị nwere ike jụọ ya ka ị nweta ozi gbasara oke ọdụ data na tebụl ha dịka egosiri.
# mysql -u root -p MariaDB [(none)]> SELECT table_schema AS "Database Name", ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size in (MB)" FROM information_schema.TABLES GROUP BY table_schema;
Iji chọpụta nha nke otu MySQL nchekwa data akpọrọ rcubemail (nke na-egosipụta nha nke tebụl niile dị na ya) jiri ajụjụ mysql na-esonụ.
MariaDB [(none)]> SELECT table_name AS "Table Name", ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size in (MB)" FROM information_schema.TABLES WHERE table_schema = "rcubemail" ORDER BY (data_length + index_length) DESC;
N'ikpeazụ, iji chọpụta nha faịlụ nchekwa data MySQL niile dị na diski (filesystem), mee iwu du n'okpuru.
# du -h /var/lib/mysql
Ị nwekwara ike ịmasị ịgụ akụkọ MySQL metụtara ndị a.
- 4 Ngwa iwu iwu bara uru iji nyochaa arụmọrụ MySQL na Linux
- 12 MySQL/MariaDB Omume Kachasị Mma maka Linux
Maka ajụjụ ọ bụla ma ọ bụ echiche ndị ọzọ ịchọrọ ịkekọrịta gbasara isiokwu a, jiri ụdị nzaghachi dị n'okpuru.