Re: MYSQL CRASHING FREQUENTLY
Posted by: Sam Mathews
Date: July 04, 2017 02:37AM

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)

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.