[Solved]Locked table in MySQL
InnoDB Supports transactions, row-level locking, and foreign keys MyISAM Default engine as of MySQL 3.23 with great performance
myisam
MYSQL PERFORMANCE TUNING PRIMER and MySQLTuner 1.1.1
[root@server src]# ./tuning-primer.sh — MYSQL PERFORMANCE TUNING PRIMER — – By: Matthew Montgomery – MySQL Version 5.0.88-community-log i686 Uptime = 22 days 18 hrs 12 min 36 sec Avg. qps = 14 Total Questions = 28279137 Threads Connected = 4