Re: MYSQL CRASHING FREQUENTLY

[Sam Mathews]

mysql> select engine, round(sum(data_length)/1024/1024/1024,1) as 'DATA GB',
-> round(sum(index_length)/1024/1024/1024,1) as 'INDEX GB' from
-> information_schema.tables where engine is not null group by engine;
+--------------------+---------+----------+
| engine | DATA GB | INDEX GB |
+--------------------+---------+----------+
| CSV | 0.0 | 0.0 |
| InnoDB | 2050.8 | 2257.0 |
| MEMORY | 0.0 | 0.0 |
| MyISAM | 0.0 | 0.0 |
| PERFORMANCE_SCHEMA | 0.0 | 0.0 |
+--------------------+---------+----------+
5 rows in set (16.60 sec)