How large is your total memory? There parameters' value seem too large. On Mon, Jun 16, 2008 at 4:49 PM, Moon's Father <[EMAIL PROTECTED]> wrote:
> How large is your total memory? > There parameter seems too large. > > > On Sun, Feb 10, 2008 at 5:42 PM, VeeJay <[EMAIL PROTECTED]> wrote: > >> Hello >> >> I am running a Freebsd server: >> >> 1. Software: >> Apache 1.3 >> mysql 5.0.27 >> php 4.4 >> >> >> 2. Hardware: >> 2 intel procerssors >> 4 gb ram >> RAID 10 with hard drives 15K rpm >> >> I am having this problem quite often now. Apache stops responding due to >> mysql (my guess). And I cannot connect to mysql server: >> >> /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed >> error: 'Out of memory; check if mysqld or some other process uses all >> available memory; if not, you may have to use 'ulimit' to allow mysqld to >> use more memory or you can add more swap space' >> >> >> There is following configuration for mysql: >> >> # The following options will be passed to all MySQL clients >> [client] >> port = 3306 >> socket = /tmp/mysql.sock >> default-character-set=utf8 >> >> # Here follows entries for some specific programs >> >> # The MySQL server >> [mysqld] >> port = 3306 >> socket = /tmp/mysql.sock >> skip-locking >> skip-networking >> skip-name-resolve >> >> server-id=1 >> >> max_connections=1000 >> key_buffer = 1024M >> max_allowed_packet = 16M >> table_cache = 512K >> sort_buffer_size = 4M >> net_buffer_length = 64K >> read_buffer_size = 4M >> read_rnd_buffer_size = 4M >> join_buffer_size=4M >> >> myisam_sort_buffer_size = 128M >> >> # increase until threads_created doesnt grow anymore >> thread_cache=512 >> >> query_cache_type=1 >> query_cache_limit=2M >> query_cache_size=64M >> >> # Try number of CPU's*2 for thread_concurrency >> thread_concurrency=4 >> >> >> set-variable=local-infile=0 >> init_connect='SET collation_connection = utf8_unicode_ci' >> init_connect='SET NAMES utf8' >> default-character-set=utf8 >> character-set-server=utf8 >> collation-server=utf8_unicode_ci >> ft_min_word_len=2 >> ft_max_word_len=15 >> >> log-bin=mysql-bin >> >> server-id = 1 >> >> [mysqldump] >> quick >> max_allowed_packet = 16M >> >> [mysql] >> no-auto-rehash >> default-character-set=utf8 >> >> [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 >> >> [mysqlhotcopy] >> interactive-timeout >> >> ANY COMMENTS WILL BE WELCOMED, thanks!!! >> >> >> -- >> Thanks! >> >> BR / vj >> > > > > -- > I'm a MySQL DBA in china. > More about me just visit here: > http://yueliangdao0608.cublog.cn -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
