When upgrading the gateway version from 10.0 to 10.1
We successfully uploaded and installed the 10.1 Platform and Application patches, but during Gateway embedded DB upgrade from 10.0 to 10.1 via SSG menu encountered an issue with as it took more than an hour and half to complete the task and resulted a communication error.
Release : 7.1
Command
SELECT table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` from information_schema.TABLES WHERE table_schema = "ssg" ORDER BY (data_length + index_length) DESC limit 10;
Showed counters to be a high data table largest usage. Counters is used by apply throughput quota assertion.
You can selectively delete by reviewing below.
this query should do a select,
NOTE: <value> in below needs to be populated. SEE BELOW!
SELECT COUNT(*) FROM ssg.counters WHERE last_update <= ((unix_timestamp(curtime()) * 1000)-<value?>);
Delete
DELETE FROM ssg.counters WHERE last_update <= ((unix_timestamp(curtime()) * 1000)-<value>);
Where <value> is the milliseconds you want to delete.
I.e. if you use 7776000000
This is basically anything older then 3 months.
like,
DELETE FROM ssg.counters WHERE last_update <= ((unix_timestamp(curtime()) * 1000)-7776000000);
But you may want to make this much more aggressive