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?
wait_timeout. I presume that @jaceklubzinski wants to be able to set some mysql variables via core:archive param.
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.