Top "Innodb" questions

When exactly MySQL locks a row on updating InnoDB table?

If I have this multiupdate query UPDATE user u INNER JOIN user_profile up ON up.user_id = u.id …

mysql locking innodb rowlocking

What's the safest way to convert table with InnoDB to MyISAM?

My database is currently using the InnoDB engine. Now I want to add the fulltext search feature, which is why …

mysql innodb myisam

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

I have read several times that after you delete a row in an InnoDB table in MySQL, its space is …

mysql database size innodb rows

MySQL Memory Engine vs InnoDB on RAMdisk

I'm writing a bit of software that needs to flatten data from a hierarchical type of format into tabular format. …

mysql performance memory innodb ramdisk

Deadlock issue when transaction tries to accuire a lock it's already holding

I've found a very confusing deadlock situation that I need help to understand. There are two transactions going on: (2) holds …

mysql transactions innodb deadlock

Why would innoDB lock tables

I'm using innoDB on AWS. I keep getting a ton of the following messages in my logs: Waiting for table …

mysql innodb table-locking database-engine

When MyISAM is better than InnoDB?

Sometimes I got asked on some interviews: what benefits does InnoDB have against MyISAM and when MyISAM is better than …

mysql innodb myisam

How to properly handle InnoDB deadlocks in Java/JDBC?

I am working on a theory basis here, I want to make sure all my bases are covered. I have …

java mysql innodb deadlock database-deadlocks

Trying to add foreign key in mysql with heidisql

I've been trying to add a foreign key to my table using heidisql and I keep getting the error 1452. After …

foreign-keys innodb mysql-error-1452 heidisql

MySQL transaction journaling

I am working on a project for which we are required to use "transaction journaling" in our DBMS (MySQL). We …

mysql transactions innodb journaling