Marek, check this URL http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
Best regards, Mikhail. ----- Original Message ----- From: "Marek Wysmulek" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 6:56 PM Subject: efficiency of mysql 2.23 > 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 > --------------------------------------------------------------------- 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