Question : I’m trying to understand why Mariadb (v10.4.12) is writing most of the temp tables to disk. Created_tmp_disk_tables 196,8k […]
Tag: mariadb-10.4
an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Select data from a table to insert/update another similar table
Question : I have two tables (in two databases): create table catalog_product_entity_text ( value_id int auto_increment comment ‘Value ID’ primary […]
How to get all previous week record by using creating a imaginary column
Question : I have problem an now this is more than 2days and I can’t find any answer. can you […]
slow UPDATE of rows by COUNTing from another table
Question : I try to update a table by counting rows from another table as UPDATE t1 SET c1 = […]
Join without indexing the entire table
Question : I have a query that pulls the 3 most recently commented posts on our forum. The issue is […]
MariaDB Out-of-Order Parallel Replication and OPTIMIZE TABLE
Question : I am using MariaDB 10.4 and have question about Out-of-Order parallel replication. I am optimizing databases(about 400GB of […]
slow UPDATE of rows by COUNTing from another table
Question : I try to update a table by counting rows from another table as UPDATE t1 SET c1 = […]
How do I set up one server to replicate X schemas from X different server, without resorting to mysqldump?
Question : In other words; I’m trying to figure out how to restore multiple mariabackup dumps to one server (different […]
UTF8mb4 MariaDB 10.4 – Max key length is 767 bytes error
Question : I am running MariaDB 10.4. I am trying to setup symmetricDS for database syncing. Some of the tables […]
- 1
- 2