Question : The server has 128GB of RAM. The innodb_buffer_pool_size is set to 106GB. mysql> show global variables like ‘innodb_buffer_pool_size’; […]
Category: InnoDB
MySQL Bug required remedy : [Warning] Invalid (old?) table or database name ‘#sql-‘
Question : We have a master & multiple slave replication in our production environment. At first, I found this error […]
Does a database update force index rebuild regardless of updated field?
Question : With MySQL (InnoDB), I understand that having indexes slow down UPDATE queries. I would like to know if […]
Deleting hundreds milion of rows in single MySQL query
Question : we have a project with a huge MySQL table (MySQL version 5.7.35-0 on Ubuntu 18.04.1 using InnoDB) table. […]
MySQL – Installing InnoDB Plugin
Question : I have a Master/Slave Replication Setup, both servers run MySQL 5.1.61. I want to upgrade the master server […]
MySQL InnoDB transactions with lot of delete instructions
Question : We have a process that runs frequently and does the following steps on a mysql database of type […]
Two updates cause a deadlock
Question : I have a mysql queue with the following sheme: CREATE TABLE IF NOT EXISTS `media` ( `mid` int(11) […]
MariaDB ALTER TABLE produced a separate .ibd file, how can I re-integrate the data into the shared table space?
Question : We have a multi-GB InnoDB MariaDB (recently switched from MySQL). For some reason, the value of innodb_file_per_table changed […]
SELECT from table without blocking INSERTs into it?
Question : I have an application where each page load inserts information about the visit into a MariaDB table. There […]
Optimize mysql database performance
Question : I have a database with some relatively small tables and one big table with about 10 million rows […]