[FreeBSD]

ERROR 1206 : The total number of locks exceeds the lock table size

как избавиться от такой ошибки...? может можно сделать количество запросов чтоб не превышало..?

Вот на этих запросах выдает:

DELETE `character_account_data`.* 
     FROM `character_account_data` 
         LEFT JOIN `characters` 
         ON `character_account_data`.`guid` = `characters`.`guid` 
     WHERE `characters`.`guid` IS NULL;

DELETE `character_achievement`.* 
     FROM `character_achievement` 
        LEFT JOIN `characters` 
        ON `character_achievement`.`guid` = `characters`.`guid` 
     WHERE `characters`.`guid` IS NULL;