https://kb.rvmgroup.it/index.php?action=history&feed=atom&title=Ottimizzare_tutte_le_tabelle_in_un_database_MySQLOttimizzare tutte le tabelle in un database MySQL - Revision history2026-05-05T20:23:29ZRevision history for this page on the wikiMediaWiki 1.44.2https://kb.rvmgroup.it/index.php?title=Ottimizzare_tutte_le_tabelle_in_un_database_MySQL&diff=11180&oldid=prevGabriele.vivinetto: 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>"2024-06-11T14:47:03Z<p>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>"</p>
<p><b>New page</b></p><div>* Usare lo script<br />
<pre><br />
#!/bin/bash<br />
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;")<br />
do<br />
echo OPTIMIZE $table<br />
mysql -u root -proot_pwd -e "OPTIMIZE TABLE $table;"<br />
done<br />
</pre></div>Gabriele.vivinetto