Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySQL Table Limit

Status
Not open for further replies.

sOlsTiCezA

Programmer
Mar 20, 2002
17
ZA
Hi

MySQL states that there is no limit on the number of tables that can be created, but the problem I have is that when I reach +- 7500 tables, I receive an error stating 'Cant create/write to file .\DbName\TableName.myi Error 13' ( 13 = Permission Denied ) If I drop 'n' tables, then I can create 'n' tables, but no more than that, which suggests a limit. I have tried changing tuning parameters, but this is to no avail. Has anyone else experienced this problem/ know a solution.

Thanks
 
True, mysql does not mind itself, but the OS may and in general does. What Operating system are you using?
(If you are using Windows, I have no idea how to proceed.
I should add that I have a database with some 63000 tables
under linux. If you are using Unix/linux, check ulimit and the filedescriptors)

Good luck,
svar
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top