1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Database was "optimised" by previous hosts, anyway to check what they did?

Discussion in 'XenForo Questions and Support' started by RobParker, Jun 19, 2013.

  1. RobParker

    RobParker Well-Known Member

    With our previous hosts we were having performance issues (we ended up leaving and moving to Nimbus with beefier hardware) but while we were still with them they had their "mysql specialist" take a look at at our database and run his custom optimisation code on it.

    I think this entailed things like checking what keys there were and changing them to improve performance. Whilst I trust that they knew what they were doing, they weren't specialists in XF and since then we've had a few new versions and I was just wondering if there was a simple way to see what keys etc should be set on what tables and if they changed anything from the default that's now maybe a bad idea?

    From the above you can probably tell that I don't really know what I'm talking about so any pointers would be great :)

    Cheers

    Rob
     
  2. HWS

    HWS Well-Known Member

    Dumping your database structure and comparing it to the default XF database structure is your way to go.

    However, I highly doubt that a "database specialist" will change anything at any customer db layout. Usually they tweak only the database settings in my.cnf.
     
  3. RobParker

    RobParker Well-Known Member

    We were experiencing really bad levels of performance and they did start delving into the database to find out why, looking at slow queries, keys, etc. They were very good hosts and I think they expended a lot of staff resources on us to try and fix things, worth way more than we were paying them for hosting. They took people off special projects to try and help us etc but in the end we just couldn't get a decent xf performance with them.
     
  4. Walter

    Walter Well-Known Member

    As a former database specialist I can tell you that I would never change a key in the database without talking to the software developer.
    The only common thing (besides tuning the configuration) is to add indexes to tables.

    As HWS said, you need to compare your database structure with a standard install to see what they modified. BTW, if your host was really that good he should have given you a documentation what exactly they modified.
     
  5. HWS

    HWS Well-Known Member

    A real "database specialist" would never change anything in the structure of a customer database without working very closely with the creator of that database.

    If the guys at your host did exactly that, they are no "specialists" for sure.

    Anyway, the only way to find out is comparing your database with the default one.
     
  6. RobParker

    RobParker Well-Known Member

    I believe they also did that. I'll do a diff and see what the changes are.

    Cheers guys :)
     
  7. RoldanLT

    RoldanLT Well-Known Member

    While reading the 1st post, I feel that Nimbus Hosting is really great!
    They help costumers all in all.
     
  8. RobParker

    RobParker Well-Known Member

    Yep, Tim has been a massive help and identified exactly what hardware he thought we needed to run XF smoothly.
     
  9. RoldanLT

    RoldanLT Well-Known Member

    OT, May I know how much did you pay for them every month?
    And hopefully your board size? :)
     
  10. RobParker

    RobParker Well-Known Member

    We're on a dedicate server with Nimbus. I'm not sure if they'd be ok disclosing the amount so would rather not. If you contact them, let them know I'd be happy for you to know if they are ok with that.

    We have around 600-1000 users online (in last 15 mins) usually and a few million posts. We're a football forum and our traffic goes crazy during the transfer window with 3000+ users online at peak times. Nimbus has helped us massively with their "flood protection".
     
    RoldanLT likes this.
  11. RoldanLT

    RoldanLT Well-Known Member

    That was doubled my online user's at a time, 3000+..
    This is really a big board (y)
     

Share This Page