Multi Server Video Won't Play with IE

[RAMMSTEIN]

My main server MySql is using over 130% of CPU..my server is super slow even though i'm paying $500 for it. It's a core2Quad with 1 CPU and 4 cores, 1000GB hard drive, 8GB RAM.

Yes that is true vshare script is very slow due to the SQL. It needs caching system for fast page loads and to reduce the SQL connections. This is one of the main feature request that need to be completed in the next version.

[topfreaks]

Can someone help me fine tune this with better optimization?

#set-variable = innodb_buffer_pool_size=10M
#set-variable = innodb_additional_mem_pool_size=500K
#set-variable = innodb_log_buffer_size=500K
#set-variable = innodb_thread_concurrency=2
#set-variable = interactive_timeout=60
#set-variable = max_connections=1000
#set-variable = max_user_connections=1000
#set-variable = key_buffer=140M
#set-variable = join_buffer_size=4M
#set-variable = read_buffer_size=1M
#set-variable = sort_buffer_size=8M
#set-variable = table_cache=1800
#set-variable = thread_cache_size=64
#set-variable = wait_timeout=120
#set-variable = connect_timeout=60
#set-variable = tmp_table_size=300M
#set-variable = max_heap_table_size=64M
#set-variable = max_allowed_packet=200M
#set-variable = max_connect_errors=10
#set-variable = thread_concurrency=2
#set-variable = read_rnd_buffer_size=300M
#set-variable = myisam_sort_buffer_size=64M
#set-variable = bulk_insert_buffer_size=8M
#set-variable = query_cache_limit=1M
#set-variable = query_cache_size=32M
#set-variable = query_cache_type=1

[admin]

That is all commented values, that is content of your /etc/my.cnf ?

Try this configuration

[mysqld]
datadir=/var/lib/mysql
skip-locking
safe-show-database
query_cache_limit=1M
query_cache_size=256M
query_cache_type=1
max_user_connections=30
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=256M
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=8M
read_buffer_size=8M
read_rnd_buffer_size=8M
thread_concurrency=16
myisam_sort_buffer_size=64M
server-id=1

[mysql.server]
user=mysql

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash

[topfreaks]

I changed my.cnf to your codes. MySql is running normal now but load average is still high. Super High: load average: 11.01, 8.63, 8.55

[bplex]

What mySQL version are you running? Also, is it standard or max?

Also, run a "top," take a screenshot, and post it. I think I may know what your problem is, but I'll need to see a top to see.

[topfreaks]

My server is max. MySQL is fine now but still load average is high:

Top:

top - 01:56:52 up 2 days, 20:07, 3 users, load average: 19.85, 17.76, 16.55
Tasks: 457 total, 1 running, 456 sleeping, 0 stopped, 0 zombie
Cpu(s): 6.5%us, 1.7%sy, 0.0%ni, 39.5%id, 47.1%wa, 0.5%hi, 4.7%si, 0.0%st
Mem: 8300172k total, 8001448k used, 298724k free, 23024k buffers
Swap: 8385920k total, 588k used, 8385332k free, 6581360k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
25581 mysql 5 -10 652m 59m 4712 S 8 0.7 0:51.85 mysqld
20785 apache 15 0 48708 18m 5616 S 3 0.2 0:03.76 httpd
25339 apache 16 0 48644 17m 4720 S 3 0.2 0:01.10 httpd
20814 apache 16 0 48516 17m 4724 S 2 0.2 0:01.72 httpd
26029 drweb 18 0 9976 8156 1648 D 2 0.1 0:03.03 update.pl
18110 apache 15 0 48584 17m 4764 S 2 0.2 0:04.25 httpd
24117 apache 15 0 48616 17m 4732 S 2 0.2 0:01.49 httpd
24236 apache 15 0 48688 18m 5552 S 2 0.2 0:01.45 httpd
21505 apache 15 0 48616 17m 4756 S 1 0.2 0:03.89 httpd
21764 apache 16 0 48692 17m 4756 S 1 0.2 0:04.40 httpd
25671 apache 16 0 48684 17m 4716 S 1 0.2 0:00.89 httpd
21388 apache 16 0 48516 18m 5604 S 1 0.2 0:02.38 httpd
21459 apache 16 0 48584 17m 4776 S 1 0.2 0:04.75 httpd
456 root 10 -5 0 0 0 D 0 0.0 8:12.45 kjournald
18428 apache 15 0 48440 17m 4748 S 0 0.2 0:07.05 httpd
20539 apache 15 0 48632 17m 4756 S 0 0.2 0:04.14 httpd
20798 apache 15 0 48636 17m 4768 S 0 0.2 0:05.29 httpd
21094 apache 15 0 48404 17m 4760 S 0 0.2 0:04.09 httpd
21096 apache 15 0 48500 18m 5624 S 0 0.2 0:05.57 httpd
21456 apache 15 0 48704 18m 5620 S 0 0.2 0:02.31 httpd
21726 apache 15 0 48516 17m 4756 S 0 0.2 0:03.33 httpd
21727 apache 16 0 48608 17m 4752 S 0 0.2 0:03.61 httpd
21795 apache 16 0 48684 18m 5616 D 0 0.2 0:03.97 httpd
21867 apache 15 0 49932 21m 6088 S 0 0.3 0:04.52 httpd
22551 apache 16 0 48596 17m 4704 S 0 0.2 0:01.93 httpd
23981 apache 15 0 48512 17m 4748 S 0 0.2 0:02.54 httpd
24114 apache 16 0 48520 18m 5092 S 0 0.2 0:01.07 httpd
24200 apache 15 0 48620 18m 5612 S 0 0.2 0:01.85 httpd
24782 apache 15 0 48584 17m 4724 S 0 0.2 0:02.14 httpd
24925 gradmin 15 0 11928 1732 1088 S 0 0.0 0:00.03 sshd
25341 apache 15 0 48416 17m 4724 S 0 0.2 0:00.88 httpd
25755 apache 15 0 48524 17m 4688 S 0 0.2 0:00.84 httpd
26172 root 15 0 2484 1284 824 R 0 0.0 0:00.09 top
1 root 15 0 2088 688 584 S 0 0.0 0:01.11 init

[bplex]

Thanks for posting that. Confirms what I was thinking. Based on your top, your mySQL is fine (could use a bit more tweaking), but your Apache settings are now in need of some adjustment. You have a lot of Apache threads open which means that Apache is probably hanging on to connections too long. First, let's tweak mySQL a bit more. Change your mySQL configuration to the following:

[mysqld]
datadir=/var/lib/mysql
skip-locking
safe-show-database
query_cache_limit=3M
query_cache_size=256M
query_cache_type=1
query_prealloc_size = 163840
query_alloc_block_size = 32768
max_user_connections=300
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=10
thread_cache_size=384
key_buffer=256M
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=8M
read_buffer_size=8M
read_rnd_buffer_size=8M
thread_concurrency=16
myisam_sort_buffer_size=64M
server-id=1

[mysql.server]
user=mysql

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash

This will give you a bit more performance out of mySQL. Be sure to restart mySQL after making the change.

Next, for Apache, find the following lines in your httpd.conf and change them to:

KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5
MinSpareServers 10
MaxSpareServers 20
StartServers 15
MaxClients 180
MaxRequestsPerChild 1000

Restart Apache after making that change and see if your load decreases.

[RAMMSTEIN]

wow i made those changes and the server is fast and furious :D

thank you

[bplex]

Not a problem at all

[RAMMSTEIN]

I get max_user_connections blank page :( with those settings bplex. I think there is a need to increase users connections to 40-50. I will try 40. :D