MySQL Forums
Forum List  »  MySQL Shell

mysqlsh vs mysql performance difference
Posted by: nitesh th
Date: January 20, 2021 03:19AM

I am executing a query remotely using mysql utility and also through mysqlsh utility. I see that with mysql, entire dataset is loaded in memory at once, whereas in case of mysqlsh, it appears to be fetching a single row or a subset of rows at a time. I want to achieve the same behaviour as mysql in mysqlsh. Any configurations available for this ?

mysql -h <> -p <> database < query.sql

Options: ReplyQuote

Written By
mysqlsh vs mysql performance difference
January 20, 2021 03:19AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.