I have a Datebase with 10MB size . The Tables' engines were MyISAM (table-lock level). So I deiced to change them to InnoDB (row-lock level). I used the sql query for each table :
ALTER TABLE t ENGINE = INNODB;
After that the type column in PHPMyAdmin is showing InnoDB.
After this I found that my table is still using table-lock level because when I have two queries:
INSERT OR UPDATE (which should use row-lock) and after them a
SELECT. All the select queries stop until the users finishes their
- I did not restart MySQL service after changing the engines .
- MySQl version 5.1.72-cll
- The default engine of my database is still MyISAM
what I want to Know is : Should I change any system variables in MySQL when I move to InnoDB?