|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
<div>Hello, I would greatly appreciate it if someone would look over my setup and offer some advice as to any improvements that could be made. Thanks in advance! 1. Dedicated server 2. Quote: processor : 1 vendor_id : AuthenticAMD cpu family : 15 model : 67 model name : Dual-Core AMD Opteron(tm) Processor 1212 stepping : 3 cpu MHz : 1000.000 cache size : 1024 KB cpu cores : 2 Ram: 2GB DDR RAM OS: Red Hat Enterprise Linux 5 - 64 bit PHP Version 5.1.6 Apache version - 2.2.3 Hard drive: 250GB SATA Raid: SATA RAID Controller (RAID 1) MySql version: 5.0.45 3. vBulletin 3.8.1 4. N/A 5. C compiler: gcc (GCC) 4.1.2 20071124 (Red Hat 4.1.2-41) >C++ compiler: g++ (GCC) 4.1.2 20071124 (Red Hat 4.1.2-41) 6. Quote: top - 15:05:59 up 2:43, 1 user, load average: 1.88, 1.86, 1.66 Tasks: 126 total, 2 running, 124 sleeping, 0 stopped, 0 zombie Cpu0 : 40.2%us, 3.7%sy, 0.0%ni, 56.1%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu1 : 73.2%us, 5.6%sy, 0.0%ni, 20.5%id, 0.0%wa, 0.3%hi, 0.3%si, 0.0%st Mem: 2059748k total, 1817328k used, 242420k free, 46404k buffers Swap: 2040244k total, 74616k used, 1965628k free, 1054500k cached 7. Quote: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock #old_passwords=1 skip-locking key_buffer = 64M max_allowed_packet = 16M table_cache = 2048 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 16 thread_concurrency = 8 query_cache_size = 32M tmp_table_size=64M back_log = 100 max_connect_errors = 10000 join_buffer_size=1M open-files = 20000 max_connections = 500 interactive_timeout = 600 wait_timeout = 600 #max_connections=200 # The following directives should be commented out # but included as they are things that get added # very frequently on tickets. These are more in a # need-this-feature basis. # The below 2 cannot be set on the fly. If the customer already has # InnoDB tables and wants to change the size of the InnoDB tablespace # and InnoDB logs, then: # 1. Run a full backup with mysqldump # 2. Stop MySQL # 3. Move current ibdata and ib_logfiles out of /var/lib/mysql # 4. Uncomment the below innodb_data_file_path and innodb_log_file_size # 5. Start MySQL (it will recreate new InnoDB files) # 6. Restore data from backup #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend #innodb_log_file_size = 100M innodb_buffer_pool_size = 64M innodb_additional_mem_pool_size = 8M #log-slow-queries=/var/lib/mysqllogs/slow-log #long_query_time=2 #log-queries-not-using-indexes #log-bin=/var/lib/mysqllogs/bin-log #log-slave-updates #expire_logs_days = 14 server-id = 1 [mysql.server] user=mysql #basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid open_files_limit=65536 8. <div style="margin:20px; margin-top:5px; "> Quote: +---------------------------------+---------------------------------------------------------+ | Variable_name | Value | +---------------------------------+---------------------------------------------------------+ | auto_increment_increment | 1 | | auto_increment_offset | 1 | | automatic_sp_privileges | ON | | back_log | 100 | | basedir | /usr/ | | bdb_cache_size | 8388600 | | bdb_home | /var/lib/mysql/ | | bdb_log_buffer_size | 1048576 | | 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 | 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 | + -> __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
أدوات الموضوع | |
انواع عرض الموضوع | |
| |
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
Server Optimisation Request | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 05-06-2009 07:10 PM |
Server Optimisation Request | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 04-30-2009 03:40 AM |
Server optimisation request | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 04-30-2009 01:40 AM |
Server (VPS) optimisation request | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 04-21-2009 01:10 AM |
Server (VPS) optimisation request | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 04-21-2009 01:00 AM |