Top "Innodb" questions

Why doesn't MySQL's MyISAM engine support Foreign keys?

I am writing a web-app for my studies which includes fulltext search and foreign keys. I have read somewhere, MyISAM …

mysql database innodb myisam

How to optimize COUNT(*) performance on InnoDB by using index

I have a largish but narrow InnoDB table with ~9m records. Doing count(*) or count(id) on the table is …

mysql innodb

Mysql 'Got error -1 from storage engine' error

I have a myism table 'test' which holds some out-dated data, now I want to recreate the table, all columns …

mysql innodb

Is there any performance gain in indexing a boolean field?

I'm just about to write a query that includes a WHERE isok=1. As the name implies, isok is a boolean …

mysql indexing innodb

mysql_upgrade failed - innodb tables doesn't exist?

I am upgrading my mysql-5.5 docker container database to mysql-5.6 docker container. I was able to fix all other problems. …

mysql docker innodb mysqlupgrade

How to improve INSERT INTO ... SELECT locking behavior

In our production database, we ran the following pseudo-code SQL batch query running every hour: INSERT INTO TemporaryTable (SELECT FROM …

mysql select insert locking innodb

Magento install complains about missing InnoDB when it is available

During installation, Magento produces the following error: Database server does not support the InnoDB storage engine. I've fixed all the …

php mysql magento innodb

Storing base64 encoded data as BLOB or TEXT datatype

We have a MySQL InnoDB table holding ~10 columns of small base64 encoded javascript files and png (<2KB size) images …

mysql text blob innodb

Prevent auto increment on MySQL duplicate insert

Using MySQL 5.1.49, I'm trying to implement a tagging system the problem I have is with a table with two columns: …

mysql insert duplicates innodb auto-increment

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

I have mysql DB on server S1 (mysql version 5.1.41-3ubuntu12.7-log), i have created master-slave for this DB on …

mysql innodb master-slave