I use Nextcloud (18 currently). Everything was working fine until this day when I got this message when accessing my cloud via the webbrowser. Internal Server Error The server encountered an internal error and was unable to complete your request.…
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…
EDIT 2: now that we have optimized the db and narrowed down in MySQL - Why is phpMyAdmin extremely slow with this query that is super fast in php/mysqli? EDIT 1: there are two solutions that helped us. One on…
I need to select all rows added in the last week in the database. This is for a "Top 5" page which should show the most sold products over the past 7 days. I tried: SELECT order_id FROM orders WHERE…
Actually, I would like to switch the engine of my tables. There are in InnoDB and I want to set them to MyISAM because of this ALTER TABLE `xxx_db`.`yyy` ADD FULLTEXT `ft_modele` ( `anno_modele` ) Error : Documentation #1214 -…