Ottimizzare tutte le tabelle in un database MySQL: Revision history

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

11 June 2024

  • curprev 14:4714:47, 11 June 2024 Gabriele.vivinetto talk contribs 319 bytes +319 Created page with "* Usare lo script <pre> #!/bin/bash for table in $(mysql -u root -proot_pwd -sss -e "select concat(table_schema,'.',table_name) from information_schema.tables where table_schema in ('mydatabasename') order by data_free desc;") do echo OPTIMIZE $table mysql -u root -proot_pwd -e "OPTIMIZE TABLE $table;" done </pre>" Tag: Visual edit
Retrieved from "https://kb.rvmgroup.it/index.php/Ottimizzare_tutte_le_tabelle_in_un_database_MySQL"