Configuring for performance

January 9th, 2009
  • Considering Windows 2000, MySQL, and PHP. What are the settings to ensure the fastest possible boards? I'm running Win2K with 512 RAM but the boards seem slow. Is there any tweaking to MySQL that needs to be done?

    Just curious of the communities consensus on how to get the best speed out of the vBulletin software.

    Thanks!


  • Originally posted by eva2000
    could you please enter your username on the form on this page http://www.vbulletin.com/members/forums.php - to do so you need your customer license info to access the form

    This will allow us moderators only to know if you're a licensed user

    when you have done that please provide the following

    1. your server specs, such as mysql and php version
    2. if possible how mysql was compiled/installed
    3. your top stats
    4. your mysql configuration variables located at /etc/my.cnf or c:my.cnf if on Windows server if you don't have that file you need to log into telnet and as root user type

    mysqladmin -u root -p variables

    copy and paste output here

    5. your mysql extended-status output either still telnet as root user type

    mysqladmin -u root -p extended-status

    copy and paste output here

    or preferred is to installed extended-status output script which is located at http://vbulletin.com/forum/showthread.php?threadid=3477

    and post url to that here

    6. oh and is your vB the only thing on the server? or other scripts? sites?

    err it's a win2k server George


  • hence why i posted #4

    4. your mysql configuration variables located at /etc/my.cnf or c:my.cnf if on Windows server if you don't have that file you need to log into telnet and as root user type
    :)


  • i think eve2000 have a genric post. that he post when users ask questions like this.


  • could you please enter your username on the form on this page http://www.vbulletin.com/members/forums.php - to do so you need your customer license info to access the form

    This will allow us moderators only to know if you're a licensed user

    when you have done that please provide the following

    1. your server specs, such as mysql and php version
    2. if possible how mysql was compiled/installed
    3. your top stats
    4. your mysql configuration variables located at /etc/my.cnf or c:my.cnf if on Windows server if you don't have that file you need to log into telnet and as root user type

    mysqladmin -u root -p variables

    copy and paste output here

    5. your mysql extended-status output either still telnet as root user type

    mysqladmin -u root -p extended-status

    copy and paste output here

    or preferred is to installed extended-status output script which is located at http://vbulletin.com/forum/showthread.php?threadid=3477

    and post url to that here

    6. oh and is your vB the only thing on the server? or other scripts? sites?


  • Everything in George's post except the top output will work fine on Windows servers...mysql still provide all of the same admin tools.

    Instead of the 'top' output you could go into task manager (Ctrl-Shift-Esc) and copy the CPU usage % as well as the Memory Usage.


  • Originally posted by cyo
    i think eve2000 have a genric post. that he post when users ask questions like this. 3 weeks later ? :)







  • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about Configuring for performance , Please add it free.