Re: High memory usage on mysql 5.6.36-log on linux server

[Priya Pawar]

Hi,

Please find the result of queries that you asked for.

mysql> select
-> engine,
-> concat(round(sum(table_rows)/1000000,2),'m') rows,
-> concat(round(sum(data_length)/(1024*1024*1024),2),'g') data,
-> concat(round(sum(index_length)/(1024*1024*1024),2),'g') idx,
-> concat(round(sum(data_length+index_length)/(1024*1024*1024),2),'g')
-> total_size,
-> round(sum(index_length)/sum(data_length),2) idxfrac
-> from information_schema.tables
-> group by engine;
+--------------------+--------+-------+-------+------------+---------+
| engine | rows | data | idx | total_size | idxfrac |
+--------------------+--------+-------+-------+------------+---------+
| CSV | 0.00m | 0.00g | 0.00g | 0.00g | NULL |
| InnoDB | 29.69m | 6.39g | 4.46g | 10.85g | 0.70 |
| MEMORY | NULL | 0.00g | 0.00g | 0.00g | NULL |
| MyISAM | 0.99m | 0.14g | 0.03g | 0.17g | 0.24 |
| PERFORMANCE_SCHEMA | 0.07m | 0.00g | 0.00g | 0.00g | NULL |
+--------------------+--------+-------+-------+------------+---------+