Alex Rivera | Logout

Questions tagged innodb

40 questions

Sort by: Newest Votes Active
16
votes
1
answers

Transaction necessary for single update query?

mysql transactions innodb
asked 2013-07-25T11:11:07.003
9
votes
5
answers

update query sometimes does not update field in mySQL database

mysql innodb
asked 2013-01-08T22:57:47.007
41
votes
3
answers

MySQL InnoDB: autoincrement non-primary key

mysql primary-key innodb
asked 2012-12-29T22:02:46.277
983
votes
4
answers

TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes

mysql innodb
asked 2012-12-18T12:13:35.297
10
votes
2
answers

Foreign keys for myISAM and InnoDB tables

mysql innodb
asked 2012-11-22T00:12:02.640
290
votes
2
answers

What's the difference between MyISAM and InnoDB?

mysql database innodb myisam
asked 2012-09-27T05:18:04.837
24
votes
6
answers

MySQL: Very slow update/insert/delete queries hanging on "query end" step

mysql performance replication innodb
asked 2012-09-07T10:16:06.870
9
votes
2
answers

Life without transactions (MyISAM)

mysql transactions innodb myisam vds
asked 2012-08-28T23:33:10.850
10
votes
2
answers

With PHP and MySQL, should you check for rollback failures?

php mysql transactions innodb
asked 2012-08-23T21:45:44.273
28
votes
12
answers

Is there a simpler way to achieve this style of user messaging?

mysql sql database database-design innodb
asked 2012-05-14T17:43:05.270
13
votes
3
answers

"The total number of locks exceeds the lock table size" Deleting 267 Records

mysql locking innodb sql-delete
asked 2012-04-20T20:59:56.007
10
votes
3
answers

#1033 - Incorrect information in file: './database_name/table_name.frm'

php mysql phpmyadmin innodb myisam
asked 2012-03-18T18:44:37.250
10
votes
1
answers

MySQL - Different Engines for Different Tables

mysql join innodb myisam
asked 2012-03-10T16:26:44.767
11
votes
2
answers

InnoDB inserts very slow and slowing down

mysql performance innodb
asked 2012-02-02T14:39:26.527
10
votes
5
answers

Error 'Unknown table engine 'InnoDB'' on query. after restarting mysql

mysql innodb master-slave
asked 2011-10-16T07:02:43.897
9
votes
2
answers

How can I override the ENGINE=INNODB parameter while importing a MySQL dump file?

database import innodb mysql
asked 2011-10-12T12:07:53.610
25
votes
7
answers

Unknown table engine 'InnoDB'

mysql innodb
asked 2011-09-05T01:09:43.387
9
votes
4
answers

InnoDB vs. MyISAM insert query time

mysql database optimization innodb myisam
asked 2011-08-27T21:32:01.883
19
votes
2
answers

Muzak replication advice and techniques

php mysql replication innodb myisam
asked 2011-08-27T20:07:07.270
37
votes
5
answers

Renaming an InnoDB table without updating foreign key references to it?

mysql innodb
asked 2011-06-17T11:00:11.427
10
votes
6
answers

MySQL InnoDB hangs on waiting for table-level locks

java mysql locking innodb
asked 2011-05-31T10:02:36.503
311
votes
12
answers

How to debug Lock wait timeout exceeded on MySQL?

mysql debugging transactions innodb acid
asked 2011-05-14T07:07:45.043
21
votes
2
answers

MySQL: Column Contains Word From List of Words

sql mysql innodb
asked 2011-01-14T06:51:29.633
56
votes
3
answers

MySQL Integer vs DateTime index

mysql indexing innodb
asked 2011-01-04T13:40:16.727
74
votes
3
answers

What are MySQL database engines?

mysql database storage innodb database-engine
asked 2010-11-20T16:48:44.180
10
votes
1
answers

How to make innodb as default engine

mysql innodb
asked 2010-11-16T21:58:00.233
83
votes
4
answers

MySQL InnoDB foreign key between different databases

mysql database foreign-keys innodb
asked 2010-10-11T09:32:41.537
139
votes
8
answers

What is InnoDB and MyISAM in MySQL?

mysql innodb myisam
asked 2010-09-29T04:36:38.657
9
votes
1
answers

Which MySQL database engine is better for storing sessions and session data: MyISAM or InnoDB?

php mysql session innodb myisam
asked 2010-07-29T04:01:30.117
114
votes
11
answers

UUID performance in MySQL?

mysql performance innodb sequence uuid
asked 2010-03-02T17:14:44.267
68
votes
4
answers

InnoDB takes over an hour to import 600MB file, MyISAM in a few minutes

mysql performance innodb
asked 2010-01-30T10:23:07.973
33
votes
6
answers

MySQL query caching: limited to a maximum cache size of 128 MB?

caching mysql performance innodb
asked 2010-01-19T17:43:03.240
61
votes
11
answers

Hibernate: Create Mysql InnoDB tables instead of MyISAM

java mysql hibernate jpa innodb
asked 2009-09-22T10:23:53.707
26
votes
3
answers

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

mysql database size innodb rows
asked 2009-03-11T12:11:40.967
97
votes
11
answers

MySQL AUTO_INCREMENT does not ROLLBACK

mysql transactions innodb auto-increment
asked 2009-01-16T02:49:44.330
44
votes
12
answers

MySql: MyISAM vs. Inno DB!

mysql database innodb myisam
asked 2008-11-10T09:42:23.120
494
votes
14
answers

How can I check MySQL engine type for a specific table?

mysql innodb myisam
asked 2008-10-17T19:28:38.230
12
votes
3
answers

mysql "drop database" takes time -- why?

mysql database schema innodb
asked 2008-09-29T18:42:14.657
10
votes
3
answers

MySQL InnoDB database restore

mysql backup innodb restore
asked 2008-09-22T15:49:22.957
893
votes
25
answers

MyISAM versus InnoDB

mysql database performance innodb myisam
asked 2008-08-21T14:50:52.780