Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 21

Thread: Multi Server Video Won't Play with IE

  1. #11
    Join Date
    Feb 2008
    Location
    Greece
    Posts
    235

    Default Re: Multi Server Video Won't Play with IE

    Quote Originally Posted by topfreaks
    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.

  2. #12

    Default Re: Multi Server Video Won't Play with IE

    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
    TopFreaks.com/index.php - Free Black Porn

    BootyCallFriends.com - 100% Free Booty Call Friends Finder

  3. #13
    Join Date
    Apr 2007
    Posts
    2,202

    Default Re: Multi Server Video Won't Play with IE

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

    Try this configuration


    Code:
    [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

  4. #14

    Default Re: Multi Server Video Won't Play with IE

    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
    TopFreaks.com/index.php - Free Black Porn

    BootyCallFriends.com - 100% Free Booty Call Friends Finder

  5. #15
    Join Date
    Sep 2008
    Posts
    1,019

    Default Re: Multi Server Video Won't Play with IE

    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.
    vShare Solutions
    Custom vShare Modules and Services

    Now, your visitors can watch videos on your site using their mobile or tablet device with the Mobility Mod for vShare 2.8!

  6. #16

    Default Re: Multi Server Video Won't Play with IE

    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
    TopFreaks.com/index.php - Free Black Porn

    BootyCallFriends.com - 100% Free Booty Call Friends Finder

  7. #17
    Join Date
    Sep 2008
    Posts
    1,019

    Default Re: Multi Server Video Won't Play with IE

    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:

    Code:
    [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:

    Code:
    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.
    vShare Solutions
    Custom vShare Modules and Services

    Now, your visitors can watch videos on your site using their mobile or tablet device with the Mobility Mod for vShare 2.8!

  8. #18
    Join Date
    Feb 2008
    Location
    Greece
    Posts
    235

    Default Re: Multi Server Video Won't Play with IE

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

    thank you

  9. #19
    Join Date
    Sep 2008
    Posts
    1,019

    Default Re: Multi Server Video Won't Play with IE

    Not a problem at all
    vShare Solutions
    Custom vShare Modules and Services

    Now, your visitors can watch videos on your site using their mobile or tablet device with the Mobility Mod for vShare 2.8!

  10. #20
    Join Date
    Feb 2008
    Location
    Greece
    Posts
    235

    Default Re: Multi Server Video Won't Play with IE

    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

Page 2 of 3 FirstFirst 123 LastLast

Similar Threads

  1. Multi-Server Help
    By browniegirl in forum Installation Support
    Replies: 23
    Last Post: 05-04-2008, 11:07 PM
  2. Import & Upload Video - Multi Server
    By reyeskane in forum Bug Reports
    Replies: 1
    Last Post: 03-11-2008, 12:31 PM
  3. 2.6 Q: Video Import + Multi Server
    By cyberdog in forum Sales Questions
    Replies: 2
    Last Post: 01-28-2008, 06:17 PM
  4. Need Help in multi server + not working in 2.6
    By hoque in forum Installation Support
    Replies: 18
    Last Post: 01-09-2008, 05:39 AM
  5. Multi Server Config
    By pipermac in forum Feature Requests
    Replies: 2
    Last Post: 10-09-2007, 05:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •