Hi,
Below is the content of my my.cnf file. I would like to get the optimum performance from MySQL and would like to modify some of the values. Specifically, my W2K Machine has 192MB of ram, what should I have in order for MySQL to take advanatge of that 192MB memory and what effect does it have? Jaime # Example mysql config file. # Copy this file to c:/my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking default-character-set=latin1 set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 basedir = C:/APPS/MYSQL/ # Uncomment the following row if you move the MySQL distribution to another # location #basedir = d:/mysql/ [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key=16M [client_fltk] help_file= c:/apps/mysql/sql_client/MySQL.help client_file= c:/apps/mysql/MySQL.options history_length=20 database = test queries_root= c:/apps/mysql/queries last_database_file= c:/apps/mysql/lastdb --------------------------------------------------------------------- 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
