Anticlue

MySQL DB Properties

Recently, I have been examining the dbms of MySQL. A couple of items of note have arise when using MySQL with a web application.

First, MySQL utilizes table locking strategy instead of row level locks. This aspect causes an issue when you have several people entering data in a web application. DeadLocks will occur, so be careful in utilizing this choice.

Second, MySQL has no views, stored procedures, or triggers. All queries must be manually coded within the application.