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.

  1. 4 Ngwa iwu iwu bara uru iji nyochaa arụmọrụ MySQL na Linux
  2. 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.