Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 12

MySQL Script to Defrag all my Indexes

Could anyone please share their scripts to run a scheduled job to defrag all the indexes on their MySQL databases for Solarwinds?  I'm looking for scripts to:

1) Do a one time scheduled job at midnight

2) Do a weekly job at midnight on Saturdays

3) Do a nightly job every midnight

These scripts would be ran in MySQL.  Thank you in advance.  Also, what are potential issues that could arise from having these scripts ran?  For example, would there be any impact on the network?

0 Kudos
0 Replies