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]
