Thanks Hartmut On Mon, 3 Jul 2023, 10:49 Hartmut Holzgraefe via discuss, < [email protected]> wrote:
> On 03.07.23 11:39, robert k Wild via discuss wrote: > > hi all, > > > > looking at this guide > > > > > https://www.ibm.com/support/pages/temporarily-reduce-space-taken-console-database > < > https://www.ibm.com/support/pages/temporarily-reduce-space-taken-console-database > > > > > > do i ideally have to stop the database before i truncate some tables ie > > > > /opt/aspera/common/mysql/bin/mysql -u root -p'password' aspera_console > > TRUNCATE*fasp_sessions fasp_files fasp_rates * *jobs job_steps* > > > with the database stopped you would not be able to executed any SQL > commands, > including TRUNCATE. So no, do not stop the database before doing a TRUNCATE > > > -- > Hartmut Holzgraefe, Principal Support Engineer (EMEA) > MariaDB Corporation | http://www.mariadb.com/ > > _______________________________________________ > discuss mailing list -- [email protected] > To unsubscribe send an email to [email protected] >
_______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
