Questions about innodb
Read more about innodb
python (12.9k questions)
javascript (9.2k questions)
reactjs (4.7k questions)
java (4.2k questions)
java (4.2k questions)
c# (3.5k questions)
c# (3.5k questions)
html (3.3k questions)
Why MySql Load_File(TextFile) return BLOB string?
Windows 7, MySQL 8.0, InnoDB.
File contains ususal text, load result contains BLOB string.
select load_file('d:/temp.txt');
result: 0x62...43
Why it happens? And can i get TEXT result whithout convert...
Tohares
Votes: 0
Answers: 0
InnoDB: preallocating 147456 bytes for file XXX.ibd failed with error 2
I'm using official MariadDB 10.7 docker image, Windows 10. Had this error started today that kept repeating, tried everything:
- mysqlcheck -Ar
- delete docker image with all the data
- chkdsk -F
- du...
SubjectX
Votes: 0
Answers: 1
MYSQL8. Why is transaction 2 locked in this situation?
READY
# ready
CREATE TABLE table_a
(
id int PRIMARY KEY AUTO_INCREMENT,
col_1 INT,
INDEX idx_a (col_1)
) ENGINE = innodb;
id
col_a
1
10
2
15
3
20
4
25
Trnasaction 1
STAR...
bbang
Votes: 0
Answers: 1
MYSQL in XAMPP v3.3.0 is not starting, was running fine till yesterday HY2006 error
It was running till yesterday suddenly it's crashing from today morning.
I'm attaching the error log, any help will be appreciated.
I've also tried to find out if any process using up this port with t...
Debajyoti Das
Votes: 0
Answers: 1