MySQL error

[InoculateIT]

I have been looking for a solution how to stop this error:
Changed limits: max_open_files: 2048 max_connections: 800 table_cache: 619


But not matter what I do, it won't stop.

I tried to change my.ini to higher and lower, but same message come after each reboot.
Its like its ignoring my changes i made.

Any solution?

 

[RSchwarz]

Do you have 2 instances of myql installed?

If not you could be hitting the hard limit for open files in windows 2008 which is 2048. Maybe you have no file descriptors left. Do you have anything running that would use up all those rsources?

 

[InoculateIT]

No just one.

I got a playsite running with 8000+ flashfiles, forums ect...

I can only read solution to wait for MySQL 6, that can't be true.

 

[InoculateIT]

No response...?

 

[RSchwarz]

If you are hitting the 2048 file limit there is isn't much you could do.

 

[susanspy]

hello all,

i am trying to install mysql on my pc but i got some error. i dont know what happended? so could any one suggest how do install mysql on my pc and getting the solve my problem.

thanks in advance


cheers!!!!!!!!!!

 

[RSchwarz]

hello all,

i am trying to install mysql on my pc but i got some error. i dont know what happended? so could any one suggest how do install mysql on my pc and getting the solve my problem.

thanks in advance


cheers!!!!!!!!!!

See this article I wrote. It is for Windows 2003, but, it the same way you install mysql on Windows 2008.

Windows: Installing MYSQL | Admin Reports