The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!
You are not logged in.
Pages: 1
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
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 - EXOClick - PopAds
Offline
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
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 - EXOClick - PopAds
Offline
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
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 - EXOClick - PopAds
Offline
Pages: 1