On 9/10/2012 9:55 AM, Garot Conklin wrote:
> Not to beat the perms to death but /tmp should have the sticky bit set as well... so
> 1777 not just 0777. Perhaps hard kill any lingering mysql PIDS unless this is production
> and u expect other DB's to be running... if u have duplicated this DB schema somewhow by
> mistake and a second or first identical instance is running it is plausable to assume that
> the other running instance has locked the file it is using preventing it from being
> written to.
Excellent point! Yes, you can have multiple MySQL instances running on
the same host machine but they cannot share the same --tmpdir location.
Name collisions can and do occur between them if they attempt to share a
common folder. Verify that you have properly isolated each instance from
every other by following these guidelines:
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN