-----Original Message----- > From: Mel [mailto:[EMAIL PROTECTED] > Sent: 15 April 2008 07:52 PM > To: freebsd-questions@freebsd.org > Cc: Vikash Badal > Subject: Re: How do I use more process memory with mysqld > > On Tuesday 15 April 2008 17:07:14 Vikash Badal wrote: > > > datasize 33554432 kB > > That says 3G. > > > > 48647 mysql 35 20 0 963M 938M kserel 0 718.9H > 22.17% mysqld > > Your my.cnf is missing. Are you sure you're allowing mysql to > go beyong 1G?
Sorry about that ... Missed that one. My.cnf: ~~~~~~~~~~ # The MySQL server [mysqld] key_buffer = 768M max_allowed_packet = 2M table_cache = 1024 sort_buffer_size = 4M read_buffer_size = 4M read_rnd_buffer_size = 16M myisam_sort_buffer_size = 128M thread_cache_size = 8 query_cache_size = 64M max_connections = 200 # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 server-id = 31 aths to different dedicated disks #tmpdir = /tmp/ tmpdir = /mnt/ramfs/tmp/ [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Please note: This email and its content are subject to the disclaimer as displayed at the following link http://www.is.co.za/legal/E-mail+Confidentiality+Notice+and+Disclaimer.htm. Should you not have Web access, send a mail to [EMAIL PROTECTED] and a copy will be emailed to you. _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"