im using mysql quite a while now & as days goes on, im encountering low memory problem. before there are no problems with connecting to the db, but now more users using the db & that the problems starts, low memory.
my machine has 1G ram, Celeron 1.6Ghz, 60G hd space & using Mysql 3.23.56 for i686 with kernel 2.4.20. the machine runs only mysql server. my question is how can i tune up my mysql server for optimum performance? or shall i say is there a way to optimized the linux memory handling? can also somebody help me where to find good documentation on increasing linux threads? thanks here is my mysql config file. (my.cnf) # This is for large system with memory = 1G where the system runs mainly MySQL. [client] port = 3306 socket = /tmp/mysql.sock [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking set-variable = max_connections=3000 set-variable = wait_timeout=2880000000000 set-variable = key_buffer=384M set-variable = max_allowed_packet=1M set-variable = table_cache=512 set-variable = sort_buffer=8M set-variable = record_buffer=8M set-variable = myisam_sort_buffer_size=64M set-variable = thread_cache=8 set-variable = thread_concurrency=8 server-id = 1 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable = key_buffer=256M set-variable = sort_buffer=256M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=256M set-variable = sort_buffer=256M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003 -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
