Stats
Stats Method
Table Of Stats Method
Parameters
- table (the name of the table to get the stats of it)
stats(table)
Example Usage
await db.stats("my_table");
// -> return table info
Returned Data
Returns object of table stats
{
Name: 'new_table',
Engine: 'InnoDB',
Version: 10,
Row_format: 'Dynamic',
Rows: 2,
Avg_row_length: 8192,
Data_length: 16384,
Max_data_length: 0,
Index_length: 0,
Data_free: 0,
Auto_increment: 4,
Create_time: 2021-06-18T03:38:22.000Z,
Update_time: 2021-06-18T03:38:22.000Z,
Check_time: null,
Collation: 'utf8mb4_general_ci',
Checksum: null,
Create_options: '',
Comment: '',
Max_index_length: 0,
Temporary: 'N'
}