XFileSharing Pro - High load on index_dl.cgi

[bbgnetwork]

On my main server, I am getting about 90% cpu load, mostly from index_dl.cgi.

What is this file used for? Is there anyway I could lower the load on this file?

[speakerbox]

As far as i know the index file is used to generate the download links - so if your this is causing high load then it's likely time for a more powerful server.

[hostlife]

get nginx for reliability.

[verzing]

if main server high load I thinks its from sql, I hope sibsoft can reduce sql load in next version of xfs

[stamos]

sql loads are getting way to high since to many actions are performed when a user downloads a file (logs etc)
hopefully there will be some optimization in the next version

[ankurs]

hopefully there will be some optimization in the next version

why dont u suggest some ?

all the logging is necessary & not just added for fun ; its not mysql isssue its IO issue, get yourself a proper database server

[Dulci]

if you Generate direct links you schould not have any problems.

[stamos]

hopefully there will be some optimization in the next version

why dont u suggest some ?

all the logging is necessary & not just added for fun ; its not mysql isssue its IO issue, get yourself a proper database server

well, I have a dual quadcore SSD server for mysql, what do you think?!

[ankurs]

hopefully there will be some optimization in the next version

why dont u suggest some ?

all the logging is necessary & not just added for fun ; its not mysql isssue its IO issue, get yourself a proper database server

well, I have a dual quadcore SSD server for mysql, what do you think?!

get a enterprise ssd & put it in raid10; if IO is a issue

[chrda]

Dont need optimization really, just need to know how to scale your platform.

You need one (two if you want backup) loadbalancer, ect HAProxy.

Then you should get 2 or more of these servers.
1x CPU Intel Xeon 56xx, Single Sata disk , 8Gb ram. OR
1X Quad XeonE3 Series, Single Sata disk, 8Gb ram

And just ad as many as you need into the loadbalancer.

Just remember to have a high end Database server. Highend CPU, 12+Gb ram and SSD drives in Raid1. Also consider a backup DB.

This is a very good setup and its easy to scale.
The XFS script uses mostly CPU.

[stamos]

finally, my loads doesn't come from mysql but from apache,
the apache server burns at peak times, mysql server load is good.

both are dual quadcore with ssd hdds.

any ideas?