Jump to content
The Uniform Server Community
Sign in to follow this  
FrankWSweet

How do I change MySQL starup variables?

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...