Hi Abdul, As I only use MyISAM, I can only reinforce Keith Roberts mentioned, these are three separate instances and will require three separate memory spaces.
Have you looked here? http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html and http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html I could also recommend the book by Jeremy Zawodny, High Performance MySQL. This has a fair bit of information which would be helpful to you. Chapter 6, Server Tuning, is on the mysql website here http://dev.mysql.com/books/hpmysql-excerpts/ch06.html Sorry, that is about all the help I can be as I am no InnoDB expert. Regards --------------------------------------------------------------- ********** _/ ********** David Logan ******* _/ ******* ITO Delivery Specialist - Database ***** _/ ***** Hewlett-Packard Australia Ltd **** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED] **** _/ _/ _/ _/ **** Desk: +618 8408 4273 **** _/ _/ _/_/_/ **** Mobile: 0417 268 665 ***** _/ ****** ****** _/ ******** Postal: 148 Frome Street, ******** _/ ********** Adelaide SA 5001 Australia i n v e n t --------------------------------------------------------------- -----Original Message----- From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED] Sent: Monday, 17 April 2006 12:35 PM To: Logan, David (SST - Adelaide) Cc: mysql@lists.mysql.com; [EMAIL PROTECTED] Subject: RE: ~ How to install 3 instances of mysql~ Hi Logan, Thanks for the links. But how am i suppose to allocate my physical memory for the 3 mysql instances. Pls guide me on the innodb memory settings. My total RAM memory is 1 GB. Thanks in advance, Abdul. On Sat, 2006-04-15 at 23:35 +1000, Logan, David (SST - Adelaide) wrote: > Hi, > > Also a read of > http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html and > http://dev.mysql.com/doc/refman/5.0/en/mysqld-multi.html would probably > be quite helpful. The second gives you a good idea on how to setup the > my.cnf file for multiple servers. The concepts are the same for version > 4.1 > > Regards > > --------------------------------------------------------------- > ********** _/ ********** David Logan > ******* _/ ******* ITO Delivery Specialist - Database > ***** _/ ***** Hewlett-Packard Australia Ltd > **** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED] > **** _/ _/ _/ _/ **** Desk: +618 8408 4273 > **** _/ _/ _/_/_/ **** Mobile: 0417 268 665 > ***** _/ ****** > ****** _/ ******** Postal: 148 Frome Street, > ******** _/ ********** Adelaide SA 5001 > Australia > i n v e n t > --------------------------------------------------------------- > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Saturday, 15 April 2006 10:45 PM > To: mysql@lists.mysql.com > Subject: Re: ~ How to install 3 instances of mysql~ > > On Sat, 15 Apr 2006, Mohammed Abdul Azeem wrote: > > > To: [EMAIL PROTECTED] > > From: Mohammed Abdul Azeem <[EMAIL PROTECTED]> > > Subject: Re: ~ How to install 3 instances of mysql~ > > > > Hello Keith, > > > > Thank you very much for your guidence. > > > > This is my existing my.cnf file > > > > > > [mysqld] > > port = 3306 > > socket = /tmp/mysql.sock > > skip-locking > > key_buffer = 384M > > max_allowed_packet = 1M > > table_cache = 512 > > sort_buffer_size = 2M > > read_buffer_size = 2M > > read_rnd_buffer_size = 8M > > thread_cache = 8 > > query_cache_size = 32M > > log_bin_trust_routine_creators = 1 > > # Try number of CPU's*2 for thread_concurrency > > thread_concurrency = 8 > > #specify the storage engine > > default-storage-engine = InnoDB > > #specify the table type > > default-table-type = InnoDB > > #enable the full query log > > log > > #Print warnings to error log file > > log_warnings > > #specify max connections > > max_connections = 30 > > #specify max user connections > > max_user_connections = 12 > > # Uncomment the following if you are using InnoDB tables > > innodb_data_home_dir = /mysql-system/mysql/data/ > > innodb_data_file_path = ibdata1:10M:autoextend > > innodb_log_group_home_dir = /mysql-system/mysql/data/ > > innodb_log_arch_dir = /mysql-system/mysql/data/ > > # You can set .._buffer_pool_size up to 50 - 80 % > > # of RAM but beware of setting memory usage too high > > innodb_buffer_pool_size = 384M > > innodb_additional_mem_pool_size = 20M > > # Set .._log_file_size to 25 % of buffer pool size > > innodb_log_file_size = 5242880 > > innodb_log_buffer_size = 8M > > innodb_flush_log_at_trx_commit = 1 > > innodb_lock_wait_timeout = 100 > > > > The variables key_buffer = 384M, innodb_buffer_pool_size = 384M, > > innodb_additional_mem_pool_size = 20M, innodb_log_buffer_size = 8M > > > > are set for 1 instance. > > > > My RAM memory is 1GB. Can i have the same values for the above > variables > > set for all the 3 instances ? if yes, will that not exceed the > available > > RAM memory. Please help me set the correct values for these variables > > for each instance. > > Well, if you are running multiple instances of mysqld > concurrently, then I guess you will have to share the system > resorces as well, such as memory and file handles. > > Note that if you are using qps to monitor processes, for > each mysqld you have running, the memory usage will increase > appropriately. > > I only use MyISAM tables the moment, so I cannot help you > with your InnoDB table settings. > > Kind Regards > > Keith Roberts > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > ________________________________________ > This email has been Scanned for Viruses! > www.newbreak.com > ________________________________________ This email has been Scanned for Viruses! www.newbreak.com ======================================== -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]