Skip to content

Schelstraete.org

  • Home
  • Home
2107, 2019

Linux – commvault: create systemd file

Bschelst/ July 21, 2019/ Linux/ 0 comments

1407, 2019

Mysql: optimize all tables in all databases

Bschelst/ July 14, 2019/ Linux/ 0 comments

In order to optimize all databases & tables within your mysql instance, you can use the code below. You can also use a more specific script, where only the tables are optimized which have 10MB free space and 10% free space.

Search for:

Recent Posts

  • T-SQL: Kill all inactive sessions from specific user
  • T-SQL: Check status of automatic seeding
  • T-SQL: size of replication specific tables
  • T-SQL: check replication backlog
  • T-SQL: Resume or suspend all always on databases

Archives

  • July 2020
  • March 2020
  • February 2020
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • February 2019
  • November 2017
  • August 2017
  • July 2017
  • June 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016

Categories

  • Avamar
  • General
  • Ispconfig
  • Linux
  • Oracle
  • PowerShell
  • SAP Hana
  • SQL-Server
  • Uncategorized
Schelstraete.org