# ls -lh /var/lib/mysql/thegeekstuff/EMPLOYEE.* In the above optimization, the EMPLOYEE table is an MyISAM table.įor this example, before the optimization, you’ll see the following. #MYSQL OPTIMIZER TURN OFF UPDATE#If you have indexes, it will also resort the index pages, and update the statistics.ĭuring optimization, MySQL will create a temporary table for the table, and after the optimization it will delete the original table, and rename this temporary table to the original table.For InnoDB tables, optimize table will simply perform an alter table to reclaim the space.For MyISAM tables, it will analyze the table, it will defragment the corresponding MySQL datafile, and reclaim the unused space. #MYSQL OPTIMIZER TURN OFF ARCHIVE#
1 Comment
7/2/2023 10:32:26 am
En iyi ısparta ilan sitesi burada. https://isparta.escorthun.com/
Reply
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |