How to replace content in large file?

Many time developer just need to replace a bit of text inside the large file like *.sql or *.sqlite
Opening a file into editor take too much resource of system or server. So I come up with the very easy and useful way to replace content into large file using linux command like. sed command.

Here I am taking an example of MySql file which having *.sql as file extension

sed -i '' 's/utf8mb4_0900_ai_ci/utf8mb4_unicode_ci/g'

How to improve mysql performance?

There are various kind of improvement are available to tweek the mysql configuration to improve and measure how to improve but few of my favorites tips are noted here.