Yadda ake Duba Girman Database MySQL a cikin Linux

A cikin wannan labarin, zan nuna muku yadda ake bincika girman bayanan MySQL/MariaDB da tebur ta hanyar harsashi na MySQL. Za ku koyi yadda ake tantance ainihin girman fayil ɗin bayanai akan faifai da kuma girman bayanan da yake gabatarwa a cikin ma'ajin bayanai.

Ta hanyar tsoho MySQL/MariaDB yana adana duk bayanan da ke cikin tsarin fayil, kuma girman bayanan da ke kan ma'aunin bayanai na iya bambanta da ainihin girman bayanan Mysql akan faifan da za mu gani daga baya.

Bugu da kari, MySQL yana amfani da bayanan_schema rumbun bayanai don adana bayanai game da bayanan bayananku da sauran saitunanku. Kuna iya tambayarsa don tattara bayanai game da girman ma'ajin bayanai da kuma teburin su kamar yadda aka nuna.

# 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; 

Don gano girman ma'ajin bayanai na MySQL guda daya da ake kira rcubemail (wanda ke nuna girman dukkan allunan dake cikinsa) yi amfani da tambayar mysql mai zuwa.

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;

A ƙarshe, don gano ainihin girman duk fayilolin MySQL akan faifai (filesystem), gudanar da umarnin du a ƙasa.

# du -h /var/lib/mysql

Hakanan kuna iya son karanta waɗannan labarai masu alaƙa da MySQL.

1. 4 Kayan Aikin Layi Mai Amfani don Kula da Ayyukan MySQL a cikin Linux
2. 12 MySQL/MariaDB Mafi kyawun Ayyuka na Tsaro don Linux

Don kowace tambaya ko ƙarin ra'ayoyin da kuke son raba game da wannan batu, yi amfani da fom ɗin amsa da ke ƙasa.