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

You can set the skip-innodb option in my.cnf

-Eric

On Tue, Apr 1, 2008 at 9:28 PM, Ananda Kumar <anandkl@gmail.com> wrote:
> 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
>



--
high performance mysql consulting.
http://provenscaling.com

Hi,
Enter in my.cnf file
[mysqld]
skip-bdb
skip-innodb

Regards
Rakesh

-----Original Message-----
From: Ananda Kumar [mailto:anandkl@gmail.com]
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 tothis message are intended for the exclusive use of the addressee(s) and maycontain proprietary, confidential or privileged information. If you are notthe intended recipient, you should not disseminate, distribute or copy thise-mail. Please notify the sender immediately and destroy all copies of thismessage and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient shouldcheck 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

Hi All,
Thanks a lot for you reply. Will do this setup.

regards
anandkl


On 4/2/08, rakesh.gupta1@wipro.com <rakesh.gupta1@wipro.com> wrote:
>
> Hi,
> Enter in my.cnf file
> [mysqld]
> skip-bdb
> skip-innodb
>
> Regards
> Rakesh
>
> -----Original Message-----
> From: Ananda Kumar [mailto:anandkl@gmail.com]
> 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
>
>

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.



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 <anandkl@gmail.com> wrote:
>
> Hi All,
> Thanks a lot for you reply. Will do this setup.
>
> regards
> anandkl
>
>
> On 4/2/08, rakesh.gupta1@wipro.com <rakesh.gupta1@wipro.com> wrote:
> >
> > Hi,
> > Enter in my.cnf file
> > [mysqld]
> > skip-bdb
> > skip-innodb
> >
> > Regards
> > Rakesh
> >
> > -----Original Message-----
> > From: Ananda Kumar [mailto:anandkl@gmail.com]
> > 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
> >
> >
>

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 <anandkl@gmail.com> wrote:
>
>> Hi All,
>> Thanks a lot for you reply. Will do this setup.
>>
>> regards
>> anandkl
>>
>>
>> On 4/2/08, rakesh.gupta1@wipro.com <rakesh.gupta1@wipro.com> wrote:
>>
>>> Hi,
>>> Enter in my.cnf file
>>> [mysqld]
>>> skip-bdb
>>> skip-innodb
>>>
>>> Regards
>>> Rakesh
>>>
>>> -----Original Message-----
>>> From: Ananda Kumar [mailto:anandkl@gmail.com]
>>> 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
>>>
>>>
>>>
>
>

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 <ml@kiewel-online.de> 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 <anandkl@gmail.com> wrote:
> >
> >
> > > Hi All,
> > > Thanks a lot for you reply. Will do this setup.
> > >
> > > regards
> > > anandkl
> > >
> > >
> > > On 4/2/08, rakesh.gupta1@wipro.com <rakesh.gupta1@wipro.com> wrote:
> > >
> > >
> > > > Hi,
> > > > Enter in my.cnf file
> > > > [mysqld]
> > > > skip-bdb
> > > > skip-innodb
> > > >
> > > > Regards
> > > > Rakesh
> > > >
> > > > -----Original Message-----
> > > > From: Ananda Kumar [mailto:anandkl@gmail.com]
> > > > 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/mysql?unsub=anandkl@gmail.com
>
>