on 8/26/03 1:40 AM, Roger Baklund at [EMAIL PROTECTED] wrote: > * 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 >
Where do all my defaults come from if my.cnf only has datadir=/usr/local/mysql/data And can I just add in more vars to that file and not harm anything, or will I then need to define all the vars. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
