XFileSharing Pro - caching ?

Message
Author
ankurs
Posts: 1054
Joined: Mar 10, 2009 2:34 am

caching ?

#1 Postby ankurs » Oct 22, 2010 7:31 am

can memcached be used with xfs ? and would it help

my db keeps crashing, when i run latest downloads or anti hacker

admin
Site Admin
Posts: 1839
Joined: Mar 22, 2006 12:32 pm

#2 Postby admin » Oct 22, 2010 10:35 am

It should not be crashing by itself. Consider mysql fine tuning.

As for memcached - question is still open. Not sure yet.

ankurs
Posts: 1054
Joined: Mar 10, 2009 2:34 am

#3 Postby ankurs » Oct 22, 2010 2:29 pm

yes it shouldn't crash, but when i open those two pages; ip2file table gets locked as i have a couple of mil. entries in it

i was thinking to change the table format from myisam to innodb ; as it doesnt lock table

chrda
Posts: 296
Joined: Sep 14, 2009 7:16 pm

#4 Postby chrda » Oct 22, 2010 9:47 pm

For fixing the crashing, update to newest stable mysql and run cron from shell atleast few times a day.

for backup without locking, use r1soft or replicate db, then backup from replicate.

And put your website on a CDN so you can get some load off the server.

Contact me at [email protected] for a free CDN testing, ill show you how to edit XFS