Welcome Guest, Not a member yet? Register   Sign In
How to use optimize_database() ?
#1

Hi guys, I have a question.
What use has the optimize database () function? as this function is used?

I was looking for information on the internet but could not find exactly what I need to know. The information in the official document of CodeIgniter is very little

Sorry for my poor English!
Reply
#2

Do you mean this?
https://codeigniter.com/userguide3/datab...a-database

If you use MySQL,  it runs "OPTIMIZE TABLE"
https://dev.mysql.com/doc/refman/5.7/en/...table.html

See $_optimize_table property in the DB Utility Class.
CodeIgniter/mysqli_utility.php at develop · bcit-ci/CodeIgniter
https://github.com/bcit-ci/CodeIgniter/b...ty.php#L63
Reply
#3

optimize on MyIsam table, analyze for innodb table. i use phpmyadmin, or do it manually, refer mysql official documentation
Reply




Theme © iAndrew 2016 - Forum software by © MyBB