Adult Script Pro Community Forums

Create, help and share your ideas with the community!

You are not logged in.

#1 2013-02-12 09:53:01

Jadmanx
Member
Registered: 2012-05-25
Posts: 127

best Cache Settings for optimising

whats the best Cache Settings for sql.
i have a real big database and a hight load of it whats the best Cache Settings to optimise this ?
Cache Driver:
file
APC

Offline

#2 2013-02-12 10:09:49

symtab
Administrator
Registered: 2010-08-23
Posts: 7,323
Website

Re: best Cache Settings for optimising

Use file. For APC you need a lot of memory or a lot of visitors (in which case the cache will be updated faster).


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - PopAds

Offline

#3 2013-02-13 23:49:51

Mitomind
Member
Registered: 2012-06-27
Posts: 166

Re: best Cache Settings for optimising

Once you get MySQL 5.6.10 larger databases will function better.

You might want to allocate more memory to MySQL in the my.cnf file located in the /etc/ folder (if you are using CentOS).

You might want to consider using Nginx and allocating the extra ram saved to MySQL.

Offline

#4 2013-02-14 07:52:29

symtab
Administrator
Registered: 2010-08-23
Posts: 7,323
Website

Re: best Cache Settings for optimising

Are you saving the videos views ? (Admin -> Video -> Config -> Advanced) If yes, disable this setting.


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - PopAds

Offline

#5 2013-05-20 07:36:48

rbmoss
Member
Registered: 2012-08-17
Posts: 36

Re: best Cache Settings for optimising

can both file and APC be used for caching for optimized result letting the program choose which methodology to use in optimized way. suppose if there are plenty of visitors program can switch to APC and then when visitor count drops it could switch file caching.

Offline

#6 2013-05-20 10:18:53

symtab
Administrator
Registered: 2010-08-23
Posts: 7,323
Website

Re: best Cache Settings for optimising

The best method for caching is currently memcache. It should be used when you have a large number of visitors (100k). If you use it with a low number of visitors, it wont speed anything. You can use APC for a overall speed improvement.


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - PopAds

Offline

#7 2013-11-20 11:50:31

ivatigoal
Member
Registered: 2013-06-07
Posts: 366
Website

Re: best Cache Settings for optimising

What is the best option to set for cache lifetime. i am using APC


Analtube4u

Offline

Board footer

Powered by FluxBB