mysql配置文件常用修改.pdf

讲师讲师 李强强李强强 QQ 447096447 邮箱邮箱 liqiangqiang mysql 常用修改 1 有关慢查询 开户和设置慢查询时间 vi etc f log slow queries yes long query time 5 查看设置后是否生效 mysql show variables like quer 慢查询次数 mysql show global status like quer 2 设置 mysql 的默认存储引擎 vi etc f default storage engine innodb innodb data home dir var lib mysql innodb data file path ibdata1 10M autoextend innodb log group home dir var lib mysql innodb log arch dir var lib mysql innodb buffer pool size 16M innodb additional mem pool size 2M innodb log file size 5M innodb log buffer size 8M innodb flush log at trx commit 1 innodb lock wait timeout 50 lamp 兄弟连高级讲师兄弟连高级讲师 讲师讲师 李强强李强强 QQ 447096447 邮箱邮箱 liqiangqiang 查看默认存储引擎 mysql show engines mysql show create table t1 3 设置 mysql 字符集问题 client password your password port 3306 socket var lib mysql mysql sock default character set utf8 mysqld port 3306 socket var lib mysql mysql sock skip locking key buffer 16M max allowed packet 1M table cache 64 sort buffer size 512K net buffer length 8K read buffer size 256K read rnd buffer size 512K myisam sort buffer size 8M character set server utf8 collation server utf8 general ci lamp 兄弟连高级讲师兄弟连高级讲师 讲师讲师 李强强李强强 QQ 447096447 邮箱邮箱 liqiangqiang 查看生效后的结果 在 utf8 的 php 程序来与 mysql 交互时 要用 set names utf8 来与最通用的 utf8 的 mysql 字符 集通信 4 创建唯一索引问题 alter table t1 add unique u name name create unique index u name on t1 name mysql desc t1 mysql show index from t1 mysql show index from t1 lamp 兄弟连高级讲师兄弟连高级讲师 讲师讲师 李强强李强强 QQ 447096447 邮箱邮箱 liqiangqiang lamp 兄弟连高级讲师兄弟连高级讲师 mysql drop index name on t1