I recently upgraded the mariadb engine to InnoDb as recommended. The strange thing is that suddenly the sys_storage_tokens table has increased to 3gb. Is there a way to empty this table?
Thx
Can the tables in the image be emptied?
@LeonidS
The sys_storage_tokens table is already 10.1GB in my database. Can it be safely emptied?
@Andrey Yasko @Alex T⚜️ @Leonid S
Hello @Antonio !
You may try to launch the following commands in your UNA database managing panel:
RENAME TABLE `sys_storage_tokens` TO `sys_storage_tokens_old`; CREATE TABLE IF NOT EXISTS `sys_storage_tokens` ( `iid` int(11) NOT NULL AUTO_INCREMENT, `id` int(11) NOT NULL, `object` varchar(64) NOT NULL, `hash` varchar(32) NOT NULL, `created` int(10) unsigned NOT NULL, PRIMARY KEY (`iid`), UNIQUE KEY `id` (`id`,`object`,`hash`), KEY `created` (`created`) );
And check the work of your UNA site. If it is OK - then drop the `sys_storage_tokens_old` table.
Perfect. Thx
Can the tables in the image be emptied?
Thx
@LeonidS
The sys_storage_tokens table is already 10.1GB in my database. Can it be safely emptied?
@Andrey Yasko @Alex T⚜️ @Leonid S
Hello @Antonio !
You may try to launch the following commands in your UNA database managing panel:
RENAME TABLE `sys_storage_tokens` TO `sys_storage_tokens_old`; CREATE TABLE IF NOT EXISTS `sys_storage_tokens` ( `iid` int(11) NOT NULL AUTO_INCREMENT, `id` int(11) NOT NULL, `object` varchar(64) NOT NULL, `hash` varchar(32) NOT NULL, `created` int(10) unsigned NOT NULL, PRIMARY KEY (`iid`), UNIQUE KEY `id` (`id`,`object`,`hash`), KEY `created` (`created`) );And check the work of your UNA site. If it is OK - then drop the `sys_storage_tokens_old` table.
Perfect. Thx