I have the following mysql query: SELECT pagos.id, codigo_factura as code, pagos.importe as amount FROM pagos INNER JOIN m_labores p ON (pagos.id_producto = p.id) INNER JOIN maquinas m ON (pagos.id_maquina = m.id) WHERE m.id = 561 AND fecha_registro BETWEEN '2022-10-11…
The company I am working uses an older stack, and I need to install MySQL 5.7 on my Ubuntu 22.04 LTS to work on some projects locally. Does anyone knows how to do this? I just can't find anything besides…
There are 2 samples. In the first example, it gives faster results when using orderby. (according to phpmyadmin speed report) In the other example, I don't use order by, it gives slower results. (according to phpmyadmin speed report) Isn't it…
Using: MySQL 5.6 on Debian 9, total DB size is around 450Gb Updated to 5.7, ran mysql_upgrade, noticed that around 150 GB has been taken up. 2 tables are really large and they stayed in 'copying to tmp table' for…
We have a Magento website that works as expected. We are at the optimization point and are trying to run our caches. We navigate to the index manager and receive the following: SQLSTATE[HY000]: General error: 2006 MySQL server has gone…
I was going to work on a new web project and found that mysql 5.7+, the latest entry, is not yet supported by cPanel. Can you guys please share your experience, which work around you have found to this ?…