> > > How-To-Repeat: Generate plenty of mysql connections until the machine
> > > starts swapping. When the bug is triggered, you will not be able to
> > > connect to mysqld anymore and if you kill off all other processes, you
> > > will find mysql happily taking up all CPU that is available to run its
> > > infinite loop.
> >
> > Please prepare Repeatable Test case including version or MySQL, how it
was
> > installed and and my.cnf file.
>
> Argh! Sorry forgot. version 3.23.55. Compiled from source tar ball
including
> '--with-innodb' in the parameters to configure. The other parameters are
> location type ones.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = thread_cache_size=700
set-variable = table_cache=850
set-variable = key_buffer_size=16M
set-variable = max_connections=850
set-variable = max_connect_errors=999999999
skip-name-resolve
skip-locking
memlock
master-host=
master-user=
master-password=
master-port=
master-connect-retry=
server-id=
#myisam-sort-buffer-size=200M
#myisam-max-sort-file-size=200M
####### INNODB CONFIG #######
innodb_data_home_dir = /var/lib/mysql/innodbdata
innodb_data_file_path = datafile:4096M:autoextend
set-variable = innodb_buffer_pool_size=24M
set-variable = innodb_additional_mem_pool_size=8M
innodb_log_group_home_dir = /var/lib/mysql/innodblog
innodb_log_arch_dir = /var/lib/mysql/innodblog
set-variable = innodb_log_file_size=10M
set-variable = innodb_log_buffer_size=8M
set-variable = innodb_thread_concurrency=20
innodb_flush_log_at_trx_commit=0
#############################
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/lib/mysql/mysqld.log
pid-file=/var/lib/mysql/mysqld.pid
>
> >
> > mysqlbug script can help you dong this.
> >
> > Without knowing even version you use we don't have smallest chance to
try
> > repeating your problem. We can only guess what it might be and this
can't
> help you
> > a lot.
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail bugs-thread13943@stripped
> To unsubscribe, e-mail <bugs-unsubscribe@stripped>
>
>
