> I wish to tune our MySQL Server Parameter to increase > the speed of Join. I was trying to do a simple join > with two tables. One is big (~2,500,000 records); the > other one is small. The current join seems to take > forever to finish even on the indexed attribute. > > I am trying to learn from > http://www.mysql.com/doc/en/Server_parameters.html but > not confident enough to play with our server yet. Any > advice will be much appreciated. I am running > mysql3.23.49 on linux7.3 with 4 GB memory. So I want > to try the following from that doc: > > shell> safe_mysqld -O key_buffer=64M -O > table_cache=256 -O sort_buffer=4M -O > read_buffer_size=1M & > > My questions: if I run the above command (as root), > should I run it every time when the server starts? If > so, how can I set the above option automatically when > server starts. Thanks!
Modify you my.cnf to add or change this parameter and mysql will "normally" read this cnf file each time you launch it via mysql.server script ... David --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
