filesystem information for large fs's is getting truncated when it's inserted into the db: bsize frsize blocks bfree bavail file ffree favail sent: 4096 4096 5846347456 5846346248 5846346248 4677104128 4677104125 4677104125 rcvd: 4096 4096 2147483647 2147483647 2147483647 2147483647 2147483647 2147483647 this is due to the int(11) types for most of the fields: +----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+----------------+ | id | bigint(20) | NO | PRI | NULL | auto_increment | | host_id | int(11) | YES | MUL | NULL | | | mnt_pnt | varchar(64) | YES | | NULL | | | fs_type | varchar(16) | YES | | NULL | | | f_favail | int(11) | YES | | NULL | | | f_bsize | int(11) | YES | | NULL | | | f_frsize | int(11) | YES | | NULL | | | f_blocks | int(11) | YES | | NULL | | | f_bfree | int(11) | YES | | NULL | | | f_bavail | int(11) | YES | | NULL | | | f_files | int(11) | YES | | NULL | | | f_ffree | int(11) | YES | | NULL | | | f_fssize | bigint(24) | YES | | NULL | | +----------+-------------+------+-----+---------+----------------+ All but f_bsize and f_frsize should likely be increased to bigint(24) to accomodate larger filesystems. Thanks, -Eric
Ok, I think this is fixed upstream. It didn't require downtime like I thought it might. Only took about 30-40 seconds per column to update.