Archive: innodb

Posts Tagged ‘innodb’

Failing to Create Foreign Keys (errno 150) + Solution

October 19, 2010 No Comments

If you are struggling to get some foreign keys set up on your MySQL InnoDB database then perhaps this is your problem and a pretty simple solution. If you are getting errno 150 then take a look at the data types for the two fields that you are trying to relate to each other. I [...]

mysql, By: admin
Tags: errno 150, foreign keys, innodb, magento, mysql

Slow Truncating InnoDB Tables that have Foreign Keys set on them

August 10, 2010 No Comments

One of the advantages of using InnoDB as your storage engine in MySQL is that you can create a database structure that will automatically keep itself clean and tidy, by having deletes cascade through your tables as soon as you delete the main entity. However, if you need to empty a large table, you will [...]

mysql, By: admin
Tags: foreign keys, innodb, mysql, speed, truncate

Categories:

Archive by date:

Got any questions?

Send us a message or call us on 0844 357 0201

Edmonds Commerce offers professional PHP development by Zend Certified PHP developers. We are based in Leeds in West Yorkshire, easily accessible via the M1, national express rail, Leeds Bradford airport or any other transport you can think of. we are located right in the heart of the UK and can offer our services to any UK business looking for ecommerce, magento, oscommerce or PHP development work.