Find integer columns nearing the max column value

MySQL & MariaDB Percona Server for MySQL 5.7
1

Hi

Is there any way to find all columns in all tables in a database where the max value is approaching the max value of the integer column ?

eg - when column is integer

Select * from table where max(column) > 2147480000

2

Hi, you should be able to write a script to determine this by querying the max(col) for each column for each table and comparing to the max possible value. Something like this for example: https://github.com/RickPizzi/pztools/blob/master/findmax.sh

Please note I haven’t tested it so use with care