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'm trying to import an online wordpress website on my local Wamp server. I exported my database from my online website, and now I'm importing it to my local server with phpmyadmin. Then, the following error message shows up :…
I am trying to fetch posts with meta values where posts have some meta value. for pagination i need count of all rows matched with query so i can divide that into pages and serve to frontend. But I think…
My goal is to make a column in phpMyAdmin, which counts down the remaining days of a trial period (or something like that). So for example when I set remainingDays to 30, I want the database to execute the query…
This code works to give me what I want in my phpMyAdmin server: SET @row_number = 0; SELECT salesperson, units, profit, (@row_number:=@row_number + 1) AS position FROM sales AS t ORDER BY profit DESC; The problem happens when I transfer…
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…
Hello everyone, 1/ I want to do a sql query that transform the result from row to column like it's shown in the picture. Is it possible ? 2/ How can I update the second table with the first one…
i am using a mysql database version 5. I have a table, that has about 500.000.000 rows.The table reclaims 50GB of diskspace if i trust phpmyadmin. I like to delete 90% of the rows to reclaim disk space. What is…
We have automation to login into different websites and perform some operations on website accounts. It is required that only one BOT can login simultaneously into a specific account to avoid inconsistency in automation flow. We have a table in…
Tables and data: CREATE TABLE major ( id INT PRIMARY KEY, name VARCHAR(200) ); insert into major values (101, 'Computing'), (102, 'Arquitecture'); CREATE TABLE student ( id INT PRIMARY KEY, name VARCHAR(200), major_id INT, foreign key(major_id) references major(id) ); insert…