<div>
- Dedicated Server
- cpu speed/type single or dual cpus): Intel Quad Q6600 4x 2.40+ GHz 64 bits
how much memory installed: 4 GB DDR 2
hard drive type/configuration: 250 GB
linux distributor or windows version: linux plesk84
apache/IIS version: Apache v2.2.3
PHP version: php 5.1.6
MySQL version: mysql 5.0.22 - 3.8.1 Patch Level 1.
- .
- .
Code:
- top - 18:16:57 up 25 days, 22:57, 1 user, load average: 3.20, 3.27, 3.38
- Tasks: 221 total, 1 running, 220 sleeping, 0 stopped, 0 zombie
- Cpu0 : 10.3%us, 1.0%sy, 0.0%ni, 88.4%id, 0.0%wa, 0.0%hi, 0.3%si, 0.0%st
- Cpu1 : 92.0%us, 3.0%sy, 0.0%ni, 5.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
- Cpu2 : 33.0%us, 2.0%sy, 0.0%ni, 65.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
- Cpu3 : 40.1%us, 3.0%sy, 0.0%ni, 56.6%id, 0.0%wa, 0.0%hi, 0.3%si, 0.0%st
- Mem: 4130072k total, 2989376k used, 1140696k free, 204380k buffers
- Swap: 522104k total, 10024k used, 512080k free, 1652524k cached
- PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
- 4146 mysql 20 0 156m 51m 5276 S 97 1.3 5320:23 mysqld
- 20537 apache 20 0 66652 37m 4892 S 11 0.9 0:02.74 httpd
- 17659 apache 20 0 64656 35m 4400 S 10 0.9 0:05.60 httpd
- 20883 apache 20 0 64232 34m 4396 S 10 0.9 0:03.36 httpd
- 18554 apache 20 0 65368 35m 4400 S 9 0.9 0:06.56 httpd
- 22014 apache 20 0 65004 35m 4380 S 9 0.9 0:00.68 httpd
- 18580 apache 20 0 65380 35m 4416 S 7 0.9 0:05.96 httpd
- 22016 apache 20 0 65572 35m 4348 S 5 0.9 0:01.74 httpd
- 21148 apache 20 0 65228 35m 4368 S 3 0.9 0:00.84 httpd
- 16622 apache 20 0 65212 35m 4476 S 3 0.9 0:07.26 httpd
- 20520 apache 20 0 63812 34m 4356 S 3 0.8 0:01.14 httpd
- 21882 apache 20 0 65340 35m 4368 S 3 0.9 0:01.14 httpd
- 22039 apache 20 0 64696 35m 4368 S 3 0.9 0:01.04 httpd
- 21453 apache 20 0 64068 34m 4400 S 2 0.9 0:01.68 httpd
- 21999 apache 20 0 59996 30m 4204 S 2 0.8 0:00.42 httpd
- 17611 apache 20 0 64200 35m 4760 S 1 0.9 0:05.40 httpd
- 17678 apache 20 0 65096 35m 4412 S 1 0.9 0:03.06 httpd
- 20939 apache 20 0 64760 35m 4376 S 1 0.9 0:01.80 httpd
- 22042 apache 20 0 63264 33m 4336 S 1 0.8 0:00.52 httpd
- 29452 named 20 0 60648 7264 1984 S 1 0.2 1:51.12 named
- 7288 apache 20 0 65152 35m 4492 S 1 0.9 0:22.08 httpd
- 14321 qmailr 20 0 1664 396 296 S 1 0.0 0:02.84 qmail-rspawn
- 22043 apache 20 0 64864 35m 4812 S 1 0.9 0:00.90 httpd
- 4 root 15 -5 0 0 0 S 0 0.0 7:06.00 ksoftirqd/0
- 3194 root 15 -5 0 0 0 S 0 0.0 4:26.00 kjournald
- 1 root 20 0 2036 580 504 S 0 0.0 0:11.08 init
- 2 root 15 -5 0 0 0 S 0 0.0 0:00.00 kthreadd
- 3 root RT -5 0 0 0 S 0 0.0 0:02.56 migration/0
- 5 root RT -5 0 0 0 S 0 0.0 0:01.62 migration/1
- 6 root 15 -5 0 0 0 S 0 0.0 4:53.28 ksoftirqd/1
- 7 root RT -5 0 0 0 S 0 0.0 0:01.06 migration/2
- 8 root 15 -5 0 0 0 S 0 0.0 3:33.08 ksoftirqd/2
- 9 root RT -5 0 0 0 S 0 0.0 0:01.18 migration/3
- 10 root 15 -5 0 0 0 S 0 0.0 3:47.00 ksoftirqd/3
- 11 root 15 -5 0 0 0 S 0 0.0 1:30.76 events/0
- 12 root 15 -5 0 0 0 S 0 0.0 1:09.69 events/1
- 13 root 15 -5 0 0 0 S 0 0.0 0:58.38 events/2
- 14 root 15 -5 0 0 0 S 0 0.0 1:08.13 events/3
- 15 root 15 -5 0 0 0 S 0 0.0 0:00.00 khelper
- 122 root 15 -5 0 0 0 S 0 0.0 0:00.00 kintegrityd/0
- 123 root 15 -5 0 0 0 S 0 0.0 0:00.00 kintegrityd/1
- 124 root 15 -5 0 0 0 S 0 0.0 0:00.00 kintegrityd/2
- 125 root 15 -5 0 0 0 S 0 0.0 0:00.00 kintegrityd/3
- 126 root 15 -5 0 0 0 S 0 0.0 0:04.12 kblockd/0
- 127 root 15 -5 0 0 0 S 0 0.0 0:03.08 kblockd/1
- 128 root 15 -5 0 0 0 S 0 0.0 0:02.34 kblockd/2
- 129 root 15 -5 0 0 0 S 0 0.0 0:02.32 kblockd/3
- 130 root 15 -5 0 0 0 S 0 0.0 0:00.00 kacpid
- 131 root 15 -5 0 0 0 S 0 0.0 0:00.00 kacpi_notify
- 215 root 15 -5 0 0 0 S 0 0.0 0:00.00 ata/0
7.
Code:
[mysqld] set-variable=local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
8.
<div style="margin:20px; margin-top:5px"> Code:
<ol style="list-style-type: decimal">+---------------------------------+--------------------------------------------------------+
| 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 | 32768 |
| 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 | + ->
