* Scott Haneda > I have mysql 3.23.51-entropy.ch > I have never used a my.conf file other than to tell it one thing which is > datadir=/usr/local/mysql/data > > I have a gig of memory and only apache runs on this machine. It is OS X > 10.1.5. How can I tell how mysql is running, since I donıt have any > variables set in my.conf, where are they coming from? What commands do I > look to issue to be able to see if I should give more memory to mysql, and > how would I do this.
For information on the options files: <URL: http://www.mysql.com/doc/en/Option_files.html > For information on variables you can adjust: <URL: http://www.mysql.com/doc/en/Server_parameters.html > I guess you should increase the size of the 'key_buffer_size' variable. This is a shared global index buffer for MyIsam tables. The default value is rather low. See also this page: <URL: http://www.mysql.com/doc/en/Memory_use.html > -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]