|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
I hope I have all the required information below. Pleases advise if you need anything else. I really appreciate any help I can get as I have been having odd issues and I just want to make sure I have a good configuration moving forward on this new server. THANK YOU in advance! 1.) Dedicated. 2.) Intel(R) Core(TM)2 Quad CPU Q9400 @ 2.66GHz 4GB of DDR2 RAM 1 x 250 GB SATA II Linux CentOS 5.3 (Final) (32bit) 2.6.18-128.2.1.el5PAE i686 Kernel Apache 2.2.3 PHP 5.1.6 (cli) (built: Apr 7 2009 0804) Copyright (c) 1997-2006 The PHP Group Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies with XCache v1.2.2, Copyright (c) 2005-2007, by mOo with the ionCube PHP Loader v3.1.16, Copyright (c) 2002-2006, by ionCube Ltd. MySQL 5.0.45-7.el5 Plesk 9.2.1 3.) vBulletin 3.8.3, with latest vbSEO install, also using xCache file store system in config.php 4.) I have to keep innodb enabled for Plesk to work - I suppose. When I skip-innodb mysqld can restart just fine, but plesk gives errors. 5.) Unsure on how mySQL was compiled 6.) top top - 22:07:16 up 23:19, 1 user, load average: 0.24, 0.14, 0.13 Tasks: 183 total, 1 running, 175 sleeping, 6 stopped, 1 zombie Cpu0 : 4.4%us, 0.9%sy, 0.0%ni, 94.6%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu1 : 0.6%us, 0.0%sy, 0.0%ni, 99.4%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu2 : 0.6%us, 0.3%sy, 0.0%ni, 99.1%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu3 : 18.7%us, 1.9%sy, 0.0%ni, 77.8%id, 1.6%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 4148560k total, 3460592k used, 687968k free, 423056k buffers Swap: 2096472k total, 0k used, 2096472k free, 1938852k cached 7.) nano my.cnf [mysqld] set-variable=local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 safe-show-database back_log = 50 max_connections = 500 key_buffer_size = 128M 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 = 60 connect_timeout = 10 tmp_table_size = 64M max_heap_table_size = 64M max_allowed_packet = 64M net_buffer_length = 16384 max_connect_errors = 100000 thread_concurrency = 8 concurrent_insert = 2 table_lock_wait_timeout = 30 read_rnd_buffer_size = 786432 bulk_insert_buffer_size = 8M query_cache_limit = 4M query_cache_size = 96M 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 [mysqldump] quick max_allowed_packet = 64M [myisamchk] key_buffer = 64M sort_buffer = 16M read_buffer = 16M write_buffer = 16M [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid nice = -5 open_files_limit = 8192 8.) +--------------------------------- +---------------------------------------------------------+ | Variable_name | Value | +--------------------------------- +---------------------------------------------------------+ | auto_increment_increment | 1 | | auto_increment_offset | 1 | | automatic_sp_privileges | ON | | back_log | 50 | | basedir | /usr/ | | bdb_cache_size | 8388600 | | bdb_home | /var/lib/mysql/ | | bdb_log_buffer_size | 2048000 | | bdb_logdir | | | bdb_max_lock | 10000 | | bdb_shared_data | OFF | | bdb_tmpdir | /tmp/ | | 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 | | engine_condition_pushdown | OFF | | expire_logs_days | 0 | | flush | OFF | | flush_time | 0 | | ft_boolean_syntax | + ->br /;; For windows users, replace xcache.so with php_xcache.dllbr /zend_extension_ts = c:/php/extensions/php_xcache.dllbr /;; or install as extension, make sure your extension_dir setting is correctbr /; extension = xcache.sobr /;; or win32:br /; extension = php_xcache.dllbr /br /br /[xcache]br /; ini only settings, all the values here is default unless explainedbr /br /; select low level shm/allocator scheme implemenationbr /xcache.shm_scheme = "mmap"br /; to disable: xcache.size=0br /; to enable : xcache.size=64M etc (any size > 0) and your system mmap allows xcache.size = 164M ; set to cpu count (cat /proc/cpuinfo |grep -c processor) xcache.count = 4 ; just a hash hints, you can always store count(items) > slots xcache.slots = 2K ; ttl of the cache item, 0=forever xcache.ttl = 0 ; interval of gc scanning expired items, 0=no scan, other values is in seconds xcache.gc_interval = 0 ; same as aboves but for variable cache xcache.var_size = 2M xcache.var_count = 4 xcache.var_slots = 2K ; default ttl xcache.var_ttl = 0 xcache.var_maxttl = 0 xcache.var_gc_interval = 300 xcache.test = Off ; N/A for /dev/zero xcache.readonly_protection = Off ; for *nix, xcache.mmap_path is a file path, not directory. ; Use something like "/tmp/xcache" if you want to turn on ReadonlyProtection ; 2 group of php won't share the same /tmp/xcache ; for win32, xcache.mmap_path=anonymous map name, not file path xcache.mmap_path = "/dev/zero" ; leave it blank(disabled) or "/tmp/phpcore/" ; make sure it's writable by php (without checking open_basedir) xcache.coredump_directory = "" ; per request settings xcache.cacher = On xcache.stat = On xcache.optimizer = On [xcache.coverager] ; per request settings ; enable coverage data collecting for xcache.coveragedump_directory and xcache_coverager_start/stop/get/clean() functions (will hurt executing performance) xcache.coverager = Off ; ini only settings ; make sure it's readable (care open_basedir) by coverage viewer script ; requires xcache.coverager=On xcache.coveragedump_directory = "" __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
Server optimization request | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 06-20-2009 04:10 PM |
Server Optimization Request. First time optimization | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 06-08-2009 04:40 AM |
Server Optimization Request | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 05-07-2009 05:50 AM |
Server Optimization Request - Please help! Server loads way too high! | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 05-05-2009 02:00 AM |
Server Optimization Request | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 04-20-2009 03:30 PM |