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