StackOverflow Questions for Tag: innodb

tcett
tcett

Reputation: 37

MySQL Error:#1238 - Variable 'innodb_lock_wait_timeout' is a read only variable

Score: 1

Views: 9060

Answers: 2

Read More
Sváťa Filev
Sváťa Filev

Reputation: 89

How to use fulltext matching for emails in MySQL?

Score: -1

Views: 581

Answers: 2

Read More
ii G
ii G

Reputation: 1

Mysql: insert same value on a unique index, why locked?

Score: 0

Views: 51

Answers: 1

Read More
Daniel
Daniel

Reputation: 4559

Why do MySQL foreign key constraint names have to be unique?

Score: 7

Views: 3794

Answers: 1

Read More
Hao Xi
Hao Xi

Reputation: 381

Inno DB / MySQL deadlock with two UPDATE statements to the same table but different rows

Score: 0

Views: 75

Answers: 0

Read More
lefticus
lefticus

Reputation: 3416

How do I repair an InnoDB table?

Score: 40

Views: 191469

Answers: 9

Read More
Raden Bagus
Raden Bagus

Reputation: 560

Proper Way for Laravel Indexing for ForeignKey

Score: 0

Views: 44

Answers: 0

Read More
Junior
Junior

Reputation: 557

High write times (apparently random) to a MySQL InnoDB table

Score: 0

Views: 64

Answers: 1

Read More
Desaintflorent
Desaintflorent

Reputation: 51

Mysql Select count with geospatial ST_Contains is very slow with multiple rows

Score: 1

Views: 1093

Answers: 3

Read More
nyx
nyx

Reputation: 489

How to find rows in a table that have no references left?

Score: 0

Views: 44

Answers: 1

Read More
Furqan Freed
Furqan Freed

Reputation: 376

mysql is getting long lock while adding foreign key column as nullable and no default value with index on a big table

Score: 1

Views: 41

Answers: 0

Read More
user9059272
user9059272

Reputation:

What are the current differences between MyISAM and InnoDB storage engines specifically in MySQL 5.7?

Score: 4

Views: 4307

Answers: 2

Read More
Rob Brandt
Rob Brandt

Reputation: 292

Converting MySQL MyISAM longtext to Innodb

Score: 0

Views: 43

Answers: 0

Read More
Michael Modan
Michael Modan

Reputation: 11

Incredibly slow count(*) on MariaDB / MySQL

Score: 1

Views: 120

Answers: 1

Read More
Mustaque Ahmed
Mustaque Ahmed

Reputation: 135

Error : 1071, Specified key was too long; max key length is 1000 bytes

Score: -2

Views: 1152

Answers: 1

Read More
u LoV
u LoV

Reputation: 1

MySQL DeadLock on Delete and Insert

Score: 0

Views: 20

Answers: 0

Read More
Sharon
Sharon

Reputation: 55

Has anyone tried to capture the ON DELETE CASCADE changes that happen in the child tables in Mysql for Auditing purposes?

Score: 0

Views: 17

Answers: 0

Read More
user1411272
user1411272

Reputation:

Does the space occupied by deleted rows get re-used?

Score: 26

Views: 13031

Answers: 3

Read More
Sergei Illarionov
Sergei Illarionov

Reputation: 753

Speed up SQL query with huge amount of data

Score: 0

Views: 258

Answers: 1

Read More
collin ter steege
collin ter steege

Reputation: 89

Auto increment is lower than total rows

Score: 0

Views: 378

Answers: 1

Read More
PreviousPage 4Next