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]
