All Questions
35 questions
0
votes
1
answer
768
views
MariaDB InnoDB does not reuse blob storage and file keeps getting bigger. Why?
I have two tables in my MariaDB (10.4.12) which store images (JPEG). They are mediumblobs, typically around 1MB each (though it varies). When a new image first arrives, it gets placed in the ...
- 724
-2
votes
2
answers
121
views
Which serverless database to store user data and images?
I am designing a cloud deployed system where users can log in and upload some user-specific images (not super large files, but maybe sometimes >1mb that are then later displayed in the system to ...
-1
votes
2
answers
2k
views
Error on updating a field with binary values
I have a problem on emoji showing on webpage after migration to new DB Server. But I have a workaround. I will get the binary values of a certain field of TABLE1 on our OLD DB Server. Then update the ...
- 137
1
vote
1
answer
3k
views
LOAD_FILE() works on SELECT, but returns NULL on insert
I'm having troubles using the LOAD_FILE() function in my environment.
I'm trying to add a file to a BLOB field but whenever I try to insert or update this field with LOAD_FILE(), this field is being ...
- 79
-1
votes
1
answer
1k
views
MySQL - Optimize a table which has mostly text data type
I recently faced some performance issue on a CMS based application. I can somehow fix other tables. But Im not able to optimize the table which has 40+ columns and 10 columns are having text as the ...
- 1,986
0
votes
2
answers
3k
views
Insert a large TEXT. Is INSERT the only way?
I am not a strong expert in databases at this level, so I was wondering the following.
A database I am currently working on has a large TEXT field where potentially hundreds of megabytes are stored ...
- 109
0
votes
2
answers
8k
views
BLOB or VARBINARY to store simple Strings that are converted into byte[ ]?
I've read that In MySQL, BLOBs are often used to store image files, file path pointers, video & audio files, and any other big data objects.
But can BLOBs be used for simple Strings that are ...
- 39
2
votes
1
answer
1k
views
Storing files with extension in database as BLOB
Recently during development process I've faced file storage issue. I'm not sure which solution is the best one that's why I decided to write this question. I don't have a lot experience of database ...
- 123
1
vote
1
answer
325
views
What data is duplicated when MySQL/MariaDB BLOB columns are copied?
Let table_1 be created as follows:
CREATE TABLE table_1 (
id INT AUTO_INCREMENT PRIMARY KEY,
some_blob BLOB
);
Let table_2 be created as follows:
CREATE TABLE table_2 (
id INT ...
- 111
9
votes
2
answers
5k
views
In what cases are BLOB and TEXT stored in-line on InnoDB?
I've googled this and can't find it, you can see Rick James mention it here.
... BLOB and TEXT are not always stored separately
The answer on What is the difference between MySQL VARCHAR and TEXT ...
- 65.6k
0
votes
2
answers
2k
views
Dump single rows (with blobs) to single files
I am creating MySQLDumps for the sake of versioning of a database. The problem currently is a table with blobs.
My first approach would be to dump single tables to single files. But next, I want on ...
- 1,243
3
votes
1
answer
6k
views
Storing large files (~1GB) in MySQL
We are considering a solution that will store large files in MySQL with InnoDB. The size of the files can range from 250MB - 1GB (might grow up to 50GB in future). Here is what the plan is.
Create two ...
- 131
3
votes
1
answer
5k
views
Very slow query on table with Blob column [closed]
I have a table with approximately 3500 rows. This table contains a longblob column with an average blob size of 750kb. My query performance really deteriorates when trying to filter on the primary ...
- 31
2
votes
1
answer
3k
views
Do large longtext necessarily slow down a database
I have a MySQL database that is over a million rows, and has a longtext type data column. Most of these are fairly short, but a few dozen of these rows have more than a MB in the longtext column. No ...
- 319
2
votes
1
answer
4k
views
How to search in blob binary wise, and how to export data binary wise
I've a table with a blob field for each row.
The blob contains binary data, which can be represented as bytes or text ( using mysql workbench - open value in viewer)
Does anybody know how can I search ...
- 21