Allow to customize mysql settings when running core:archive console command #9959

We have many archiving processes and don't want to change the global parameters only if one of the archiving needs this.
Generally it is not a good practice to change some variables globally e.g. http://piwik.org/faq/troubleshooting/faq_183/

Can you explain the issue in more details? I'm not sure which mysql params you mean etc. And how would you like to set and use them?

E.g. wait_timeout. I presume that @jaceklubzinski wants to be able to set some mysql variables via core:archive param.

Similar to php-cli-options and we would do something like $this->_connection->query("SET foobarparam = $foobarvalue"); whenever we create database connection?

Exactly what we want. Set database dynamic parameter like wait_timeout and max_allowed_packet as session parameter each time we create new database connection.