Skip to main content
100%

Get Table Sizes (in MB) for a database

✓ Published0🌍 Public
WWilliamQLiu
Last edited Jan 30, 2019
Created on Jan 30, 2019

This visualization shows the size of each table in a MySQL database in megabytes, sorted from largest to smallest. It displays the table names alongside their computed sizes using a bar chart or similar comparison layout. The SQL query in `get_table_size.sql` calculates each table’s total size by summing `data_length` and `index_length` from the `information_schema.TABLES` metadata, then divides by 1024 twice and rounds to two decimal places. The query orders results by size in descending order, and the visualization renders this data as its primary output.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist 860389

This example visualizes the schema of a phpBB posts database table, showing its columns, data types, and indexing structure. It uses a custom layout to represent each field as a node, with primary key and foreign key relationships highlighted through color and grouping. The visualization is rendered using D3.js, likely with `d3.forceSimulation` or a similar layout algorithm, and the underlying data is read directly from the SQL `CREATE TABLE` statement in the gist file. The code parses the schema definitions to generate the graph, mapping attributes like keys and full-text indexes visually.

TTBD
55% match
Loading thumbnail…

Gist 4434273

This example visualizes the hierarchical structure of database tables and their backup progress as a node-link diagram. It shows how a PHP script recursively traverses MySQL databases and tables, with each node representing a table and links reflecting parent-child relationships. The visualization uses D3.js’s `d3.forceSimulation` for layout and rendering, while the underlying data comes from the script’s output, which logs backup status via `+`, `-`, or error messages. The code explicitly relies on PHP’s `mysql_connect`, `mysql_query`, and `system` calls, alongside `mysqldump` and `gzip`, to generate the backup process that the graph depicts.

PPhilippe Rivière
54% match
Loading thumbnail…

500 Weight/Height

This example displays a table summary of automobile data from the UCI Machine Learning Repository’s Auto MPG dataset, showing row count, column count, and file size in kilobytes. It also renders the first 500 rows as formatted JSON text. The visualization uses `d3.csv` to load the data, `csvFormat` to calculate byte size, and `select` to append `<pre>` elements displaying the summary and data in a terminal-style monospace layout. The black background and green text evoke a classic command-line interface.

Cceltic660
53% match
Loading thumbnail…

Gist be32a2ac117700d3dbde6b0824367ba5

This example demonstrates how to create a simple database table visualization from a SQL schema definition. The code defines a `Demo` table with three columns—`ID`, `Key`, and `Value`—and shows how to map those column types and constraints into a visual entity-relationship style diagram. Using the provided `CREATE TABLE` statement as the data source, the visualization renders each column as a node, with the primary key and nullable attributes indicated through distinct visual encodings. The implementation leverages `d3.forceSimulation` for the node layout and `d3.geoPath` for any geometric rendering, while relying on standard DOM elements for interactivity. No additional behavior beyond the table’s structural representation is implied.

HHugoberry
52% match
Loading thumbnail…

mysql backup cron

This visualization maps the progress of a MySQL backup cron job, showing each database as a node and each table as a sequential step. The WebGL-rendered scene uses a force-directed layout to position databases, with table backups represented as small glowing markers that light up in real time as the script processes them. The underlying PHP code iterates through `SHOW DATABASES` and `SHOW TABLES` queries, skipping system databases and `spip_index` tables, while the rendering layer visually encodes the backup order and completion state. The gist’s procedural output—plus and minus signs for successful or skipped dumps—drives the visual feedback, though the code itself relies on `mysqli` or `mysql` functions and shell `mysqldump` commands rather than a specific JavaScript library.

PPhilippe Rivière
52% match
Loading thumbnail…

International Cabinets - Dataset Overview

This visualization displays a concise dataset summary for the International Cabinets dataset, showing the file size in kilobytes, the total number of rows (over 50,000 entries), and the number of columns. The example uses D3.js v5 to fetch the CSV from a remote gist URL via `d3.csv`, then calculates the data size with `d3.csvFormat` and accesses row and column counts through the parsed data object. The information is presented as large text within an HTML `<pre>` element.

RRudy Shayganfar
51% match
Loading thumbnail…

Data Table Summary

This example displays a plain-text summary of a CSV data table about population estimates for the most populous countries in 2018. It shows the number of rows, columns, and file size in kilobytes, followed by the first 10 rows of the data formatted as JSON. The visualization uses d3.csv to load the data and d3.csvFormat to calculate the size, then writes results into <pre> elements via d3.select. The styling adopts a green-on-black terminal aesthetic from the provided CSS.

Ffloresh
51% match
Loading thumbnail…

MySQL Cheat Sheet

This example presents a plain-text MySQL cheat sheet as a structured reference for database management and SQL querying. It demonstrates how to organize commands for user administration, database and table creation, data manipulation, and complex queries such as joins and foreign key relationships. The text is formatted with markdown headers and code blocks, showing SQL statements for operations like `CREATE TABLE`, `SELECT`, `INSERT`, and `INNER JOIN`. It also includes configuration tips for adding MySQL to the system PATH via bash commands, while the underlying source is a GitHub Gist authored by Lyndoman.

LLyndoman
51% match