Top "Innodb" questions

MySQL: What is a page?

I can't for the life of me remember what a page is, in the context of a MySQL database. When …

mysql database innodb

MySQL InnoDB database restore

I have to restore a database that has been inadvertently DROPped in MySQL 5.0. From checking the backup files, I only …

mysql backup innodb restore

Why does TRANSACTION / COMMIT improve performance so much with PHP/MySQL (InnoDB)?

I've been working with importing large CSV files of data; usually less than 100,000 records. I'm working with PHP and MySQL (…

php mysql csv transactions innodb

Why does MySQL Innodb "Creating sort index" when unique index exists?

On a simple but very large Innodb table, I have a unique index on column A and I want to …

mysql sql-order-by innodb filesort

MySQL Integer vs DateTime index

Let me start by saying I have looked at many similar questions asked, but all of them relate to Timestamp …

mysql indexing innodb

recover mysql database from ibdata1

I have a client who appears to have lost all of their mysql databases from their local machine. They are …

mysql innodb corruption

xtradb vs innodb

I was asked to check Mariadb as Centos does not provider MySQL 5.5 for the moment. I have read that xtradb …

mysql database innodb mariadb xtradb

Laravel & InnoDB

I am using laravel and laravel migration mechanism. I created tables and seted up foreign keys. But the tables are …

php mysql laravel innodb

MySQL: Column Contains Word From List of Words

I have a list of words. Lets say they are 'Apple', 'Orange', and 'Pear'. I have rows in the database …

sql mysql innodb

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

I have a large and heavy loaded mysql database which performs quite fast at times, but some times get terribly …

mysql performance replication innodb