[Optimization]Server Tips

Discussion in 'Server & Community Management' started by Zeokon, Nov 25, 2012.

Thread Status:
Not open for further replies.
  1. Zeokon

    Zeokon

    [Optimization]Server Tips​

    [MySQL]​

    If you're using MySQL server to hold your files edit your my.cnf to the simplest form for the best performance.

    Delete everything under mysqld and add

    [mysqld]
    set-variable = max_connections=500
    log-slow-queries
    safe-show-database
    wait_timeout = 28800
    max_allowed_packet = 16777216


    [TPS/FPS]​

    TPS and FPS lag is a bugger, changing the view-distance in server.properties to a lower number than 10 solves that.
    ​
    ​
    [RAM]​

    Low RAM becoming an issue? download ClearLagg, it removes all your entities after a period of time allowing more ram to free up.

    Click here to download


    [Best Server Location]​

    Choosing the best location for your server to decrease lag on all ends is a pain, I'll provide you with information about this.

    West Coast = Asia + Australia and America
    Dallas = All Rounder
    East Coast = Europe and America
    North = America and Canada

    Obviously I would go with Dallas, I would recommend LimestoneNetworks, no I'm not paid to do this but it's a really good company.


    ​
    Rape that like button!​
     
    #1 Zeokon, Nov 25, 2012
    • Like Like x 1
    • Disagree Disagree x 1
    • Useful Useful x 1
  3. mbaxter

    mbaxter

    Uh, exactly how much ram do you think entities utilize? ._o
     
    #2 mbaxter, Nov 25, 2012
  5. Zeokon

    Zeokon

    50mb...I don't know 10mb
     
    #3 Zeokon, Nov 25, 2012
  7. Kainzo

    Kainzo

    Entities don't really cause a lot of 'ram usage' ... for the most part... it cant at a certain extent but for the average server, its really not needed to wipe every X hours.
     
    #4 Kainzo, Nov 26, 2012
  9. Aikar

    Aikar

    I strongly recommend removing the Mysql part.

    Deleting everything under mysqld is a bad idea. you should at bare minimum use one of the preset config files distributed with MySQL based on your server size...

    Also removing the core config settings like socket/user/port may even cause it to fail to load... These should remain defined and not deleted.

    Then your also removing all the default performance settings... Your MySQL section is a horrible idea and should be removed.

    Low ram is solved by getting more ram... this is java... your going to need alot of ram.
     
    #5 Aikar, Nov 26, 2012
  11. Kainzo

    Kainzo

    Yep. It's true - honestly, this post should be "gathering the best optimizations"
     
    #6 Kainzo, Nov 26, 2012
  13. PhanaticD

    PhanaticD
    Patron

    mysql - get a SSD for good mysql performance, gonna stay away from your unverified tips there

    tps - get spigot :p and lower view distance does help alot, I also do run a clearlagg which does refresh the mobs on server too, though i suspect it affects performance

    ram - get more ram

    ping - mines in germany and im in america and the ping isnt noticeable, also recommended is a gigabit port for larger servers
     
    #7 PhanaticD, Nov 27, 2012
  15. sirmyllox

    sirmyllox

    Regarding MySQL

    I recommend to investigate the size of the database, type of database and how large the indices are. then you can adjust my.cnf to what ever suits you the best.

    Use scripts like MySQL Tuner (http://mysqltuner.com/) and Tuning Primer (https://launchpad.net/mysql-tuning-primer) to find flaws in your MySQL settings.

    The most important setting for mysql is the key_buffer size if you use myisam db's or innodb_buffer_pool_size for innodb which helps alot for plugins like logblock etc. other settings like max Connections, Query_cache_size etc should be tuned with the help of the scripts above.
     
    #8 sirmyllox, Nov 29, 2012
  17. NoEffex

    NoEffex

    If your having MySQL issues, check how your indexes are, the size of your tables, if their crashing etc. The config file is NOT the first place to start...
     
    #9 NoEffex, Nov 29, 2012
    • Friendly Friendly x 1
  19. archlinux

    archlinux

    I recommend using MariaDB instead of MySQL, especially if you use MyISAM tables. We're running it with a great improvement on performance.
     
    #10 archlinux, Dec 4, 2012
    • Agree Agree x 1
Thread Status:
Not open for further replies.