Optimizing Cpanel Server--Help Me please

[vietcgi]

here is my server information let me know if you guys need more information about the server. Thanks in advanced.

Operating System: Red Hat Linux 7.3/Apache Web Server
Server Specifications: Server Special #Dual P3. 866Mhz, 512MB RAM, 36GB SCSI

php 4.2.3, mysql 3.23.53a, running vbulletin 2.2.9

top status 9 processes: 78 sleeping, 1 running, 0 zombie, 0 stopped
CPU0 states: 3.2% user, 6.0% system, 0.0% nice, 90.1% idle
CPU1 states: 1.3% user, 4.2% system, 0.0% nice, 93.3% idle
Mem: 513256K av, 486716K used, 26540K free, 0K shrd, 75756K buff
Swap: 1048552K av, 28604K used, 1019948K free 304604K cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
6294 root 0 0 4528 4300 4120 S 1.5 0.8 0:54 httpd
6898 root 12 0 1056 1056 824 R 0.7 0.2 0:00 top
24738 root 18 19 2992 2104 1336 S N 0.1 0.4 0:03 cpanellogd
24234 nobody 11 0 4580 4356 4164 S 0.1 0.8 0:00 httpd
7674 nobody 11 0 4580 4356 4164 S 0.1 0.8 0:00 httpd
1 root 8 0 476 432 412 S 0.0 0.0 0:18 init
2 root 9 0 0 0 0 SW 0.0 0.0 0:00 keventd
3 root 19 19 0 0 0 SWN 0.0 0.0 0:00 ksoftirqd_CPU0
4 root 19 19 0 0 0 SWN 0.0 0.0 0:16 ksoftirqd_CPU1
5 root 9 0 0 0 0 SW 0.0 0.0 0:24 kswapd
6 root 9 0 0 0 0 SW 0.0 0.0 0:00 bdflush
7 root 9 0 0 0 0 SW 0.0 0.0 0:17 kupdated
8 root 9 0 0 0 0 SW 0.0 0.0 0:03 kjournald
10243 root 9 0 0 0 0 SW 0.0 0.0 0:00 kjournald
31636 root 9 0 0 0 0 SW 0.0 0.0 0:11 kjournald
4509 root 9 0 0 0 0 SW 0.0 0.0 0:01 kjournald
17203 root 9 0 0 0 0 SW 0.0 0.0 0:13 kjournald
1681 root 9 0 0 0 0 SW 0.0 0.0 0:14 kjournald
24900 root 9 0 548 532 460 S 0.0 0.1 0:03 syslogd
31303 root 9 0 428 372 372 S 0.0 0.0 0:00 klogd
17404 nobody 8 0 1232 1144 992 S 0.0 0.2 0:01 proftpd
31217 named 9 0 4828 4636 1696 S 0.0 0.9 0:00 named
27943 named 9 0 4828 4636 1696 S 0.0 0.9 0:02 named
31916 named 9 0 4828 4636 1696 S 0.0 0.9 0:17 named
15572 named 9 0 4828 4636 1696 S 0.0 0.9 0:01 named
29858 named 9 0 4828 4636 1696 S 0.0 0.9 0:01 named
5218 root 9 0 1100 1040 924 S 0.0 0.2 0:01 sshd
323 root 9 0 812 748 680 S 0.0 0.1 0:00 xinetd
8064 root 9 0 1340 1300 1148 S 0.0 0.2 0:17 antirelayd
21451 nobody 9 0 564 340 340 S 0.0 0.0 0:00 melange
22976 root 9 0 1332 1176 1116 S 0.0 0.2 0:00 exim
31162 root 9 0 1152 960 960 S 0.0 0.1 0:00 safe_mysqld
32466 mysql 9 0 15912 14M 1404 S 0.0 2.9 0:05 mysqld
27068 mysql 9 0 15912 14M 1404 S 0.0 2.9 0:02 mysqld
21004 mysql 9 0 15912 14M 1404 S 0.0 2.9 0:24 mysqld
2631 root 8 0 620 608 540 S 0.0 0.1 0:02 crond
12909 root 8 0 604 572 532 S 0.0 0.1 0:00 rhnsd
20305 root 9 0 440 376 372 S 0.0 0.0 0:00 portsentry
17066 root 9 0 368 316 316 S 0.0 0.0 0:00 mingetty
24532 root 9 0 368 316 316 S 0.0 0.0 0:00 mingetty

[vietcgi]

mysqladmin -u root -p variables
Enter password:
+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| character_set | latin1 |
| character_sets | latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON |
| connect_timeout | 10 |
| datadir | /var/lib/mysql/ |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| flush | OFF |
| flush_time | 0 |
| have_bdb | NO |
| have_gemini | NO |
| have_innodb | NO |
| have_isam | YES |
| have_raid | NO |
| have_openssl | NO |
| init_file | |
| interactive_timeout | 28800 |
| join_buffer_size | 1044480 |
| key_buffer_size | 16773120 |

[vietcgi]

| log_update | OFF |
| log_bin | OFF |
| log_slave_updates | OFF |
| log_long_queries | OFF |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connections | 300 |
| max_connect_errors | 10 |
| max_delayed_threads | 20 |
| max_heap_table_size | 16777216 |
| max_join_size | 4294967295 |
| max_sort_length | 1024 |
| max_user_connections | 0 |
| max_tmp_tables | 32 |
| max_write_lock_count | 4294967295 |
| myisam_max_extra_sort_file_size | 256 |
| myisam_max_sort_file_size | 2047 |
| myisam_recover_options | 0 |
| myisam_sort_buffer_size | 67108864 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| open_files_limit | 0 |
| pid_file | /var/lib/mysql/host.vietking.com.pid |
| port | 3306 |
| protocol_version | 10 |

[vietcgi]

| record_buffer | 1044480 |
| record_rnd_buffer | 1044480 |
| query_buffer_size | 0 |
| safe_show_database | OFF |
| server_id | 0 |
| slave_net_timeout | 3600 |
| skip_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer | 2097144 |
| sql_mode | 0 |
| table_cache | 512 |
| table_type | MYISAM |
| thread_cache_size | 64 |
| thread_stack | 65536 |
| transaction_isolation | READ-COMMITTED |
| timezone | EST |
| tmp_table_size | 33554432 |
| tmpdir | /tmp/ |
| version | 3.23.53a |
| wait_timeout | 14400 |

[eva2000]

just upload your mysqlinfo.php from your vB extras folder to /admin/mysqlinfo.php and post the url here

[vietcgi]

here you go

http://www.aznprincess.com/phpinfo.php

[eva2000]

Originally posted by vietcgi
here you go

http://www.aznprincess.com/phpinfo.php mysqlinfo.php page not phpinfo.php ;)

[vietcgi]

sorry it's there now

http://www.aznprincess.com/mysqlinfo.php

[eva2000]

Originally posted by vietcgi
sorry it's there now

http://www.aznprincess.com/mysqlinfo.php change your /etc/my.cnf file to below one and restart mysql


[client]
port = 3306
socket = /var/lib/mysql/mysql.sock

[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = max_connections=500
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
set-variable = wait_timeout=9600
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10

[safe_mysqld]
open_files_limit=8192

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M

[vietcgi]

Originally posted by eva2000
change your /etc/my.cnf file to below one and restart mysql cool thx eva2000

[eva2000]

Originally posted by vietcgi
cool thx eva2000 no probs :D

[Joe Gronlund]

Originally posted by eva2000
change your /etc/my.cnf file to below one and restart mysql

hey george, how do i go about doing this myself? and what advantages will it give me to do so??


"change your /etc/my.cnf file to below one" , im not sure what you mean by that, is that an option in my.cnf???


http://www.asendtechnologies.com/vb/admin/mysqlinfo.php

thanks for your help :)