Helza
Sat 9th Jun '01, 5:19pm
ok well i'm not sure if this is truely a mysql problem or a server problem.. but i thought lets give this a go ;)
My server is a RAQ4i with 128 memory (another 128 will be installed within the next 48 hours)
System Linux www.operationflashpoint.com 2.2.16C24_III #1 Thu Mar 22 21:17:39 PST 2001 i586 unknown
Build Date Jun 2 2001
Configure Command './configure' '--prefix=/usr' '--with-apxs=/usr/sbin/apxs' '--with-gd' '--with-gettext=/usr' '--enable-safe-mode' '--with-config-file-path=/etc/httpd' '--with-exec-dir=/usr/bin' '--enable-magic-quotes' '--with-regex=system' '--enable-track-vars' '--enable-xml' '--disable-debug' '--with-interbase=shared' '--with-pgsql=shared' '--with-ldap' '--with-imap' '--with-mysql'
Server API Apache
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc/httpd/php.ini
ZEND_DEBUG disabled
Thread Safety disabled
hope that should do for the technical magic :).. it doesn't mean anything to me .. hehehe
It has happened now 3 times within maybe 3 days that our server went totally balistic.. 100% cpu/memory use..
It wasn't even accepting telnet sessions anymore so we had to manually reboot it :( (which took 3 days.. gues ev1 had some problems with it.. hehe)
Anyway i just installed that stats.php . which you can find here:
http://www.operationflashpoint.com/admins/stats.php
some other settings:
+---------------------------------+-----------------------------------------+
| Variable_name | Value |
+---------------------------------+-----------------------------------------+
| ansi_mode | OFF |
| back_log | 50 |
| basedir | /home/mysql/ |
| binlog_cache_size | 32768 |
| character_set | latin1 |
| character_sets | latin1 big5 czech euc_kr gb2312 gbk sjis tis
620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1
251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON |
| connect_timeout | 5 |
| datadir | /home/mysql/data/ |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| flush | OFF |
| flush_time | 0 |
| have_bdb | NO |
| have_gemini | NO |
| have_innodb | NO |
| have_isam | YES |
| have_raid | NO |
| have_ssl | NO |
| init_file | |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 8388600 |
| language | /home/mysql/share/mysql/english/ |
| large_files_support | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_update | OFF |
| log_bin | OFF |
| log_slave_updates | OFF |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 1048576 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connections | 100 |
| max_connect_errors | 10 |
| max_delayed_threads | 20 |
| max_heap_table_size | 16777216 |
| max_join_size | 4294967295 |
| max_sort_length | 1024 |
| max_user_connections | 0 |
| max_tmp_tables | 32 |
| max_write_lock_count | 4294967295 |
| myisam_recover_options | OFF |
| myisam_max_extra_sort_file_size | 256 |
| myisam_max_sort_file_size | 2047 |
| myisam_sort_buffer_size | 8388608 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| open_files_limit | 0 |
| pid_file | /home/mysql/data/www.operationflashpoint.com
.pid |
| port | 3306 |
| protocol_version | 10 |
| record_buffer | 131072 |
| query_buffer_size | 0 |
| safe_show_database | OFF |
| server_id | 0 |
| skip_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /tmp/mysql.sock |
| sort_buffer | 2097144 |
| table_cache | 64 |
| table_type | MYISAM |
| thread_cache_size | 0 |
| thread_stack | 65536 |
| transaction_isolation | READ-COMMITTED |
| timezone | CDT |
| tmp_table_size | 1048576 |
| tmpdir | /tmp/ |
| version | 3.23.38 |
| wait_timeout | 28800 |
+---------------------------------+-----------------------------------------+
and (although the next one was taken a little earlier.. but not more then 30minutes) :
+--------------------------+----------+
| Variable_name | Value |
+--------------------------+----------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Bytes_received | 3546860 |
| Bytes_sent | 57091145 |
| Connections | 1247 |
| Created_tmp_disk_tables | 383 |
| Created_tmp_tables | 845 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 124 |
| Handler_read_first | 962 |
| Handler_read_key | 116590 |
| Handler_read_next | 133141 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 159140 |
| Handler_read_rnd_next | 704737 |
| Handler_update | 2409 |
| Handler_write | 5821 |
| Key_blocks_used | 759 |
| Key_read_requests | 514384 |
| Key_reads | 755 |
| Key_write_requests | 960 |
| Key_writes | 760 |
| Max_used_connections | 33 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 48 |
| Open_files | 88 |
| Open_streams | 0 |
| Opened_tables | 54 |
| Questions | 25507 |
| Select_full_join | 383 |
| Select_full_range_join | 0 |
| Select_range | 2985 |
| Select_range_check | 0 |
| Select_scan | 4621 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 2680 |
| Sort_rows | 161922 |
| Sort_scan | 3309 |
| Table_locks_immediate | 26732 |
| Table_locks_waited | 0 |
| Threads_cached | 0 |
| Threads_created | 1246 |
| Threads_connected | 29 |
| Threads_running | 1 |
| Uptime | 8665 |
+--------------------------+----------+
I noticed this with 13 users online at the stats.php:
Mem: 127868K av, 122368K used, 5500K free, 51180K shrd, 2716K buff
Swap: 131532K av, 32804K used, 98728K free 25844K cached
5mb free physical memory .... this is probably causing the server to go ballistic at times.. thats why i put in a order for 128 memory upgrade (from 128 to 256)
Any Help would be pretty much appreciated.. as i thing something is totally wrong here.. this wasn't a peak hour btw... max users online was 35 (since we moved to this server) but it flipped out today at 20 users or so..
ohyeah and take it easy with me.. I don't know anything about linux ;)
My server is a RAQ4i with 128 memory (another 128 will be installed within the next 48 hours)
System Linux www.operationflashpoint.com 2.2.16C24_III #1 Thu Mar 22 21:17:39 PST 2001 i586 unknown
Build Date Jun 2 2001
Configure Command './configure' '--prefix=/usr' '--with-apxs=/usr/sbin/apxs' '--with-gd' '--with-gettext=/usr' '--enable-safe-mode' '--with-config-file-path=/etc/httpd' '--with-exec-dir=/usr/bin' '--enable-magic-quotes' '--with-regex=system' '--enable-track-vars' '--enable-xml' '--disable-debug' '--with-interbase=shared' '--with-pgsql=shared' '--with-ldap' '--with-imap' '--with-mysql'
Server API Apache
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc/httpd/php.ini
ZEND_DEBUG disabled
Thread Safety disabled
hope that should do for the technical magic :).. it doesn't mean anything to me .. hehehe
It has happened now 3 times within maybe 3 days that our server went totally balistic.. 100% cpu/memory use..
It wasn't even accepting telnet sessions anymore so we had to manually reboot it :( (which took 3 days.. gues ev1 had some problems with it.. hehe)
Anyway i just installed that stats.php . which you can find here:
http://www.operationflashpoint.com/admins/stats.php
some other settings:
+---------------------------------+-----------------------------------------+
| Variable_name | Value |
+---------------------------------+-----------------------------------------+
| ansi_mode | OFF |
| back_log | 50 |
| basedir | /home/mysql/ |
| binlog_cache_size | 32768 |
| character_set | latin1 |
| character_sets | latin1 big5 czech euc_kr gb2312 gbk sjis tis
620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1
251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON |
| connect_timeout | 5 |
| datadir | /home/mysql/data/ |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| flush | OFF |
| flush_time | 0 |
| have_bdb | NO |
| have_gemini | NO |
| have_innodb | NO |
| have_isam | YES |
| have_raid | NO |
| have_ssl | NO |
| init_file | |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 8388600 |
| language | /home/mysql/share/mysql/english/ |
| large_files_support | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_update | OFF |
| log_bin | OFF |
| log_slave_updates | OFF |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 1048576 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connections | 100 |
| max_connect_errors | 10 |
| max_delayed_threads | 20 |
| max_heap_table_size | 16777216 |
| max_join_size | 4294967295 |
| max_sort_length | 1024 |
| max_user_connections | 0 |
| max_tmp_tables | 32 |
| max_write_lock_count | 4294967295 |
| myisam_recover_options | OFF |
| myisam_max_extra_sort_file_size | 256 |
| myisam_max_sort_file_size | 2047 |
| myisam_sort_buffer_size | 8388608 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| open_files_limit | 0 |
| pid_file | /home/mysql/data/www.operationflashpoint.com
.pid |
| port | 3306 |
| protocol_version | 10 |
| record_buffer | 131072 |
| query_buffer_size | 0 |
| safe_show_database | OFF |
| server_id | 0 |
| skip_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /tmp/mysql.sock |
| sort_buffer | 2097144 |
| table_cache | 64 |
| table_type | MYISAM |
| thread_cache_size | 0 |
| thread_stack | 65536 |
| transaction_isolation | READ-COMMITTED |
| timezone | CDT |
| tmp_table_size | 1048576 |
| tmpdir | /tmp/ |
| version | 3.23.38 |
| wait_timeout | 28800 |
+---------------------------------+-----------------------------------------+
and (although the next one was taken a little earlier.. but not more then 30minutes) :
+--------------------------+----------+
| Variable_name | Value |
+--------------------------+----------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Bytes_received | 3546860 |
| Bytes_sent | 57091145 |
| Connections | 1247 |
| Created_tmp_disk_tables | 383 |
| Created_tmp_tables | 845 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 124 |
| Handler_read_first | 962 |
| Handler_read_key | 116590 |
| Handler_read_next | 133141 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 159140 |
| Handler_read_rnd_next | 704737 |
| Handler_update | 2409 |
| Handler_write | 5821 |
| Key_blocks_used | 759 |
| Key_read_requests | 514384 |
| Key_reads | 755 |
| Key_write_requests | 960 |
| Key_writes | 760 |
| Max_used_connections | 33 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 48 |
| Open_files | 88 |
| Open_streams | 0 |
| Opened_tables | 54 |
| Questions | 25507 |
| Select_full_join | 383 |
| Select_full_range_join | 0 |
| Select_range | 2985 |
| Select_range_check | 0 |
| Select_scan | 4621 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 2680 |
| Sort_rows | 161922 |
| Sort_scan | 3309 |
| Table_locks_immediate | 26732 |
| Table_locks_waited | 0 |
| Threads_cached | 0 |
| Threads_created | 1246 |
| Threads_connected | 29 |
| Threads_running | 1 |
| Uptime | 8665 |
+--------------------------+----------+
I noticed this with 13 users online at the stats.php:
Mem: 127868K av, 122368K used, 5500K free, 51180K shrd, 2716K buff
Swap: 131532K av, 32804K used, 98728K free 25844K cached
5mb free physical memory .... this is probably causing the server to go ballistic at times.. thats why i put in a order for 128 memory upgrade (from 128 to 256)
Any Help would be pretty much appreciated.. as i thing something is totally wrong here.. this wasn't a peak hour btw... max users online was 35 (since we moved to this server) but it flipped out today at 20 users or so..
ohyeah and take it easy with me.. I don't know anything about linux ;)