title: How can I rebuild indexes and update stats in MySQL innoDB?
body: <p>I have experience with MS SQL server where it is possible and useful to <a href="https://msdn.microsoft.com/en-us/library/ms187348.aspx?f=255&amp;MSPPError=-2147217396" rel="noreferrer">update statistic</a> and <a href="https://msdn.microsoft.com/en-us/library/ms189858.aspx" rel="noreferrer">rebuild indexes</a>. I can't find such option in MySQL innoDB, is there such option? If not, how MySQL database create an execution plan? Does the MySQL update indexes and statistic with every UPDATE and INSERT?</p>