Qhov wikiHow no qhia koj yuav txheeb xyuas qhov loj ntawm MySQL database li cas. Koj tuaj yeem tshawb xyuas qhov loj ntawm lub hauv paus siv MySQL Workbench, lossis los ntawm kev nug cov lus nug hauv MySQL.
Cov kauj ruam
Txoj Kev 1 ntawm 2: Siv MySQL Workbench
Kauj Ruam 1. Qhib MySQL Workbench
Nws muaj lub cim xiav uas nrog cov duab uas zoo li tus ntses taub ntswg ntev. Nyem lub cim qhib MySQL Workbench.
Kauj Ruam 2. Txuas rau MySQL server
Ob npaug nias rau MySQL server nyob rau hauv SQL Kev txhim kho tus qauv hauv qhov pib ua haujlwm. Tom qab ntawd nkag mus rau tus lej cim tus lej nkag mus txuas.
Yog tias SQL server tsis tau teev nyob rau ntawm qhov screen no, nyem Kev Sib Txuas Tshiab thiab nkag mus rau cov ntaub ntawv server, suav nrog hostname, chaw nres nkoj, username, thiab password.
Kauj Ruam 3. Hover hla tus database hauv kab ntawv schema
Nws nyob rau sab laug sab laug. Qhov no qhia ob peb lub cim rau sab xis ntawm lub npe database.
Kauj Ruam 4. Nyem rau lub cim qhia
Nws yog lub cim uas zoo ib yam li "i" nyob ib sab ntawm lub npe database hauv kab ntawv schema.
Kauj Ruam 5. Nyem rau Info tab
Nws yog thawj lub tab hauv lub pane tseem ceeb hauv nruab nrab. Qhov no qhia cov ntaub ntawv hais txog lub database. Qhov loj me ntawm cov ntaub ntawv teev tseg nyob ib sab ntawm Database loj (kwv yees kwv yees).
Txoj Kev 2 ntawm 2: Khiav Cov Lus Nug
Kauj Ruam 1. Txuas mus rau MySQL server
Muaj ntau cov apps koj tuaj yeem siv txuas rau MySQL database, suav nrog MySQL Workbench. Koj tseem tuaj yeem nug MySQL database hauv kab hais kom ua hauv Windows, lossis davhlau ya nyob twg ntawm Mac. Thaum MySQL tau teeb tsa hauv koj lub khoos phis tawj koj yuav tsum mus rau MySQL cov npe hauv Windows kab hais kom ua thiab ntaus mysql -u hauv paus -p. Tom qab ntawd nkag tus password rau koj lub database.
Kauj Ruam 2. Ntaus SELECT table_schema "DB Name", ua kab ntawv thawj ntawm koj cov lus nug
Nov yog xaiv cov lus txib los nug cov lus nug ntawm lub database.
Kauj Ruam 3. Ntaus SUM (cov ntaub ntawv ntev + cov lus ntev) 'Loj hauv bytes', raws li kab thib ob
Cov lus txib no yuav tso saib qhov loj ntawm txhua lub rooj hauv bytes.
Kauj Ruam 4. Ntaus ROUND (SUM (data_length + index_length) / 1024 /1024, 2) 'Loj hauv MiB' raws li kab ntawv tom ntej
Qhov no qhia txog tus lej sib npaug ntawm qhov loj hauv megabytes.
Txhawm rau tso saib tus lej sib npaug hauv kilobytes, ntaus ROUND (SUM (data_length + index_length) / 1024, 2) 'Size in KiB' xwb
Kauj Ruam 5. Ntaus FROM information_schema.tables ua kab kawg
Cov lus txib no qhia meej cov ntaub ntawv database twg los nug.
Kauj Ruam 6. Ntaus GROUP BY table_schema; thiab ua cov lus nug
Qhov no yuav tso saib qhov loj ntawm koj cov databases. Koj kuj tseem tuaj yeem ntaus {[kbd | WHERE table_schema = 'database name';}} txhawm rau txheeb xyuas qhov loj ntawm cov ntaub ntawv tshwj xeeb. Ntaus lub npe tiag tiag ntawm cov ntaub ntawv khaws cia hauv qhov chaw ntawm "lub npe database". Koj qhov lus nug yuav tsum zoo li qhov no:
SELECT table_schema "DB Name" SUM (data length + table length) 'Size in bytes', ROUND (SUM (data_length + index_length) / 1024 /1024, 2) 'Size in MiB' FROM information_schema.tables GROUP BY table_schema;