you mean to day, i install mysql using source. But i have installed using binary, is there any way i can do it .
regards anandkl On 4/3/08, Uwe Kiewel <[EMAIL PROTECTED]> wrote: > > Ananda Kumar schrieb: > > > Hi All, > > i set the skip-innodb in my.cnf, but when i do the below, it still > > shows > > some default values assigned to innodb parameters, can i avoid this as > > there > > is some amount of memory allocated to innodb, and i dont what that. I > > want > > all resource to allocated to only myisam. Please let me know how i can > > achive this. > > > > > > > > > maybe compile mysql without innodb support > > > > > > > mysql> show variables like '%innodb%'; > > +---------------------------------+----------+ > > | Variable_name | Value | > > +---------------------------------+----------+ > > | have_innodb | DISABLED | > > | innodb_additional_mem_pool_size | 1048576 | > > | innodb_autoextend_increment | 8 | > > | innodb_buffer_pool_awe_mem_mb | 0 | > > | innodb_buffer_pool_size | 8388608 | > > | innodb_checksums | ON | > > | innodb_commit_concurrency | 0 | > > | innodb_concurrency_tickets | 500 | > > | innodb_data_file_path | | > > | innodb_data_home_dir | | > > | innodb_doublewrite | ON | > > | innodb_fast_shutdown | 1 | > > | innodb_file_io_threads | 4 | > > | innodb_file_per_table | OFF | > > | innodb_flush_log_at_trx_commit | 1 | > > | innodb_flush_method | | > > | innodb_force_recovery | 0 | > > | innodb_lock_wait_timeout | 50 | > > | innodb_locks_unsafe_for_binlog | OFF | > > | innodb_log_arch_dir | | > > | innodb_log_archive | OFF | > > | innodb_log_buffer_size | 1048576 | > > | innodb_log_file_size | 5242880 | > > | innodb_log_files_in_group | 2 | > > | innodb_log_group_home_dir | | > > | innodb_max_dirty_pages_pct | 90 | > > | innodb_max_purge_lag | 0 | > > | innodb_mirrored_log_groups | 1 | > > | innodb_open_files | 300 | > > | innodb_rollback_on_timeout | OFF | > > | innodb_support_xa | ON | > > | innodb_sync_spin_loops | 20 | > > | innodb_table_locks | ON | > > | innodb_thread_concurrency | 8 | > > | innodb_thread_sleep_delay | 10000 | > > +---------------------------------+----------+ > > > > > > > > > > > > > > > > On 4/2/08, Ananda Kumar <[EMAIL PROTECTED]> wrote: > > > > > > > Hi All, > > > Thanks a lot for you reply. Will do this setup. > > > > > > regards > > > anandkl > > > > > > > > > On 4/2/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > > > > > > > Hi, > > > > Enter in my.cnf file > > > > [mysqld] > > > > skip-bdb > > > > skip-innodb > > > > > > > > Regards > > > > Rakesh > > > > > > > > -----Original Message----- > > > > From: Ananda Kumar [mailto:[EMAIL PROTECTED] > > > > Sent: Wednesday, April 02, 2008 9:59 AM > > > > To: MySql > > > > Subject: only myisam storage engine > > > > > > > > Hi All, > > > > We have a linux box running debain, with 8 cpu and 8 GB RAM, we want > > > > only myisam engine to be running on this. > > > > > > > > So, should i not setup any innodb parameters or is there any other > > > > way > > > > to have only myisam engine running on this machine, please let me > > > > know. > > > > > > > > regards > > > > anandkl > > > > > > > > The information contained in this electronic message and any > > > > attachments > > > > to this message are intended for the exclusive use of the > > > > addressee(s) and > > > > may contain proprietary, confidential or privileged information. If > > > > you are > > > > not the intended recipient, you should not disseminate, distribute > > > > or copy > > > > this e-mail. Please notify the sender immediately and destroy all > > > > copies of > > > > this message and any attachments. > > > > > > > > WARNING: Computer viruses can be transmitted via email. The > > > > recipient > > > > should check this email and any attachments for the presence of > > > > viruses. The > > > > company accepts no liability for any damage caused by any virus > > > > transmitted > > > > by this email. > > > > > > > > www.wipro.com > > > > > > > > > > > > > > > > > > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
