kambiz
Thu 14th Dec '06, 3:46am
1-Dedicated
2-specs:
P4 3.6 HT
Ram 2GB
250GB HDD SATA non raid
Centos 4.4 32 bit
Lighttpd 1.4.11
PHP as FastCGI 4.4.4
Mysql 4.1.20
3-mysql 4.x
4-mysql installed
5-
top - 21:28:28 up 13 days, 8:55, 1 user, load average: 0.26, 0.19, 0.16
Tasks: 102 total, 1 running, 100 sleeping, 0 stopped, 1 zombie
Cpu(s): 0.8% us, 1.2% sy, 0.0% ni, 97.2% id, 0.8% wa, 0.0% hi, 0.0% si
Mem: 2066668k total, 2045656k used, 21012k free, 63432k buffers
Swap: 2040244k total, 14016k used, 2026228k free, 1633000k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
21015 mysql 16 0 120m 77m 3268 S 2 3.8 160:32.77 mysqld
2264 lighttpd 15 0 12392 10m 716 S 2 0.5 27:31.32 lighttpd
13034 lighttpd 16 0 49732 17m 12m S 1 0.9 1:07.70 php
13030 lighttpd 17 0 47772 15m 11m S 0 0.8 1:08.30 php
24990 root 16 0 2868 984 760 R 0 0.0 0:08.31 top
1 root 16 0 3548 552 472 S 0 0.0 0:02.84 init
2 root RT 0 0 0 0 S 0 0.0 0:00.90 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:02.48 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.95 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.23 ksoftirqd/1
6 root 5 -10 0 0 0 S 0 0.0 0:00.09 events/0
7 root 5 -10 0 0 0 S 0 0.0 0:00.03 events/1
8 root 5 -10 0 0 0 S 0 0.0 0:00.00 khelper
9 root 15 -10 0 0 0 S 0 0.0 0:00.00 kacpid
29 root 5 -10 0 0 0 S 0 0.0 0:00.10 kblockd/0
30 root 5 -10 0 0 0 S 0 0.0 0:00.03 kblockd/1
31 root 15 0 0 0 0 S 0 0.0 0:00.00 khubd
51 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/0
52 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/1
50 root 15 0 0 0 0 S 0 0.0 1:56.96 kswapd0
198 root 25 0 0 0 0 S 0 0.0 0:00.00 kseriod
308 root 5 -10 0 0 0 S 0 0.0 0:00.03 ata/0
309 root 5 -10 0 0 0 S 0 0.0 0:00.03 ata/1
313 root 23 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_0
314 root 23 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_1
334 root 15 0 0 0 0 S 0 0.0 1:43.66 kjournald
1524 root 6 -10 2656 460 380 S 0 0.0 0:00.02 udevd
1955 root 6 -10 0 0 0 S 0 0.0 0:00.00 kauditd
2020 root 7 -10 0 0 0 S 0 0.0 0:00.00 kmirrord
2038 root 15 0 0 0 0 S 0 0.0 0:00.00 kjournald
2039 root 15 0 0 0 0 S 0 0.0 0:16.43 kjournald
2593 root 16 0 5624 1040 744 S 0 0.1 0:00.06 sshd
3183 root 16 0 2460 300 220 S 0 0.0 0:01.01 irqbalance
3211 root 16 0 4840 340 172 S 0 0.0 0:01.82 rpc.idmapd
3269 root 15 0 3104 508 300 S 0 0.0 0:00.12 smartd
3278 root 19 0 3356 436 368 S 0 0.0 0:00.00 acpid
3301 root 18 0 3304 756 624 S 0 0.0 0:00.00 xinetd
3318 ntp 16 0 4672 4672 3436 S 0 0.2 0:03.80 ntpd
3344 root 16 0 3156 420 308 S 0 0.0 0:00.03 atd
6-
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
[mysqld]
bind-address=localhost
port = 3306
socket = /tmp/mysql.sock
#datadir=/var/lib/mysql
#changing path
datadir = /backups/mysqldata
skip-locking
skip-innodb
query_cache_limit=2M
query_cache_size=32M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=256
max_heap_table_size=64M
key_buffer=64M
join_buffer=1M
max_allowed_packet=64M
read_rnd_buffer_size= 524288
bulk_insert_buffer_size = 8M
table_cache=1800
tmp_table_size = 64M
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=4
myisam_sort_buffer_size=64M
log-bin
server-id=1
old-passwords
query_prealloc_size = 163840
query_alloc_block_size = 32768
default-storage-engine = MyISAM
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
#pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=32M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
7-
+---------------------------------+--------------------------------------------------------------+
| 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 | /backups/mysqldata/ |
| 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 | 67108864 |
| 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 | 67107840 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 500 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 67107840 |
| 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 | 0 |
| 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 | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | ON |
| open_files_limit | 4110 |
| pid_file | /backups/mysqldata/hostname.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 32768 |
| query_cache_limit | 2097152 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 33554432 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 163840 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 2093056 |
| read_only | OFF |
| read_rnd_buffer_size | 520192 |
| 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 | /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 | IRST |
| table_cache | 1800 |
| table_type | MyISAM |
| thread_cache_size | 256 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 67108864 |
| 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 | 100 |
+---------------------------------+--------------------------------------------------------------+
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 1210 |
| Aborted_connects | 1500 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 1619381788 |
| Bytes_sent | 3512834394 |
| Com_admin_commands | 695 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 107739 |
| 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 | 12007 |
| 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 | 102361 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 29 |
| Com_optimize | 1 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 1 |
| Com_replace | 13321 |
| 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 | 4090780 |
| Com_set_option | 974 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 7 |
| Com_show_charsets | 33 |
| Com_show_collations | 33 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 816 |
| Com_show_databases | 5 |
| Com_show_errors | 0 |
| Com_show_fields | 828 |
| Com_show_grants | 18 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 12 |
| 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 | 3 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 14 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 924 |
| Com_show_variables | 118 |
| 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 | 4 |
| Com_unlock_tables | 29 |
| Com_update | 6751690 |
| Com_update_multi | 0 |
| Connections | 107003 |
| Created_tmp_disk_tables | 1080 |
| Created_tmp_files | 5508 |
| Created_tmp_tables | 55073 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 14162 |
| Handler_discover | 0 |
| Handler_read_first | 43208 |
| Handler_read_key | 22795537 |
| Handler_read_next | 540314161 |
| Handler_read_prev | 140605256 |
| Handler_read_rnd | 2287186 |
| Handler_read_rnd_next | 3519931336 |
| Handler_rollback | 0 |
| Handler_update | 7232547 |
| Handler_write | 70686832 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 30251 |
| Key_blocks_used | 27834 |
| Key_read_requests | 186430127 |
| Key_reads | 53238 |
| Key_write_requests | 6994685 |
| Key_writes | 4309175 |
| Max_used_connections | 21 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 391 |
| Open_streams | 0 |
| Open_tables | 244 |
| Opened_tables | 282 |
| Qcache_free_blocks | 3050 |
| Qcache_free_memory | 15916320 |
| Qcache_hits | 1815574 |
| Qcache_inserts | 4080503 |
| Qcache_lowmem_prunes | 1700 |
| Qcache_not_cached | 9474 |
| Qcache_queries_in_cache | 5925 |
| Qcache_total_blocks | 15242 |
| Questions | 13002224 |
| Rpl_status | NULL |
| Select_full_join | 14447 |
| Select_full_range_join | 0 |
| Select_range | 109545 |
| Select_range_check | 0 |
| Select_scan | 99507 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 35 |
| Sort_merge_passes | 2754 |
| Sort_range | 66801 |
| Sort_rows | 117367270 |
| Sort_scan | 77892 |
| Table_locks_immediate | 11611194 |
| Table_locks_waited | 567 |
| Threads_cached | 20 |
| Threads_connected | 1 |
| Threads_created | 21 |
| Threads_running | 1 |
| Uptime | 196930 |
+----------------------------+------------+
Uptime: 196930 Threads: 1 Questions: 13002225 Slow queries: 35 Opens: 282 Flush tables: 1 Open tables: 244 Queries per second avg: 66.025
mysqladmin Ver 8.41 Distrib 4.1.20, 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: 2 days 6 hours 42 min 10 sec
Threads: 1 Questions: 13002225 Slow queries: 35 Opens: 282 Flush tables: 1 Open tables: 244 Queries per second avg: 66.025
MysqlReport:
MySQL 4.1.20-log uptime 2 6:43:34 Wed Dec 13 21:33:38 2006
__ Key __________________________________________________ _______________
Buffer used 27.18M of 64.00M %Used: 42.47
Current 34.46M %Usage: 53.84
Write ratio 0.616
Read ratio 0.000
__ Questions __________________________________________________ _________
Total 13.00M 66.0/s
DMS 10.97M 55.7/s %Total: 84.37
QC Hits 1.82M 9.2/s 13.96
Com_ 112.33k 0.6/s 0.86
COM_QUIT 106.44k 0.5/s 0.82
-Unknown 2.19k 0.0/s 0.02
Slow 35 0.0/s 0.00 %DMS: 0.00
DMS 10.97M 55.7/s 84.37
UPDATE 6.75M 34.3/s 51.93 61.54
SELECT 4.09M 20.8/s 31.46 37.29
INSERT 102.38k 0.5/s 0.79 0.93
REPLACE 13.32k 0.1/s 0.10 0.12
DELETE 12.01k 0.1/s 0.09 0.11
Com_ 112.33k 0.6/s 0.86
change_db 107.78k 0.5/s 0.83
set_option 974 0.0/s 0.01
show_tables 924 0.0/s 0.01
__ SELECT and Sort __________________________________________________ ___
Scan 99.56k 0.5/s %SELECT: 2.43
Range 109.61k 0.6/s 2.68
Full join 14.45k 0.1/s 0.35
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 77.93k 0.4/s
Sort range 66.84k 0.3/s
Sort mrg pass 2.75k 0.0/s
__ Query Cache __________________________________________________ _______
Memory usage 18.29M of 32.00M %Used: 57.16
Block Fragmnt 19.11%
Hits 1.82M 9.2/s
Inserts 4.08M 20.7/s
Insrt:Prune 2.40k:1 20.7/s
Hit:Insert 0.44:1
__ Table Locks __________________________________________________ _______
Waited 567 0.0/s %Total: 0.00
Immediate 11.61M 58.9/s
__ Tables __________________________________________________ ____________
Open 244 of 1800 %Cache: 13.56
Opened 282 0.0/s
__ Connections __________________________________________________ _______
Max used 21 of 500 %Max: 4.20
Total 107.05k 0.5/s
__ Created Temp __________________________________________________ ______
Disk table 1.08k 0.0/s
Table 55.10k 0.3/s
File 5.51k 0.0/s
__ Threads __________________________________________________ ___________
Running 1 of 1
Cached 20 of 256 %Hit: 99.98
Created 21 0.0/s
Slow 0 0/s
__ Aborted __________________________________________________ ___________
Clients 1.21k 0.0/s
Connects 1.50k 0.0/s
__ Bytes __________________________________________________ _____________
Sent 3.54G 17.9k/s
Received 1.62G 8.2k/s
8- No , there is another website with very light mysql usage but evey hour ( using cron ) it analyzing logs that taking about 10-15 second of mysql usage
9- average 35 - 40 users online and 50 - 80 guests. ( but forums are closed to guests right now and are available only to logged in users)
10- http://72.232.137.93/info.php
11- lighttpd with fastcgi
12- 3.6.2
13- No
14-
uname -a
Linux hostname 2.6.9-42.0.3.ELsmp #1 SMP Fri Oct 6 06:21:39 CDT 2006 i686 i686 i386 GNU/Linux
ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
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) 32636
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) 4 CPU 3.60GHz
stepping : 3
cpu MHz : 3589.438
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
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 pni monitor ds_c
pl est tm2 cid xtpr
bogomips : 7182.68
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) 4 CPU 3.60GHz
stepping : 3
cpu MHz : 3589.438
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
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 pni monitor ds_c
pl est tm2 cid xtpr
bogomips : 7175.91
2-specs:
P4 3.6 HT
Ram 2GB
250GB HDD SATA non raid
Centos 4.4 32 bit
Lighttpd 1.4.11
PHP as FastCGI 4.4.4
Mysql 4.1.20
3-mysql 4.x
4-mysql installed
5-
top - 21:28:28 up 13 days, 8:55, 1 user, load average: 0.26, 0.19, 0.16
Tasks: 102 total, 1 running, 100 sleeping, 0 stopped, 1 zombie
Cpu(s): 0.8% us, 1.2% sy, 0.0% ni, 97.2% id, 0.8% wa, 0.0% hi, 0.0% si
Mem: 2066668k total, 2045656k used, 21012k free, 63432k buffers
Swap: 2040244k total, 14016k used, 2026228k free, 1633000k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
21015 mysql 16 0 120m 77m 3268 S 2 3.8 160:32.77 mysqld
2264 lighttpd 15 0 12392 10m 716 S 2 0.5 27:31.32 lighttpd
13034 lighttpd 16 0 49732 17m 12m S 1 0.9 1:07.70 php
13030 lighttpd 17 0 47772 15m 11m S 0 0.8 1:08.30 php
24990 root 16 0 2868 984 760 R 0 0.0 0:08.31 top
1 root 16 0 3548 552 472 S 0 0.0 0:02.84 init
2 root RT 0 0 0 0 S 0 0.0 0:00.90 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:02.48 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.95 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.23 ksoftirqd/1
6 root 5 -10 0 0 0 S 0 0.0 0:00.09 events/0
7 root 5 -10 0 0 0 S 0 0.0 0:00.03 events/1
8 root 5 -10 0 0 0 S 0 0.0 0:00.00 khelper
9 root 15 -10 0 0 0 S 0 0.0 0:00.00 kacpid
29 root 5 -10 0 0 0 S 0 0.0 0:00.10 kblockd/0
30 root 5 -10 0 0 0 S 0 0.0 0:00.03 kblockd/1
31 root 15 0 0 0 0 S 0 0.0 0:00.00 khubd
51 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/0
52 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/1
50 root 15 0 0 0 0 S 0 0.0 1:56.96 kswapd0
198 root 25 0 0 0 0 S 0 0.0 0:00.00 kseriod
308 root 5 -10 0 0 0 S 0 0.0 0:00.03 ata/0
309 root 5 -10 0 0 0 S 0 0.0 0:00.03 ata/1
313 root 23 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_0
314 root 23 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_1
334 root 15 0 0 0 0 S 0 0.0 1:43.66 kjournald
1524 root 6 -10 2656 460 380 S 0 0.0 0:00.02 udevd
1955 root 6 -10 0 0 0 S 0 0.0 0:00.00 kauditd
2020 root 7 -10 0 0 0 S 0 0.0 0:00.00 kmirrord
2038 root 15 0 0 0 0 S 0 0.0 0:00.00 kjournald
2039 root 15 0 0 0 0 S 0 0.0 0:16.43 kjournald
2593 root 16 0 5624 1040 744 S 0 0.1 0:00.06 sshd
3183 root 16 0 2460 300 220 S 0 0.0 0:01.01 irqbalance
3211 root 16 0 4840 340 172 S 0 0.0 0:01.82 rpc.idmapd
3269 root 15 0 3104 508 300 S 0 0.0 0:00.12 smartd
3278 root 19 0 3356 436 368 S 0 0.0 0:00.00 acpid
3301 root 18 0 3304 756 624 S 0 0.0 0:00.00 xinetd
3318 ntp 16 0 4672 4672 3436 S 0 0.2 0:03.80 ntpd
3344 root 16 0 3156 420 308 S 0 0.0 0:00.03 atd
6-
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
[mysqld]
bind-address=localhost
port = 3306
socket = /tmp/mysql.sock
#datadir=/var/lib/mysql
#changing path
datadir = /backups/mysqldata
skip-locking
skip-innodb
query_cache_limit=2M
query_cache_size=32M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=256
max_heap_table_size=64M
key_buffer=64M
join_buffer=1M
max_allowed_packet=64M
read_rnd_buffer_size= 524288
bulk_insert_buffer_size = 8M
table_cache=1800
tmp_table_size = 64M
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=4
myisam_sort_buffer_size=64M
log-bin
server-id=1
old-passwords
query_prealloc_size = 163840
query_alloc_block_size = 32768
default-storage-engine = MyISAM
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
#pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=32M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
7-
+---------------------------------+--------------------------------------------------------------+
| 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 | /backups/mysqldata/ |
| 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 | 67108864 |
| 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 | 67107840 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 500 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 67107840 |
| 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 | 0 |
| 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 | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | ON |
| open_files_limit | 4110 |
| pid_file | /backups/mysqldata/hostname.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 32768 |
| query_cache_limit | 2097152 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 33554432 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 163840 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 2093056 |
| read_only | OFF |
| read_rnd_buffer_size | 520192 |
| 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 | /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 | IRST |
| table_cache | 1800 |
| table_type | MyISAM |
| thread_cache_size | 256 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 67108864 |
| 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 | 100 |
+---------------------------------+--------------------------------------------------------------+
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 1210 |
| Aborted_connects | 1500 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 1619381788 |
| Bytes_sent | 3512834394 |
| Com_admin_commands | 695 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 107739 |
| 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 | 12007 |
| 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 | 102361 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 29 |
| Com_optimize | 1 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 1 |
| Com_replace | 13321 |
| 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 | 4090780 |
| Com_set_option | 974 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 7 |
| Com_show_charsets | 33 |
| Com_show_collations | 33 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 816 |
| Com_show_databases | 5 |
| Com_show_errors | 0 |
| Com_show_fields | 828 |
| Com_show_grants | 18 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 12 |
| 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 | 3 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 14 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 924 |
| Com_show_variables | 118 |
| 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 | 4 |
| Com_unlock_tables | 29 |
| Com_update | 6751690 |
| Com_update_multi | 0 |
| Connections | 107003 |
| Created_tmp_disk_tables | 1080 |
| Created_tmp_files | 5508 |
| Created_tmp_tables | 55073 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 14162 |
| Handler_discover | 0 |
| Handler_read_first | 43208 |
| Handler_read_key | 22795537 |
| Handler_read_next | 540314161 |
| Handler_read_prev | 140605256 |
| Handler_read_rnd | 2287186 |
| Handler_read_rnd_next | 3519931336 |
| Handler_rollback | 0 |
| Handler_update | 7232547 |
| Handler_write | 70686832 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 30251 |
| Key_blocks_used | 27834 |
| Key_read_requests | 186430127 |
| Key_reads | 53238 |
| Key_write_requests | 6994685 |
| Key_writes | 4309175 |
| Max_used_connections | 21 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 391 |
| Open_streams | 0 |
| Open_tables | 244 |
| Opened_tables | 282 |
| Qcache_free_blocks | 3050 |
| Qcache_free_memory | 15916320 |
| Qcache_hits | 1815574 |
| Qcache_inserts | 4080503 |
| Qcache_lowmem_prunes | 1700 |
| Qcache_not_cached | 9474 |
| Qcache_queries_in_cache | 5925 |
| Qcache_total_blocks | 15242 |
| Questions | 13002224 |
| Rpl_status | NULL |
| Select_full_join | 14447 |
| Select_full_range_join | 0 |
| Select_range | 109545 |
| Select_range_check | 0 |
| Select_scan | 99507 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 35 |
| Sort_merge_passes | 2754 |
| Sort_range | 66801 |
| Sort_rows | 117367270 |
| Sort_scan | 77892 |
| Table_locks_immediate | 11611194 |
| Table_locks_waited | 567 |
| Threads_cached | 20 |
| Threads_connected | 1 |
| Threads_created | 21 |
| Threads_running | 1 |
| Uptime | 196930 |
+----------------------------+------------+
Uptime: 196930 Threads: 1 Questions: 13002225 Slow queries: 35 Opens: 282 Flush tables: 1 Open tables: 244 Queries per second avg: 66.025
mysqladmin Ver 8.41 Distrib 4.1.20, 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: 2 days 6 hours 42 min 10 sec
Threads: 1 Questions: 13002225 Slow queries: 35 Opens: 282 Flush tables: 1 Open tables: 244 Queries per second avg: 66.025
MysqlReport:
MySQL 4.1.20-log uptime 2 6:43:34 Wed Dec 13 21:33:38 2006
__ Key __________________________________________________ _______________
Buffer used 27.18M of 64.00M %Used: 42.47
Current 34.46M %Usage: 53.84
Write ratio 0.616
Read ratio 0.000
__ Questions __________________________________________________ _________
Total 13.00M 66.0/s
DMS 10.97M 55.7/s %Total: 84.37
QC Hits 1.82M 9.2/s 13.96
Com_ 112.33k 0.6/s 0.86
COM_QUIT 106.44k 0.5/s 0.82
-Unknown 2.19k 0.0/s 0.02
Slow 35 0.0/s 0.00 %DMS: 0.00
DMS 10.97M 55.7/s 84.37
UPDATE 6.75M 34.3/s 51.93 61.54
SELECT 4.09M 20.8/s 31.46 37.29
INSERT 102.38k 0.5/s 0.79 0.93
REPLACE 13.32k 0.1/s 0.10 0.12
DELETE 12.01k 0.1/s 0.09 0.11
Com_ 112.33k 0.6/s 0.86
change_db 107.78k 0.5/s 0.83
set_option 974 0.0/s 0.01
show_tables 924 0.0/s 0.01
__ SELECT and Sort __________________________________________________ ___
Scan 99.56k 0.5/s %SELECT: 2.43
Range 109.61k 0.6/s 2.68
Full join 14.45k 0.1/s 0.35
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 77.93k 0.4/s
Sort range 66.84k 0.3/s
Sort mrg pass 2.75k 0.0/s
__ Query Cache __________________________________________________ _______
Memory usage 18.29M of 32.00M %Used: 57.16
Block Fragmnt 19.11%
Hits 1.82M 9.2/s
Inserts 4.08M 20.7/s
Insrt:Prune 2.40k:1 20.7/s
Hit:Insert 0.44:1
__ Table Locks __________________________________________________ _______
Waited 567 0.0/s %Total: 0.00
Immediate 11.61M 58.9/s
__ Tables __________________________________________________ ____________
Open 244 of 1800 %Cache: 13.56
Opened 282 0.0/s
__ Connections __________________________________________________ _______
Max used 21 of 500 %Max: 4.20
Total 107.05k 0.5/s
__ Created Temp __________________________________________________ ______
Disk table 1.08k 0.0/s
Table 55.10k 0.3/s
File 5.51k 0.0/s
__ Threads __________________________________________________ ___________
Running 1 of 1
Cached 20 of 256 %Hit: 99.98
Created 21 0.0/s
Slow 0 0/s
__ Aborted __________________________________________________ ___________
Clients 1.21k 0.0/s
Connects 1.50k 0.0/s
__ Bytes __________________________________________________ _____________
Sent 3.54G 17.9k/s
Received 1.62G 8.2k/s
8- No , there is another website with very light mysql usage but evey hour ( using cron ) it analyzing logs that taking about 10-15 second of mysql usage
9- average 35 - 40 users online and 50 - 80 guests. ( but forums are closed to guests right now and are available only to logged in users)
10- http://72.232.137.93/info.php
11- lighttpd with fastcgi
12- 3.6.2
13- No
14-
uname -a
Linux hostname 2.6.9-42.0.3.ELsmp #1 SMP Fri Oct 6 06:21:39 CDT 2006 i686 i686 i386 GNU/Linux
ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
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) 32636
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) 4 CPU 3.60GHz
stepping : 3
cpu MHz : 3589.438
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
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 pni monitor ds_c
pl est tm2 cid xtpr
bogomips : 7182.68
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) 4 CPU 3.60GHz
stepping : 3
cpu MHz : 3589.438
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
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 pni monitor ds_c
pl est tm2 cid xtpr
bogomips : 7175.91