How did you minimize your mysql server memory consumption?

[Moshe1010]

Mine doesn't show

1. Query Cache: 106.71M/256.00M (41.68%)

Do I need to add something to show this?

Max Used Connections: 50/80 (62.50%)
Key Buffer Used: 4.36M/32.00M (13.62%)
Current Key Buffer Usage: 6.63M (20.72%)
InnoDB Buffer Pool: 2.43G/2.96G (82.13%)
Table Locks Waited: 290 Rate: 0.0/s (0.00%)

 

[rdn]

Mine doesn't show

1. Query Cache: 106.71M/256.00M (41.68%)

Do I need to add something to show this?

Max Used Connections: 50/80 (62.50%)
Key Buffer Used: 4.36M/32.00M (13.62%)
Current Key Buffer Usage: 6.63M (20.72%)
InnoDB Buffer Pool: 2.43G/2.96G (82.13%)
Table Locks Waited: 290 Rate: 0.0/s (0.00%)

Yes, I think it will help.

 

[rdn]

This: http://www.howtogeek.com/howto/programming/speed-up-your-web-site-with-mysql-query-caching/

 

[Moshe1010]

This: http://www.howtogeek.com/howto/programming/speed-up-your-web-site-with-mysql-query-caching/

How's your overall experience with OVH? I'm looking to get this:
http://www.soyoustart.ie/offers/sys-e32-4.xml

In France.

 

[rdn]

I'm very happy with them
No downtime from the start, 3 months now.
If I'm not mistaken @MattW is also using them ?

 

[Moshe1010]

I'm very happy with them
No downtime from the start, 3 months now.
If I'm not mistaken @MattW is also using them ?

I read horrible stories over WebHostingTalk about OVH and their support, so I'm not sure. It's kind of mixed, but I guess people are expecting too much from them. They just provide an infrastructure and hardware and that's it.
Are you using the server as a dedicated, or you split it up to VPS nodes?

 

[rdn]

I read horrible stories over WebHostingTalk about OVH and their support, so I'm not sure. It's kind of mixed, but I guess people are expecting too much from them.

Because most of them are not fluent on English and they only support for the hardware.

They just provide an infrastructure and hardware and that's it.

Yes, this is correct.
I don't have any complaint's for them, overall awesome Dedicated server.

Are you using the server as a dedicated, or you split it up to VPS nodes?

Just a plain Dedicated CentOS server.

 

[Moshe1010]

Because most of them are not fluent on English and they only support for the hardware.

Yes, this is correct.
I don't have any complaint's for them, overall awesome Dedicated server.

Just a plain Dedicated CentOS server.

Did you get it straight from OVH's website or through SoYouStart?

 

[rdn]

Did you get it straight from OVH's website or through SoYouStart?

They are the same Company I think.
Soyoustart is just their new website.
I purchased last December, so straight from OVH.

 

[Moshe1010]

They are the same Company I think.
Soyoustart is just their new website.
I purchased last December, so straight from OVH.

Yes, it's the same company but different policies/support team.

 

[MattW]

I'm very happy with them
No downtime from the start, 3 months now.
If I'm not mistaken @MattW is also using them ?

Yes, as of Saturday morning, I migrated my sites to them.

How's your overall experience with OVH? I'm looking to get this:
http://www.soyoustart.ie/offers/sys-e32-4.xml

In France.

I'm using the slightly lower spec'd CPU with software raid.
http://www.soyoustart.ie/offers/sys-e32-2.xml

If you don't go in with unrealistic support expectations (they are an un-managed provider), then you get a bloody good server, for a very reasonable price.

Check my sites running on there now
https://z22se.co.uk
https://mattwservices.co.uk

My members have noticed a big speed increase now we are on the dedicated server.

https://z22se.co.uk/threads/dedicated-server-22-02-2014.25523/

Yes, it's the same company but different policies/support team.

It's their new range structure.
Kimsufi - low spec, zero support
SoYouStart - higher spec, basic support
OVH - highest spec, proper support

 

[Moshe1010]

Yes, as of Saturday morning, I migrated my sites to them.

I'm using the slightly lower spec'd CPU with software raid.
http://www.soyoustart.ie/offers/sys-e32-2.xml

If you don't go in with unrealistic support expectations (they are an un-managed provider), then you get a bloody good server, for a very reasonable price.

Check my sites running on there now
https://z22se.co.uk
https://mattwservices.co.uk

My members have noticed a big speed increase now we are on the dedicated server.

https://z22se.co.uk/threads/dedicated-server-22-02-2014.25523/



It's their new range structure.
Kimsufi - low spec, zero support
SoYouStart - higher spec, basic support
OVH - highest spec, proper support

Are you running cPanel? If yes, which license did you get?

 

[MattW]

Are you running cPanel? If yes, which license did you get?

No, CentOS with nginx and mariaDB.

If you want Cpanel, you'll either need a dedicated server licence, or split the dedicated up into VM's to get the cheaper VM licence.

 

[Moshe1010]

No, CentOS with nginx and mariaDB.

If you want Cpanel, you'll either need a dedicated server licence, or split the dedicated up into VM's to get the cheaper VM licence.

Yeah, I was thinking about splitting it with OpenVZ. Is it possible to get additional IPv4 from a different datacenter to configure DNS properly?

 

[MattW]

Yeah, I was thinking about splitting it with OpenVZ. Is it possible to get additional IPv4 from a different datacenter to configure DNS properly?

You can get 5 failover IP's, I'm not 100% sure on how they let it work though:
http://www.ovh.co.uk/dedicated_servers/ip_failover.xml

Just use a 3rd party for your DNS (such as DNSMadeEasy.....I've been with them 5 years now).

 

[rdn]

MattW I have some questions to you later. ( mobile mode for now )

Congrats for the moved

 

[Moshe1010]

You can get 5 failover IP's, I'm not 100% sure on how they let it work though:
http://www.ovh.co.uk/dedicated_servers/ip_failover.xml

Just use a 3rd party for your DNS (such as DNSMadeEasy.....I've been with them 5 years now).

What's their advantage over self DNS hosting?

 

[MattW]

What's their advantage over self DNS hosting?

Enterprise class ip anycast service. One less thing for you to configure on the server, worry about, secure.

It also means my e-mail doesn't go down if the server is down (I have e-mail for my domain name on outlook.com, but if DNS was to go down, so would all my e-mail).

 

[MattW]

http://forum.ovh.co.uk/showthread.php?7887-Number-of-IPs-on-dedicated-upgradable

You can buy the 5 extra IP addresses.

 

[Moshe1010]

Yeah I know, I was wondering about additional IPs from a different datacenter