Questions tagged [storage-engine]

The tag has no usage guidance.

10 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3 votes
0 answers

Moving from dynamic disk allocation to direct space disk via storage pool in SQL server

Pardon me if I am not clear in asking the question since I have very less understanding from storage terms used or how it's used with Sql server. Currently our storage team is testing to move disk ...
BeginnerDBA's user avatar
  • 2,169
1 vote
0 answers

Non RAM based in-browser database solutions?

I want to decentralize my databases and upload it to Sia Skynet to give the users the ability to search on front-end. It is important to be able to deal with large amounts of data, but the RAM-based ...
DaWe's user avatar
  • 119
1 vote
0 answers

Is there any such thing as an https storage engine?

Maybe I have too much time on my hands, and this may be a stupid idea, but... I have recently had to download data in table-form from websites, and I got to thinking that it might have been easier, ...
j4nd3r53n's user avatar
  • 231
1 vote
0 answers

Is the idea of 'pages' and 'extents' unique to SQL Server or shared by other database management systems?

I know that a database management system like MySQL can make use of multiple storage engines - i.e. InnoDB, MyISAM, etc. And reading into how SQL Server stores data (Understanding Pages and Extents), ...
Zach Smith's user avatar
  • 2,300
0 votes
0 answers

Connect Engine: behaviour on network outage

I am working in an environment with worldwide distributed databases. For the reporting, we use MariaDB Connect Engine to access the remote data from our central site. Sometimes the Network connection ...
DavidRamseier's user avatar
0 votes
0 answers

Table-specific storage engines blocking mysql_secure_installation

I've just installed MySQL 8.0 on an Ubuntu 22.04 system. I tried running mysql_secure_installation, but I got the following error: New password:   Re-enter new password:   ... Failed! Error: ...
Darien Marks's user avatar
0 votes
1 answer

csv engine and mysql start

my question is about speed when perform service mysql start. with many tables (some not often used). what engines consumes more or less start time ? example: innodb --> the more tables, the more ...
Jintor's user avatar
  • 113
0 votes
1 answer

Best way to store HTML dropdown options

I'm developing a web site for a model agency. I have a "model" table with the details about each model (this is just an example): CREATE TABLE model { model_id INT PRIMARY KEY, name VARCHAR(...
Lucas's user avatar
  • 9
0 votes
1 answer

Change Storage Engine on Referenced Tables

i need to change storage engine from 'InnoDB' to 'MyISAM' on some tables of different databases. So i made a script file to do so: #!/bin/bash DATABASES=$(mysql -u XXXXX -pXXXXX --skip-column-names -...
kriegu's user avatar
  • 640
-1 votes
1 answer

MariaDB CONNECT engine to read external mongodb collections

I want to access MongoDB collections through MariaDB 10.4.17. Both are installed on my local machine running Windows 10. Software listening port MongoDB 27017 MariaDB 15501 I installed the MariaDB ...
DB guy's user avatar
  • 69