dear all, i try to use the autoshrink feature, but on startup i get the message "InnoDB: User table exists in the system tablespace.Please try to move the data from system tablespace to separate tablespace before defragment the system tablespace."
i had some tables within this tablespace, but i already deleted them. if i' issue the command "SELECT name FROM information_schema.INNODB_SYS_TABLES WHERE space = 0;" i get the following tables listed: +------------------+ | name | +------------------+ | SYS_DATAFILES | | SYS_FOREIGN | | SYS_FOREIGN_COLS | | SYS_TABLESPACES | | SYS_VIRTUAL | +------------------+ but i think these are no user tables .... so how can i find out which user tables are still in the system tablespace ?!?!? MariaDB 11.8.3 sincerely Heinz _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
