Top "Innodb" questions

Why is MySQL InnoDB insert so slow?

I am using large random numbers as keys (coming in from another system). Inserts and updates on fairly-small (as in …

mysql performance innodb

Is there a REAL performance difference between INT and VARCHAR primary keys?

Is there a measurable performance difference between using INT vs. VARCHAR as a primary key in MySQL? I'd like to …

mysql performance primary-key innodb myisam

Database corruption with MariaDB : Table doesn't exist in engine

I'm in an environement setup, running OSX with MariaDB 10.0.12-MariaDB Homebrew I've screwed up the installation so I did completely …

mysql innodb mariadb

#1025 - Error on rename of './database/#sql-2e0f_1254ba7' to './database/table' (errno: 150)

So I am trying to add a primary key to one of the tables in my database. Right now it …

mysql sql phpmyadmin innodb mysql-error-1025

How to enable INNODB in mysql

When I execute a query in MySQL it returns an error saying that InnoDB is not enabled. When I clicked …

mysql sql transactions innodb

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

My application is very database intensive so I've tried really hard to make sure the application and the MySQL database …

caching mysql performance innodb

What is InnoDB and MyISAM in MySQL?

What is InnoDB and MyISAM in MySQL ?

mysql innodb myisam

"Unknown column in 'field list'", but column does exist

DROP TABLE IF EXISTS `transactions`; CREATE TABLE `transactions` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `purchase_date` datetime DEFAULT NULL, …

mysql sql insert innodb

mysql change innodb_large_prefix

I just setup debian 8.3 on a VM and installed xampp after this Tutorial. Everything is working, until I tried to …

mysql innodb utf8mb4

Mysql won't start - ibdata1 corrupt? - operating system error number 13 - permissions issue

Server shutdown from power failure. Mysql will not start now. Disk is not full. Syslog is below Oct 11 15:03:31 joe mysqld_…

mysql file permissions innodb