asasi
Mon 25th Jun '07, 3:50am
Hi
our forum is on a shared server and it has about 1.3 million posts and 30 users and 100 guests online. our site was on other shared server and maked old server load problem and we are now on a new shared server and its up but too slow.
website url: www.ziafat.com/forums
server details:
1. Shared server
2. Dual Processor Quad Core Xeon 5320 - 1.86Ghz
4 GB Ram
2 x 500 GB Raid 1
REDHAT Enterprise 4 i686
Apache Version 1.3.37
PHP version 4.4.6 / PHP 5 installed as secondary
MySQL version 5.0.27-standard
3.
4. yes
5.
6.top - 15:03:03 up 3 days, 43 min, 2 users, load average: 19.52, 19.41, 19.65
Tasks: 244 total, 2 running, 239 sleeping, 2 stopped, 1 zombie
Cpu(s): 0.9% us, 22.1% sy, 11.0% ni, 65.8% id, 0.2% wa, 0.0% 0.0% si
Mem: 4148848k total, 2895744k used, 1253104k free, 405180k buffers
Swap: 2096440k total, 348k used, 2096092k free, 1697700k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5245 mysql 21 6 150m 57m 4496 S 758 1.4 9774:22 mysqld
7641 ziafatco 21 4 90996 14m 3916 S 35 0.4 0:00.28 php
7645 root 15 0 2892 980 684 R 2 0.0 0:00.01 top
1 root 15 0 3252 548 468 S 0 0.0 0:10.11 init
2 root RT 0 0 0 0 S 0 0.0 0:00.67 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:00.07 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:04.44 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.42 ksoftirqd/1
6 root RT 0 0 0 0 S 0 0.0 0:00.16 migration/2
7 root 34 19 0 0 0 S 0 0.0 0:00.11 ksoftirqd/2
8 root RT 0 0 0 0 S 0 0.0 0:00.54 migration/3
9 root 34 19 0 0 0 S 0 0.0 0:00.64 ksoftirqd/3
10 root RT 0 0 0 0 S 0 0.0 0:02.66 migration/4
11 root 34 19 0 0 0 S 0 0.0 0:00.28 ksoftirqd/4
12 root RT 0 0 0 0 S 0 0.0 0:00.07 migration/5
13 root 34 19 0 0 0 S 0 0.0 0:01.05 ksoftirqd/5
14 root RT 0 0 0 0 S 0 0.0 0:00.96 migration/6
15 root 34 19 0 0 0 S 0 0.0 0:00.20 ksoftirqd/6
16 root RT 0 0 0 0 S 0 0.0 0:01.84 migration/7
17 root 34 19 0 0 0 S 0 0.0 0:00.20 ksoftirqd/7
18 root 5 -10 0 0 0 S 0 0.0 0:00.73 events/0
19 root 5 -10 0 0 0 S 0 0.0 0:00.10 events/1
20 root 5 -10 0 0 0 S 0 0.0 0:00.13 events/2
21 root 5 -10 0 0 0 S 0 0.0 0:00.02 events/3
22 root 5 -10 0 0 0 S 0 0.0 0:00.06 events/4
23 root 5 -10 0 0 0 S 0 0.0 0:00.05 events/5
24 root 5 -10 0 0 0 S 0 0.0 0:00.03 events/6
25 root 5 -10 0 0 0 S 0 0.0 0:00.05 events/7
26 root 5 -10 0 0 0 S 0 0.0 0:00.00 khelper
27 root 6 -10 0 0 0 S 0 0.0 0:00.00 kacpid
70 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/0
71 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/1
72 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/2
73 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/3
74 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/4
75 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/5
76 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/6
77 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/7
78 root 15 0 0 0 0 S 0 0.0 0:00.06 khubd
95 root 15 0 0 0 0 S 0 0.0 0:00.03 pdflush
97 root 15 0 0 0 0 S 0 0.0 0:07.42 kswapd0
98 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/0
99 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/1
100 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/2
101 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/3
102 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/4
103 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/5
104 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/6
105 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/7
7. mysqld]
set-variable = max_connections=500
safe-show-database
8. +---------------------------------+------------------------------------------------+
| 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 | 1 |
| connect_timeout | 5 |
| 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 |
| 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 | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_dynamic_loading | YES |
| have_example_engine | NO |
| have_federated_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_merge_engine | YES |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_checksums | ON |
| innodb_commit_concurrency | 0 |
| innodb_concurrency_tickets | 500 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| 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_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 | 131072 |
| key_buffer_size | 8388600 |
| 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 | 1048576 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 500 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| 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 | 0 |
| max_write_lock_count | 4294967295 |
| multi_range_count | 256 |
| myisam_data_pointer_size | 6 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 8388608 |
| 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 | OFF |
| open_files_limit | 4096 |
| optimizer_prune_level | 1 |
| optimizer_search_depth | 62 |
| pid_file | /var/lib/mysql/bm3.onlineserversystems.com.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 0 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 131072 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 0 |
| 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 | 2097144 |
| 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 | 64 |
| table_lock_wait_timeout | 50 |
| table_type | MyISAM |
| thread_cache_size | 0 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| timed_mutexes | OFF |
| tmp_table_size | 33554432 |
| tmpdir | /tmp/ |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| updatable_views_with_limit | YES |
| version | 5.0.27-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 28800 |
+---------------------------------+------------------------------------------------+
+-----------------------------------+------------+
| Variable_name | Value |
+-----------------------------------+------------+
| Aborted_clients | 90 |
| Aborted_connects | 24060 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 1670354167 |
| Bytes_sent | 3635288081 |
| Com_admin_commands | 78 |
| Com_alter_db | 0 |
| Com_alter_table | 132 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 635 |
| Com_change_db | 505689 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 635 |
| Com_create_db | 18 |
| Com_create_function | 0 |
| Com_create_index | 8 |
| Com_create_table | 868 |
| Com_dealloc_sql | 0 |
| Com_delete | 47185 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 6 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 818 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 1022 |
| Com_grant | 2155 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 191398 |
| Com_insert_select | 1091 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 60053 |
| Com_optimize | 23 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 1 |
| Com_replace | 47706 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 21 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 6576436 |
| Com_set_option | 7727 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 19 |
| Com_show_charsets | 174 |
| Com_show_collations | 174 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 249 |
| Com_show_databases | 988 |
| Com_show_errors | 0 |
| Com_show_fields | 566 |
| Com_show_grants | 199 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 38 |
| 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 | 875 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 7 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 5186 |
| Com_show_triggers | 241 |
| Com_show_variables | 867 |
| 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 | 328 |
| Com_unlock_tables | 60051 |
| Com_update | 370433 |
| Com_update_multi | 1654 |
| 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 | 321447 |
| Created_tmp_disk_tables | 82285 |
| Created_tmp_files | 6 |
| Created_tmp_tables | 419610 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 1273 |
| Handler_delete | 175840 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 1001802 |
| Handler_read_key | 512263767 |
| Handler_read_next | 313416086 |
| Handler_read_prev | 3100750 |
| Handler_read_rnd | 23396756 |
| Handler_read_rnd_next | 2650532306 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 364383825 |
| Handler_write | 10544377 |
| Innodb_buffer_pool_pages_data | 63 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 2638 |
| Innodb_buffer_pool_pages_free | 448 |
| Innodb_buffer_pool_pages_latched | 0 |
| Innodb_buffer_pool_pages_misc | 1 |
| Innodb_buffer_pool_pages_total | 512 |
| Innodb_buffer_pool_read_ahead_rnd | 3 |
| Innodb_buffer_pool_read_ahead_seq | 0 |
| Innodb_buffer_pool_read_requests | 51981 |
| Innodb_buffer_pool_reads | 23 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 12094 |
| Innodb_data_fsyncs | 1685 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 4214784 |
| Innodb_data_reads | 121 |
| Innodb_data_writes | 2977 |
| Innodb_data_written | 96594944 |
| Innodb_dblwr_pages_written | 2638 |
| Innodb_dblwr_writes | 346 |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 19601 |
| Innodb_log_writes | 745 |
| Innodb_os_log_fsyncs | 990 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 10026496 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 20 |
| Innodb_pages_read | 43 |
| Innodb_pages_written | 2638 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 919 |
| Innodb_row_lock_time_avg | 39 |
| Innodb_row_lock_time_max | 144 |
| Innodb_row_lock_waits | 23 |
| Innodb_rows_deleted | 36 |
| Innodb_rows_inserted | 35 |
| Innodb_rows_read | 1567 |
| Innodb_rows_updated | 589 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 6209 |
| Key_blocks_used | 7248 |
| Key_read_requests | 451666052 |
| Key_reads | 9728571 |
| Key_write_requests | 2805639 |
| Key_writes | 720573 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 105 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 86 |
| Open_streams | 0 |
| Open_tables | 64 |
| Opened_tables | 1887811 |
| Qcache_free_blocks | 0 |
| Qcache_free_memory | 0 |
| Qcache_hits | 0 |
| Qcache_inserts | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 0 |
| Questions | 8184182 |
| Rpl_status | NULL |
| Select_full_join | 26683 |
| Select_full_range_join | 55 |
| Select_range | 773654 |
| Select_range_check | 0 |
| Select_scan | 1322569 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 176 |
| Sort_merge_passes | 0 |
| Sort_range | 992445 |
| Sort_rows | 172122477 |
| Sort_scan | 605817 |
| Table_locks_immediate | 11108987 |
| Table_locks_waited | 641 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 0 |
| Threads_connected | 18 |
| Threads_created | 321446 |
| Threads_running | 16 |
| Uptime | 260323 |
+-----------------------------------+------------+
Uptime: 260323 Threads: 18 Questions: 8184183 Slow queries: 176 Opens: 1887811 Flush tables: 1 Open tables: 64 Queries per second avg: 31.439
mysqladmin Ver 8.41 Distrib 5.0.27, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.0.27-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 3 days 18 min 43 sec
Threads: 18 Questions: 8184183 Slow queries: 176 Opens: 1887811 Flush tables: 1 Open tables: 64 Queries per second avg: 31.439
9. No, other scripts and sites utilise php and mysql.
10.
11. www.ziafat.com/phpinfo.php
12. KeepAlive ON
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 150
13. no
14. Linux bm3.onlineserversystems.com 2.6.9-42.0.10.ELsmp #1 SMP Fri Feb 16 17:17:21 EST 2007 i686 i686 i386 GNU/Linux
core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 4096
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU E5320 @ 1.86GHz
stepping : 7
cpu MHz : 1867.683
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 0
cpu cores : 4
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
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 pbe nx lm pni monitor ds_cpl est tm2 xtpr
bogomips : 3736.41
processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU E5320 @ 1.86GHz
stepping : 7
cpu MHz : 1867.683
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 1
cpu cores : 4
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
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 pbe nx lm pni monitor ds_cpl est tm2 xtpr
bogomips : 3732.92
processor : 2
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU E5320 @ 1.86GHz
stepping : 7
cpu MHz : 1867.683
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 2
cpu cores : 4
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
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 pbe nx lm pni monitor ds_cpl est tm2 xtpr
bogomips : 3732.93
processor : 3
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU E5320 @ 1.86GHz
stepping : 7
cpu MHz : 1867.683
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 3
cpu cores : 4
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
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 pbe nx lm pni monitor ds_cpl est tm2 xtpr
bogomips : 3732.95
processor : 4
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU E5320 @ 1.86GHz
stepping : 7
cpu MHz : 1867.683
cache size : 4096 KB
physical id : 1
siblings : 4
core id : 4
cpu cores : 4
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
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 pbe nx lm pni monitor ds_cpl est tm2 xtpr
bogomips : 3732.98
processor : 5
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU E5320 @ 1.86GHz
stepping : 7
cpu MHz : 1867.683
cache size : 4096 KB
physical id : 1
siblings : 4
core id : 5
cpu cores : 4
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
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 pbe nx lm pni monitor ds_cpl est tm2 xtpr
bogomips : 3732.99
processor : 6
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU E5320 @ 1.86GHz
stepping : 7
cpu MHz : 1867.683
cache size : 4096 KB
physical id : 1
siblings : 4
core id : 6
cpu cores : 4
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
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 pbe nx lm pni monitor ds_cpl est tm2 xtpr
bogomips : 3733.02
processor : 7
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU E5320 @ 1.86GHz
stepping : 7
cpu MHz : 1867.683
cache size : 4096 KB
physical id : 1
siblings : 4
core id : 7
cpu cores : 4
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
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 pbe nx lm pni monitor ds_cpl est tm2 xtpr
bogomips : 3732.97
than you very much for your time spending
our forum is on a shared server and it has about 1.3 million posts and 30 users and 100 guests online. our site was on other shared server and maked old server load problem and we are now on a new shared server and its up but too slow.
website url: www.ziafat.com/forums
server details:
1. Shared server
2. Dual Processor Quad Core Xeon 5320 - 1.86Ghz
4 GB Ram
2 x 500 GB Raid 1
REDHAT Enterprise 4 i686
Apache Version 1.3.37
PHP version 4.4.6 / PHP 5 installed as secondary
MySQL version 5.0.27-standard
3.
4. yes
5.
6.top - 15:03:03 up 3 days, 43 min, 2 users, load average: 19.52, 19.41, 19.65
Tasks: 244 total, 2 running, 239 sleeping, 2 stopped, 1 zombie
Cpu(s): 0.9% us, 22.1% sy, 11.0% ni, 65.8% id, 0.2% wa, 0.0% 0.0% si
Mem: 4148848k total, 2895744k used, 1253104k free, 405180k buffers
Swap: 2096440k total, 348k used, 2096092k free, 1697700k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5245 mysql 21 6 150m 57m 4496 S 758 1.4 9774:22 mysqld
7641 ziafatco 21 4 90996 14m 3916 S 35 0.4 0:00.28 php
7645 root 15 0 2892 980 684 R 2 0.0 0:00.01 top
1 root 15 0 3252 548 468 S 0 0.0 0:10.11 init
2 root RT 0 0 0 0 S 0 0.0 0:00.67 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:00.07 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:04.44 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.42 ksoftirqd/1
6 root RT 0 0 0 0 S 0 0.0 0:00.16 migration/2
7 root 34 19 0 0 0 S 0 0.0 0:00.11 ksoftirqd/2
8 root RT 0 0 0 0 S 0 0.0 0:00.54 migration/3
9 root 34 19 0 0 0 S 0 0.0 0:00.64 ksoftirqd/3
10 root RT 0 0 0 0 S 0 0.0 0:02.66 migration/4
11 root 34 19 0 0 0 S 0 0.0 0:00.28 ksoftirqd/4
12 root RT 0 0 0 0 S 0 0.0 0:00.07 migration/5
13 root 34 19 0 0 0 S 0 0.0 0:01.05 ksoftirqd/5
14 root RT 0 0 0 0 S 0 0.0 0:00.96 migration/6
15 root 34 19 0 0 0 S 0 0.0 0:00.20 ksoftirqd/6
16 root RT 0 0 0 0 S 0 0.0 0:01.84 migration/7
17 root 34 19 0 0 0 S 0 0.0 0:00.20 ksoftirqd/7
18 root 5 -10 0 0 0 S 0 0.0 0:00.73 events/0
19 root 5 -10 0 0 0 S 0 0.0 0:00.10 events/1
20 root 5 -10 0 0 0 S 0 0.0 0:00.13 events/2
21 root 5 -10 0 0 0 S 0 0.0 0:00.02 events/3
22 root 5 -10 0 0 0 S 0 0.0 0:00.06 events/4
23 root 5 -10 0 0 0 S 0 0.0 0:00.05 events/5
24 root 5 -10 0 0 0 S 0 0.0 0:00.03 events/6
25 root 5 -10 0 0 0 S 0 0.0 0:00.05 events/7
26 root 5 -10 0 0 0 S 0 0.0 0:00.00 khelper
27 root 6 -10 0 0 0 S 0 0.0 0:00.00 kacpid
70 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/0
71 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/1
72 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/2
73 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/3
74 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/4
75 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/5
76 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/6
77 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/7
78 root 15 0 0 0 0 S 0 0.0 0:00.06 khubd
95 root 15 0 0 0 0 S 0 0.0 0:00.03 pdflush
97 root 15 0 0 0 0 S 0 0.0 0:07.42 kswapd0
98 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/0
99 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/1
100 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/2
101 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/3
102 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/4
103 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/5
104 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/6
105 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/7
7. mysqld]
set-variable = max_connections=500
safe-show-database
8. +---------------------------------+------------------------------------------------+
| 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 | 1 |
| connect_timeout | 5 |
| 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 |
| 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 | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_dynamic_loading | YES |
| have_example_engine | NO |
| have_federated_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_merge_engine | YES |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_checksums | ON |
| innodb_commit_concurrency | 0 |
| innodb_concurrency_tickets | 500 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| 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_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 | 131072 |
| key_buffer_size | 8388600 |
| 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 | 1048576 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 500 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| 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 | 0 |
| max_write_lock_count | 4294967295 |
| multi_range_count | 256 |
| myisam_data_pointer_size | 6 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 8388608 |
| 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 | OFF |
| open_files_limit | 4096 |
| optimizer_prune_level | 1 |
| optimizer_search_depth | 62 |
| pid_file | /var/lib/mysql/bm3.onlineserversystems.com.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 0 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 131072 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 0 |
| 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 | 2097144 |
| 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 | 64 |
| table_lock_wait_timeout | 50 |
| table_type | MyISAM |
| thread_cache_size | 0 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| timed_mutexes | OFF |
| tmp_table_size | 33554432 |
| tmpdir | /tmp/ |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| updatable_views_with_limit | YES |
| version | 5.0.27-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 28800 |
+---------------------------------+------------------------------------------------+
+-----------------------------------+------------+
| Variable_name | Value |
+-----------------------------------+------------+
| Aborted_clients | 90 |
| Aborted_connects | 24060 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 1670354167 |
| Bytes_sent | 3635288081 |
| Com_admin_commands | 78 |
| Com_alter_db | 0 |
| Com_alter_table | 132 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 635 |
| Com_change_db | 505689 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 635 |
| Com_create_db | 18 |
| Com_create_function | 0 |
| Com_create_index | 8 |
| Com_create_table | 868 |
| Com_dealloc_sql | 0 |
| Com_delete | 47185 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 6 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 818 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 1022 |
| Com_grant | 2155 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 191398 |
| Com_insert_select | 1091 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 60053 |
| Com_optimize | 23 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 1 |
| Com_replace | 47706 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 21 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 6576436 |
| Com_set_option | 7727 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 19 |
| Com_show_charsets | 174 |
| Com_show_collations | 174 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 249 |
| Com_show_databases | 988 |
| Com_show_errors | 0 |
| Com_show_fields | 566 |
| Com_show_grants | 199 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 38 |
| 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 | 875 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 7 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 5186 |
| Com_show_triggers | 241 |
| Com_show_variables | 867 |
| 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 | 328 |
| Com_unlock_tables | 60051 |
| Com_update | 370433 |
| Com_update_multi | 1654 |
| 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 | 321447 |
| Created_tmp_disk_tables | 82285 |
| Created_tmp_files | 6 |
| Created_tmp_tables | 419610 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 1273 |
| Handler_delete | 175840 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 1001802 |
| Handler_read_key | 512263767 |
| Handler_read_next | 313416086 |
| Handler_read_prev | 3100750 |
| Handler_read_rnd | 23396756 |
| Handler_read_rnd_next | 2650532306 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 364383825 |
| Handler_write | 10544377 |
| Innodb_buffer_pool_pages_data | 63 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 2638 |
| Innodb_buffer_pool_pages_free | 448 |
| Innodb_buffer_pool_pages_latched | 0 |
| Innodb_buffer_pool_pages_misc | 1 |
| Innodb_buffer_pool_pages_total | 512 |
| Innodb_buffer_pool_read_ahead_rnd | 3 |
| Innodb_buffer_pool_read_ahead_seq | 0 |
| Innodb_buffer_pool_read_requests | 51981 |
| Innodb_buffer_pool_reads | 23 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 12094 |
| Innodb_data_fsyncs | 1685 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 4214784 |
| Innodb_data_reads | 121 |
| Innodb_data_writes | 2977 |
| Innodb_data_written | 96594944 |
| Innodb_dblwr_pages_written | 2638 |
| Innodb_dblwr_writes | 346 |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 19601 |
| Innodb_log_writes | 745 |
| Innodb_os_log_fsyncs | 990 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 10026496 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 20 |
| Innodb_pages_read | 43 |
| Innodb_pages_written | 2638 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 919 |
| Innodb_row_lock_time_avg | 39 |
| Innodb_row_lock_time_max | 144 |
| Innodb_row_lock_waits | 23 |
| Innodb_rows_deleted | 36 |
| Innodb_rows_inserted | 35 |
| Innodb_rows_read | 1567 |
| Innodb_rows_updated | 589 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 6209 |
| Key_blocks_used | 7248 |
| Key_read_requests | 451666052 |
| Key_reads | 9728571 |
| Key_write_requests | 2805639 |
| Key_writes | 720573 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 105 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 86 |
| Open_streams | 0 |
| Open_tables | 64 |
| Opened_tables | 1887811 |
| Qcache_free_blocks | 0 |
| Qcache_free_memory | 0 |
| Qcache_hits | 0 |
| Qcache_inserts | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 0 |
| Questions | 8184182 |
| Rpl_status | NULL |
| Select_full_join | 26683 |
| Select_full_range_join | 55 |
| Select_range | 773654 |
| Select_range_check | 0 |
| Select_scan | 1322569 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 176 |
| Sort_merge_passes | 0 |
| Sort_range | 992445 |
| Sort_rows | 172122477 |
| Sort_scan | 605817 |
| Table_locks_immediate | 11108987 |
| Table_locks_waited | 641 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 0 |
| Threads_connected | 18 |
| Threads_created | 321446 |
| Threads_running | 16 |
| Uptime | 260323 |
+-----------------------------------+------------+
Uptime: 260323 Threads: 18 Questions: 8184183 Slow queries: 176 Opens: 1887811 Flush tables: 1 Open tables: 64 Queries per second avg: 31.439
mysqladmin Ver 8.41 Distrib 5.0.27, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.0.27-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 3 days 18 min 43 sec
Threads: 18 Questions: 8184183 Slow queries: 176 Opens: 1887811 Flush tables: 1 Open tables: 64 Queries per second avg: 31.439
9. No, other scripts and sites utilise php and mysql.
10.
11. www.ziafat.com/phpinfo.php
12. KeepAlive ON
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 150
13. no
14. Linux bm3.onlineserversystems.com 2.6.9-42.0.10.ELsmp #1 SMP Fri Feb 16 17:17:21 EST 2007 i686 i686 i386 GNU/Linux
core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 4096
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU E5320 @ 1.86GHz
stepping : 7
cpu MHz : 1867.683
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 0
cpu cores : 4
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
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 pbe nx lm pni monitor ds_cpl est tm2 xtpr
bogomips : 3736.41
processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU E5320 @ 1.86GHz
stepping : 7
cpu MHz : 1867.683
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 1
cpu cores : 4
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
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 pbe nx lm pni monitor ds_cpl est tm2 xtpr
bogomips : 3732.92
processor : 2
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU E5320 @ 1.86GHz
stepping : 7
cpu MHz : 1867.683
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 2
cpu cores : 4
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
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 pbe nx lm pni monitor ds_cpl est tm2 xtpr
bogomips : 3732.93
processor : 3
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU E5320 @ 1.86GHz
stepping : 7
cpu MHz : 1867.683
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 3
cpu cores : 4
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
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 pbe nx lm pni monitor ds_cpl est tm2 xtpr
bogomips : 3732.95
processor : 4
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU E5320 @ 1.86GHz
stepping : 7
cpu MHz : 1867.683
cache size : 4096 KB
physical id : 1
siblings : 4
core id : 4
cpu cores : 4
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
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 pbe nx lm pni monitor ds_cpl est tm2 xtpr
bogomips : 3732.98
processor : 5
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU E5320 @ 1.86GHz
stepping : 7
cpu MHz : 1867.683
cache size : 4096 KB
physical id : 1
siblings : 4
core id : 5
cpu cores : 4
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
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 pbe nx lm pni monitor ds_cpl est tm2 xtpr
bogomips : 3732.99
processor : 6
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU E5320 @ 1.86GHz
stepping : 7
cpu MHz : 1867.683
cache size : 4096 KB
physical id : 1
siblings : 4
core id : 6
cpu cores : 4
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
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 pbe nx lm pni monitor ds_cpl est tm2 xtpr
bogomips : 3733.02
processor : 7
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU E5320 @ 1.86GHz
stepping : 7
cpu MHz : 1867.683
cache size : 4096 KB
physical id : 1
siblings : 4
core id : 7
cpu cores : 4
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
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 pbe nx lm pni monitor ds_cpl est tm2 xtpr
bogomips : 3732.97
than you very much for your time spending