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

R

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
 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
HWS said:
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.
Click to expand...

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.
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
RoldanLT said:
OT, May I know how much did you pay for them every month?
And hopefully your board size? :)
Click to expand...

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".
 
  • Like
Reactions: rdn
Upvote 0 Downvote
RobParker said:
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".
Click to expand...

That was doubled my online user's at a time, 3000+..
This is really a big board (y)
 
Upvote 0 Downvote
You must log in or register to reply here.
Back
Top Bottom