Re: ElkArte 1.1.7 - Release announcement
Reply #9 –
If you are running InnoDB as your storage engine, then it will not "optimize" those tables.
Doing optimize on an InnoDB table is usually not necessary (unlike MyISAM). Maybe after you have done A LOT of insert/update/delete against the table IN A WAY that could result in fragmentation. Perhaps if you are using a FULLTEXT search index on an InnoDB table, that may benefit from DROP INDEX, then ADD INDEX but optimize really does a ALTER TABLE ... FORCE on InnoDB whichi is mostly a don't bother with our tables.
You are much better off tinkering with your conf file if you want to optimize InnoDB.
I recall some discussion on what the real IP is when using cloudflare or some others, Its in one of the x-headers. Do a site search on cloudflare and see if those solutions will work for you. But like @tino said, that IP should not change in session.