Windows 2003, MySQL 5.0.24, Windows Updates causes problems with MySQL?

Question

our Windows 2003 webserver has 2 GB of ram and MySQL v. 5.0.24-community-nt. Maybe due to Windows Updates (is it possible??) I've problems with MySQL databases. I should restart everyday IIS services.

Events: "Changed limits: max_open_files: 2048 max_connections: 800 table_cache: 619" "Do you already have another mysqld server running on port: 3306 ?" "Can't connect to MySQL server on 'localhost'" 10055

Should I increase the innodb_buffer_pool_size, from 250M to 500M? Or/and?

Thanks

Answer 1

You should upgrade your MySQL to the latest version (MySQL 5.5.9).

I remember years ago the Windows versions of MySQL having issues with mfc42.dll during the days of MySQL 5.0.33 - 5.0.37. Windows binaries have jumped through many hoops over the years.

If you want to up the innodb_buffer_pool_size to 512M, that's OK. Just remember:

1. net stop mysql
2. set innodb_buffer_pool_size to 512M in my.ini
3. set innodb_log_file_size to 128M in my.ini
4. set max_connections to 500 in my.ini
5. delete ib_logfile0 and ib_logfile1. DO NOT TOUCH ibdata1 !!!!!
6. net start mysql (ib_logfile0 and ib_logfile1 are recreated)

Give it a Try !!!