New answers tagged

0 votes

table is full in innodb

-- Step 1: Backup Your Data -- Make sure to backup your data before proceeding with any changes to the table structure. -- Step 2: Alter the Column Type -- Change the column type from INT to BIGINT ...
warashi nguyen's user avatar
1 vote

Mariadb threads blocking randomly

We've upgraded Mariadb to version 10.6.17 5 days ago and haven't seen the issue again. Although we're still monitoring, its most likely resolved.
vamyip's user avatar
  • 121
0 votes
Accepted

Fatal error 1408 when installing mariadb-server / mariadb-upgrade

Ended up submitting a bug report and got help from a MariaDB developer on how to fix this: https://jira.mariadb.org/browse/MDEV-33262. In case that link breaks, here was his summary of the problem: ...
Curtis Spencer's user avatar
0 votes

InnoDB High history list length grows indefinitely

The following may avoid the problem: If the UPDATEs are on "like" or "upvote" counters, remove the column from the main table. Instead, have a separate table with the counter; ...
Rick James's user avatar
  • 77.6k
0 votes

Mariadb threads blocking randomly

(Nothing jumps out as being helpful for the problem at hand.) Analysis of GLOBAL STATUS and VARIABLES: Observations: Version: 10.6.16-MariaDB-0ubuntu0.22.04.1 8 GB of RAM -- my ...
Rick James's user avatar
  • 77.6k
0 votes

Mariadb threads blocking randomly

These indexes might help: `tabGL Entry`: INDEX(company, docstatus, party_type, party, -- in any order account_currency) -- last tabDefaultValue: INDEX(defkey, parent) -- in ...
Rick James's user avatar
  • 77.6k
0 votes

MySQL FullText search on string shorter than 3 chars returns no rows

I tried @RolandMySQLDBA solution, but still no results. The query is simple: SELECT * FROM agreement a WHERE MATCH (a.title) AGAINST ('it*' IN BOOLEAN MODE) The table is MyISAM, the title column has ...
long's user avatar
  • 101
0 votes

MariaDB in the cloud....need some guidance

Based on the data provided, at least 4TB of disk on your server. The rest depends on the complexity and frequency of queries, plus the size of the result sets. The number of CPU cores is not likely ...
Rick James's user avatar
  • 77.6k

Top 50 recent answers are included