Bill Dalton Posted September 13, 2014 Share Posted September 13, 2014 Been testing MariaDB the last few days. Complete drop in replacement for MySQL 5.6. Using it with PS 1.5.6.2 and I did get a small boost in speed of approximately 400ms per page load. Every little bit helps. YMMV 6 Link to comment Share on other sites More sharing options...
El Patron Posted September 13, 2014 Share Posted September 13, 2014 Thanks Bill for posting results of your effort, increasing speed of 1.5.6.2 is not easy. Link to comment Share on other sites More sharing options...
parsifal Posted September 18, 2014 Share Posted September 18, 2014 (edited) I have also used MariaDB in my last 2 projects (not PrestaShop-related) with no problems up to now. I will be soon reimplenting a PrestaShop store, going from a 512MB RAM-1 vCPU VPS with Apache+PHP+MySQL+PS1.5 to a 4GB RAM-4 vCPU VPS with nginx+PHP-FPM+MariaDB+PS1.6. I really hope the speed gain will be worth the effort (and the added cost of the new VPS)... Edited September 18, 2014 by parsifal (see edit history) 1 Link to comment Share on other sites More sharing options...
Bill Dalton Posted September 18, 2014 Author Share Posted September 18, 2014 I had been reading about a 10% speed boast just by adding the just released PHP 5.6. I installed and tested and could not confirm any speed advantage. I'm mainly looking for speed improvements related to the server sending first byte. PHP 5.6 also, for whatever reason caused my social logins to malfunction. I quickly reverted back to the safety of PHP 5.4.15 I very happy with MariaDB, and Googles PageSpeed Module. 1 Link to comment Share on other sites More sharing options...
parsifal Posted September 18, 2014 Share Posted September 18, 2014 Perhaps it's a little early for PHP 5.6. I keep reading about better performance in 5.5+ due to native opcode caching, but there are other things that may cause problems to older PHP-based web apps (depreciation and changes to functions, function arguments etc.)... 1 Link to comment Share on other sites More sharing options...
El Patron Posted September 18, 2014 Share Posted September 18, 2014 btw: module in test that core cache db, similar in concept to sql slave, but something that one can implement without back bone changes mysql sync which is impossible for 99% of shop owners to implement..uses php shared memory (when enabled on server) else php server storage. the problem with db is 1) having to access for reads and 2) only paid versions support real cache (i.e. if I update record 'viewed' count, the db engine will immediate file vs file vs. nth time or withing certain time frame). All serious performance rely on advanced db engine cache and/or use 'other' method, typically virtual file access (core caching). I am after 'other'. happy day, Fred 2 Link to comment Share on other sites More sharing options...
Bill Dalton Posted September 19, 2014 Author Share Posted September 19, 2014 Sound fantastic! 1 Link to comment Share on other sites More sharing options...
jstepp28 Posted September 25, 2014 Share Posted September 25, 2014 I've been playing with the Percona/MariaDB/MySQL innodb memcached plugin and not having much luck beyond getting the pieces installed but I can't get the plugin to initialize so if there are any PHP/mySQL gurus out there that think this is worth some time and effort I'd love to know how to setup a test environment so we can test functionality and performance. Here are some links that will help get it installed and setup which is where I'm at but actually getting a Prestashop table loaded into cache is giving me fits. So even some help in that area would be amazing. Warning Not for casual/new admins --- "This will not be over quick... you will not enjoy this," - 300 http://the-phpjs-ldc.rgou.net/mysql/storage-engines.html#innodb-memcached Always trying to find ways to improve performance using tools that are free "if you're willing to go through the pains of the setup". Thanks- James Link to comment Share on other sites More sharing options...
carras Posted November 2, 2015 Share Posted November 2, 2015 Hi, What performance tuning do you guys use with MariaDB? Thanks. Hi, Using MaridDB 10.10.8; which cache setting do you recommend? I believe MariaDB doesn't not use Memcached. What do you guys use? Thanks. Link to comment Share on other sites More sharing options...
Bill Dalton Posted November 2, 2015 Author Share Posted November 2, 2015 Carras, take a look at this, https://mariadb.com/kb/en/mariadb/query-cache/ Link to comment Share on other sites More sharing options...
carras Posted November 3, 2015 Share Posted November 3, 2015 Carras, take a look at this, https://mariadb.com/kb/en/mariadb/query-cache/ Thanks for you answer. Does that mean that with "query cache" theres is no use for Memcached or APC in prestashop? Thanks. Link to comment Share on other sites More sharing options...
Bill Dalton Posted November 3, 2015 Author Share Posted November 3, 2015 (edited) With Memcache and shopping carts you need to exclude from cache any calls that relate to changing data. For example if I add to the cart, I not only need to stop my cart from being cached, but if I continue shopping I'm going to need to make sure all modules that show updated data are not included in the cache. So Memcached is not something you just turn on and forget about. Memcached is lots of work. That said if you are already using it or are planning on it, then yes you can use the same mySQL pluggin for memcached. Please see, http://itresident.com/mysql/innodb-memcached-plugin/ Edited November 3, 2015 by Bill Dalton (see edit history) Link to comment Share on other sites More sharing options...
carras Posted November 3, 2015 Share Posted November 3, 2015 With Memcache and shopping carts you need to exclude from cache any calls that relate to changing data. For example if I add to the cart, I not only need to stop my cart from being cached, but if I continue shopping I'm going to need to make sure all modules that show updated data are not included in the cache. So Memcached is not something you just turn on and forget about. Memcached is lots of work. That said if you are already using it or are planning on it, then yes you can use the same mySQL pluggin for memcached. Please see, http://itresident.com/mysql/innodb-memcached-plugin/ But I just mean to activate it on the PS Performance Menu. I stopped using it since I moved to MariaDB. What's your configuration on Performance? The last one call "cache" with Memcached, APC, Xcache available. I've use Memcached, Xcache and APC in the past (with mysql); and they've work. Thanks. Link to comment Share on other sites More sharing options...
Bill Dalton Posted November 3, 2015 Author Share Posted November 3, 2015 (edited) Got it. What version of MariaDB are you using? Here is an article testing PS 1.6X with MariaDB 10.X http://build.prestashop.com/news/prestashop-1-6-1-0-performances/ Edited November 3, 2015 by Bill Dalton (see edit history) Link to comment Share on other sites More sharing options...
carras Posted November 3, 2015 Share Posted November 3, 2015 Got it. What version of MariaDB are you using? Here is an article testing PS 1.6X with MariaDB 10.X http://build.prestashop.com/news/prestashop-1-6-1-0-performances/ Using MariaDB 10.1.8 Thanks a lot for the article, this is the information I was looking for: "Final note: Whereas in 1.6.0.14 we recommended to not enable the PrestaShop cache, in 1.6.1.0 we recommend you to enable it, with a local Memcached server (APC should be OK as well)." So I'll use Memcached. 1 Link to comment Share on other sites More sharing options...
El Patron Posted May 22, 2016 Share Posted May 22, 2016 btw: module in test that core cache db, similar in concept to sql slave, but something that one can implement without back bone changes mysql sync which is impossible for 99% of shop owners to implement..uses php shared memory (when enabled on server) else php server storage. the problem with db is 1) having to access for reads and 2) only paid versions support real cache (i.e. if I update record 'viewed' count, the db engine will immediate file vs file vs. nth time or withing certain time frame). All serious performance rely on advanced db engine cache and/or use 'other' method, typically virtual file access (core caching). I am after 'other'. happy day, Fred I'm back on this pet project. again. 1 Link to comment Share on other sites More sharing options...
Bill Dalton Posted May 22, 2016 Author Share Posted May 22, 2016 I see Jack Nicholson chopping through my door with an axe ... and I like it! I'll be a tester if needed. 1 Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts