10 MySQL settings to tune after installation

mysqlcheck -u -p[password] -o [database name]

STEP 01) Change the following in /etc/my.cnf [mysqld] innodb_log_buffer_size = 32M innodb_buffer_pool_size = 2G innodb_log_file_size…

How to import data from csv, txt or other export files into MYSQL Syntax: LOAD…