Kumar <[EMAIL PROTECTED]> wrote:
>
> i have high performance dell server. i want to
> increase Read_Buffer_Size server variable to 5 MB.
>
> i have found docs on this in mysql site. like this
>
> mysqld_safe --key_buffer_size=64M --table_cache=256 \
> --sort_buffer_size=4M --read_buffer_size=1M
> &
>
> where i type that command i am getting status
> message as Mysqld is already running.
>
> how can i change those variables to take effect
> permanently.
You can restart MySQL server with new value of read_buffer_size.
If version of MySQL server >= 4.0.3 you can set variable at runtime using SET
statement:
http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
http://dev.mysql.com/doc/mysql/en/Dynamic_System_Variables.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
