[EMAIL PROTECTED] wrote: > uname -a: > Linux parthenon 2.4.26-openmosix1 #10 SMP Wed Sep 14 10:18:08 EDT 2005 > i686 i686 i386 GNU/Linux > > > free -m > total used free shared buffers > cached > Mem: 11841 11594 246 0 97 > 10076 > -/+ buffers/cache: 1419 10421 > Swap: 6655 392 6263 >
You might be running out of virtual memory in mysql. I guess your system has 2GB virtual memory available for each applications user space (the Linux 2.4 kernel has a 2GB:2GB user/kernel split). You are spending quite of lot of heap for buffers and your system probably has 2MB of spacing between each mysql thread. I guess what happens is that at some point you get a lot of connections and that glibc starts allocating thread stacks right in the innodb_buffer_pool. Your solution would be to set a maximum on the number of connections (50-100?) and reduce the buffers you don't need. Try this for a few weeks and if you still have trouble come back to us. If you can't do this then you need to migrate some of the mysql databases of to another machine. > ################### /etc/my.cnf ####################################### > # Example MySQL config file for large systems. > # > # This is for a large system with memory = 512M where the system runs mainly > # MySQL. > > # The following options will be passed to all MySQL clients > [client] > #password = your_password > port = 3306 > socket = /var/lib/mysql/mysql.sock > > # Here follows entries for some specific programs > > # The MySQL server > [mysqld] > port = 3306 > socket = /var/lib/mysql/mysql.sock > skip-locking > key_buffer = 256M > Do you use a lot of myisam? > max_allowed_packet = 8M > table_cache = 256 > sort_buffer_size = 1M > read_buffer_size = 1M > read_rnd_buffer_size = 4M > myisam_sort_buffer_size = 64M > > thread_cache_size = 8 > thread_cache is ususaly not needed on linux. Linux has fast thread creation. > query_cache_size= 16M > # Try number of CPU's*2 for thread_concurrency > thread_concurrency = 4 > > > # Replication Master Server (default) > # binary logging is required for replication > log-bin=mysql-bin > > # required unique id between 1 and 2^32 - 1 > # defaults to 1 if master-host is not set > # but will not function as a master if omitted > server-id = 1 > > > # Point the following paths to different dedicated disks > tmpdir = /san3/var/tmp # It's a faster disk than / > #log-update = /path-to-dedicated-directory/hostname > > # Uncomment the following if you are using BDB tables > #bdb_cache_size = 64M > #bdb_max_lock = 100000 > > # Uncomment the following if you are using InnoDB tables > innodb_data_home_dir = /var/lib/mysql/ > innodb_data_file_path = ibdata1:100M: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 = 512M > #innodb_additional_mem_pool_size = 20M > # Set .._log_file_size to 25 % of buffer pool size > innodb_log_file_size = 256M # Default is 64M > innodb_log_buffer_size = 64M # Default is 8M > This last one doesnt make sense. You gain nothing. Set it back to 8M. > innodb_flush_log_at_trx_commit = 1 > innodb_lock_wait_timeout = 75 > > [mysqldump] > quick > max_allowed_packet = 64M > > [mysql] > no-auto-rehash > # Remove the next comment character if you are not familiar with SQL > safe-updates > > [isamchk] > key_buffer = 128M > sort_buffer_size = 128M > read_buffer = 2M > write_buffer = 2M > > [myisamchk] > key_buffer = 128M > sort_buffer_size = 128M > read_buffer = 2M > write_buffer = 2M > > [mysqlhotcopy] > interactive-timeout > ########################################################################### > > Yes, the machine is doing way too many things to be the best choice for a > bacula server...but that's going to change very soon. > > > Thanks for all your help, > Good luck. Per. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
