Top "Innodb" questions

I want to use foreign keys to keep the integrity and avoid orphans (I already use innoDB). How do I …

I get this error message: ERROR 1217 (23000) at line 40: Cannot delete or update a parent row: a foreign key constraint fails ... …

I'm trying to add a row to an InnoDB table with a simply query: INSERT INTO zip_codes (zip_code, …

I have a simple task where I need to search a record starting with string characters and a single digit …

I was using mysqldump to export the database, like this: mysqldump -u root -ppassword my_database > c:\temp\my_…

We (apparently) had poorly executed of our Solaris MySQL database engine last night. At least some of the InnoDB tables …

Is it possible to clean a mysql innodb storage engine so it is not storing data from deleted tables? Or …

I am trying to increase the size of the innodb_buffer_pool_size in MySQL 5.1 as I keep running into …

I have one MySQL table using the InnoDB storage engine; it contains about 2M data rows. When I deleted data …

I have experience with MS SQL server where it is possible and useful to update statistic and rebuild indexes. I …