منتدى استراحات زايد - Server Optimizing Request

<div>1. Is this on dedicated or shared virual server. If shared, how many sites share this server (ask web host if needed) dedicated
2. your server specs. For example:

cpu speed/type single or dual cpus): AMD Athlon(tm) 64 X2 Dual Core Processor 4200+
how much memory installed: 2gb ram
hard drive type/configuration: 2 x 300gb Sata
linux distributor or windows version: Debian lenny
apache/IIS version: nginx
PHP version: PHP 5.2.6-1+lenny3 with Suhosin-Patch 0.9.6.2 (cli) (built: Apr 26 2009 22:16:23)
MySQL version: mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486)

3. what version of vB are you running ? 3.8.2

4. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ? No
5. if possible how mysql was compiled/installed
6. your top stats. So log into your server via ssh telnet as root user and type the command in bold - top

You'll see stats like the following

PHP Code:

top - 18:22:22 up 1:10, 1 user, load average: 4.17, 4.12, 3.74
Tasks: 90 total, 4 running, 86 sleeping, 0 stopped, 0 zombie
Cpu(s): 87.5%us, 11.5%sy, 0.0%ni, 0.7%id, 0.0%wa, 0.0%hi, 0.3%si, 0.0%st
Mem: 2075208k total, 682532k used, 1392676k free, 42240k buffers
Swap: 4200988k total, 0k used, 4200988k free, 509672k cached

i.e. after hitting 1

PHP Code:

top - 18:21:36 up 1:09, 1 user, load average: 4.13, 4.10, 3.72
Tasks: 108 total, 3 running, 105 sleeping, 0 stopped, 0 zombie
Cpu0 : 87.3%us, 10.3%sy, 0.0%ni, 2.4%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 82.6%us, 13.8%sy, 0.0%ni, 2.4%id, 0.0%wa, 0.0%hi, 1.2%si, 0.0%st
Mem: 2075208k total, 686812k used, 1388396k free, 41976k buffers
Swap: 4200988k total, 0k used, 4200988k free, 508324k cached

Best to provide the 2nd example top stats in your threads where possible.

7. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf or my.ini so post the contents inside of my.cnf (minus any passwords of course).

from vbulletin

<div style="margin:20px; margin-top:5px; "> Quote:
auto_increment_increment 1 auto_increment_offset 1 automatic_sp_privileges ON back_log 50 basedir /usr/ 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 keep_files_on_create OFF engine_condition_pushdown OFF expire_logs_days 10 flush OFF flush_time 0 ft_boolean_syntax + ->