I have a problem. My web site very slowly I think it's mysql. Max user connection instant 100 users. 30-40 people in most cases. My server : Intel Xeon E3-1230v3 16 GB DDR3 Ram 240 GB OCZ SSD Disk Centos…
I am trying to build a set of Docker images that includes an installation of Magento 2 and MariaDB. In rare cases it succeeds (although this could be due to small changes in the app), but in most cases it…
Earlier this year I moved a lightly traffic, data centric site from shared hosting onto a CentOs CloudVM. Performance was perfectly acceptable for 7+ months - now ~10% of queries per day are taking longer than 5 seconds to complete,…
so I have a problem with DB migration from one webserver to another. Server 1 has MySQL version 5.6 running under cPanel hosting... Server 2 has MariaDB version 5.5 running under Webmin/Virtualmin PHP version is the same on both of…
I'm trying to set up a PHP server. We have an old server that runs a bunch of in house forms over an intranet that is coded in ASP, and I'm trying to rebuild that into a better system using…
I have enabled mariadb general log. When I open my web app homepage in prod. env. I have like: 134777 Connect root@58 as anonymous on google 134777 Query use `google` 134777 Prepare set names 'utf8' collate 'utf8' 134777 Execute set…
I've just downloaded phpMyAdmin 4.8.1 via composer on my local machine (windows) after installing my lamp stack apache 2.4, php 7.2, mariadb 10.3, but when I login using root (without password) it gave me this error on Chrome 67: http://localhost/phpmyadmin/…
We run a CentOS DirectAdmin install with MariaDB 10.2.14 where on Magento is installed. Currently our DB locks very often when a process runs, so all other processes are waiting until the current process finishes. This is quite a problem,…
I am running LAMP environment with MYSQL 5.6.38 and Cakephp 2.4.6 in WHM/Cpanel. I am facing high TTFB 400-500ms on my website, I have been told that MariaDB 10.x will fix MYSQL performance issues? Is this true? if I go…
I have developed a website using PhalconPHP. the website works perfectly fine on my local computer with the following specifications: PHP Version 7.0.22 Apache/2.4.18 PhalconPHP 3.3.1 and also on my previous Server (with DirectAdmin): PHP Version 5.6.26 Apache 2 PhalconPHP…