Top "Innodb" questions

How do I recreate an FRM file for an MySQL InnoDB table with only the ibdata and *.ibd files?

This is a slightly different question than the related InnoDB repair questions I have seen on stackoverflow. Assume that I …

mysql database innodb restore database-restore

MySQL Full-text Search Workaround for innoDB tables

I'm designing an internal web application that uses MySQL as its backend database. The integrity of the data is crucial, …

mysql search innodb myisam full-text-search

How to resolve "specified key was too long max key length is 255 bytes" in mysql?

Whenever i fire this query from one of the mysql client (emma): CREATE TABLE `tbl_mappings` ( `id` int(11) unsigned NOT …

mysql database innodb mysql-5.7 my.cnf

InnoDB performance tweaks

I'm switching a large table to InnoDB from myISAM. There has been a lot of discussion regarding why switching makes …

mysql innodb myisam

Optimal MySQL-configuration (my.cnf)

The following is my default production MySQL configuration file (my.cnf) for a pure UTF-8 setup with InnoDB as the …

mysql optimization utf-8 innodb my.cnf

Should I migrate from MySQL to Percona server

I have been experiencing dirty pages flushing problem in MySQL server. This occupies lot of CPU resources and my site …

mysql innodb percona

Joining InnoDB tables with MyISAM tables

We have a set of tables which contain the meta level data like organizations, organization users, organization departments etc. All …

mysql innodb myisam

MySQL tables gone after deleting ibdata1

A couple of days ago I couldn't get mysql to run anymore(xampp) after some googling I found this post: …

mysql innodb data-recovery

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

I'm trying to delete 267 records out of about 40 million. The query looks like: delete from pricedata where pricedate > '20120413…

mysql locking innodb sql-delete

Windows 7 MySQL Error 1067 Services Will not Start

This has been a nightmare of a problem. I initially installed WAMP and everything worked fine. I restarted my computer …

mysql service innodb mysql-error-1067