bigdata

MySQL常见问题解答

SQL优化总结 - MySQL（2022最新版）

show variables like '%char%';show global variables like '%char%';SET character_set_client = utf8;SET character_set_server=utf8;SET character_set_results = utf8;SET character_set_connection = utf8;SET character_set_database=utf8;SET GLOBAL characte.

查看mysql日志[atguigu@hadoop102 ~]$ cd /var/log[atguigu@hadoop102 log]$ sudo tail -n50 mysqld.log#查询日志末尾50行数据[atguigu@hadoop102 log]$ sudo tail -50f mysqld.log#查询#实时监控100行日志启动mysql服务[atguigu@hadoop102 software]$ sudo systemctl status mysqld...