Dear group. I have on server Intel Pentium IV 1,8 GHz, 1GB RAM.
I would like to set some efficiency settings into my my_multi.conf of mysql .3.23 BUT although I read docs (unclear for me ;-)) I don't know how to set proper values and where to set ones. Problem is that servers stops answering for ~2 or 3 seconds when a lot of users are connected. Stop answering - I mean that ex. when I'm working on console (doing another then selecting activity) ex. during opening config file server show me ingredience after 2 or 3 seconds. I don't tell about working on end user application because from "consum of time during makeing selects" point of view delays are not objective. OK. Let say there is such section It is common section. #[mysqld] #port = 3306 #socket = /tmp/mysql.sock #skip-locking #set-variable = key_buffer=16K #set-variable = max_allowed_packet=1M #set-variable = thread_stack=64K #set-variable = table_cache=4 #set-variable = sort_buffer=64K set-variable = net_buffer_length=2K #server-id = 1 It is commented because the final are like for "0" server [mysqld0] socket = /tmp/mysql.sock.0 port = 3306 pid-file = /usr/local/mysql/var2/hostname.pid.0 3datadir = /mnt/mysql language = /usr/local/mysql/share/mysql/english but nowhere was written if any efficency variables can be puted into. Please show me UNDERSTENDABLE information for meaning of those variables OR just tell me what values should be puted into config file to satisfy users regarding ability of my server machine. Another question is that whether storing on fisical the same drive system and mysql data base datas have influence on efficiency ? I can try if I will separate it and system will start from hda and datas will be stored on hdb for ex. would incease flexibility of data flow. --------------------------- Marek Wysmułek --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
