[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
08/21/2009 at 11:04AM PDT, ID: 24672191
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
9.0

mysql high load , big problem I hope some one help

Asked by xserverx in MySQL Server, Web Hosting, Apache Web Server

Tags: mysql, high load, optimization, performance, vBulletin

mysql cause high load can any one help to optimaze mysql server please
this information about my server :

1- dedicated server only 1 site hosted on it

2- server specs :

CPU : Dual Intel Xeon CPU  E5430  @ 2.66GHz 12MB
RAM: 24Gb  
HDD: 300 GB SA-SCSI 15K none raid
Linux CentOS 64 5bit
Apache: Apache/2.2.13 (Unix)
Mysql: 5.0.81-community
PHP :5.2.9

3- script installed vbulletin 3.8.2
4- there is no innodb type on my server
5- mysql compiled with cpanel
6- top stats


[CODE]
top - 16:46:38 up 18:06,  3 users,  load average: 238.38, 206.04, 131.13
Tasks: 1250 total,  38 running, 1211 sleeping,   0 stopped,   1 zombie
Cpu(s): 92.4%us,  5.7%sy,  0.0%ni,  0.9%id,  0.0%wa,  0.1%hi,  0.9%si,  0.0%st
Mem:  24689152k total, 23738664k used,   950488k free,   232164k buffers
Swap: 32456344k total,      172k used, 32456172k free, 10289108k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
20180 mysql      5 -10 1356m 409m 4072 S 247.1  1.7  82:27.61 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=my
19609 nobody    15   0  324m  30m  14m S 16.3  0.1   0:13.47 /usr/local/apache/bin/httpd -k start -DSSL
22238 nobody    15   0  325m  30m  13m S 11.8  0.1   0:16.16 /usr/local/apache/bin/httpd -k start -DSSL
25704 nobody    15   0  321m  26m  13m S 11.8  0.1   0:11.10 /usr/local/apache/bin/httpd -k start -DSSL
  630 nobody    15   0  317m  21m  12m S 11.4  0.1   0:04.40 /usr/local/apache/bin/httpd -k start -DSSL
 1650 nobody    15   0  323m  26m  12m S 11.4  0.1   0:03.85 /usr/local/apache/bin/httpd -k start -DSSL
15117 nobody    15   0  326m  30m  13m S 11.4  0.1   0:23.36 /usr/local/apache/bin/httpd -k start -DSSL
22257 nobody    15   0  320m  25m  13m S 11.4  0.1   0:15.91 /usr/local/apache/bin/httpd -k start -DSSL
23193 nobody    15   0  326m  33m  16m S 11.4  0.1   0:12.37 /usr/local/apache/bin/httpd -k start -DSSL
23219 nobody    15   0  323m  27m  13m S 11.4  0.1   0:11.86 /usr/local/apache/bin/httpd -k start -DSSL
 1631 nobody    15   0  323m  27m  12m S 11.1  0.1   0:04.40 /usr/local/apache/bin/httpd -k start -DSSL
 1651 nobody    15   0  324m  28m  12m S 11.1  0.1   0:04.11 /usr/local/apache/bin/httpd -k start -DSSL
11756 nobody    15   0  323m  27m  13m S 11.1  0.1   0:21.62 /usr/local/apache/bin/httpd -k start -DSSL
12173 nobody    15   0  321m  25m  12m S 11.1  0.1   0:20.20 /usr/local/apache/bin/httpd -k start -DSSL
16214 nobody    15   0  325m  30m  13m S 11.1  0.1   0:20.16 /usr/local/apache/bin/httpd -k start -DSSL
19854 nobody    15   0  323m  28m  13m S 11.1  0.1   0:16.44 /usr/local/apache/bin/httpd -k start -DSSL
19883 nobody    15   0  325m  29m  13m S 11.1  0.1   0:16.05 /usr/local/apache/bin/httpd -k start -DSSL
22300 nobody    15   0  321m  27m  13m S 11.1  0.1   0:14.58 /usr/local/apache/bin/httpd -k start -DSSL
 1117 nobody    16   0  323m  27m  12m S 10.8  0.1   0:04.43 /usr/local/apache/bin/httpd -k start -DSSL
32090 nobody    15   0  323m  27m  12m S 10.8  0.1   0:04.82 /usr/local/apache/bin/httpd -k start -DSSL
11915 nobody    15   0  321m  26m  13m S 10.1  0.1   0:24.88 /usr/local/apache/bin/httpd -k start -DSSL
13438 nobody    16   0  325m  30m  13m R 10.1  0.1   0:20.84 /usr/local/apache/bin/httpd -k start -DSSL
21976 nobody    15   0  324m  29m  13m S 10.1  0.1   0:15.99 /usr/local/apache/bin/httpd -k start -DSSL
 2176 nobody    15   0  325m  28m  12m S  9.8  0.1   0:03.95 /usr/local/apache/bin/httpd -k start -DSSL
11922 nobody    15   0  322m  27m  13m S  9.5  0.1   0:25.08 /usr/local/apache/bin/httpd -k start -DSSL
17507 nobody    15   0  325m  32m  16m S  9.5  0.1   0:18.08 /usr/local/apache/bin/httpd -k start -DSSL
11759 nobody    15   0  323m  27m  13m S  9.1  0.1   0:22.74 /usr/local/apache/bin/httpd -k start -DSSL
12190 nobody    15   0  325m  30m  13m S  9.1  0.1   0:23.61 /usr/local/apache/bin/httpd -k start -DSSL
  728 nobody    15   0  323m  27m  12m S  8.2  0.1   0:05.16 /usr/local/apache/bin/httpd -k start -DSSL
 1125 nobody    15   0  323m  27m  12m S  7.5  0.1   0:04.38 /usr/local/apache/bin/httpd -k start -DSSL
32445 nobody    16   0  323m  27m  12m S  7.5  0.1   0:04.44 /usr/local/apache/bin/httpd -k start -DSSL

[/CODE]

[CODE]
top - 16:48:05 up 18:08,  3 users,  load average: 165.38, 190.85, 132.31
Tasks: 1265 total,  33 running, 1232 sleeping,   0 stopped,   0 zombie
Cpu0  : 37.6%us,  3.7%sy,  0.3%ni, 57.7%id,  0.6%wa,  0.0%hi,  0.1%si,  0.0%st
Cpu1  : 37.4%us,  3.7%sy,  0.4%ni, 54.6%id,  3.6%wa,  0.0%hi,  0.2%si,  0.0%st
Cpu2  : 39.1%us,  3.2%sy,  0.3%ni, 56.8%id,  0.4%wa,  0.0%hi,  0.2%si,  0.0%st
Cpu3  : 39.3%us,  3.2%sy,  0.3%ni, 56.1%id,  1.0%wa,  0.0%hi,  0.2%si,  0.0%st
Cpu4  : 37.6%us,  3.2%sy,  0.3%ni, 57.8%id,  1.0%wa,  0.0%hi,  0.1%si,  0.0%st
Cpu5  : 40.6%us,  3.0%sy,  0.2%ni, 55.5%id,  0.5%wa,  0.0%hi,  0.1%si,  0.0%st
Cpu6  : 38.1%us,  3.1%sy,  0.3%ni, 58.0%id,  0.4%wa,  0.0%hi,  0.2%si,  0.0%st
Cpu7  : 42.2%us,  5.6%sy,  0.1%ni, 47.8%id,  0.6%wa,  0.2%hi,  3.4%si,  0.0%st
Mem:  24689152k total, 23766372k used,   922780k free,   234424k buffers
Swap: 32456344k total,      172k used, 32456172k free, 10290164k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
20180 mysql      5 -10 1356m 421m 4072 S 747.3  1.7  85:47.72 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=my
11542 nobody    16   0  326m  31m  13m S 27.1  0.1   0:23.82 /usr/local/apache/bin/httpd -k start -DSSL
15131 nobody    16   0  326m  30m  13m S 27.1  0.1   0:19.53 /usr/local/apache/bin/httpd -k start -DSSL
20286 nobody    16   0  325m  32m  16m S 26.3  0.1   0:12.03 /usr/local/apache/bin/httpd -k start -DSSL
23164 nobody    16   0  325m  29m  12m S 24.0  0.1   0:12.65 /usr/local/apache/bin/httpd -k start -DSSL
25704 nobody    16   0  323m  28m  13m S 23.2  0.1   0:11.71 /usr/local/apache/bin/httpd -k start -DSSL
19293 nobody    16   0  325m  29m  13m R 22.4  0.1   0:20.55 /usr/local/apache/bin/httpd -k start -DSSL
32079 nobody    16   0  324m  28m  12m S 22.4  0.1   0:06.46 /usr/local/apache/bin/httpd -k start -DSSL
11589 nobody    15   0  323m  28m  12m S 21.7  0.1   0:20.83 /usr/local/apache/bin/httpd -k start -DSSL
20315 nobody    15   0  324m  28m  13m S 21.7  0.1   0:17.18 /usr/local/apache/bin/httpd -k start -DSSL
22242 nobody    15   0  325m  29m  13m S 20.9  0.1   0:14.33 /usr/local/apache/bin/httpd -k start -DSSL
11659 nobody    16   0  324m  29m  13m S 18.6  0.1   0:21.41 /usr/local/apache/bin/httpd -k start -DSSL
17307 nobody    15   0  324m  28m  13m R 18.6  0.1   0:18.57 /usr/local/apache/bin/httpd -k start -DSSL
12341 nobody    15   0  324m  29m  13m R 15.5  0.1   0:17.46 /usr/local/apache/bin/httpd -k start -DSSL
19853 nobody    16   0  326m  33m  16m R 15.5  0.1   0:15.04 /usr/local/apache/bin/httpd -k start -DSSL
22306 nobody    16   0  324m  29m  13m S 15.5  0.1   0:17.73 /usr/local/apache/bin/httpd -k start -DSSL
25710 nobody    16   0  325m  29m  13m S 15.5  0.1   0:15.38 /usr/local/apache/bin/httpd -k start -DSSL
 5752 root      25   0 10580 1020  644 R 14.7  0.0   0:00.19 netstat -ntu
20285 nobody    16   0  325m  29m  13m S 14.7  0.1   0:17.64 /usr/local/apache/bin/httpd -k start -DSSL
23179 nobody    16   0  325m  29m  12m S 14.7  0.1   0:15.22 /usr/local/apache/bin/httpd -k start -DSSL
23180 nobody    16   0  323m  27m  12m R 14.7  0.1   0:15.14 /usr/local/apache/bin/httpd -k start -DSSL
11376 nobody    15   0  325m  30m  13m S 13.9  0.1   0:26.78 /usr/local/apache/bin/httpd -k start -DSSL
29522 nobody    15   0  318m  22m  12m S 13.9  0.1   0:08.03 /usr/local/apache/bin/httpd -k start -DSSL
15122 nobody    15   0  325m  29m  13m S 13.2  0.1   0:22.09 /usr/local/apache/bin/httpd -k start -DSSL
24560 nobody    15   0  324m  29m  13m S 12.4  0.1   0:13.96 /usr/local/apache/bin/httpd -k start -DSSL
 2423 nobody    15   0  325m  29m  12m S 11.6  0.1   0:02.98 /usr/local/apache/bin/httpd -k start -DSSL
11537 nobody    16   0  324m  30m  14m R 11.6  0.1   0:20.24 /usr/local/apache/bin/httpd -k start -DSSL
12171 nobody    16   0  324m  29m  13m R 10.8  0.1   0:27.00 /usr/local/apache/bin/httpd -k start -DSSL

[/CODE]
7-/etc/my.cnf
[CODE]
[mysqld]
tmpdir=/backup/tmp
local-infile=0
skip-networking
safe-show-database
#back_log = 50

max_connections = 1000
max_user_connections= 100
key_buffer_size = 768M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 4000
thread_cache_size = 384
wait_timeout = 10
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 128M
net_buffer_length = 16384
max_connect_errors = 10000
thread_concurrency = 16
concurrent_insert = 2
table_lock_wait_timeout = 30
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 1M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_write_lock_count = 8
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
nice = -10
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 786M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

[/CODE]
8- mysqladmin -u root -p var ext stat ver proc  
[CODE]
+---------------------------------+----------------------------------------+
| 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          | latin1                                 |
| character_set_filesystem        | binary                                 |
| character_set_results           | latin1                                 |
| character_set_server            | latin1                                 |
| character_set_system            | utf8                                   |
| character_sets_dir              | /usr/share/mysql/charsets/             |
| collation_connection            | latin1_swedish_ci                      |
| collation_database              | latin1_swedish_ci                      |
| collation_server                | latin1_swedish_ci                      |
| completion_type                 | 0                                      |
| concurrent_insert               | 2                                      |
| connect_timeout                 | 10                                     |
| 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          | 300                                    |
| 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                 | 4                                      |
| 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_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                 | DISABLED                               |
| have_openssl                    | NO                                     |
| have_ssl                        | NO                                     |
| have_query_cache                | YES                                    |
| have_raid                       | NO                                     |
| have_rtree_keys                 | YES                                    |
| have_symlink                    | YES                                    |
| hostname                        | al-wlid.al-wlid.com                    |
| 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                                  |
| interactive_timeout             | 28800                                  |
| join_buffer_size                | 1048576                                |
| key_buffer_size                 | 805306368                              |
| 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                    | OFF                                    |
| 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              | 134217728                              |
| max_binlog_cache_size           | 18446744073709547520                   |
| max_binlog_size                 | 1073741824                             |
| max_connect_errors              | 10000                                  |
| max_connections                 | 1000                                   |
| 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               | 18446744073709551615                   |
| max_sort_length                 | 1024                                   |
| max_sp_recursion_depth          | 0                                      |
| max_tmp_tables                  | 32                                     |
| max_user_connections            | 100                                    |
| max_write_lock_count            | 8                                      |
| multi_range_count               | 256                                    |
| myisam_data_pointer_size        | 6                                      |
| myisam_max_sort_file_size       | 9223372036853727232                    |
| myisam_recover_options          | OFF                                    |
| myisam_repair_threads           | 1                                      |
| myisam_sort_buffer_size         | 67108864                               |
| myisam_stats_method             | nulls_unequal                          |
| ndb_autoincrement_prefetch_sz   | 1                                      |
| ndb_force_send                  | ON                                     |
| ndb_use_exact_count             | ON                                     |
| ndb_use_transactions            | ON                                     |
| ndb_cache_check_time            | 0                                      |
| ndb_connectstring               |                                        |
| net_buffer_length               | 16384                                  |
| net_read_timeout                | 30                                     |
| net_retry_count                 | 10                                     |
| net_write_timeout               | 60                                     |
| new                             | OFF                                    |
| old_passwords                   | OFF                                    |
| open_files_limit                | 9010                                   |
| optimizer_prune_level           | 1                                      |
| optimizer_search_depth          | 62                                     |
| pid_file                        | /var/lib/mysql/al-wlid.al-wlid.com.pid |
| plugin_dir                      |                                        |
| port                            | 0                                      |
| preload_buffer_size             | 32768                                  |
| profiling                       | OFF                                    |
| profiling_history_size          | 15                                     |
| protocol_version                | 10                                     |
| query_alloc_block_size          | 65536                                  |
| query_cache_limit               | 1048576                                |
| query_cache_min_res_unit        | 4096                                   |
| query_cache_size                | 134217728                              |
| query_cache_type                | ON                                     |
| query_cache_wlock_invalidate    | OFF                                    |
| query_prealloc_size             | 262144                                 |
| range_alloc_block_size          | 4096                                   |
| read_buffer_size                | 1048576                                |
| read_only                       | OFF                                    |
| read_rnd_buffer_size            | 786432                                 |
| 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                       | 0                                      |
| skip_external_locking           | ON                                     |
| skip_networking                 | ON                                     |
| skip_show_database              | OFF                                    |
| slave_compressed_protocol       | OFF                                    |
| slave_load_tmpdir               | /backup/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                | 2097152                                |
| 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                | WET                                    |
| table_cache                     | 4000                                   |
| table_lock_wait_timeout         | 30                                     |
| table_type                      | MyISAM                                 |
| thread_cache_size               | 384                                    |
| thread_stack                    | 262144                                 |
| time_format                     | %H:%i:%s                               |
| time_zone                       | SYSTEM                                 |
| timed_mutexes                   | OFF                                    |
| tmp_table_size                  | 67108864                               |
| tmpdir                          | /backup/tmp                            |
| transaction_alloc_block_size    | 8192                                   |
| transaction_prealloc_size       | 4096                                   |
| tx_isolation                    | REPEATABLE-READ                        |
| updatable_views_with_limit      | YES                                    |
| version                         | 5.0.81-community                       |
| version_comment                 | MySQL Community Edition (GPL)          |
| version_compile_machine         | x86_64                                 |
| version_compile_os              | unknown-linux-gnu                      |
| wait_timeout                    | 10                                     |
+---------------------------------+----------------------------------------+
+-----------------------------------+-------------+
| Variable_name                     | Value       |
+-----------------------------------+-------------+
| Aborted_clients                   | 417         |
| Aborted_connects                  | 857         |
| Binlog_cache_disk_use             | 0           |
| Binlog_cache_use                  | 0           |
| Bytes_received                    | 754507455   |
| Bytes_sent                        | 53648413489 |
| Com_admin_commands                | 121         |
| 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                     | 370119      |
| 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                  | 2           |
| Com_create_user                   | 0           |
| Com_dealloc_sql                   | 0           |
| Com_delete                        | 636         |
| Com_delete_multi                  | 0           |
| Com_do                            | 0           |
| Com_drop_db                       | 0           |
| Com_drop_function                 | 0           |
| Com_drop_index                    | 0           |
| Com_drop_table                    | 2           |
| 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                        | 64656       |
| Com_insert_select                 | 2           |
| Com_kill                          | 0           |
| Com_load                          | 0           |
| Com_load_master_data              | 0           |
| Com_load_master_table             | 0           |
| Com_lock_tables                   | 105         |
| 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                       | 1082        |
| 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                        | 979114      |
| Com_set_option                    | 116         |
| 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                   | 1           |
| 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              | 34          |
| Com_show_slave_hosts              | 0           |
| Com_show_slave_status             | 0           |
| Com_show_status                   | 19          |
| Com_show_storage_engines          | 0           |
| Com_show_tables                   | 0           |
| Com_show_triggers                 | 0           |
| Com_show_variables                | 1           |
| 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                      | 2           |
| Com_unlock_tables                 | 105         |
| Com_update                        | 215955      |
| Com_update_multi                  | 2           |
| 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                       | 261731      |
| Created_tmp_disk_tables           | 195         |
| Created_tmp_files                 | 15805       |
| Created_tmp_tables                | 471588      |
| Delayed_errors                    | 0           |
| Delayed_insert_threads            | 0           |
| Delayed_writes                    | 0           |
| Flush_commands                    | 1           |
| Handler_commit                    | 0           |
| Handler_delete                    | 1219        |
| Handler_discover                  | 0           |
| Handler_prepare                   | 0           |
| Handler_read_first                | 62192       |
| Handler_read_key                  | 369984098   |
| Handler_read_next                 | 206328090   |
| Handler_read_prev                 | 147978      |
| Handler_read_rnd                  | 360641788   |
| Handler_read_rnd_next             | 1246051665  |
| Handler_rollback                  | 0           |
| Handler_savepoint                 | 0           |
| Handler_savepoint_rollback        | 0           |
| Handler_update                    | 210768      |
| Handler_write                     | 457752956   |
| Innodb_buffer_pool_pages_data     | 20          |
| Innodb_buffer_pool_pages_dirty    | 0           |
| Innodb_buffer_pool_pages_flushed  | 0           |
| Innodb_buffer_pool_pages_free     | 492         |
| Innodb_buffer_pool_pages_misc     | 0           |
| Innodb_buffer_pool_pages_total    | 512         |
| Innodb_buffer_pool_read_ahead_rnd | 1           |
| Innodb_buffer_pool_read_ahead_seq | 0           |
| Innodb_buffer_pool_read_requests  | 240         |
| Innodb_buffer_pool_reads          | 13          |
| Innodb_buffer_pool_wait_free      | 0           |
| Innodb_buffer_pool_write_requests | 0           |
| Innodb_data_fsyncs                | 3           |
| Innodb_data_pending_fsyncs        | 0           |
| Innodb_data_pending_reads         | 0           |
| Innodb_data_pending_writes        | 0           |
| Innodb_data_read                  | 2510848     |
| Innodb_data_reads                 | 26          |
| Innodb_data_writes                | 3           |
| Innodb_data_written               | 1536        |
| Innodb_dblwr_pages_written        | 0           |
| Innodb_dblwr_writes               | 0           |
| Innodb_log_waits                  | 0           |
| Innodb_log_write_requests         | 0           |
| Innodb_log_writes                 | 1           |
| Innodb_os_log_fsyncs              | 3           |
| Innodb_os_log_pending_fsyncs      | 0           |
| Innodb_os_log_pending_writes      | 0           |
| Innodb_os_log_written             | 512         |
| Innodb_page_size                  | 16384       |
| Innodb_pages_created              | 0           |
| Innodb_pages_read                 | 20          |
| Innodb_pages_written              | 0           |
| 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                 | 586088      |
| Key_blocks_used                   | 60630       |
| Key_read_requests                 | 1497402980  |
| Key_reads                         | 60631       |
| Key_write_requests                | 67819       |
| Key_writes                        | 61185       |
| Last_query_cost                   | 0.000000    |
| Max_used_connections              | 150         |
| Ndb_cluster_node_id               | 0           |
| Ndb_config_from_host              |             |
| Ndb_config_from_port              | 0           |
| Ndb_number_of_data_nodes          | 0           |
| Not_flushed_delayed_rows          | 0           |
| Open_files                        | 610         |
| Open_streams                      | 0           |
| Open_tables                       | 541         |
| Opened_tables                     | 555         |
| Prepared_stmt_count               | 0           |
| Qcache_free_blocks                | 3207        |
| Qcache_free_memory                | 89421984    |
| Qcache_hits                       | 1699759     |
| Qcache_inserts                    | 496964      |
| Qcache_lowmem_prunes              | 0           |
| Qcache_not_cached                 | 482029      |
| Qcache_queries_in_cache           | 5104        |
| Qcache_total_blocks               | 14435       |
| Queries                           | 3599589     |
| Questions                         | 3599589     |
| Rpl_status                        | NULL        |
| Select_full_join                  | 5           |
| Select_full_range_join            | 0           |
| Select_range                      | 209756      |
| Select_range_check                | 0           |
| Select_scan                       | 99865       |
| Slave_open_temp_tables            | 0           |
| Slave_retried_transactions        | 0           |
| Slave_running                     | OFF         |
| Slow_launch_threads               | 0           |
| Slow_queries                      | 0           |
| Sort_merge_passes                 | 7900        |
| Sort_range                        | 169255      |
| Sort_rows                         | 420213794   |
| Sort_scan                         | 441396      |
| Table_locks_immediate             | 1949936     |
| Table_locks_waited                | 76867       |
| Tc_log_max_pages_used             | 0           |
| Tc_log_page_size                  | 0           |
| Tc_log_page_waits                 | 0           |
| Threads_cached                    | 110         |
| Threads_connected                 | 40          |
| Threads_created                   | 150         |
| Threads_running                   | 33          |
| Uptime                            | 4895        |
| Uptime_since_flush_status         | 3599589     |
+-----------------------------------+-------------+
Uptime: 4895  Threads: 40  Questions: 3599591  Slow queries: 0  Opens: 555  Flush tables: 1  Open tables: 541  Queries per second avg: 735.361
mysqladmin  Ver 8.41 Distrib 5.0.81, for unknown-linux-gnu on x86_64
Copyright (C) 2000-2006 MySQL 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 5.0.81-community
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 hour 21 min 35 sec

Threads: 40  Questions: 3599591  Slow queries: 0  Opens: 555  Flush tables: 1  Open tables: 541  Queries per second avg: 735.361
+--------+---------------+-----------+---------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| Id     | User          | Host      | db            | Command | Time | State                | Info                                                                                                 |
+--------+---------------+-----------+---------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| 236320 | root          | localhost |               | Sleep   | 497  |                      |                                                                                                      |
| 261340 | forum_games | localhost | forum_games | Sleep   | 7    |                      |                                                                                                      |
| 261508 | eximstats     | localhost | eximstats     | Sleep   | 3    |                      |                                                                                                      |
| 261512 | forum_games | localhost | forum_games | Sleep   | 3    |                      |                                                                                                      |
| 261591 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | UPDATE session
SET lastactivity = 1250873530, inforum = 0, inthread = 0, incalendar = 0, badloc |
| 261636 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | UPDATE session
SET lastactivity = 1250873531, inforum = 0, inthread = 0, incalendar = 0, badloc |
| 261647 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | UPDATE session
SET lastactivity = 1250873531, inforum = 0, inthread = 0, incalendar = 0, badloc |
| 261650 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | UPDATE session
SET lastactivity = 1250873531, incalendar = 0, badlocation = 0, useragent = 'Moz |
| 261654 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | UPDATE session
SET lastactivity = 1250873531, location = '/index.php', inforum = 0, inthread =  |
| 261655 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | UPDATE session
SET lastactivity = 1250873531, location = '/index.php', inforum = 0, inthread =  |
| 261657 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, |
| 261658 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | UPDATE session
SET lastactivity = 1250873531, incalendar = 0, badlocation = 0
WHERE sessio |
| 261662 | forum_vb      | localhost | forum_vb      | Sleep   | 0    |                      |                                                                                                      |
| 261669 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, |
| 261670 | forum_vb      | localhost | forum_vb      | Query   | 0    | Copying to tmp table | SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, ses |
| 261674 | forum_vb      | localhost | forum_vb      | Query   | 0    | Sorting result       | SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, ses |
| 261678 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | SELECT *
FROM session
WHERE sessionhash = '4df0bc8bd7cc93044a69fdccd988a31b'
AND lastac |
| 261679 | forum_vb      | localhost | forum_vb      | Query   | 0    | Copying to tmp table | SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, ses |
| 261680 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | SELECT *
FROM session
WHERE sessionhash = '4775661818b9c79e230a8d23f9f7f15b'
AND lastac |
| 261683 | forum_vb      | localhost | forum_vb      | Query   | 0    | Copying to tmp table | SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, ses |
| 261684 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | SELECT *
FROM session
WHERE userid = 0
AND host = '196.202.94.42'
AND idhash = '35 |
| 261685 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | SELECT *
FROM session
WHERE userid = 0
AND host = '195.229.235.37'
AND idhash = 'b |
| 261686 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | SELECT *
FROM session
WHERE userid = 0
AND host = '212.118.126.253'
AND idhash = ' |
| 261687 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | SELECT *
FROM session
WHERE sessionhash = '9556d1a20320e7b9ba9e37daa86a798f'
AND lastac |
| 261689 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | SELECT *
FROM session
WHERE userid = 0
AND host = '41.238.235.115'
AND idhash = 'a |
| 261691 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | SELECT *
FROM session
WHERE userid = 0
AND host = '188.161.238.68'
AND idhash = '7 |
| 261693 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | SELECT *
FROM session
WHERE sessionhash = '65ed78267b2d8695b6a7634bbfc7bd1e'
AND lastac |
| 261696 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | SELECT *
FROM session
WHERE sessionhash = 'fc611b0f316fa037c1e22358a46ac240'
AND lastac |
| 261702 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | SELECT *
FROM session
WHERE sessionhash = 'd293cd5ea27884b8c65b323fb26d5652'
AND lastac |
| 261709 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | SELECT *
FROM session
WHERE userid = 0
AND host = '188.49.108.246'
AND idhash = '8 |
| 261710 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | SELECT *
FROM session
WHERE sessionhash = '950f102a42d660c6e178844870dbcd8a'
AND lastac |
| 261715 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | SELECT *
FROM session
WHERE sessionhash = '97078d2d2385f4c3fb8e13bc8a5bbbfb'
AND lastac |
| 261716 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | SELECT *
FROM session
WHERE sessionhash = '98381e7a71ec379ccf1cfd1ff00676ab'
AND lastac |
| 261719 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | SELECT *
FROM session
WHERE sessionhash = '8cb7f044b93894b08b1a0b3f44f7d973'
AND lastac |
| 261720 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | SELECT *
FROM session
WHERE sessionhash = '70b82bc073290a5518fb36354eeb427c'
AND lastac |
| 261722 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | SELECT *
FROM session
WHERE sessionhash = 'bd3f2491020bc934968407857fe84ee4'
AND lastac |
| 261725 | forum_vb      | localhost | forum_vb      | Sleep   | 0    |                      |                                                                                                      |
| 261727 | forum_vb      | localhost | forum_vb      | Query   | 0    | Locked               | SELECT *
FROM session
WHERE userid = 0
AND host = '94.96.193.37'
AND idhash = '9f6 |
| 261728 | forum_games | localhost | forum_games | Sleep   | 0    |                      |                                                                                                      |
| 261730 | root          | localhost |               | Query   | 0    |                      | show processlist                                                                                     |
+--------+---------------+-----------+---------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
[/CODE]
9- vb and other 3 small scripts
10- on timeout 900 I have 2500 to 3800 users online in real time
11-phpinfo attached
12-apache prefork values :
[CODE]
DeflateCompressionLevel 6
KeepAlive On
MaxKeepAliveRequests 80
KeepAliveTimeout 6
HostnameLookups Off
Timeout 7
StartServers 15
MinSpareServers 5
MaxSpareServers 20
ServerLimit 1024
MaxClients 1024
MaxRequestsPerChild 10000
[/CODE]
13- find / -size +2000000k :

/home/forum/tmp/analog/cache
14-
uname -a :
[CODE]
Linux server.server.com 2.6.18-128.1.10.el5 #1 SMP Thu May 7 10:35:59 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
[/CODE]
ulimit -aH :
[CODE]
core file size          (blocks, -c) 1000000
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 202752
max locked memory       (kbytes, -l) 32
max memory size         (kbytes, -m) unlimited
open files                      (-n) 4096
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 8192
cpu time               (seconds, -t) unlimited
max user processes              (-u) 14335
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited
[/CODE]
cat /proc/cpuinfo :
[CODE]

processor       : 0
vendor_id       : GenuineIntel
cpu family      : 6
model           : 23
model name      : Intel(R) Xeon(R) CPU           E5430  @ 2.66GHz
stepping        : 6
cpu MHz         : 2666.816
cache size      : 6144 KB
physical id     : 0
siblings        : 4
core id         : 0
cpu cores       : 4
apicid          : 0
fpu             : yes
fpu_exception   : yes
cpuid level     : 10
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 syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips        : 5335.66
clflush size    : 64
cache_alignment : 64
address sizes   : 38 bits physical, 48 bits virtual
power management:

processor       : 1
vendor_id       : GenuineIntel
cpu family      : 6
model           : 23
model name      : Intel(R) Xeon(R) CPU           E5430  @ 2.66GHz
stepping        : 6
cpu MHz         : 2666.816
cache size      : 6144 KB
physical id     : 1
siblings        : 4
core id         : 0
cpu cores       : 4
apicid          : 4
fpu             : yes
fpu_exception   : yes
cpuid level     : 10
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 syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips        : 5332.78
clflush size    : 64
cache_alignment : 64
address sizes   : 38 bits physical, 48 bits virtual
power management:

processor       : 2
vendor_id       : GenuineIntel
cpu family      : 6
model           : 23
model name      : Intel(R) Xeon(R) CPU           E5430  @ 2.66GHz
stepping        : 6
cpu MHz         : 2666.816
cache size      : 6144 KB
physical id     : 0
siblings        : 4
core id         : 1
cpu cores       : 4
apicid          : 1
fpu             : yes
fpu_exception   : yes
cpuid level     : 10
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 syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips        : 5332.85
clflush size    : 64
cache_alignment : 64
address sizes   : 38 bits physical, 48 bits virtual
power management:

processor       : 3
vendor_id       : GenuineIntel
cpu family      : 6
model           : 23
model name      : Intel(R) Xeon(R) CPU           E5430  @ 2.66GHz
stepping        : 6
cpu MHz         : 2666.816
cache size      : 6144 KB
physical id     : 1
siblings        : 4
core id         : 1
cpu cores       : 4
apicid          : 5
fpu             : yes
fpu_exception   : yes
cpuid level     : 10
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 syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips        : 5332.79
clflush size    : 64
cache_alignment : 64
address sizes   : 38 bits physical, 48 bits virtual
power management:

processor       : 4
vendor_id       : GenuineIntel
cpu family      : 6
model           : 23
model name      : Intel(R) Xeon(R) CPU           E5430  @ 2.66GHz
stepping        : 6
cpu MHz         : 2666.816
cache size      : 6144 KB
physical id     : 0
siblings        : 4
core id         : 2
cpu cores       : 4
apicid          : 2
fpu             : yes
fpu_exception   : yes
cpuid level     : 10
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 syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips        : 5332.82
clflush size    : 64
cache_alignment : 64
address sizes   : 38 bits physical, 48 bits virtual
power management:

processor       : 5
vendor_id       : GenuineIntel
cpu family      : 6
model           : 23
model name      : Intel(R) Xeon(R) CPU           E5430  @ 2.66GHz
stepping        : 6
cpu MHz         : 2666.816
cache size      : 6144 KB
physical id     : 1
siblings        : 4
core id         : 2
cpu cores       : 4
apicid          : 6
fpu             : yes
fpu_exception   : yes
cpuid level     : 10
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 syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips        : 5332.78
clflush size    : 64
cache_alignment : 64
address sizes   : 38 bits physical, 48 bits virtual
power management:

processor       : 6
vendor_id       : GenuineIntel
cpu family      : 6
model           : 23
model name      : Intel(R) Xeon(R) CPU           E5430  @ 2.66GHz
stepping        : 6
cpu MHz         : 2666.816
cache size      : 6144 KB
physical id     : 0
siblings        : 4
core id         : 3
cpu cores       : 4
apicid          : 3
fpu             : yes
fpu_exception   : yes
cpuid level     : 10
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 syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips        : 5332.75
clflush size    : 64
cache_alignment : 64
address sizes   : 38 bits physical, 48 bits virtual
power management:

processor       : 7
vendor_id       : GenuineIntel
cpu family      : 6
model           : 23
model name      : Intel(R) Xeon(R) CPU           E5430  @ 2.66GHz
stepping        : 6
cpu MHz         : 2666.816
cache size      : 6144 KB
physical id     : 1
siblings        : 4
core id         : 3
cpu cores       : 4
apicid          : 7
fpu             : yes
fpu_exception   : yes
cpuid level     : 10
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 syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips        : 5332.77
clflush size    : 64
cache_alignment : 64
address sizes   : 38 bits physical, 48 bits virtual
power management:
[/CODE]

[+][-]08/21/09 12:13 PM, ID: 25154877

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08/21/09 12:21 PM, ID: 25154943

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08/21/09 12:26 PM, ID: 25154999

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08/21/09 12:30 PM, ID: 25155032

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08/21/09 12:32 PM, ID: 25155053

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08/21/09 12:49 PM, ID: 25155197

View this solution now by starting your 30-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MySQL Server, Web Hosting, Apache Web Server
Tags: mysql, high load, optimization, performance, vBulletin
Sign Up Now!
Solution Provided By: fosiul01
Participating Experts: 2
Solution Grade: A
 
 
[+][-]08/21/09 01:03 PM, ID: 25155308

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08/21/09 01:11 PM, ID: 25155381

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08/21/09 01:32 PM, ID: 25155549

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08/21/09 01:33 PM, ID: 25155563

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08/21/09 02:04 PM, ID: 25155828

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08/21/09 03:48 PM, ID: 25156552

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08/21/09 05:06 PM, ID: 25156844

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08/22/09 01:06 AM, ID: 25157865

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08/22/09 01:15 AM, ID: 25157890

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08/22/09 01:33 AM, ID: 25157923

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08/22/09 06:04 AM, ID: 25158559

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08/23/09 04:01 AM, ID: 25162142

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-91 - Hierarchy / EE_QW_3_20080625