ozkandonmez
Fri 23rd Jun '06, 8:57am
1. Dedicated server
2. cpu speed/type single or dual cpus): AMD dual opteron 248
how much memory installed: 3gb ram - after 3 days 4 GB
hard drive type/configuration: 2 x 80GB EIDE non raid
linux distributor or windows version: feebsd 4.x
apache/IIS version: Apache/1.3.34
PHP version: PHP 4.4.2
MySQL version: mysql 4.1.7
3. No innodb
4. No
5. last pid: 14598; load averages: 1.05, 1.37, 1.73 up 0+07:18:46 21:30:28
209 processes: 2 running, 202 sleeping, 5 zombie
CPU states: 54.5% user, 0.0% nice, 13.0% system, 0.0% interrupt, 32.6% idle
Mem: 256M Active, 1987M Inact, 272M Wired, 27M Cache, 199M Buf, 471M Free
Swap: 2048M Total, 2048M Free
6.
variable_name | Value |
+---------------------------------+------------------------------------------------------------+
| back_log | 50 |
| basedir | /usr/local/ |
| bdb_cache_size | 8388600 |
| bdb_home | /var/db/mysql/ |
| bdb_log_buffer_size | 768000 |
| bdb_logdir | |
| bdb_max_lock | 10000 |
| bdb_shared_data | OFF |
| bdb_tmpdir | /var/tmp/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 5 |
| datadir | /var/db/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | NO |
| have_bdb | YES |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_ndbcluster | DISABLED |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 ||
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 10 |
| max_write_lock_count | 4294967295 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 33554432 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 1000000 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 11095 |
| pid_file | /var/db/mysql/server.ozmena.net.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 33554432 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log_purge | ON |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slow_launch_time | 2 |
| socket | /tmp/mysql.sock |
| sort_buffer_size | 1048568 |
| sql_mode | |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| system_time_zone | EEST |
| table_cache | 1500 |
| table_type | MyISAM |
| thread_cache_size | 128 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 33554432 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.7 |
| version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (October 23, 2004) |
| version_comment | FreeBSD port: mysql-server-4.1.7 |
| version_compile_machine | i386 |
| version_compile_os | portbld-freebsd4.11 |
| wait_timeout | 10 |
+---------------------------------+------------------------------------------------------------+
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 97 |
| Aborted_connects | 121 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 44135067 |
| Bytes_sent | 3996512648 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 8182 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 925 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 2621 |
| Com_insert_select | 10 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 406 |
| Com_optimize | 0 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 270 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 42992 |
| Com_set_option | 56 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 0 |
| Com_show_variables | 1 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 406 |
| Com_update | 12652 |
| Com_update_multi | 0 |
| Connections | 8366 |
| Created_tmp_disk_tables | 15 |
| Created_tmp_files | 31 |
| Created_tmp_tables | 5259 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 2807 |
| Handler_discover | 0 |
| Handler_read_first | 2814 |
| Handler_read_key | 7421312 |
| Handler_read_next | 2319611 |
| Handler_read_prev | 114813 |
| Handler_read_rnd | 6211280 |
| Handler_read_rnd_next | 52276746 |
| Handler_rollback | 0 |
| Handler_update | 12366 |
| Handler_write | 6192118 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 0 |
| Key_blocks_used | 14497 |
| Key_read_requests | 22421239 |
| Key_reads | 30963 |
| Key_write_requests | 10104 |
| Key_writes | 6419 |
| Max_used_connections | 28 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 603 |
| Open_streams | 0 |
| Open_tables | 366 |
| Opened_tables | 377 |
| Qcache_free_blocks | 691 |
| Qcache_free_memory | 17483912 |
| Qcache_hits | 101689 |
| Qcache_inserts | 41710 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 1282 |
| Qcache_queries_in_cache | 2473 |
| Qcache_total_blocks | 6028 |
| Questions | 219933 |
| Rpl_status | NULL |
| Select_full_join | 1 |
| Select_full_range_join | 0 |
| Select_range | 8047 |
| Select_range_check | 0 |
| Select_scan | 12363 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 14 |
| Sort_range | 7638 |
| Sort_rows | 6689046 |
| Sort_scan | 8388 |
| Table_locks_immediate | 106871 |
| Table_locks_waited | 2375 |
| Threads_cached | 24 |
| Threads_connected | 4 |
| Threads_created | 28 |
| Threads_running | 2 |
| Uptime | 1993 |
+--------------------------+------------+
Uptime: 1993 Threads: 3 Questions: 219939 Slow queries: 0 Opens: 377 Flush tables: 1 Open tables: 366 Queries per second avg: 110.356
mysqladmin Ver 8.41 Distrib 4.1.7, for portbld-freebsd4.11 on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.1.7
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 33 min 13 sec
Threads: 3 Questions: 219939 Slow queries: 0 Opens: 377 Flush tables: 1 Open tables: 366 Queries per second avg: 110.356
7.
server# ./mysqlreport --all -tab
MySQL 4.1.7 uptime 0 0:42:16 Thu Jun 22 21:41:00 2006
__ Key __________________________________________________ _______________
Buffer usage 14.16M of 16.00M %Used: 88.48
Write ratio 0.67
Read ratio 0.00
__ Questions __________________________________________________ _________
Total 274.39k 108.20/s
QC Hits 126.91k 50.04/s %Total: 46.25
DMS 75.88k 29.92/s 27.65
+Unknown 49.46k 19.50/s 18.02
Com_ 11.54k 4.55/s 4.21
COM_QUIT 10.61k 4.18/s 3.87
Slow 0 0.00/s 0.00 %DMS: 0.00
DMS 75.88k 29.92/s 27.65
SELECT 54.93k 21.66/s 20.02 72.39
UPDATE 16.12k 6.36/s 5.87 21.24
INSERT 3.33k 1.31/s 1.21 4.38
DELETE 1.17k 0.46/s 0.43 1.54
REPLACE 334 0.13/s 0.12 0.44
Com_ 11.54k 4.55/s 4.21
change_db 10.45k 4.12/s 3.81
lock_tables 486 0.19/s 0.18
unlock_tabl 486 0.19/s 0.18
__ SELECT and Sort __________________________________________________ ___
Scan 15.79k 6.23/s %SELECT: 28.75
Range 10.11k 3.99/s 18.40
Full join 5 0.00/s 0.01
Range check 0 0.00/s 0.00
Full rng join 0 0.00/s 0.00
Sort scan 10.82k 4.27/s
Sort range 9.67k 3.81/s
Sort mrg pass 15 0.01/s
__ Query Cache __________________________________________________ _______
Memory usage 16.89M of 32.00M %Used: 52.77
Block Fragmnt 12.34%
Hits 126.91k 50.04/s
Inserts 53.31k 21.02/s
Prunes 1 0.00/s
Insrt:Prune 53.31k:1 21.02/s
Hit:Insert 2.38:1
__ Table Locks __________________________________________________ _______
Waited 2.95k 1.16/s %Total: 2.12
Immediate 136.34k 53.76/s
__ Tables __________________________________________________ ____________
Open 376 of 1500 %Cache: 25.07
Opened 387 0.15/s
__ Connections __________________________________________________ _______
Max used 28 of 350 %Max: 8.00
Total 10.68k 4.21/s
__ Created Temp __________________________________________________ ______
Disk table 19 0.01/s
Table 6.70k 2.64/s
File 33 0.01/s
__ Threads __________________________________________________ ___________
Running 2 of 2
Cache 26 %Hit: 99.74
Created 28 0.01/s
Slow 0 0.00/s
__ Aborted __________________________________________________ ___________
Clients 131 0.05/s
Connects 138 0.05/s
__ Bytes __________________________________________________ _____________
Sent 806.72M 318.11/s
Received 55.94M 22.06k/s
8. vB scripts and sites
9. avrega user : 1100, max. Users : 2964, cookie timeout : 2700
10. http://www.ozmena.com/phpinfo.php (http://www.ozmena.com/phpinfo.php)
11. KeepAlive : on
MaxKeepAliveRequests : 100
KeepAliveTimeout : 15
MinSpareServers : 5
MaxSpareServers : 10
StartServers : 10
MaxClients : 150
Maxrequestsperchild value = 5000
12. vB 3.5.4
13. find: -size: +2000000k: illegal trailing character
14.
server# uname –a
FreeBSD server.ozmena.net 4.11-RELEASE FreeBSD 4.11-RELEASE #0: Thu Mar 30 16:33:39 CST 2006 xxxxxx@server.ozmena.net:/usr/src/sys/compile/SMP i386
ulimit –aH not run
cat /proc/cpuinfo not run
2. cpu speed/type single or dual cpus): AMD dual opteron 248
how much memory installed: 3gb ram - after 3 days 4 GB
hard drive type/configuration: 2 x 80GB EIDE non raid
linux distributor or windows version: feebsd 4.x
apache/IIS version: Apache/1.3.34
PHP version: PHP 4.4.2
MySQL version: mysql 4.1.7
3. No innodb
4. No
5. last pid: 14598; load averages: 1.05, 1.37, 1.73 up 0+07:18:46 21:30:28
209 processes: 2 running, 202 sleeping, 5 zombie
CPU states: 54.5% user, 0.0% nice, 13.0% system, 0.0% interrupt, 32.6% idle
Mem: 256M Active, 1987M Inact, 272M Wired, 27M Cache, 199M Buf, 471M Free
Swap: 2048M Total, 2048M Free
6.
variable_name | Value |
+---------------------------------+------------------------------------------------------------+
| back_log | 50 |
| basedir | /usr/local/ |
| bdb_cache_size | 8388600 |
| bdb_home | /var/db/mysql/ |
| bdb_log_buffer_size | 768000 |
| bdb_logdir | |
| bdb_max_lock | 10000 |
| bdb_shared_data | OFF |
| bdb_tmpdir | /var/tmp/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 5 |
| datadir | /var/db/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | NO |
| have_bdb | YES |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_ndbcluster | DISABLED |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 ||
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 10 |
| max_write_lock_count | 4294967295 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 33554432 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 1000000 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 11095 |
| pid_file | /var/db/mysql/server.ozmena.net.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 33554432 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log_purge | ON |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slow_launch_time | 2 |
| socket | /tmp/mysql.sock |
| sort_buffer_size | 1048568 |
| sql_mode | |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| system_time_zone | EEST |
| table_cache | 1500 |
| table_type | MyISAM |
| thread_cache_size | 128 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 33554432 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.7 |
| version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (October 23, 2004) |
| version_comment | FreeBSD port: mysql-server-4.1.7 |
| version_compile_machine | i386 |
| version_compile_os | portbld-freebsd4.11 |
| wait_timeout | 10 |
+---------------------------------+------------------------------------------------------------+
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 97 |
| Aborted_connects | 121 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 44135067 |
| Bytes_sent | 3996512648 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 8182 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 925 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 2621 |
| Com_insert_select | 10 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 406 |
| Com_optimize | 0 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 270 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 42992 |
| Com_set_option | 56 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 0 |
| Com_show_variables | 1 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 406 |
| Com_update | 12652 |
| Com_update_multi | 0 |
| Connections | 8366 |
| Created_tmp_disk_tables | 15 |
| Created_tmp_files | 31 |
| Created_tmp_tables | 5259 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 2807 |
| Handler_discover | 0 |
| Handler_read_first | 2814 |
| Handler_read_key | 7421312 |
| Handler_read_next | 2319611 |
| Handler_read_prev | 114813 |
| Handler_read_rnd | 6211280 |
| Handler_read_rnd_next | 52276746 |
| Handler_rollback | 0 |
| Handler_update | 12366 |
| Handler_write | 6192118 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 0 |
| Key_blocks_used | 14497 |
| Key_read_requests | 22421239 |
| Key_reads | 30963 |
| Key_write_requests | 10104 |
| Key_writes | 6419 |
| Max_used_connections | 28 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 603 |
| Open_streams | 0 |
| Open_tables | 366 |
| Opened_tables | 377 |
| Qcache_free_blocks | 691 |
| Qcache_free_memory | 17483912 |
| Qcache_hits | 101689 |
| Qcache_inserts | 41710 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 1282 |
| Qcache_queries_in_cache | 2473 |
| Qcache_total_blocks | 6028 |
| Questions | 219933 |
| Rpl_status | NULL |
| Select_full_join | 1 |
| Select_full_range_join | 0 |
| Select_range | 8047 |
| Select_range_check | 0 |
| Select_scan | 12363 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 14 |
| Sort_range | 7638 |
| Sort_rows | 6689046 |
| Sort_scan | 8388 |
| Table_locks_immediate | 106871 |
| Table_locks_waited | 2375 |
| Threads_cached | 24 |
| Threads_connected | 4 |
| Threads_created | 28 |
| Threads_running | 2 |
| Uptime | 1993 |
+--------------------------+------------+
Uptime: 1993 Threads: 3 Questions: 219939 Slow queries: 0 Opens: 377 Flush tables: 1 Open tables: 366 Queries per second avg: 110.356
mysqladmin Ver 8.41 Distrib 4.1.7, for portbld-freebsd4.11 on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.1.7
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 33 min 13 sec
Threads: 3 Questions: 219939 Slow queries: 0 Opens: 377 Flush tables: 1 Open tables: 366 Queries per second avg: 110.356
7.
server# ./mysqlreport --all -tab
MySQL 4.1.7 uptime 0 0:42:16 Thu Jun 22 21:41:00 2006
__ Key __________________________________________________ _______________
Buffer usage 14.16M of 16.00M %Used: 88.48
Write ratio 0.67
Read ratio 0.00
__ Questions __________________________________________________ _________
Total 274.39k 108.20/s
QC Hits 126.91k 50.04/s %Total: 46.25
DMS 75.88k 29.92/s 27.65
+Unknown 49.46k 19.50/s 18.02
Com_ 11.54k 4.55/s 4.21
COM_QUIT 10.61k 4.18/s 3.87
Slow 0 0.00/s 0.00 %DMS: 0.00
DMS 75.88k 29.92/s 27.65
SELECT 54.93k 21.66/s 20.02 72.39
UPDATE 16.12k 6.36/s 5.87 21.24
INSERT 3.33k 1.31/s 1.21 4.38
DELETE 1.17k 0.46/s 0.43 1.54
REPLACE 334 0.13/s 0.12 0.44
Com_ 11.54k 4.55/s 4.21
change_db 10.45k 4.12/s 3.81
lock_tables 486 0.19/s 0.18
unlock_tabl 486 0.19/s 0.18
__ SELECT and Sort __________________________________________________ ___
Scan 15.79k 6.23/s %SELECT: 28.75
Range 10.11k 3.99/s 18.40
Full join 5 0.00/s 0.01
Range check 0 0.00/s 0.00
Full rng join 0 0.00/s 0.00
Sort scan 10.82k 4.27/s
Sort range 9.67k 3.81/s
Sort mrg pass 15 0.01/s
__ Query Cache __________________________________________________ _______
Memory usage 16.89M of 32.00M %Used: 52.77
Block Fragmnt 12.34%
Hits 126.91k 50.04/s
Inserts 53.31k 21.02/s
Prunes 1 0.00/s
Insrt:Prune 53.31k:1 21.02/s
Hit:Insert 2.38:1
__ Table Locks __________________________________________________ _______
Waited 2.95k 1.16/s %Total: 2.12
Immediate 136.34k 53.76/s
__ Tables __________________________________________________ ____________
Open 376 of 1500 %Cache: 25.07
Opened 387 0.15/s
__ Connections __________________________________________________ _______
Max used 28 of 350 %Max: 8.00
Total 10.68k 4.21/s
__ Created Temp __________________________________________________ ______
Disk table 19 0.01/s
Table 6.70k 2.64/s
File 33 0.01/s
__ Threads __________________________________________________ ___________
Running 2 of 2
Cache 26 %Hit: 99.74
Created 28 0.01/s
Slow 0 0.00/s
__ Aborted __________________________________________________ ___________
Clients 131 0.05/s
Connects 138 0.05/s
__ Bytes __________________________________________________ _____________
Sent 806.72M 318.11/s
Received 55.94M 22.06k/s
8. vB scripts and sites
9. avrega user : 1100, max. Users : 2964, cookie timeout : 2700
10. http://www.ozmena.com/phpinfo.php (http://www.ozmena.com/phpinfo.php)
11. KeepAlive : on
MaxKeepAliveRequests : 100
KeepAliveTimeout : 15
MinSpareServers : 5
MaxSpareServers : 10
StartServers : 10
MaxClients : 150
Maxrequestsperchild value = 5000
12. vB 3.5.4
13. find: -size: +2000000k: illegal trailing character
14.
server# uname –a
FreeBSD server.ozmena.net 4.11-RELEASE FreeBSD 4.11-RELEASE #0: Thu Mar 30 16:33:39 CST 2006 xxxxxx@server.ozmena.net:/usr/src/sys/compile/SMP i386
ulimit –aH not run
cat /proc/cpuinfo not run