 | | | -none- | -none- 2007-10-03 - By -not available-
Back
Hi Mathieu,
I found that innodb_buffer pool value isn't set..The whole innodb
settings are commented.
I found the below values from the my.cnf file:
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /var/lib/mysql/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 256M
#innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 64M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
here is the memory settings:
total
used
free
shared
buffers
cached'
mem:
4054
4038
15
0
6
1426
buffers/cache
2605
1448
swap:
4094
150
3943
Please help me out to change the parameter values
Regards,
Amarnath S
Amarnath Shivashankar wrote :
> We have found that the MYSQL on all Email DB servers starts throwing
"Out of
> memory; check if mysqld or some other process uses all available
memory;"
> error. The error goes once we restart MySQL. But after a week again
the same
> problem occurs. We have 4 GB of physical memory on the server but
Mysql
> utilizes only up to 2.5 GB & starts throwing Out of memory error
>
> Please help me to resolve this.........
>
Mathieu Bruneau wrote:
This looks like the traditionnal 32 bits limitation ... You're using a
32 bits system right ? Because of many reasons (lots of documentation on
the net about that) MySQL is in practice limited to about 2.4-2.6G of
memory, thus the error you see.
When I experienced this errors, I lowered the mysql_buffer and
innodb_buffer so that mysql would stay below this limit and never had
other issue with it. (It was crashing with an error 11 before). I kept
this settings till I could upgrade to a 64 bits host.
--
Mathieu Bruneau
aka ROunofF
Regards,
Amarnath Shivashankar
SQL Database Management
The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not the
intended recipient, you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately and destroy all copies of this message and
any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should
check this email and any attachments for the presence of viruses. The company
accepts no liability for any damage caused by any virus transmitted by this
email.
www.wipro.com
|
|
|