At 9:58 -0700 9/8/04, Patrick Campbell wrote:
I'm trying to get my key_buffer_size to 64m (default is 8m). I tried
putting it into my.cnf under [mysqld] with both key_buffer=64m and
key_buffer_size=64m seperately of course, and when that didn't work tried
putting it in from of the: /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf
/dev/null 2>&1 & line in /etc/rc.d/init.d/mysqld. All yield this error
shown in /var/log/mysqld:
/usr/libexec/mysqld: unrecognized option `--key_buffer=64m'
(or)
/usr/libexec/mysqld: unrecognized option `--key_buffer_size=64m'
MySQL is version 3.23.58 and RedHat version is Red Hat Linux release 9
(Shrike) 2.4.20.
Any suggestions?
That syntax is supported as of MySQL 4.0.
Use set-variable=key_buffer_size=64m instead.
http://dev.mysql.com/doc/mysql/en/Server_options.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
