备注：仅当前生效
|
0 1 2 3 4 5 6 7 8 |
[root@Mysql ~]# /usr/local/mysql/bin/mysql -uroot -p'admin' -e "show variables;" | grep key_buffer Warning: Using a password on the command line interface can be insecure. key_buffer_size 8388608 [root@Mysql mysql]# /usr/local/mysql/bin/mysql -uroot -p'admin' -e "set global key_buffer_size = 32M;" Warning: Using a password on the command line interface can be insecure. ERROR 1232 (42000) at line 1: Incorrect argument type to variable 'key_buffer_size' [root@Mysql mysql]# /usr/local/mysql/bin/mysql -uroot -p'admin' -e "show variables;" | grep key_buffer Warning: Using a password on the command line interface can be insecure. key_buffer_size 32776192 |
申明：本文由BYRD原创(基于Mysql5.6.16)，未经许可禁止转载！ SourceByrd's Weblog-https://note.t4x.org/database/effective-configuration-parameters/
申明：除非注明Byrd's Blog内容均为原创,未经许可禁止转载!详情请阅读版权申明!
