BAUMEISTER Alexandre writes:
> Sinisa,
>
> SM> > SM> Alex, you ran out of filedescriptors or out of anodes, depending
on OS
> SM> > SM> that you are using.
> SM> >
> SM> > I though filedescriptors could be the problem. I only had 256. I
> SM> > modified the system in order to have 1024 :
> SM> >
> SM> >
=========================================================================
> SM> > [1:16pm]# ulimit -a
> SM> > time(seconds) unlimited
> SM> > file(blocks) unlimited
> SM> > data(kbytes) unlimited
> SM> > stack(kbytes) 8192
> SM> > coredump(blocks) 0
> SM> > nofiles(descriptors) 1024
> SM> > vmemory(kbytes) unlimited
> SM> >
=========================================================================
> SM> >
> SM> > But still :
> SM> >
=========================================================================
> SM> > 010321 13:22:42 Warning: Got signal 14 from thread 4
> SM> > 010321 13:22:44 Warning: Got signal 14 from thread 8
> SM> > 010321 13:22:46 Warning: Got signal 14 from thread 5
> SM> > 010321 13:22:48 Warning: Got signal 14 from thread 8
> SM> > 010321 13:22:50 Warning: Got signal 14 from thread 4
> SM> > 010321 13:22:52 Warning: Got signal 14 from thread 4
> SM> > 010321 13:22:54 Warning: Got signal 14 from thread 4
> SM> > 010321 13:22:56 Warning: Got signal 14 from thread 4
> SM> > 010321 13:22:58 Warning: Got signal 14 from thread 8
> SM> > 010321 13:23:00 Warning: Got signal 14 from thread 8
> SM> >
=========================================================================
> SM> >
> SM> > How to know if filedescriptors or anode are the problem ?
> SM> >
> SM> > The extended stats below shows
> SM> >
> SM> > | Max_used_connections | 17 |
> SM> > | Open_files | 8 |
> SM> > | Open_tables | 18 |
> SM> >
> SM> > I'm fare from 1024 filedescriptors.
> SM> >
> SM> >
=========================================================================
> SM> > [1:23pm]# mysqladmin ext
> SM> > +--------------------------+---------+
> SM> > | Variable_name | Value |
> SM> > +--------------------------+---------+
> SM> > | Aborted_clients | 0 |
> SM> > | Aborted_connects | 0 |
> SM> > | Bytes_received | 1009183 |
> SM> > | Bytes_sent | 468860 |
> SM> > | Connections | 46 |
> SM> > | Created_tmp_disk_tables | 1 |
> SM> > | Created_tmp_tables | 1 |
> SM> > | Created_tmp_files | 0 |
> SM> > | Delayed_insert_threads | 0 |
> SM> > | Delayed_writes | 0 |
> SM> > | Delayed_errors | 0 |
> SM> > | Flush_commands | 1 |
> SM> > | Handler_delete | 0 |
> SM> > | Handler_read_first | 1 |
> SM> > | Handler_read_key | 18430 |
> SM> > | Handler_read_next | 3 |
> SM> > | Handler_read_prev | 0 |
> SM> > | Handler_read_rnd | 6 |
> SM> > | Handler_read_rnd_next | 48 |
> SM> > | Handler_update | 0 |
> SM> > | Handler_write | 70 |
> SM> > | Key_blocks_used | 3 |
> SM> > | Key_read_requests | 7 |
> SM> > | Key_reads | 3 |
> SM> > | Key_write_requests | 0 |
> SM> > | Key_writes | 0 |
> SM> > | Max_used_connections | 17 |
> SM> > | Not_flushed_key_blocks | 0 |
> SM> > | Not_flushed_delayed_rows | 0 |
> SM> > | Open_tables | 18 |
> SM> > | Open_files | 8 |
> SM> > | Open_streams | 0 |
> SM> > | Opened_tables | 24 |
> SM> > | Questions | 9331 |
> SM> > | Select_full_join | 0 |
> SM> > | Select_full_range_join | 0 |
> SM> > | Select_range | 0 |
> SM> > | Select_range_check | 0 |
> SM> > | Select_scan | 1 |
> SM> > | Slave_running | OFF |
> SM> > | Slave_open_temp_tables | 0 |
> SM> > | Slow_launch_threads | 0 |
> SM> > | Slow_queries | 0 |
> SM> > | Sort_merge_passes | 0 |
> SM> > | Sort_range | 0 |
> SM> > | Sort_rows | 6 |
> SM> > | Sort_scan | 2 |
> SM> > | Table_locks_immediate | 9308 |
> SM> > | Table_locks_waited | 0 |
> SM> > | Threads_cached | 0 |
> SM> > | Threads_created | 18 |
> SM> > | Threads_connected | 18 |
> SM> > | Threads_running | 1 |
> SM> > | Uptime | 501 |
> SM> > +--------------------------+---------+
> SM> >
> SM> > SM> It could also be caused by a bug in TCP/IP part of the kernel,
but the
> SM> > SM> above causes are much more likely.
> SM> >
> SM> > TCP/IP ? How to know if it could be the problem ?
> SM> >
> SM> > SM> Check out both your global and ulimit values.
> SM> >
> SM> > I have copied "ulimit -a" exit in this email.
> SM> >
> SM> >
> SM> > Regards,
> SM> > Alex.
> SM> >
> SM> >
> SM> >
>
> SM> What OS is that ??
>
>
> From mysqlbug :
>
> Server version 3.23.35
> Protocol version 10
> Connection Localhost via UNIX socket
> UNIX socket /tmp/mysql.sock
> Uptime: 3 min 50 sec
>
> Threads: 15 Questions: 15489 Slow queries: 0 Opens: 20 Flush tables: 1 Open
tables: 14 Queries per second avg: 67.343
> >Environment:
> <machine, os, target, libraries (multiple lines)>
> System: SunOS sun01381 5.8 Generic_108528-04 sun4u sparc SUNW,Ultra-80
> Architecture: sun4
>
> Some paths: /bin/perl /usr/ccs/bin/make /usr/local/bin/gmake /usr/local/bin/gcc
/usr/ucb/cc
> GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.2/specs
> gcc version 2.95.2 19991024 (release)
>
>
>
And all connections are on the localhost ??
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
