![]() |
I have a high load problem top - 23:10:30 up 8:23, 1 user, load average: 7.89, 8.56, 8.72 I have a high load problem My server has 2 quad core 8 GB ram. load and cpu usage is very high. Intensive site does not exist. 700 ~ 20 minutes of centering cooikede are members. I'm using Litespeed. PHP 5.2.9 MySQL Version 4.1.22-log mysql version 5 of 20 e rising down load does not. so increased. my.cnf: # The MySQL server [mysqld] port = 3306 socket = / var / lib / mysql / mysql.sock skip-locking key_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32m # Try number of CPU's * 2 for thread_concurrency thread_concurrency = 8 # Point the following paths to different dedicated disks # tmpdir = / tmp / # log-update = / path-to-dedicated-directory/hostname # Uncomment the following if you are using BDB tables # bdb_cache_size = 384M # bdb_max_lock = 100000 # Uncomment the following if you are using InnoDB tables # innodb_data_home_dir = / var / lib / mysql / # innodb_data_file_path = ibdata1: 2000; ibdata2: 10M: autoextend # innodb_log_group_home_dir = / var / lib / mysql / # innodb_log_arch_dir = / var / lib / mysql / # You can set .. _buffer_pool_size up to 50 - 80% # Of RAM but beware of setting memory usage too high # innodb_buffer_pool_size = 384M # innodb_additional_mem_pool_size = 20M # Set to 25% of buffer pool size _log_file_size .. # innodb_log_file_size = 100M # Binary logging is required for replication log-bin # Required unique id between 1 and 2 ^ 32 - 1 # Defaults to 1 if master-host is not set # But will not function as a master if omitted server-id = 1 # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname # Uncomment the following if you are using BDB tables #bdb_cache_size = 384M #bdb_max_lock = 100000 # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend #innodb_log_group_home_dir = /var/lib/mysql/ #innodb_log_arch_dir = /var/lib/mysql/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high #innodb_buffer_pool_size = 384M #innodb_additional_mem_pool_size = 20M # Set .._log_file_size to 25 % of buffer pool size #innodb_log_file_size = 100M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout php.ini: ; Allow ASP-style tags. asp_tags = Off ; The number of significant digits displayed in floating point numbers. precision = 14 ; Enforce year 2000 compliance (will cause problems with non-compliant browsers) y2k_compliance = On output_buffering = Off zlib.output_compression = Off implicit_flush = Off serialize_precision = 100 allow_call_time_pass_reference = Off ; ; Safe Mode ; safe_mode = On max_execution_time = 30 ; Maximum execution time of each script, in seconds max_input_time = 60 ; Maximum amount of time each script may spend parsing request data memory_limit = 32M ; Maximum size of POST data that PHP will accept. post_max_size = 8M ; This directive is deprecated. Use variables_order instead. gpc_order = "GPC" ; Whether to allow HTTP file uploads. file_uploads = On ; Temporary directory for HTTP uploaded files (will use system default if not ; specified). ;upload_tmp_dir = ; Maximum allowed size for uploaded files. upload_max_filesize = 2M ; Default timeout for socket based streams (seconds) default_socket_timeout = 60 [MySQL] ; Allow or prevent persistent links. mysql.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. mysql.max_persistent = -1 ; Maximum number of links (persistent + non-persistent). -1 means no limit. mysql.max_links = -1 [mSQL] ; Allow or prevent persistent links. msql.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. msql.max_persistent = -1 ; Maximum number of links (persistent+non persistent). -1 means no limit. msql.max_links = -1 [PostgresSQL] ; Allow or prevent persistent links. pgsql.allow_persistent = On ; Detect broken persistent links always with pg_pconnect(). ; Auto reset feature requires a little overheads. pgsql.auto_reset_persistent = Off ; Maximum number of persistent links. -1 means no limit. pgsql.max_persistent = -1 ; Maximum number of links (persistent+non persistent). -1 means no limit. pgsql.max_links = -1 ; Ignore PostgreSQL backends Notice message or not. ; Notice message logging require a little overheads. pgsql.ignore_notice = 0 ; Log PostgreSQL backends Noitce message or not. ; Unless pgsql.ignore_notice=0, module cannot log notice message. pgsql.log_notice = 0 ; Minimum error severity to display. mssql.min_error_severity = 10 ; Minimum message severity to display. mssql.min_message_severity = 10 ; Compatability mode with old versions of PHP 3.0. mssql.compatability_mode = Off ; Connect timeout ;mssql.connect_timeout = 5 ; Query timeout ;mssql.timeout = 60 ; Valid range 0 - 2147483647. Default = 4096. ;mssql.textlimit = 4096 ; Valid range 0 - 2147483647. Default = 4096. ;mssql.textsize = 4096 please help me |
الساعة الآن 03:29 PM |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By
Almuhajir