Weird, inconsistent problems with MySQL 5.0.33

[IMNOboist]

I'm running MySQL 5.0.33 on OpenBSD 4.1 x64. I've been having some weird problems that I can't seem to find anything consistent about. First and foremost, it locks up occasionally, especially when a lot of people are using it. Second, I'm trying to create a database using an SQL script file, and it will create the database and the first few tables, but that's it. Then it fails saying: "ERROR 1005 (HY000) at line 109: Can't create table 'table_name' (errno: 9)"

 

I'm wondering if there's a known problem with this version of MySQL or with this version on OpenBSD or on 64-bit OSes.

 

Any ideas? I'd be happy to supply any information that would help.

[IMNOboist]

Trouble-shooting steps I've already taken:

    -Moved database store (/var/mysql) to a different hard drive

    -Did repair on all tables in all databases

    -Triple-checked permissions

[fenway]

I'm running MySQL 5.0.33 on OpenBSD 4.1 x64. I've been having some weird problems that I can't seem to find anything consistent about. First and foremost, it locks up occasionally, especially when a lot of people are using it. Second, I'm trying to create a database using an SQL script file, and it will create the database and the first few tables, but that's it. Then it fails saying: "ERROR 1005 (HY000) at line 109: Can't create table 'table_name' (errno: 9)"

 

I'm wondering if there's a known problem with this version of MySQL or with this version on OpenBSD or on 64-bit OSes.

 

Any ideas? I'd be happy to supply any information that would help.

Well, error 1005 is a file permission issue... as for the sluggishness, check the slow query log.