Database server performance

[eva2000]

Centmin Mod 123.09beta01 LEMP stack with PHP 7.1.8 + PGO enabled on my 8GB 4CPU Linode KVM VPS in Fremont, CA on Intel Xeon E5-2680v3 @2.50Ghz

XF 1.5 + ~98 addons

• Forum Index = Timing: 0.0559 seconds Memory: 6.834 MB DB Queries: 18
• Centmin Mod News forum = Timing: 0.0533 seconds Memory: 6.302 MB DB Queries: 19
• PHP 7 PGO Thread = Timing: 0.0598 seconds Memory: 7.427 MB DB Queries: 22
• Featured Thread Index = Timing: 0.0474 seconds Memory: 7.017 MB DB Queries: 15
• Members List = Timing: 0.0492 seconds Memory: 5.888 MB DB Queries: 12
• Media Index = Timing: 0.0381 seconds Memory: 5.482 MB DB Queries: 17
• Resource Manager Index = Timing: 0.0392 seconds Memory: 5.627 MB DB Queries: 16
• Search = Timing: 0.0282 seconds Memory: 5.629 MB DB Queries: 11
• Help Page = Timing: 0.0288 seconds Memory: 5.193 MB DB Queries: 11

Looking forward to PHP 7.2 for more gains

Forum index

Page Time: 0.0591s
Memory: 7.0418 MB (Peak: 7.3042 MB)
Queries (18, time: 0.0071s, 12.1%)

 

[skicomau]

I've got a custom DB adaptor which shards pure read loads over the master-plus slave.

Can you shine some light on this please? Have you made available as a plugin? If not, I'd be happy to commission it.

My objective is to better utilize my AWS Aurora cluster, currently nothing hits the read replica so it's effectively little more than real-time backup.

 

[Xon]

Can you shine some light on this please? Have you made available as a plugin? If not, I'd be happy to commission it.

My objective is to better utilize my AWS Aurora cluster, currently nothing hits the read replica so it's effectively little more than real-time backup.

It is already packaged as an add-on but is unsupported for general usage;
https://github.com/Xon/XenForo-MysqlReplication/blob/master/README.md
https://github.com/Xon/XenForo-MysqlReplication/archive/1.2.0.zip

This is released as-is, and not supported for free. If you want to use it, please ensure you test it in a non-production environment.

 

[skicomau]

It is already packaged as an add-on but is unsupported for general usage;
https://github.com/Xon/XenForo-MysqlReplication/blob/master/README.md
https://github.com/Xon/XenForo-MysqlReplication/archive/1.2.0.zip

This is released as-is, and not supported for free. If you want to use it, please ensure you test it in a non-production environment.

thank you.