FrankWSweet Posted April 23, 2005 Report Share Posted April 23, 2005 Traffic on my discussion group has increased since I installed one year ago. I have moved it to a much faster machine with 2 gig of memory. I am running on W-XP. Now I need to tweak MySQL to have a larger key buffer and allow more max connections. How do I do this? Despite what the console "help" and start.bat say, I can find no file named my.cnf or anything similar anywhere on the machine. The only thing that looks plausible is a file named my-small inside W:\usr\local\mysql\bin, but this file claims to be a speed-dialer (whatever that is). And, as far as I can tell, my phpMyAdmin 2.6.0-beta2 lets me look at the parameters but does not let me change them. Surely, there must be a way to tweak this thing. Frank W. Sweet Quote Link to comment Share on other sites More sharing options...
Kevin Posted April 24, 2005 Report Share Posted April 24, 2005 mysql.exe set global max_connections=xxx; or open /etc/my.cfnchange max_connections Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted April 24, 2005 Report Share Posted April 24, 2005 That is for all u die hard command line programmers. Frank, the my-small.cnf file is the MySQL file. Windows named it a speed dialer because of the extension but that does not mean anything. You have to open it with notepad or wordpad and from there you can edit the file. Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
FrankWSweet Posted April 24, 2005 Author Report Share Posted April 24, 2005 Frank, the my-small.cnf file is the MySQL file. Windows named it a speed dialer because of the extension but that does not mean anything. You have to open it with notepad or wordpad and from there you can edit the file.Amazing! That was very well hidden indeed. Thank you. Frank W. Sweethttp://backintyme.com/publishing.htm Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.