visitor (0 QPoints)
  • FR
  • EN
  • NL
  • DE
  • ES
315 experts, 1193 registered users, 1659 questions already answered
European Experts Exchange, the very best site for high-quality IT solutions

New Improved Search!

 


05/10/2011 1h30 : Steve Jobs is dead, the father of Apple ][ is gone, we are all orphaned.

Databases :: MySql :: mysqladmin create my.ini
By: Nono Great Britain  Date: 14/06/2007 14:08:13  English  Points: 20 Status: Answered
Quality : Excellent
how to create my.ini so that mysqladmin is happy with it ? what are the necessary items therein ?
By: VGR Date: 14/06/2007 14:35:42 English  Type : Answer
AFAIK, there are no required item in this file. You should use it either to change default values for some options, or to ensure the proper values are used - in case some options change their default values between versions, as occured more than once already -

It's particularly in this second case that I find my.ini (or my.cnf) to be handy, but the current 5.1+ version of MySqld forced me to change ***a lot of*** default settings to spare the memory of my server.

Here's IMHO the basic set you "need" (this is a 2GB RAM/1TB Disk Win2K server) :

[client] port=3306 [mysql] default-character-set=latin1 [mysqld] port=3306 basedir="X:/MySQL/" datadir="X:/datadir/" default-character-set=latin1 default-storage-engine=MyISAM max_connections=100 query_cache_size=16M table_cache=256 #VGR ADDed from my-large.ini # ? skip-locking max_allowed_packet = 1M sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 2 #EoAdd tmp_table_size=103M thread_cache_size=8 #*** MyISAM Specific options #VGR14012007 MOD from 100G to 2G myisam_max_sort_file_size=2G #VGR14012007 MOD from 100G to 2G myisam_max_extra_sort_file_size=2G #VGR14012007 MOD from 205M to 64M (as in my-large.ini...) myisam_sort_buffer_size=64M #VGR14012007 MOD from 157M to 16M key_buffer = 16M key_buffer_size=16M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer_size=256K #VGR14012007 MOD uncommented to save memory & disk and speedup startup skip-innodb #VGR03042007 ADDed log-slow-queries long-query-time = 1 log-queries-not-using-indexes #EoAdd #VGR14012007 ADDed from my-large.ini [mysqldump] quick max_allowed_packet = 16M



there are other sections that you ma find useful, have a look depending on your needs :
[isamchk]
[myisamchk]
[mysqlhotcopy]

regards
By: OpConsole Date: 01/11/2007 16:14:36 English  Type : Comment
Dear,

If you found some of the above comments to have proved helpful in solving your issue, you shall Accept the Answer or sPlit points between the various useful comments. Each one can receive a quality evaluation from + (somewhat helpful) to +++ (working solution).

Given this Question has been Open for quite a while now, please accordingly "accept an Answer" ASAP

This Question will be randomely force-closed in one month from now.

Thanks and regards.

Admin.

Do register to be able to answer

©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page! Post to Twitter Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to Facebook Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

EContact
browser fav
page generated in 292.694810 milliseconds

Why Google AdSense ads ?
compteur
 Ranking-Hits PageRank for this page