Thanks Hartmut

On Mon, 3 Jul 2023, 10:49 Hartmut Holzgraefe via discuss, <discuss@lists.mariadb.org> 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 -- discuss@lists.mariadb.org
To unsubscribe send an email to discuss-leave@lists.mariadb.org