Gleb Paharenko wrote:
Hello.
> = 77591546 K
Really - something is wrong with your memory settings - MySQL is using
about 77G of memory (or you have such a cool server :)! Please send the
output of 'SHOW VARIABLES' statement, 'SHOW STATUS' statement and your
configuration file. Include the amount of physical memory.
Thanks for pointing that out ... the machine only has 8GB ram. I
massaged the config values to get under the 8GB limit but still suffer
the same problem:
mysqld got signal 11;
...
key_buffer_size=1073741824
read_buffer_size=4190208
max_used_connections=257
max_connections=256
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections
= 4193278 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
-------------->%------------------------------------------------
The server is dual AMD64 w/ 8GB RAM w/ 500GB disk. It has 4 databases,
1 mostly innodb and 3 myisam. The innodb and one of the myisam dbs see
100x the usage of the other 2 dbs. If anyone spots any problems in the
my.cnf I'd love to hear about it. :)
Hopefully this isn't line-wrapped into oblivion:
---->%--
[client]
#password = your_password
port = 3306
socket =
/var/run/mysqld/mysqld.sock
[mysql]
character-sets-dir=latin1
default-character-set=latin1
[mysqladmin]
character-sets-dir=latin1
default-character-set=latin1
[mysqlcheck]
character-sets-dir=latin1
default-character-set=latin1
[mysqldump]
character-sets-dir=latin1
default-character-set=latin1
[mysqlimport]
character-sets-dir=latin1
default-character-set=latin1
[mysqlshow]
character-sets-dir=latin1
default-character-set=latin1
[myisamchk]
character-sets-dir=latin1
[myisampack]
character-sets-dir=latin1
# use [safe_mysqld] with mysql-3
[mysqld_safe]
err-log = /var/log/mysql/mysql.err
# add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations.
[mysqld]
max_connections = 256
character-set-server = latin1
default-character-set = latin1
user = mysql
port = 3306
socket =
/var/run/mysqld/mysqld.sock
pid-file = /var/run/mysqld/mysqld.pid
log-error = /var/log/mysql/mysqld.err
basedir = /usr
datadir = /var/lib/mysql
#skip-locking
#skip-innodb
key_buffer = 1024M
max_allowed_packet = 1M
table_cache = 1556
sort_buffer_size = 8M
net_buffer_length = 64K
read_buffer_size = 4M
read_rnd_buffer_size = 1M
myisam_sort_buffer_size = 8M
language = /usr/share/mysql/english
myisam_data_pointer_size = 6
# daves: this may not quite work ...
join_buffer_size = 8M
long_query_time = 10
log-long-format
log-slow-queries
max_binlog_size = 10G
binlog_cache_size = 1M
expire_logs_days = 1
tmp_table_size = 64M
query_cache_limit = 1M
query_cache_size = 64M
query_cache_type = 1
#security:
#using "localhost" in connects use sockets by default
#skip-networking
#bind-address = 127.0.0.1
log-bin
server-id = 1
# Point the following paths to different dedicated disks
tmpdir = /tmp/
#log-update =
/path-to-dedicated-directory/hostname
# you need debug use flag enabled to use this ones.
# if needed uncomment them, start the server and issue
# #tail -f /tmp/mysqld.sql /tmp/mysqld.trace
# this will show you *exactly* what's appening in your server ;)
#log = /tmp/mysqld.sql
#gdb
#debug = d:t:i:o,/tmp/mysqld.trace
#one-thread
# Uncomment the following if you are using BDB tables
#bdb_cache_size = 4M
#bdb_max_lock = 10000
# The following is the InnoDB configuration
# if you wish to disable innodb instead
# uncomment just the next line
#skip-innodb
#
# the rest of the innodb config follows:
# don't eat too much memory, we're trying to be safe on 64Mb boxes.
# you might want to bump this up a bit on boxes with more RAM
innodb_buffer_pool_size = 1024M
# this is the default, increase if you have lots of tables
innodb_additional_mem_pool_size = 32M
#
# i'd like to use /var/lib/mysql/innodb, but that is seen as a database :-(
# and upstream wants things to be under /var/lib/mysql/, so that's the route
# we have to take for the moment
#innodb_data_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
#innodb_log_group_home_dir = /var/lib/mysql/
# you may wish to change this size to be more suitable for your system
# the max is there to avoid run-away growth on your machine
innodb_data_file_path = ibdata1:10M:autoextend
# we keep this at around 25% of of innodb_buffer_pool_size
# sensible values range from 1MB to
(1/innodb_log_files_in_group*innodb_buffer_pool_size)
innodb_log_file_size = 1G
# this is the default, increase if you have very large transactions.
innodb_log_buffer_size = 32M
# this is the default, and won't hurt you.
# you shouldn't need to tweak it.
set-variable = innodb_log_files_in_group=2
# see the innodb config docs, the other options are not always safe
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 2048M
sort_buffer_size = 2048M
read_buffer = 128M
write_buffer = 128M
[mysqlhotcopy]
interactive-timeout
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
