I have this table using InnoDB as engine: create table if not exists Playlists( UserId bigint unsigned not null, Title varchar(50) not null, IsPublic bool not null, primary key (UserId, Title), foreign key (UserId) references Users(Id) on delete cascade on…
I am running MySql v8.0 with InnoDB. I have a simple transaction that has a SELECT (not a SELECT ... FOR UPDATE) followed by an INSERT. I'm getting frequent deadlocks when many DB inserts are happening simultaneously. All inserts use…
I have a Mysql InnoDB table with storage size(+index) over 2,000GB, There are 14 billion rows in that table.. I need to drop data added over 1 month ago, and figure out a way to always keep recent 1 month…
I have a stored procedure that runs every one hour to generate a summary of the transactions that happened in the service. The stored procedure reads the data from a table called transaction_log and populates(insert or updates rows) another table…
I have an InnoDB table which looks like this right now: The table is around 126GB big, but I have read that InnoDB's default can hold up to 64 TB of data. Is this correct? I ask because of the…
I am trying to find a way to improve performance of 'Load data infile' command for InnoDB table, which is extremely slow. Generally I have been using MyISAM for more than 10 years, because this engine by design is the…
I have a table (say table t) with an index on col_a that is unique. Now the index on col_a is used in these 2 following cases - SELECT * from t WHERE(col_a,col_b) IN((x,y),(p,q)); - query_1 SELECT * from t…
Since a few days I have fatal errors "InnoDB: innodb_fatal_semaphore_wait_threshold was exceeded for dict_sys.latch". Neither the underlying Debian Bookworm nor the MariaDB Server 10.11.4 was changed before. What could cause this issue? The log is showing: mariadbd[324032]: 2023-12-22 11:50:54 0…
When tryint to install AzerothCore with Docker I had the following error to my ac-database container: [ERROR] [MY-012526] [InnoDB] Upgrade is not supported after a crash or shutdown with innodb_fast_shutdown = 2. This redo log was created with MySQL 8.0.29,…
I have a simple question. I have a mysql databases. I have 2 tables, that uses MYISAM, I want to change to INNODB, one of the table has 1.000 rows, if I do this this change, is there a risk…