vorlx
Tue 27th Jun '06, 7:29pm
I am currently running VB on a dedicated server but am about to migrate to a new server and wanted to make sure that I have the best settings possible.
The current settings have been played around with alot so don't laugh to hard if something is totally off base. My only current problems I have found in testing is how bad the server handles someone spam refreshing my main index. Apache seems to handle the connections but mysql just peaks to 99 and craps on itself. I have been working on trying to get iptables to throttle rapid connections to port 80 but havn't been 100% successful yet.
Anyway, please let me know what you think my best setup should be.
Also, I have been testing and researching having a seperate server for just a database. The question I had though is, is this a logical solution for a non internal lan scenario? Ie. I have 1 dedicated server at location a, and a second at location b. From testing it seems to work pretty well. I would be setting up a vpn between the 2 for security concerns.
1. Is this on dedicated or shared virual server. If shared, how many sites share this server (ask web host if needed)
Migrating to new dedicated server. I also host a few other websites in a seperate httpd but there traffic and mysql usage
is basically nill.
2. your server specs.
CPU: Pentium D 3.0ghz
Memory: 1gb
Hard Drive: 160gb sata, non raid.
Linux: CentOS Release 4.2 Final, 2.6.17.1 kernel.
Httpd: Apache 2.2.2
PHP: Php4.4.2
MYSQL: 4.1.20
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
No.
4. if possible how mysql was compiled/installed
Don't rememeber, but I can recompile if necessary.
5. Top Stats
*NOTE* This server is not 100% complete, there are a few other things that will be running. THe forum will also be active.
Main things not installed yet is the qmail/courierimap/vpopmail system. Our current server runs around .4-.5 on a single
celeron 2.53ghz system.
top - 16:53:04 up 11:46, 5 users, load average: 0.00, 0.00, 0.00
Tasks: 143 total, 1 running, 139 sleeping, 3 stopped, 0 zombie
Cpu(s): 0.0% us, 1.8% sy, 0.0% ni, 98.2% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 1024908k total, 478408k used, 546500k free, 40112k buffers
Swap: 2096472k total, 0k used, 2096472k free, 181296k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
9579 root 16 0 1952 988 748 R 2.6 0.1 0:01.27 top
1 root 16 0 1684 552 476 S 0.0 0.1 0:01.58 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.10 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.01 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.00 watchdog/0
5 root RT 0 0 0 0 S 0.0 0.0 0:00.12 migration/1
6 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
7 root RT 0 0 0 0 S 0.0 0.0 0:00.00 watchdog/1
8 root 10 -5 0 0 0 S 0.0 0.0 0:00.56 events/0
9 root 10 -5 0 0 0 S 0.0 0.0 0:00.04 events/1
10 root 19 -5 0 0 0 S 0.0 0.0 0:00.01 khelper
11 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kthread
14 root 10 -5 0 0 0 S 0.0 0.0 0:00.15 kblockd/0
15 root 10 -5 0 0 0 S 0.0 0.0 0:00.02 kblockd/1
16 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kseriod
342 root 20 0 0 0 0 S 0.0 0.0 0:00.00 pdflush
343 root 15 0 0 0 0 S 0.0 0.0 0:06.33 pdflush
344 root 16 0 0 0 0 S 0.0 0.0 0:06.76 kswapd0
345 root 13 -5 0 0 0 S 0.0 0.0 0:00.00 aio/0
346 root 13 -5 0 0 0 S 0.0 0.0 0:00.00 aio/1
347 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 cifsoplockd
348 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 cifsdnotifyd
853 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 ata/0
854 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 ata/1
858 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
859 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
877 root 16 0 0 0 0 S 0.0 0.0 0:00.00 mtdblockd
878 root 16 0 0 0 0 S 0.0 0.0 0:00.00 ftld
879 root 16 0 0 0 0 S 0.0 0.0 0:00.00 nftld
904 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kpsmoused
911 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 exec-osm/0
912 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 exec-osm/1
918 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 block-osm/0
920 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 block-osm/1
970 root 10 -5 0 0 0 S 0.0 0.0 0:07.74 kjournald
2353 root 11 -5 1584 452 384 S 0.0 0.0 0:00.01 udevd
2410 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kauditd
2451 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 kjournald
2905 root 16 0 1592 548 460 S 0.0 0.1 0:01.78 syslogd
2909 root 15 0 1544 368 304 S 0.0 0.0 0:01.10 klogd
2919 root 16 0 1544 304 224 S 0.0 0.0 0:00.11 irqbalance
2945 root 16 0 10960 4216 2256 S 0.0 0.4 0:06.93 snmpd
2954 root 15 0 4056 1136 832 S 0.0 0.1 0:00.35 sshd
2967 root 16 0 4708 916 524 S 0.0 0.1 0:00.08 crond
2984 root 16 0 1756 436 312 S 0.0 0.0 0:00.00 atd
2993 dbus 15 0 2436 800 660 S 0.0 0.1 0:00.01 dbus-daemon-1
3002 root 16 0 6032 4060 1288 S 0.0 0.4 0:01.13 hald
3170 root 16 0 7768 3804 1884 S 0.0 0.4 0:00.25 httpd
3183 apache 15 0 7964 3832 1688 S 0.0 0.4 0:00.00 httpd
3184 apache 15 0 7964 3924 1756 S 0.0 0.4 0:00.00 httpd
6. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf or my.ini so post the contents inside of my.cnf
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /chroot/www.halomega.com/tmp/mysql.sock
skip-innodb
max_connections = 100
thread_concurrency = 4
skip-locking
key_buffer = 16M
max_allowed_packet=8M
table_cache = 1024
sort_buffer_size = 2M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
record_buffer = 1M
tmp_table_size =32M
max_allowed_packet = 16M
myisam_sort_buffer_size = 64M
thread_cache = 64
query_cache_limit = 2M
query_cache_type = 1
query_cache_size = 64M
join_buffer = 1M
table_cache = 1024
interactive_timeout = 100
wait_timeout = 7200
connect_timeout = 10
max_connections = 10000
max_user_connections = 50
max_connect_errors = 10
[mysqld_safe]
open_files_limit = 8192
log-bin
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 64M
sort_buffer_size = 64M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 64M
sort_buffer_size = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
7. MySQL stats from ssh telnet as root user type:
+---------------------------------+-----------------------------------------+
| Variable_name | Value |
+---------------------------------+-----------------------------------------+
| back_log | 50 |
| basedir | /usr/local/mysql/ |
| 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/mysql/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 10 |
| datadir | /usr/local/mysql/data/ |
| 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 | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | DISABLED |
| have_isam | NO |
| have_ndbcluster | NO |
| 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 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 100 |
| join_buffer_size | 1044480 |
| key_buffer_size | 16777216 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/local/mysql/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | ON |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 10000 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 50 |
| 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 | 67108864 |
| myisam_stats_method | nulls_unequal |
| net_buffer_length | 8192 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 50010 |
| pid_file | /usr/local/mysql/data/web.aod.net.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 2097152 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 67108864 |
| 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 | 4190208 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 1 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| socket | /chroot/www.halomega.com/tmp/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | ON |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| system_time_zone | EST |
| table_cache | 1024 |
| table_type | MyISAM |
| thread_cache_size | 64 |
| 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.20-log |
| version_comment | Source distribution |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 7200 |
+---------------------------------+-----------------------------------------+
+----------------------------+----------+
| Variable_name | Value |
+----------------------------+----------+
| Aborted_clients | 96 |
| Aborted_connects | 12 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 81787578 |
| Bytes_sent | 44792147 |
| Com_admin_commands | 87 |
| Com_alter_db | 0 |
| Com_alter_table | 480 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 130 |
| 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 | 240 |
| Com_dealloc_sql | 0 |
| Com_delete | 3 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 240 |
| 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 | 280 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 240 |
| 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 | 10 |
| 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 | 491 |
| Com_set_option | 16 |
| 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_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 1 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 40 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 1 |
| Com_show_variables | 4 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 240 |
| Com_update | 247 |
| Com_update_multi | 0 |
| Connections | 107 |
| Created_tmp_disk_tables | 8 |
| Created_tmp_files | 0 |
| Created_tmp_tables | 18 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 1 |
| Handler_discover | 0 |
| Handler_read_first | 237 |
| Handler_read_key | 4734 |
| Handler_read_next | 65776 |
| Handler_read_prev | 52 |
| Handler_read_rnd | 4421 |
| Handler_read_rnd_next | 1092230 |
| Handler_rollback | 0 |
| Handler_update | 180 |
| Handler_write | 953814 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 14494 |
| Key_blocks_used | 4520 |
| Key_read_requests | 3089836 |
| Key_reads | 14645 |
| Key_write_requests | 1214967 |
| Key_writes | 14278 |
| Max_used_connections | 37 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 12 |
| Open_streams | 0 |
| Open_tables | 5 |
| Opened_tables | 878 |
| Qcache_free_blocks | 1 |
| Qcache_free_memory | 67100000 |
| Qcache_hits | 525 |
| Qcache_inserts | 427 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 64 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 1 |
| Questions | 3194 |
| Rpl_status | NULL |
| Select_full_join | 11 |
| Select_full_range_join | 0 |
| Select_range | 64 |
| Select_range_check | 0 |
| Select_scan | 145 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 19 |
| Sort_rows | 6748 |
| Sort_scan | 47 |
| Table_locks_immediate | 1994 |
| Table_locks_waited | 1 |
| Threads_cached | 35 |
| Threads_connected | 2 |
| Threads_created | 37 |
| Threads_running | 1 |
| Uptime | 25652 |
+----------------------------+----------+
Uptime: 25652 Threads: 2 Questions: 3195 Slow queries: 0 Opens: 878 Flush tables: 1 Open tables: 5 Queries per
second avg: 0.125
mysqladmin Ver 8.41 Distrib 4.1.12, for redhat-linux-gnu on i686
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.20-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 7 hours 7 min 32 sec
Threads: 2 Questions: 3195 Slow queries: 0 Opens: 878 Flush tables: 1 Open tables: 5 Queries per second avg: 0.125
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
At the present time the main thing running is VB, there are a couple extremely small sites that utilize basic php/mysql.
The usage is extremley low.
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
About 120 average, 188 was our max a few days ago, the site is constantly growing so I need settings that will handle 250-300 if possible.
The cookie timeout is 60 min.
10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
http://www.halomega.net/phpinfo.php
11. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :
KeepAlive - on
MaxKeepAliveRequests - 100
KeepAliveTimeout - 10
MinSpareServers - 15
MaxSpareServers - 40
StartServers - 30
MaxClients - 200
AND Maxrequestsperchild value = 5000
12. what version of vB are you running ?
3.5.4
13. check to see if any files i.e. apache log files are hitting 2GB or 4GB max file size limits i.e. see if you have max file size exceeded messages in apache error log
All relevant log files are rotated on a daily basis, there are no large files.
14. Post output from these 3 commands
Linux web.aod.net 2.6.17.1 #2 SMP Tue Jun 27 05:02:31 EST 2006 i686 i686 i386 GNU/Linux
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 16360
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 16360
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) D CPU 3.00GHz
stepping : 4
cpu MHz : 2993.250
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc pni monitor ds_cpl est cid cx16 xtpr
bogomips : 5994.91
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) D CPU 3.00GHz
stepping : 4
cpu MHz : 2993.250
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc pni monitor ds_cpl est cid cx16 xtpr
bogomips : 5985.75
The current settings have been played around with alot so don't laugh to hard if something is totally off base. My only current problems I have found in testing is how bad the server handles someone spam refreshing my main index. Apache seems to handle the connections but mysql just peaks to 99 and craps on itself. I have been working on trying to get iptables to throttle rapid connections to port 80 but havn't been 100% successful yet.
Anyway, please let me know what you think my best setup should be.
Also, I have been testing and researching having a seperate server for just a database. The question I had though is, is this a logical solution for a non internal lan scenario? Ie. I have 1 dedicated server at location a, and a second at location b. From testing it seems to work pretty well. I would be setting up a vpn between the 2 for security concerns.
1. Is this on dedicated or shared virual server. If shared, how many sites share this server (ask web host if needed)
Migrating to new dedicated server. I also host a few other websites in a seperate httpd but there traffic and mysql usage
is basically nill.
2. your server specs.
CPU: Pentium D 3.0ghz
Memory: 1gb
Hard Drive: 160gb sata, non raid.
Linux: CentOS Release 4.2 Final, 2.6.17.1 kernel.
Httpd: Apache 2.2.2
PHP: Php4.4.2
MYSQL: 4.1.20
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
No.
4. if possible how mysql was compiled/installed
Don't rememeber, but I can recompile if necessary.
5. Top Stats
*NOTE* This server is not 100% complete, there are a few other things that will be running. THe forum will also be active.
Main things not installed yet is the qmail/courierimap/vpopmail system. Our current server runs around .4-.5 on a single
celeron 2.53ghz system.
top - 16:53:04 up 11:46, 5 users, load average: 0.00, 0.00, 0.00
Tasks: 143 total, 1 running, 139 sleeping, 3 stopped, 0 zombie
Cpu(s): 0.0% us, 1.8% sy, 0.0% ni, 98.2% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 1024908k total, 478408k used, 546500k free, 40112k buffers
Swap: 2096472k total, 0k used, 2096472k free, 181296k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
9579 root 16 0 1952 988 748 R 2.6 0.1 0:01.27 top
1 root 16 0 1684 552 476 S 0.0 0.1 0:01.58 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.10 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.01 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.00 watchdog/0
5 root RT 0 0 0 0 S 0.0 0.0 0:00.12 migration/1
6 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
7 root RT 0 0 0 0 S 0.0 0.0 0:00.00 watchdog/1
8 root 10 -5 0 0 0 S 0.0 0.0 0:00.56 events/0
9 root 10 -5 0 0 0 S 0.0 0.0 0:00.04 events/1
10 root 19 -5 0 0 0 S 0.0 0.0 0:00.01 khelper
11 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kthread
14 root 10 -5 0 0 0 S 0.0 0.0 0:00.15 kblockd/0
15 root 10 -5 0 0 0 S 0.0 0.0 0:00.02 kblockd/1
16 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kseriod
342 root 20 0 0 0 0 S 0.0 0.0 0:00.00 pdflush
343 root 15 0 0 0 0 S 0.0 0.0 0:06.33 pdflush
344 root 16 0 0 0 0 S 0.0 0.0 0:06.76 kswapd0
345 root 13 -5 0 0 0 S 0.0 0.0 0:00.00 aio/0
346 root 13 -5 0 0 0 S 0.0 0.0 0:00.00 aio/1
347 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 cifsoplockd
348 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 cifsdnotifyd
853 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 ata/0
854 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 ata/1
858 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
859 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
877 root 16 0 0 0 0 S 0.0 0.0 0:00.00 mtdblockd
878 root 16 0 0 0 0 S 0.0 0.0 0:00.00 ftld
879 root 16 0 0 0 0 S 0.0 0.0 0:00.00 nftld
904 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kpsmoused
911 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 exec-osm/0
912 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 exec-osm/1
918 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 block-osm/0
920 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 block-osm/1
970 root 10 -5 0 0 0 S 0.0 0.0 0:07.74 kjournald
2353 root 11 -5 1584 452 384 S 0.0 0.0 0:00.01 udevd
2410 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kauditd
2451 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 kjournald
2905 root 16 0 1592 548 460 S 0.0 0.1 0:01.78 syslogd
2909 root 15 0 1544 368 304 S 0.0 0.0 0:01.10 klogd
2919 root 16 0 1544 304 224 S 0.0 0.0 0:00.11 irqbalance
2945 root 16 0 10960 4216 2256 S 0.0 0.4 0:06.93 snmpd
2954 root 15 0 4056 1136 832 S 0.0 0.1 0:00.35 sshd
2967 root 16 0 4708 916 524 S 0.0 0.1 0:00.08 crond
2984 root 16 0 1756 436 312 S 0.0 0.0 0:00.00 atd
2993 dbus 15 0 2436 800 660 S 0.0 0.1 0:00.01 dbus-daemon-1
3002 root 16 0 6032 4060 1288 S 0.0 0.4 0:01.13 hald
3170 root 16 0 7768 3804 1884 S 0.0 0.4 0:00.25 httpd
3183 apache 15 0 7964 3832 1688 S 0.0 0.4 0:00.00 httpd
3184 apache 15 0 7964 3924 1756 S 0.0 0.4 0:00.00 httpd
6. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf or my.ini so post the contents inside of my.cnf
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /chroot/www.halomega.com/tmp/mysql.sock
skip-innodb
max_connections = 100
thread_concurrency = 4
skip-locking
key_buffer = 16M
max_allowed_packet=8M
table_cache = 1024
sort_buffer_size = 2M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
record_buffer = 1M
tmp_table_size =32M
max_allowed_packet = 16M
myisam_sort_buffer_size = 64M
thread_cache = 64
query_cache_limit = 2M
query_cache_type = 1
query_cache_size = 64M
join_buffer = 1M
table_cache = 1024
interactive_timeout = 100
wait_timeout = 7200
connect_timeout = 10
max_connections = 10000
max_user_connections = 50
max_connect_errors = 10
[mysqld_safe]
open_files_limit = 8192
log-bin
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 64M
sort_buffer_size = 64M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 64M
sort_buffer_size = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
7. MySQL stats from ssh telnet as root user type:
+---------------------------------+-----------------------------------------+
| Variable_name | Value |
+---------------------------------+-----------------------------------------+
| back_log | 50 |
| basedir | /usr/local/mysql/ |
| 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/mysql/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 10 |
| datadir | /usr/local/mysql/data/ |
| 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 | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | DISABLED |
| have_isam | NO |
| have_ndbcluster | NO |
| 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 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 100 |
| join_buffer_size | 1044480 |
| key_buffer_size | 16777216 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/local/mysql/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | ON |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 10000 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 50 |
| 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 | 67108864 |
| myisam_stats_method | nulls_unequal |
| net_buffer_length | 8192 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 50010 |
| pid_file | /usr/local/mysql/data/web.aod.net.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 2097152 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 67108864 |
| 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 | 4190208 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 1 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| socket | /chroot/www.halomega.com/tmp/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | ON |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| system_time_zone | EST |
| table_cache | 1024 |
| table_type | MyISAM |
| thread_cache_size | 64 |
| 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.20-log |
| version_comment | Source distribution |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 7200 |
+---------------------------------+-----------------------------------------+
+----------------------------+----------+
| Variable_name | Value |
+----------------------------+----------+
| Aborted_clients | 96 |
| Aborted_connects | 12 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 81787578 |
| Bytes_sent | 44792147 |
| Com_admin_commands | 87 |
| Com_alter_db | 0 |
| Com_alter_table | 480 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 130 |
| 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 | 240 |
| Com_dealloc_sql | 0 |
| Com_delete | 3 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 240 |
| 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 | 280 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 240 |
| 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 | 10 |
| 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 | 491 |
| Com_set_option | 16 |
| 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_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 1 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 40 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 1 |
| Com_show_variables | 4 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 240 |
| Com_update | 247 |
| Com_update_multi | 0 |
| Connections | 107 |
| Created_tmp_disk_tables | 8 |
| Created_tmp_files | 0 |
| Created_tmp_tables | 18 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 1 |
| Handler_discover | 0 |
| Handler_read_first | 237 |
| Handler_read_key | 4734 |
| Handler_read_next | 65776 |
| Handler_read_prev | 52 |
| Handler_read_rnd | 4421 |
| Handler_read_rnd_next | 1092230 |
| Handler_rollback | 0 |
| Handler_update | 180 |
| Handler_write | 953814 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 14494 |
| Key_blocks_used | 4520 |
| Key_read_requests | 3089836 |
| Key_reads | 14645 |
| Key_write_requests | 1214967 |
| Key_writes | 14278 |
| Max_used_connections | 37 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 12 |
| Open_streams | 0 |
| Open_tables | 5 |
| Opened_tables | 878 |
| Qcache_free_blocks | 1 |
| Qcache_free_memory | 67100000 |
| Qcache_hits | 525 |
| Qcache_inserts | 427 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 64 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 1 |
| Questions | 3194 |
| Rpl_status | NULL |
| Select_full_join | 11 |
| Select_full_range_join | 0 |
| Select_range | 64 |
| Select_range_check | 0 |
| Select_scan | 145 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 19 |
| Sort_rows | 6748 |
| Sort_scan | 47 |
| Table_locks_immediate | 1994 |
| Table_locks_waited | 1 |
| Threads_cached | 35 |
| Threads_connected | 2 |
| Threads_created | 37 |
| Threads_running | 1 |
| Uptime | 25652 |
+----------------------------+----------+
Uptime: 25652 Threads: 2 Questions: 3195 Slow queries: 0 Opens: 878 Flush tables: 1 Open tables: 5 Queries per
second avg: 0.125
mysqladmin Ver 8.41 Distrib 4.1.12, for redhat-linux-gnu on i686
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.20-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 7 hours 7 min 32 sec
Threads: 2 Questions: 3195 Slow queries: 0 Opens: 878 Flush tables: 1 Open tables: 5 Queries per second avg: 0.125
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
At the present time the main thing running is VB, there are a couple extremely small sites that utilize basic php/mysql.
The usage is extremley low.
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
About 120 average, 188 was our max a few days ago, the site is constantly growing so I need settings that will handle 250-300 if possible.
The cookie timeout is 60 min.
10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
http://www.halomega.net/phpinfo.php
11. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :
KeepAlive - on
MaxKeepAliveRequests - 100
KeepAliveTimeout - 10
MinSpareServers - 15
MaxSpareServers - 40
StartServers - 30
MaxClients - 200
AND Maxrequestsperchild value = 5000
12. what version of vB are you running ?
3.5.4
13. check to see if any files i.e. apache log files are hitting 2GB or 4GB max file size limits i.e. see if you have max file size exceeded messages in apache error log
All relevant log files are rotated on a daily basis, there are no large files.
14. Post output from these 3 commands
Linux web.aod.net 2.6.17.1 #2 SMP Tue Jun 27 05:02:31 EST 2006 i686 i686 i386 GNU/Linux
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 16360
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 16360
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) D CPU 3.00GHz
stepping : 4
cpu MHz : 2993.250
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc pni monitor ds_cpl est cid cx16 xtpr
bogomips : 5994.91
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) D CPU 3.00GHz
stepping : 4
cpu MHz : 2993.250
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc pni monitor ds_cpl est cid cx16 xtpr
bogomips : 5985.75