MySql: MyISAM vs. Inno DB! [closed]

The main difference is that InnoDB supports transactions while MyISAM does not. There are numerous other differences, however the common one’s i am aware of are: MyISAM has typically been considered faster at searching, but recent InnoDB improvements are removing this difference and improving high concurrency workload performance InnoDB support transactions whilst MyISAM does not …

Read more

Changing Table Engine in MySQL

From the manual: http://dev.mysql.com/doc/refman/5.1/en/alter-table.html For example, to convert a table to be an InnoDB table, use this statement: ALTER TABLE t1 ENGINE = InnoDB; The outcome of attempting to change a table’s storage engine is affected by whether the desired storage engine is available and the setting of the NO_ENGINE_SUBSTITUTION SQL mode, as described in …

Read more

How to test an SQL Update statement before running it?

What about Transactions? They have the ROLLBACK-Feature. @see https://dev.mysql.com/doc/refman/5.0/en/commit.html For example: START TRANSACTION; SELECT * FROM nicetable WHERE somthing=1; UPDATE nicetable SET nicefield=’VALUE’ WHERE somthing=1; SELECT * FROM nicetable WHERE somthing=1; #check COMMIT; # or if you want to reset changes ROLLBACK; SELECT * FROM nicetable WHERE somthing=1; #should be the old value Answer on …

Read more