Raised This Month: $51 Target: $400
 12% 

Faster loading of web-gui


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Mike_BoG
SourceMod Donor
Join Date: Jul 2011
Old 05-02-2013 , 06:23   Faster loading of web-gui
Reply With Quote #1

Hi.

Is there anything I can do in order to ease the load on my MySQL server for the web-gui? Every time someone loads it the CPU-usage of the MySQL server spikes to 100%. I have narrowed it down to that it is indeed the HLStatsX web-gui causing this. I've got a cache solution installed on the webserver and MySQL is tuned to my needs.

Also, a quick feature request for 1.7.0: memcache(d) support allowing to store some of the pages/values in the memcache daemon.
__________________
Founder and Owner of BlackOut Gaming

Last edited by Mike_BoG; 05-02-2013 at 06:24.
Mike_BoG is offline
Rytis
Veteran Member
Join Date: Feb 2012
Location: Germany
Old 05-02-2013 , 08:37   Re: Faster loading of web-gui
Reply With Quote #2

There will be a complete rewrite with cache functions.
Rytis is offline
Mavrick4283
Veteran Member
Join Date: Apr 2010
Location: 127.0.0.1@root
Old 05-02-2013 , 14:58   Re: Faster loading of web-gui
Reply With Quote #3

Alternative PHP Cache (APC) Caching
File-based Caching
Memcached Caching

Those are the supported caching systems in 1.7
__________________
Mavrick4283 is offline
Mike_BoG
SourceMod Donor
Join Date: Jul 2011
Old 05-03-2013 , 17:25   Re: Faster loading of web-gui
Reply With Quote #4

Ok. Will there also be done optimization on the actual daemon listening for the logstreams?
__________________
Founder and Owner of BlackOut Gaming
Mike_BoG is offline
Mavrick4283
Veteran Member
Join Date: Apr 2010
Location: 127.0.0.1@root
Old 05-03-2013 , 21:11   Re: Faster loading of web-gui
Reply With Quote #5

I have been working on that also but because I have little to no control of the environments that it will be installed on we are spending more time making sure that it will be 100% functional.

The only part of HLX:CE that has not been worked on so far is the in-game plugins, and this is because not myself or any one so far on the team writes in source-pawn.
__________________
Mavrick4283 is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 22:11.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode