Home  >  Article  >  Database  >  MySQL 物理文件

MySQL 物理文件

WBOY
WBOYOriginal
2016-06-01 13:06:09994browse

1 、参数文件及mysql参数

查看mysql 的 my.cnf 配置文件位置命令:>./bin/mysql --help | grep my.cnf  

查看mysql 的参数设置命令: mysql >  show variables  --显示所有参数; // show variables like 'log_error%' 显示某匹配参数

mysql > select @@session.read_buffer_size; 查看当前session的read_buffer_size

mysql > select @@global.read_buffer_size; 查看全局的read_buffer_size

mysql > set @@session.read_buffer_size=1024000; 设置当前session的read_buffer_size

mysql > set @@session.read_buffer_size=1024000; 设置当前session的read_buffer_size

2、日志文件

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:MySQL联结表_MySQLNext article:show slave status 详解_MySQL