I downloaded a docker image with mariadb and phpmyadmin, then wrote two dockerfiles below.. # dockerfile A FROM alfvenjohn/raspbian-buster-mariadb-phpmyadmin CMD /etc/init.d/mysql start && /etc/init.d/apache2 start # dockerfile B FROM alfvenjohn/raspbian-buster-mariadb-phpmyadmin CMD service mysql start && /usr/sbin/apachectl -D FOREGROUND dockerfile B…
I need help with MariaDB server optimization. I have a lot I/O operations (created tmp disk tables) and I want to reduce it. Hardware: CPU 20 x 2197mHz, RAM 50 Gb, SSD disks RAID 10 Software: 10.1.26-MariaDB-0+deb9u1 - Debian 9.1…
I have 2 tables, 1 with ~1.5 million records and other with ~200.000, and i need to delete duplicates in the big table. I have one query and i think its correct, however can´t finish process because needs very much…
I am trying to build MariaDB v10.3 with a musl tool chain on x86_64 Debian kernel v4.19. I have mainly been using the musl-gcc gcc wrapper to achieve this. The relevant packages I installed are as follows: musl (1.1.21-2): standard…
DELETE FROM 014_terms WHERE term_id IN (SELECT term_id FROM 014_term_taxonomy WHERE taxonomy LIKE 'pa_%'); I get an error #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the…
I am trying to upgrade from mariadb 10.1 to the newest version (10.5) on Debian 8.11. Everything fine until : apt-get install mariadb-server And the error The following packages have unmet dependencies: mariadb-server : Depends: mariadb-server-10.5 (>= 1:10.5.5+maria~bionic) but it…
I have an SQL table that contains some info about projects and roughly looks like the table below. In this table a project may have multiple instances because it has multiple tasks. Each task will have a status and every…
enter image description here My table has data as shown in the picture. I selected the SiteInstanceID value based on a selection from another column "AttributeValue". SELECT `SiteInstanceID` FROM `sitecomponentattributevalues` WHERE `AttributeValue` = 00069 Now I want to select all…
I designed a database model on MySQLWorkbench. Then, I export the model to generate a SQL script. Finally, when I import it in MariaDB PhpMyAdmin it raises errors like : #1067 - Invalid default value for 'created' MariaDB version :…
We are in the middle of refactoring a custom-built middleware/API from Python 2 to 3. The software is responsible for creating and updating categories, products, listings, orders, stock, etc. on many different platforms (like ebay, amazon, shopware) by data exported…