using Mysql Vs file system

[recifbox]

i'm currently running my board in 4.1.14.1 i use php 7.0.10 and mysql 5.6.30, after installing php 7 memcache was not able to works i have switched back to no caching, as now i have to wait for it to be ok :

Quote

Installing Memcache on PHP 7.0

The Memcache extension does not currently work with PHP 7.0. If you attempt to install it on PHP 7.0, you will encounter errors building the extension. As soon as the extension is updated to work with PHP 7.0, you will be able to install it.

but he remaining question is what i gain from switching from File Systems ( i using this for now) to Mysql database, did i need to take care of details, pay attention in certain settings ?

 

[m@t]

@recifbox

you must install the "memcached" extension for PHP 7 - memcache is not working anymore at php7 

about change from filesystem to mysql there is nothing special to attended about it

[recifbox]

@m@t thank you for the message, the MySQL switch will improve performance a lot ? (or is it just a tiny %)

[ASTRAPI]

Memcached is faster as it uses ram and ram is faster than the hard disk

[recifbox]

yes i know the thing but .

i use memcached (just installed) then the last option to use is MySQL over file system so is worth it ?

last question is on Imagemagick over GD ( i currently use GD 80/100 et 8/9 ) and setings about img quality ?

(so far with memcached / GD / File systems) https://www.webpagetest.org/result/160823_6B_Q2M/

 

[recifbox]

no one have idea about it ?

[m@t]

what do you mean with " the last option to use is MySQL over file system so is worth it ? " ?
Best performance is (if you have a good server) php-cacher in combination with mysql instead of file system

with GD you cannot get really power out of the system - best it always to have pictures with minimized KB size, better you limit this for your users
if you have no community which is important for high optical quality set is as low as possible

this are all "optical" corrections for a system, with round about 1-3 % performance change maybe 

for caching you can also try to use APCu - maybe it gives you better perfomance than memcached, or try redis if possible for you - there is no general guideline 

[recifbox]

9 minutes ago, m@t said:

Best performance is (if you have a good server) php-cacher in combination with mysql instead of file system

php-cacher like memcached ?

[m@t]

4 minutes ago, recifbox said:

php-cacher like memcached ?

yes correct - best is you try different php-cacher which work together with IPS, if you have it possible to install them  (memcached, apc(c), redis) and look at the performance what you get there  

i play also with this 3 php cacher - i had some problems to get APCu working but now it also works 

[recifbox]

ok thanks you @m@t

[m@t]

you are welcome - if you have time and would like to try you can also play with nginx & apache or mariadb instead of mysql  - but always is very important that you keep everything clean then it works best