|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
<div>1. Is this on dedicated or shared virual server. Dedicated. 2. your server specs. cpu speed/type single or dual cpus): Dual AMD 2376 how much memory installed: 16GB RAM hard drive type/configuration: 2 x 250GB SATA (RAID1) linux distributor or windows version: CentOS 4.5 apache/IIS version: Apache/2.0.53 PHP version: PHP 5.2.9 MySQL version: MySQL 5.1.34 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 ? Using MySQL 5.1.34, but using a couple of innodb tables because we were experiencing a lot of table locking problems. Tables converted to innodb are: vb_thread vb_user 5. if possible how mysql was compiled/installed Not known. 6. your top stats. So log into your server via ssh telnet as root user and type the command in bold - top Code: top - 1849 up 12 days, 20:18, 1 user, load average: 2.47, 2.17, 1.70 Tasks: 164 total, 1 running, 163 sleeping, 0 stopped, 0 zombie Cpu0 : 31.2% us, 3.0% sy, 0.0% ni, 65.4% id, 0.3% wa, 0.0% hi, 0.0% si Cpu1 : 6.3% us, 1.0% sy, 0.0% ni, 28.1% id, 64.6% wa, 0.0% hi, 0.0% si Cpu2 : 0.3% us, 0.0% sy, 0.0% ni, 99.3% id, 0.3% wa, 0.0% hi, 0.0% si Cpu3 : 1.3% us, 0.3% sy, 0.0% ni, 74.0% id, 24.3% wa, 0.0% hi, 0.0% si Cpu4 : 2.3% us, 0.3% sy, 0.0% ni, 97.0% id, 0.3% wa, 0.0% hi, 0.0% si Cpu5 : 3.3% us, 0.3% sy, 0.0% ni, 96.0% id, 0.3% wa, 0.0% hi, 0.0% si Cpu6 : 0.0% us, 0.0% sy, 0.0% ni, 100.0% id, 0.0% wa, 0.0% hi, 0.0% si Cpu7 : 0.0% us, 0.0% sy, 0.0% ni, 100.0% id, 0.0% wa, 0.0% hi, 0.0% si Mem: 16634544k total, 9720656k used, 6913888k free, 53108k buffers Swap: 2040244k total, 0k used, 2040244k free, 9220312k cached 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). Code: [mysqld] 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 # To allow mysqld to connect to a MySQL Cluster management daemon, uncomment # these lines and adjust the connectstring as needed. #ndbcluster #ndb-connectstring="nodeid=4;host=localhost:1186" [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [ndbd] # If you are running a MySQL Cluster storage daemon (ndbd) on this machine, # adjust its connection to the management daemon here. # Note: ndbd init script requires this to include nodeid! connect-string="nodeid=2;host=localhost:1186" [ndb_mgm] # connection string for MySQL Cluster management tool connect-string="host=localhost:1186" 8. MySQL stats from ssh telnet as root user type: <div style="margin:20px; margin-top:5px"> Code: +-------------------------------------+-------------------------------------------------------------------------------------------+ | Variable_name | Value | +-------------------------------------+-------------------------------------------------------------------------------------------+ | auto_increment_increment | 1 | | auto_increment_offset | 1 | | autocommit | ON | | automatic_sp_privileges | ON | | back_log | 50 | | basedir | /usr/ | | big_tables | OFF | | binlog_cache_size | 32768 | | binlog_format | STATEMENT | | 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 | 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 | ON | | error_count | 0 | | event_scheduler | OFF | | expire_logs_days | 0 | | flush | OFF | | flush_time | 0 | | foreign_key_checks | ON | | 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 |