{"id":24712,"date":"2026-11-06T03:28:07","date_gmt":"2026-11-06T03:28:07","guid":{"rendered":"https:\/\/www.hostinger.com\/support\/?p=24712"},"modified":"2026-11-06T10:02:01","modified_gmt":"2026-11-06T10:02:01","slug":"why-the-database-size-in-the-hostinger-dashboard-is-higher-than-in-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/support\/why-the-database-size-in-the-hostinger-dashboard-is-higher-than-in-phpmyadmin\/","title":{"rendered":"Why the database size in the Hostinger dashboard is higher than in phpMyAdmin"},"content":{"rendered":"<p>The Hostinger database size in the dashboard is higher than in phpMyAdmin because the Hostinger dashboard measures the disk space your database folder uses on the server. phpMyAdmin shows only the data and index size that MySQL reports for your tables. The difference comes from free space left inside tables after deletions, hidden FULLTEXT index files, and the information MySQL stores to manage each table file. Reduce it by repairing the database, optimizing tables, or removing unused FULLTEXT indexes.<\/p><h2 id=\"h-how-the-hostinger-dashboard-and-phpmyadmin-measure-database-size\">How the Hostinger dashboard and phpMyAdmin measure database size<\/h2><p>The Hostinger dashboard and phpMyAdmin measure two different things, so their database sizes don&rsquo;t match. There are two measurements:<\/p><ul>\n<li><b>Hostinger dashboard:<\/b> the actual disk space the database folder takes up on the hosting server.<\/li>\n<li><b>phpMyAdmin:<\/b> the data and index size that MySQL reports for each table, which leaves out free space inside the table files and hidden index files.<\/li>\n<\/ul><p>A higher size in the Hostinger dashboard doesn&rsquo;t mean your database is out of sync or damaged. A small difference exists even when a database has no free space and no FULLTEXT indexes, because every table file also holds information MySQL uses to manage it. Your database size limit is listed in <a data-click-id=\"hgr-post-content-link-parameters-and-limits-of-hosting-plans-in-hostinger\" href=\"https:\/\/www.hostinger.com\/support\/6976044-parameters-and-limits-of-hosting-plans-in-hostinger\/\">Parameters and limits of hosting plans in Hostinger<\/a>.<\/p><h2 id=\"h-why-the-hostinger-dashboard-shows-a-higher-database-size\">Why the Hostinger dashboard shows a higher database size<\/h2><p>There are three common reasons the Hostinger dashboard database size is higher than phpMyAdmin&rsquo;s:<\/p><ol>\n<li><b>Free space inside tables:<\/b> MySQL doesn&rsquo;t shrink a table file when you delete or update rows. The InnoDB storage engine keeps the freed space inside the file for future data, so the file stays the same size on disk. For example, in one case a WordPress Action Scheduler table (<code>wp_actionscheduler_actions<\/code>) of 2,008 MB held 1,977 MB of free space after old completed actions were deleted.<\/li>\n<li><b>FULLTEXT index files:<\/b> a FULLTEXT index lets MySQL search words inside text columns. MySQL stores FULLTEXT indexes in separate hidden files that phpMyAdmin doesn&rsquo;t count. Search and related-posts plugins often create FULLTEXT indexes, and these files can grow to several gigabytes.<\/li>\n<li><b>Table file structure:<\/b> MySQL stores information it needs to manage each table file, such as which parts of the file are in use, and builds files in fixed-size blocks. This is standard for every MySQL table, so each table file is slightly larger on disk than the data and indexes inside it. For example, a WordPress database with 67 tables, no free space and no FULLTEXT indexes showed 14 MB in the Hostinger dashboard and 9.2 MiB in phpMyAdmin.<\/li>\n<\/ol><h2 id=\"h-how-to-check-where-the-extra-database-space-comes-from\">How to check where the extra database space comes from<\/h2><p>Run two queries in phpMyAdmin to find free space and FULLTEXT indexes in your database. <a data-click-id=\"hgr-post-content-link-access-phpmyadmin\" href=\"https:\/\/www.hostinger.com\/support\/1583545-how-to-access-phpmyadmin-at-hostinger\/\">Access phpMyAdmin<\/a>, select your database, and open the <b>SQL<\/b> tab. Paste each query, replace <code>u123456789_database<\/code> with your database name, and click <b>Go<\/b>.<\/p><ol>\n<li>Check the free space inside each table:\n<pre><code>SELECT TABLE_NAME, ROUND(DATA_FREE \/ 1024 \/ 1024, 2) AS free_mb\r\nFROM information_schema.TABLES\r\nWHERE TABLE_SCHEMA = 'u123456789_database'\r\nORDER BY DATA_FREE DESC;<\/code><\/pre>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-24714\" src=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-25.png\" alt=\"phpMyAdmin SQL tab showing the free space query results with the free_mb value for each table\" width=\"1646\" height=\"670\" srcset=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-25.png 1646w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-25-300x122.png 300w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-25-1024x417.png 1024w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-25-768x313.png 768w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-25-1536x625.png 1536w\" sizes=\"(max-width: 1646px) 100vw, 1646px\" \/><\/p><\/li>\n<li>List the FULLTEXT indexes in your database:\n<pre><code>SELECT DISTINCT TABLE_NAME, INDEX_NAME\r\nFROM information_schema.STATISTICS\r\nWHERE TABLE_SCHEMA = 'u123456789_database' AND INDEX_TYPE = 'FULLTEXT';<\/code><\/pre>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-24713\" src=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-24.png\" alt=\"phpMyAdmin SQL tab showing the FULLTEXT index query results with the table name and index name\" width=\"1642\" height=\"669\" srcset=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-24.png 1642w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-24-300x122.png 300w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-24-1024x417.png 1024w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-24-768x313.png 768w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-24-1536x626.png 1536w\" sizes=\"(max-width: 1642px) 100vw, 1642px\" \/><\/p><\/li>\n<\/ol><p>Tables with a high <code>free_mb<\/code> value hold reclaimable free space. The second query lists the tables that have FULLTEXT indexes. If the first query shows no free space and the second query returns no rows, the remaining difference comes from the table file structure, which is standard for every MySQL database and doesn&rsquo;t need fixing.<\/p><h2 id=\"h-how-to-reduce-the-database-size-in-the-hostinger-dashboard\">How to reduce the database size in the Hostinger dashboard<\/h2><p>Reclaim free space by repairing the database or optimizing its tables, and remove FULLTEXT index space by dropping unused FULLTEXT indexes. Deleting rows alone doesn&rsquo;t lower the Hostinger dashboard size until you repair the database or optimize its tables. <a data-click-id=\"hgr-post-content-link-export-a-backup-of-your-database\" href=\"https:\/\/www.hostinger.com\/support\/4529011-how-to-export-a-database-with-phpmyadmin-in-hostinger\/\">Export a backup of your database<\/a> before you start.<\/p><div class=\"intercom-interblocks-callout\" style=\"background-color: #feedaf80;border-color: #fbc91633\">\n<p>Repairing or optimizing tables isn&rsquo;t guaranteed to shrink FULLTEXT index files. Dropping the FULLTEXT index is the sure way to free that space.<\/p>\n<\/div><h3>Option 1 &ndash; Repair the database in the Hostinger dashboard<\/h3><p>Repairing the database reclaims free space left inside tables after deletions. In the <b>List of Current MySQL Databases And Users<\/b> section, click &#8942; next to the database and select <b>Repair<\/b>. The message <b>Database repaired successfully<\/b> appears when the repair finishes.<\/p><h3>Option 2 &ndash; Optimize tables in phpMyAdmin<\/h3><p>Run <code>OPTIMIZE TABLE<\/code> in the phpMyAdmin <b>SQL<\/b> tab to rebuild a table and release its free space. Replace <code>wp_options<\/code> with the table name from the free space query:<\/p><pre><code>OPTIMIZE TABLE wp_options;<\/code><\/pre><p><img decoding=\"async\" class=\"alignnone size-full wp-image-24715\" src=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-25_1.png\" alt=\"phpMyAdmin OPTIMIZE TABLE result showing the recreate and analyze note followed by status OK\" width=\"1640\" height=\"658\" srcset=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-25_1.png 1640w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-25_1-300x120.png 300w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-25_1-1024x411.png 1024w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-25_1-768x308.png 768w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-25_1-1536x616.png 1536w\" sizes=\"(max-width: 1640px) 100vw, 1640px\" \/><\/p><p>A note saying <b>Table does not support optimize, doing recreate + analyze instead<\/b> appears, followed by the status <b>OK<\/b>. This note is normal for InnoDB tables and means the table was rebuilt successfully.<\/p><p>The Hostinger dashboard size can rise temporarily while <code>OPTIMIZE TABLE<\/code> runs, because MySQL builds a new copy of the table before it removes the old one. The size drops once the optimization finishes.<\/p><p><code>OPTIMIZE TABLE<\/code> fails with error <code>#1142<\/code> (<code>INSERT command denied<\/code>) if your database is over its size limit, because write permissions are suspended. See <a data-click-id=\"hgr-post-content-link-what-to-do-if-the-database-size-limit-has-been-reached-in-ho\" href=\"https:\/\/www.hostinger.com\/support\/5534251-what-to-do-if-the-database-size-limit-has-been-reached-in-hostinger\/\">What to do if the database size limit has been reached in Hostinger<\/a> to reduce the database size in that case.<\/p><h3>Option 3 &ndash; Remove unused FULLTEXT indexes<\/h3><p>Drop a FULLTEXT index you no longer use to delete its hidden index files. Replace <code>table_name<\/code> and <code>index_name<\/code> with the values from the FULLTEXT query:<\/p><pre><code>ALTER TABLE table_name DROP INDEX index_name;<\/code><\/pre><p><img decoding=\"async\" class=\"alignnone size-full wp-image-24716\" src=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-26.png\" alt=\"phpMyAdmin SQL tab showing a successful ALTER TABLE DROP INDEX query\" width=\"1648\" height=\"664\" srcset=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-26.png 1648w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-26-300x121.png 300w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-26-1024x413.png 1024w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-26-768x309.png 768w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/11\/2026-11-06_10-26-1536x619.png 1536w\" sizes=\"(max-width: 1648px) 100vw, 1648px\" \/><\/p><p>Features that rely on the index, such as plugin search or related posts, stop working until the index is recreated. Check which plugin created the index before you drop it.<\/p><p>Removing free space and unused FULLTEXT indexes lowers your Hostinger database size and keeps it further from your hosting plan&rsquo;s limit.<\/p><h2 id=\"h-hostinger-database-size-faq\">Hostinger database size FAQ<\/h2><h3>Why doesn&rsquo;t deleting rows reduce my database size in the Hostinger dashboard?<\/h3><p>MySQL keeps the space from deleted rows inside the table file for future data, so the Hostinger dashboard size stays the same after you delete rows. Repair the database or optimize its tables to release that free space.<\/p><h3>Is a difference between the Hostinger dashboard and phpMyAdmin a problem?<\/h3><p>No. The Hostinger dashboard and phpMyAdmin measure database size in different ways, so a difference is expected. A difference doesn&rsquo;t mean your database is damaged or out of sync.<\/p><h3>Why didn&rsquo;t OPTIMIZE TABLE reduce my database size in the Hostinger dashboard?<\/h3><p><code>OPTIMIZE TABLE<\/code> releases free space inside tables, but it isn&rsquo;t guaranteed to shrink FULLTEXT index files. Check for FULLTEXT indexes with the phpMyAdmin query and drop the ones you no longer use.<\/p><p><strong>Additional resources<\/strong><\/p><ul>\n<li><a data-click-id=\"hgr-post-content-link-how-to-optimize-your-wordpress-database\" href=\"https:\/\/www.hostinger.com\/tutorials\/wordpress-database-optimization\/\">How to optimize your WordPress database<\/a>.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>On-disk database size includes free table space and FULLTEXT index files that phpMyAdmin omits.<\/p>\n","protected":false},"author":594,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_content_updated_date":"","include_on_kodee":true,"footnotes":""},"categories":[246],"tags":[],"class_list":["post-24712","post","type-post","status-publish","format-standard","hentry","category-general-information-mysql-databases"],"hreflangs":[],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/24712","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/users\/594"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/comments?post=24712"}],"version-history":[{"count":3,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/24712\/revisions"}],"predecessor-version":[{"id":24812,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/24712\/revisions\/24812"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/media?parent=24712"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/categories?post=24712"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/tags?post=24712"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}