MySQL Hogging CPU

My system 80% of its memory free but its load average stays between 17 and 20.

MySQL consistently uses between 90% and 100% of available CPU power.  

How can I find out why MySQL is using so much CPU?
LVL 16
hankknightAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pawwaCommented:
Hi,

first you should log slow queries (which happen if you could not use the indexes, or inefficient use of them, for example):

[mysqld]
log-slow-queries
long_query_time = 5
; MySQL 4.1 and newer only:
log-queries-not-using-indexes

This will log any queries that are longer than 5 seconds and those which don`t use indexes. Best view of this log is with mysqldumpslow command.

There are some tools for mysql also:

mytop is modeled after the unix top command. mytop also provides real-time and historical data about key-buffer and query-cache efficiency, and statistics about the queries being run. It's a useful tool to see what's going on -- within 10 seconds, you can get a view of the server's health and display any connections that are causing problems.

mysqlard is a daemon that connects to the MySQL server and collects data every 5 minutes, storing it in a Round Robin Database backend. A Web page displays the data, such as table-cache usage, key efficiency, connected clients, and temporary-table usage. Whereas mytop provides a snapshot of server health, mysqlard provides long-term health information. As a bonus, mysqlard uses some of the information it collects to make suggestions about how to tune your server.

Another tool for collecting SHOW STATUS information is mysqlreport. It's far more verbose in its reporting than mysqlard because it analyzes every facet of the server. It's an excellent tool for tuning a server because it performs the appropriate calculations on the status variables to help you determine what needs fixing.


0
gmckeown99Commented:
Very hard to say without some additional information.

Can you post the MySQL version and platform? Is this a MyISAM table, or Innodb?

What are the specs on the server?

Can you post the results of running SHOW VARIABLES?
0
hankknightAuthor Commented:
The server is a VPS with 8299828k total memory,  3686948k used memory.   I don't know how to find out how much CPU power it has.

All tables are MyISAM.
+-----------------------------------------+--------------------------------------+
| Variable_name                           | Value                                |
+-----------------------------------------+--------------------------------------+
| auto_increment_increment                | 1                                    | 
| auto_increment_offset                   | 1                                    | 
| automatic_sp_privileges                 | ON                                   | 
| back_log                                | 50                                   | 
| basedir                                 | /                                    | 
| binlog_cache_size                       | 32768                                | 
| bulk_insert_buffer_size                 | 8388608                              | 
| character_set_client                    | latin1                               | 
| character_set_connection                | latin1                               | 
| character_set_database                  | utf8                                 | 
| character_set_filesystem                | binary                               | 
| character_set_results                   | latin1                               | 
| character_set_server                    | utf8                                 | 
| character_set_system                    | utf8                                 | 
| character_sets_dir                      | /usr/share/mysql/charsets/           | 
| collation_connection                    | latin1_swedish_ci                    | 
| collation_database                      | utf8_unicode_ci                      | 
| collation_server                        | utf8_unicode_ci                      | 
| completion_type                         | 0                                    | 
| concurrent_insert                       | 1                                    | 
| connect_timeout                         | 20                                   | 
| datadir                                 | /var/lib/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                  | 40                                   | 
| delayed_queue_size                      | 1000                                 | 
| div_precision_increment                 | 4                                    | 
| keep_files_on_create                    | OFF                                  | 
| engine_condition_pushdown               | OFF                                  | 
| expire_logs_days                        | 0                                    | 
| flush                                   | OFF                                  | 
| flush_time                              | 0                                    | 
| ft_boolean_syntax                       | + -><()~*:""&|                       | 
| ft_max_word_len                         | 84                                   | 
| ft_min_word_len                         | 3                                    | 
| ft_query_expansion_limit                | 20                                   | 
| ft_stopword_file                        | (built-in)                           | 
| group_concat_max_len                    | 1024                                 | 
| have_archive                            | YES                                  | 
| have_bdb                                | NO                                   | 
| have_blackhole_engine                   | YES                                  | 
| have_compress                           | YES                                  | 
| have_community_features                 | NO                                   | 
| have_profiling                          | NO                                   | 
| have_crypt                              | YES                                  | 
| have_csv                                | YES                                  | 
| have_dynamic_loading                    | YES                                  | 
| have_example_engine                     | YES                                  | 
| have_federated_engine                   | YES                                  | 
| have_geometry                           | YES                                  | 
| have_innodb                             | YES                                  | 
| have_isam                               | NO                                   | 
| have_merge_engine                       | YES                                  | 
| have_ndbcluster                         | NO                                   | 
| have_openssl                            | NO                                   | 
| have_ssl                                | NO                                   | 
| have_query_cache                        | YES                                  | 
| have_raid                               | NO                                   | 
| have_rtree_keys                         | YES                                  | 
| have_symlink                            | YES                                  | 
| hostname                                | localhost                            | 
| 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_checksums                        | ON                                   | 
| innodb_commit_concurrency               | 0                                    | 
| innodb_concurrency_tickets              | 500                                  | 
| innodb_data_file_path                   | ibdata1:10M:autoextend               | 
| innodb_data_home_dir                    |                                      | 
| innodb_adaptive_hash_index              | ON                                   | 
| innodb_doublewrite                      | ON                                   | 
| innodb_fast_shutdown                    | 1                                    | 
| 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_rollback_on_timeout              | OFF                                  | 
| innodb_support_xa                       | ON                                   | 
| innodb_sync_spin_loops                  | 20                                   | 
| innodb_table_locks                      | ON                                   | 
| innodb_thread_concurrency               | 8                                    | 
| innodb_thread_sleep_delay               | 10000                                | 
| innodb_use_legacy_cardinality_algorithm | ON                                   | 
| interactive_timeout                     | 10                                   | 
| join_buffer_size                        | 1048576                              | 
| key_buffer_size                         | 33554432                             | 
| key_cache_age_threshold                 | 300                                  | 
| key_cache_block_size                    | 1024                                 | 
| key_cache_division_limit                | 100                                  | 
| language                                | /usr/share/mysql/english/            | 
| large_files_support                     | ON                                   | 
| large_page_size                         | 0                                    | 
| large_pages                             | OFF                                  | 
| lc_time_names                           | en_US                                | 
| license                                 | GPL                                  | 
| local_infile                            | ON                                   | 
| locked_in_memory                        | OFF                                  | 
| log                                     | OFF                                  | 
| log_bin                                 | OFF                                  | 
| log_bin_trust_function_creators         | OFF                                  | 
| log_error                               |                                      | 
| log_queries_not_using_indexes           | OFF                                  | 
| log_slave_updates                       | OFF                                  | 
| log_slow_queries                        | 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                      | 16777216                             | 
| max_binlog_cache_size                   | 4294963200                           | 
| max_binlog_size                         | 1073741824                           | 
| max_connect_errors                      | 20                                   | 
| max_connections                         | 100                                  | 
| max_delayed_threads                     | 20                                   | 
| max_error_count                         | 64                                   | 
| max_heap_table_size                     | 67108864                             | 
| max_insert_delayed_threads              | 20                                   | 
| max_join_size                           | 18446744073709551615                 | 
| 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_sp_recursion_depth                  | 0                                    | 
| max_tmp_tables                          | 32                                   | 
| max_user_connections                    | 25                                   | 
| max_write_lock_count                    | 4294967295                           | 
| multi_range_count                       | 256                                  | 
| myisam_data_pointer_size                | 6                                    | 
| myisam_max_sort_file_size               | 2146435072                           | 
| myisam_mmap_size                        | 4294967295                           | 
| myisam_recover_options                  | OFF                                  | 
| myisam_repair_threads                   | 1                                    | 
| myisam_sort_buffer_size                 | 33554432                             | 
| 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                        | 2158                                 | 
| optimizer_prune_level                   | 1                                    | 
| optimizer_search_depth                  | 62                                   | 
| pid_file                                | /var/lib/mysql/mydb.pid | 
| plugin_dir                              |                                      | 
| port                                    | 3306                                 | 
| preload_buffer_size                     | 32768                                | 
| protocol_version                        | 10                                   | 
| query_alloc_block_size                  | 8192                                 | 
| 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                     | 8192                                 | 
| range_alloc_block_size                  | 4096                                 | 
| read_buffer_size                        | 1048576                              | 
| read_only                               | OFF                                  | 
| read_rnd_buffer_size                    | 1048576                              | 
| relay_log                               |                                      | 
| relay_log_index                         |                                      | 
| relay_log_info_file                     | relay-log.info                       | 
| relay_log_purge                         | ON                                   | 
| relay_log_space_limit                   | 0                                    | 
| rpl_recovery_rank                       | 0                                    | 
| secure_auth                             | OFF                                  | 
| secure_file_priv                        |                                      | 
| server_id                               | 1                                    | 
| skip_external_locking                   | ON                                   | 
| skip_networking                         | OFF                                  | 
| skip_show_database                      | OFF                                  | 
| slave_compressed_protocol               | OFF                                  | 
| slave_load_tmpdir                       | /tmp/                                | 
| slave_net_timeout                       | 3600                                 | 
| slave_skip_errors                       | OFF                                  | 
| slave_transaction_retries               | 10                                   | 
| slow_launch_time                        | 2                                    | 
| socket                                  | /var/lib/mysql/mysql.sock            | 
| sort_buffer_size                        | 1048576                              | 
| sql_big_selects                         | ON                                   | 
| sql_mode                                |                                      | 
| sql_notes                               | ON                                   | 
| sql_warnings                            | OFF                                  | 
| ssl_ca                                  |                                      | 
| ssl_capath                              |                                      | 
| ssl_cert                                |                                      | 
| ssl_cipher                              |                                      | 
| ssl_key                                 |                                      | 
| storage_engine                          | MyISAM                               | 
| sync_binlog                             | 0                                    | 
| sync_frm                                | ON                                   | 
| system_time_zone                        | CDT                                  | 
| table_cache                             | 1024                                 | 
| table_lock_wait_timeout                 | 50                                   | 
| table_type                              | MyISAM                               | 
| thread_cache_size                       | 128                                  | 
| thread_stack                            | 196608                               | 
| time_format                             | %H:%i:%s                             | 
| time_zone                               | SYSTEM                               | 
| timed_mutexes                           | OFF                                  | 
| tmp_table_size                          | 67108864                             | 
| tmpdir                                  | /tmp/                                | 
| transaction_alloc_block_size            | 8192                                 | 
| transaction_prealloc_size               | 4096                                 | 
| tx_isolation                            | REPEATABLE-READ                      | 
| updatable_views_with_limit              | YES                                  | 
| version                                 | 5.0.90-community                     | 
| version_comment                         | MySQL Community Edition (GPL)        | 
| version_compile_machine                 | i686                                 | 
| version_compile_os                      | pc-linux-gnu                         | 
| wait_timeout                            | 10                                   | 
+-----------------------------------------+--------------------------------------+
233 rows in set (0.07 sec)

Open in new window

0
gmckeown99Commented:
Your innodb_buffer_pool_size is low for an 8gig machine. It's currently 8meg, raise that to 512meg at least.

I don't see any huge issues. Can you post SHOW STATUS output?

Also cat /proc/cpuinfo output
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
hankknightAuthor Commented:
gmckeown99, thank you for helping.  Here are the things you asked to see:
+-----------------------------------+------------+
| Variable_name                     | Value      |
+-----------------------------------+------------+
| Aborted_clients                   | 2          | 
| Aborted_connects                  | 2303       | 
| Binlog_cache_disk_use             | 0          | 
| Binlog_cache_use                  | 0          | 
| Bytes_received                    | 139        | 
| Bytes_sent                        | 182        | 
| Com_admin_commands                | 0          | 
| Com_alter_db                      | 0          | 
| Com_alter_table                   | 0          | 
| Com_analyze                       | 0          | 
| Com_backup_table                  | 0          | 
| Com_begin                         | 0          | 
| Com_call_procedure                | 0          | 
| Com_change_db                     | 0          | 
| 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_create_user                   | 0          | 
| Com_dealloc_sql                   | 0          | 
| Com_delete                        | 0          | 
| 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                        | 0          | 
| Com_insert_select                 | 0          | 
| Com_kill                          | 0          | 
| Com_load                          | 0          | 
| Com_load_master_data              | 0          | 
| Com_load_master_table             | 0          | 
| Com_lock_tables                   | 0          | 
| 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                       | 0          | 
| 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                        | 1          | 
| Com_set_option                    | 0          | 
| 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              | 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_triggers                 | 0          | 
| Com_show_variables                | 0          | 
| Com_show_warnings                 | 0          | 
| Com_slave_start                   | 0          | 
| Com_slave_stop                    | 0          | 
| Com_stmt_close                    | 0          | 
| Com_stmt_execute                  | 0          | 
| Com_stmt_fetch                    | 0          | 
| Com_stmt_prepare                  | 0          | 
| Com_stmt_reset                    | 0          | 
| Com_stmt_send_long_data           | 0          | 
| Com_truncate                      | 0          | 
| Com_unlock_tables                 | 0          | 
| Com_update                        | 0          | 
| Com_update_multi                  | 0          | 
| Com_xa_commit                     | 0          | 
| Com_xa_end                        | 0          | 
| Com_xa_prepare                    | 0          | 
| Com_xa_recover                    | 0          | 
| Com_xa_rollback                   | 0          | 
| Com_xa_start                      | 0          | 
| Compression                       | OFF        | 
| Connections                       | 577320     | 
| Created_tmp_disk_tables           | 0          | 
| Created_tmp_files                 | 905        | 
| Created_tmp_tables                | 1          | 
| Delayed_errors                    | 0          | 
| Delayed_insert_threads            | 0          | 
| Delayed_writes                    | 0          | 
| Flush_commands                    | 1          | 
| Handler_commit                    | 0          | 
| Handler_delete                    | 0          | 
| Handler_discover                  | 0          | 
| Handler_prepare                   | 0          | 
| Handler_read_first                | 0          | 
| Handler_read_key                  | 0          | 
| Handler_read_next                 | 0          | 
| Handler_read_prev                 | 0          | 
| Handler_read_rnd                  | 0          | 
| Handler_read_rnd_next             | 0          | 
| Handler_rollback                  | 0          | 
| Handler_savepoint                 | 0          | 
| Handler_savepoint_rollback        | 0          | 
| Handler_update                    | 0          | 
| Handler_write                     | 132        | 
| Innodb_buffer_pool_pages_data     | 39         | 
| Innodb_buffer_pool_pages_dirty    | 0          | 
| Innodb_buffer_pool_pages_flushed  | 1          | 
| Innodb_buffer_pool_pages_free     | 473        | 
| Innodb_buffer_pool_pages_misc     | 0          | 
| Innodb_buffer_pool_pages_total    | 512        | 
| Innodb_buffer_pool_read_ahead_rnd | 2          | 
| Innodb_buffer_pool_read_ahead_seq | 0          | 
| Innodb_buffer_pool_read_requests  | 3546       | 
| Innodb_buffer_pool_reads          | 23         | 
| Innodb_buffer_pool_wait_free      | 0          | 
| Innodb_buffer_pool_write_requests | 1          | 
| Innodb_data_fsyncs                | 7          | 
| Innodb_data_pending_fsyncs        | 0          | 
| Innodb_data_pending_reads         | 0          | 
| Innodb_data_pending_writes        | 0          | 
| Innodb_data_read                  | 2822144    | 
| Innodb_data_reads                 | 38         | 
| Innodb_data_writes                | 7          | 
| Innodb_data_written               | 35328      | 
| Innodb_dblwr_pages_written        | 1          | 
| Innodb_dblwr_writes               | 1          | 
| Innodb_log_waits                  | 0          | 
| Innodb_log_write_requests         | 0          | 
| Innodb_log_writes                 | 2          | 
| Innodb_os_log_fsyncs              | 5          | 
| Innodb_os_log_pending_fsyncs      | 0          | 
| Innodb_os_log_pending_writes      | 0          | 
| Innodb_os_log_written             | 1024       | 
| Innodb_page_size                  | 16384      | 
| Innodb_pages_created              | 0          | 
| Innodb_pages_read                 | 39         | 
| Innodb_pages_written              | 1          | 
| Innodb_row_lock_current_waits     | 0          | 
| Innodb_row_lock_time              | 0          | 
| Innodb_row_lock_time_avg          | 0          | 
| Innodb_row_lock_time_max          | 0          | 
| Innodb_row_lock_waits             | 0          | 
| Innodb_rows_deleted               | 0          | 
| Innodb_rows_inserted              | 0          | 
| Innodb_rows_read                  | 0          | 
| Innodb_rows_updated               | 0          | 
| Key_blocks_not_flushed            | 0          | 
| Key_blocks_unused                 | 23501      | 
| Key_blocks_used                   | 7442       | 
| Key_read_requests                 | 2166879262 | 
| Key_reads                         | 9381       | 
| Key_write_requests                | 5381329    | 
| Key_writes                        | 3420838    | 
| Last_query_cost                   | 0.000000   | 
| Max_used_connections              | 45         | 
| Not_flushed_delayed_rows          | 0          | 
| Open_files                        | 659        | 
| Open_streams                      | 0          | 
| Open_tables                       | 493        | 
| Opened_tables                     | 0          | 
| Prepared_stmt_count               | 0          | 
| Qcache_free_blocks                | 2635       | 
| Qcache_free_memory                | 19150432   | 
| Qcache_hits                       | 16000615   | 
| Qcache_inserts                    | 6684840    | 
| Qcache_lowmem_prunes              | 0          | 
| Qcache_not_cached                 | 534262     | 
| Qcache_queries_in_cache           | 8955       | 
| Qcache_total_blocks               | 20595      | 
| Queries                           | 28210351   | 
| Questions                         | 2          | 
| Rpl_status                        | NULL       | 
| Select_full_join                  | 0          | 
| Select_full_range_join            | 0          | 
| Select_range                      | 0          | 
| Select_range_check                | 0          | 
| Select_scan                       | 1          | 
| 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                        | 0          | 
| Sort_rows                         | 0          | 
| Sort_scan                         | 0          | 
| Table_locks_immediate             | 21097208   | 
| Table_locks_waited                | 325042     | 
| Tc_log_max_pages_used             | 0          | 
| Tc_log_page_size                  | 0          | 
| Tc_log_page_waits                 | 0          | 
| Threads_cached                    | 39         | 
| Threads_connected                 | 6          | 
| Threads_created                   | 45         | 
| Threads_running                   | 2          | 
| Uptime                            | 101092     | 
+-----------------------------------+------------+
225 rows in set (0.00 sec)



-------------------------------------------------------------------------


processor       : 0
vendor_id       : GenuineIntel
cpu family      : 6
model           : 30
model name      : Intel(R) Xeon(R) CPU           X3450  @ 2.67GHz
stepping        : 5
cpu MHz         : 2660.085
cache size      : 8192 KB
physical id     : 0
siblings        : 8
core id         : 0
cpu cores       : 4
apicid          : 0
fdiv_bug        : no
hlt_bug         : no
f00f_bug        : no
coma_bug        : no
fpu             : yes
fpu_exception   : yes
cpuid level     : 11
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 rdtscp lm constant_tsc ida nonstop_tsc pni monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr sse4_1 sse4_2 popcnt lahf_lm [8]
bogomips        : 5320.17

processor       : 1
vendor_id       : GenuineIntel
cpu family      : 6
model           : 30
model name      : Intel(R) Xeon(R) CPU           X3450  @ 2.67GHz
stepping        : 5
cpu MHz         : 2660.085
cache size      : 8192 KB
physical id     : 0
siblings        : 8
core id         : 0
cpu cores       : 4
apicid          : 1
fdiv_bug        : no
hlt_bug         : no
f00f_bug        : no
coma_bug        : no
fpu             : yes
fpu_exception   : yes
cpuid level     : 11
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 rdtscp lm constant_tsc ida nonstop_tsc pni monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr sse4_1 sse4_2 popcnt lahf_lm [8]
bogomips        : 5319.90

processor       : 2
vendor_id       : GenuineIntel
cpu family      : 6
model           : 30
model name      : Intel(R) Xeon(R) CPU           X3450  @ 2.67GHz
stepping        : 5
cpu MHz         : 2660.085
cache size      : 8192 KB
physical id     : 0
siblings        : 8
core id         : 1
cpu cores       : 4
apicid          : 2
fdiv_bug        : no
hlt_bug         : no
f00f_bug        : no
coma_bug        : no
fpu             : yes
fpu_exception   : yes
cpuid level     : 11
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 rdtscp lm constant_tsc ida nonstop_tsc pni monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr sse4_1 sse4_2 popcnt lahf_lm [8]
bogomips        : 5319.94

processor       : 3
vendor_id       : GenuineIntel
cpu family      : 6
model           : 30
model name      : Intel(R) Xeon(R) CPU           X3450  @ 2.67GHz
stepping        : 5
cpu MHz         : 2660.085
cache size      : 8192 KB
physical id     : 0
siblings        : 8
core id         : 1
cpu cores       : 4
apicid          : 3
fdiv_bug        : no
hlt_bug         : no
f00f_bug        : no
coma_bug        : no
fpu             : yes
fpu_exception   : yes
cpuid level     : 11
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 rdtscp lm constant_tsc ida nonstop_tsc pni monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr sse4_1 sse4_2 popcnt lahf_lm [8]
bogomips        : 5319.95

processor       : 4
vendor_id       : GenuineIntel
cpu family      : 6
model           : 30
model name      : Intel(R) Xeon(R) CPU           X3450  @ 2.67GHz
stepping        : 5
cpu MHz         : 2660.085
cache size      : 8192 KB
physical id     : 0
siblings        : 8
core id         : 2
cpu cores       : 4
apicid          : 4
fdiv_bug        : no
hlt_bug         : no
f00f_bug        : no
coma_bug        : no
fpu             : yes
fpu_exception   : yes
cpuid level     : 11
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 rdtscp lm constant_tsc ida nonstop_tsc pni monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr sse4_1 sse4_2 popcnt lahf_lm [8]
bogomips        : 5319.94

processor       : 5
vendor_id       : GenuineIntel
cpu family      : 6
model           : 30
model name      : Intel(R) Xeon(R) CPU           X3450  @ 2.67GHz
stepping        : 5
cpu MHz         : 2660.085
cache size      : 8192 KB
physical id     : 0
siblings        : 8
core id         : 2
cpu cores       : 4
apicid          : 5
fdiv_bug        : no
hlt_bug         : no
f00f_bug        : no
coma_bug        : no
fpu             : yes
fpu_exception   : yes
cpuid level     : 11
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 rdtscp lm constant_tsc ida nonstop_tsc pni monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr sse4_1 sse4_2 popcnt lahf_lm [8]
bogomips        : 5319.96

processor       : 6
vendor_id       : GenuineIntel
cpu family      : 6
model           : 30
model name      : Intel(R) Xeon(R) CPU           X3450  @ 2.67GHz
stepping        : 5
cpu MHz         : 2660.085
cache size      : 8192 KB
physical id     : 0
siblings        : 8
core id         : 3
cpu cores       : 4
apicid          : 6
fdiv_bug        : no
hlt_bug         : no
f00f_bug        : no
coma_bug        : no
fpu             : yes
fpu_exception   : yes
cpuid level     : 11
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 rdtscp lm constant_tsc ida nonstop_tsc pni monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr sse4_1 sse4_2 popcnt lahf_lm [8]
bogomips        : 5319.91

processor       : 7
vendor_id       : GenuineIntel
cpu family      : 6
model           : 30
model name      : Intel(R) Xeon(R) CPU           X3450  @ 2.67GHz
stepping        : 5
cpu MHz         : 2660.085
cache size      : 8192 KB
physical id     : 0
siblings        : 8
core id         : 3
cpu cores       : 4
apicid          : 7
fdiv_bug        : no
hlt_bug         : no
f00f_bug        : no
coma_bug        : no
fpu             : yes
fpu_exception   : yes
cpuid level     : 11
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 rdtscp lm constant_tsc ida nonstop_tsc pni monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr sse4_1 sse4_2 popcnt lahf_lm [8]
bogomips        : 5319.94

Open in new window

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Linux

From novice to tech pro — start learning today.