Is it possible in MySQL / MariaDB to calculate row size like in PostgreSQL ?
I'm looking to calculate in a multi tenant application how much space did the user use for the database but I couldn't find anything relevant about this.
MySQL / MariaDB granular row size
MySQLmysql-5.7
Related Question
- AWS RDS – How to Change Instance Class
- Mysql – mariaDB not caching queries cached by thesql
- MySQL Row Size Too Large (> 8126) with MyISAM tables
- Mysql – Does MySQL or MariaDB have a master option to strictly require TLS for ALL connections, no matter what
- MySQL vs MariaDB Binary Logging – Key Differences
- Mysql – Unable to fix ROW size too large even with innodb_file_per_table
- Mysql – Vertical / Horizontal Scaling Disk Size MySQL or MariaDB
- MySQL least privileges to get database/tables size
Best Answer
In phpmyadmin you see the size of every table at the end . after you select a database.
if you want to do this in a query do, you need only the put in your own database name instead of testdb