Mysql 8.0 “ERROR 1030 (HY000): Got error 100” when adding index to very large table
I’m attempting to add an index to a very large table (2B rows) and the command fails after a few hours with:
innodb
Can it be safe to disable binary logging in MySQL?
Is the MySQL binlog similar to Oracle’s redo log or PostgreSQL’s Write-Ahead Log?
Change location of innodb_temporary
I want to change the path where the ibtmp1 is stored in mysql 8.0.25 on debian 11. How to do this? I see:
Database becoming unresponsive after time (4 to 24 hours)
Since a couple of days my mariadb database randomly becomes unresponsive after random intervals (which have been between 4 and 20 hours).
MySQL InnoDB migrations custom implementation: How to deal with DML statements which trigger a commit in the background?
After some discussion on that topic I can assume that there is a quite frustrating fact about MySQL InnoDB: It does not support (atomic) transactions when it comes to DML.
How to change value for innodb_buffer_pool_size in MySQL on Mac OS?
I am trying to increase the size of the innodb_buffer_pool_size in MySQL 5.1 as I keep running into the following error indicating I have run out of space for the table locks.
What are MySQL database engines?
A database engine (or storage engine) is the underlying software component that a database management system (DBMS) uses to create, read, update and delete (CRUD) data from a database. Most database management systems include their own application programming interface (API) that allows the user to interact with their underlying engine without going through the user interface of the DBMS.
InnoDB takes over an hour to import 600MB file, MyISAM in a few minutes
I’m currently working on creating an environment to test performance of an app; I’m testing with MySQL and InnoDB to find out which can serve us best. Within this environment, we’ll automatically prepare the database (load existing dumps) and instrument our test tools.
How do I know if a mysql table is using myISAM or InnoDB Engine?
In MySQL, there is no way to specify a storage engine for a certain database, only for single tables. However, you can specify a storage engine to be used during one session with:
#1025 – Error on rename of ‘./database/#sql-2e0f_1254ba7’ to ‘./database/table’ (errno: 150)
So I am trying to add a primary key to one of the tables in my database. Right now it has a primary key like this: