Category : mysql
Repair check and optimize every table in all databases
Posted on 2009-06-17 by JamesWhen updating and deleting rows from tables and databases you may encounter problems with your MySQL speed.
To solve this problem we can run a very simple command.
This solution also works when you come across the SQL error is marked as crashed and should be repaired.
read full article
ON DUPLICATE KEY UPDATE
Posted on 2010-05-09 by JamesSometimes it's not known if the record you are about to insert into MySQL exists or not. You can catch this possible event by using ON DUPLICATE KEY.
read full article