How to get the sizes of the tables of a mysql database.

You can use this query :

mysql> select table_name as 'Table', round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB"
from information_schema.tables where table_schema = 'database' and table_name = 'log';
+----------+------------+
| Table    | Size in MB |
+----------+------------+
| log      |    2357.02 |
+----------+------------+
1 row in set (0.00 sec)

mysql> 

“How to get the sizes of the tables of a mysql database.”Continue reading

Align partitions for best performance using parted

There are two common problems when creating partitions in Linux on big storage arrays. The first is easy, and the warning message from fdisk is a bit of a giveaway:

WARNING: The size of this disk is 8.0 TB (7970004230144 bytes).
DOS partition table format can not be used on drives for volumes
larger than (2199023255040 bytes) for 512-byte sectors. Use parted(1) and GUID 
partition table format (GPT).

“Align partitions for best performance using parted”Continue reading

Email notifications from Redmine with sendmail of exim.

sysnetb@vh36 [~/]# cat config/configuration.yml | egrep -A 6 '^default'
default:
  # Outgoing emails configuration (see examples above)
  email_delivery:
    delivery_method: :sendmail
    sendmail_settings:
      location: /usr/sbin/sendmail
      arguments: ""
sysnetb@vh36 [~/]# 
Scroll to top