Question : We have a multi-GB InnoDB MariaDB (recently switched from MySQL). For some reason, the value of innodb_file_per_table changed […]
Tag: datafile
Storing blobs outside the database
Question : I had a PostgreSQL database with loads of scanned documents, as a document bytea column in the table […]
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 […]
Restore InnoDB tables / database using only data files
Question : I have MySQL Server 5.1.51 installed on Windows Server 2003 as Operating System and using InnoDB as database […]
SQL Server Storage for multiple data files
Question : Recently, our company wants to add 4TB on the drive size for SQL Server. We have two drives […]
How to get readonly access to mysql files via g+w permission 750 or 640?
Question : The data-dir itself has permissions 700 thereby limiting access to the mysql user. I want other folks who […]
Splitting a large SQL Server MDF file
Question : I have a large (1.2 terabyte) SQL Server database that I need to migrate to a new server. […]
SQL Server split mdf into multiple files
Question : I have a database called example.mdf with a total size of 1GB which suffers from performance issues. I […]
How does subpartitioning actually work and what physical files are created?
Question : I can’t understand how the subpartitioning works in mysql. I am reading the following example: create table invoices […]
Migrating Postgres server from Windows to Linux
Question : Simple question: I want to migrate all of a Postgres server’s data, schema, roles, everything from Windows to […]