From: Gleb Paharenko (gleb.paharenkoensita.net)
Date: Sun Oct 02 2005 - 05:58:35 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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
 / /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenkoensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
       <___/ www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]