The problem is mysql can not store directive password in shell. If doing repetition for import many sql in file, we must entered password as how many file sql.
I learned something amazing about MySQL. If you allocate a single monolithic InnoDB Buffer Pool that is bigger that Total Installed Divided By Number of Physical CPUs, your will incite the OS to regular intervals memory swapping due to a full InnoDB Buffer Pool. MySQL 5.5’s option known as innodb_buffer_pool_instances can be used to split…
Most often stuck connections are due to DNS not resolving properly, which the skip-name-resolve option will help with. Skipping with my.cnf option skip-name-resolve restart mysql