mySQL try to Optimize

References:

[1] https://dev.mysql.com/doc/refman/5.7/en/insert-optimization.html

[1] connection options https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-connection-parameters.html#codbc-dsn-option-flags
[2] autocommit problem http://www.mysqlab.net/knowledge/kb/detail/topic/innodb/id/5934
[3] 101 tips https://www.monitis.com/blog/101-tips-to-mysql-tuning-and-optimization/
[4] Create table  https://dev.mysql.com/doc/refman/8.0/en/create-table.html