Hello.
Sorry for a delayed answer. Could you provide a whole error message with a resolved stack trace? Check if the problem remains when you switch to the official binaries. David Sparks wrote: > 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 > > > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
