looks like your mn.cnf has this commented #set default_storage_engine=InnoDB
Can u please uncomment it, if u want INNODB as ur default storage engine. On 5/6/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > Hi all, > > I have change the data directory from /var/lib/mysql to /data/mysql > directory and adding innodb_file_per_table. By doing this innodb storage > engine get dissabled. my.cnf doesn't contains "#skip-innodb". Is it's > adding > will enable or not > > HOW CAN I ENABLE INNODB > > mysql> show engines; > > +------------+----------+----------------------------------------------------------------+ > | Engine | Support | > Comment | > > +------------+----------+----------------------------------------------------------------+ > | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great > performance | > | MEMORY | YES | Hash based, stored in memory, useful for > temporary > tables | > | InnoDB | DISABLED | Supports transactions, row-level locking, and > foreign keys | > | BerkeleyDB | NO | Supports transactions and page-level > locking | > | BLACKHOLE | NO | /dev/null storage engine (anything you write to > it > disappears) | > | EXAMPLE | NO | Example storage > engine | > | ARCHIVE | YES | Archive storage > engine | > | CSV | YES | CSV storage > engine | > | ndbcluster | DISABLED | Clustered, fault-tolerant, memory-based > tables | > | FEDERATED | YES | Federated MySQL storage > engine | > | MRG_MYISAM | YES | Collection of identical MyISAM > tables | > | ISAM | NO | Obsolete storage > engine | > > +------------+----------+----------------------------------------------------------------+ > 12 rows in set (0.00 sec) > > > # /etc/mysql/my.cnf: The global mysql configuration file. > # $Header: /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-4.1-r1,v 1.3 > 2006/02/01 20:25:56 vivo Exp $ > # > # $Revision:$ > # $Id:$ > > # The following options will be passed to all MySQL clients > [client] > #password = > port = 3306 > socket = > /var/run/mysqld/mysqld.sock > > [mysql] > character-sets-dir=utf8 > default-character-set=utf8 > > [mysqladmin] > character-sets-dir=utf8 > default-character-set=utf8 > > [mysqlcheck] > character-sets-dir=utf8 > default-character-set=utf8 > > [mysqldump] > character-sets-dir=utf8 > default-character-set=utf8 > > [mysqlimport] > character-sets-dir=utf8 > default-character-set=utf8 > > [mysqlshow] > character-sets-dir=utf8 > default-character-set=utf8 > > [myisamchk] > character-sets-dir=utf8 > default-character-set=utf8 > > [myisampack] > character-sets-dir=utf8 > > > # use [safe_mysqld] with mysql-3 > [mysqld_safe] > err-log = /var/log/mysql/mysql.err > > # add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations. > [mysqld] > old_passwords = false # inserted by debconf > character-set-server = utf8 > default-character-set = utf8 > user = mysql > port = 3306 > socket = /var/run/mysqld/mysqld.sock > pid-file = /var/run/mysqld/mysqld.pid > log-error = /var/log/mysql/mysqld.err > basedir = /usr > #datadir = /var/lib/mysql > skip-locking > #set default_storage_engine=InnoDB > key_buffer = 384M > max_allowed_packet = 16M > table_cache = 1024 > > sort_buffer_size = 9M > > net_buffer_length = 8K > read_buffer_size = 2M > read_rnd_buffer_size = 32M > myisam_sort_buffer_size = 64M > > query_cache_type = 1 > query_cache_size = 100M > > language = /usr/share/mysql/english > > set-variable = max_connections=1024 > > # Begin replication section > log-bin=/var/db/db05-master-bin.log > server-id=5 > > # End replication section > > #security: > #using "localhost" in connects use sockets by default > #skip-networking > #bind-address = 127.0.0.1 > > # Point the following paths to different dedicated disks > tmpdir = /tmp/ > #log-update = /path-to-dedicated-directory/hostname > > # you need debug use flag enabled to use this ones. > # if needed uncomment them, start the server and issue > # #tail -f /tmp/mysqld.sql /tmp/mysqld.trace > # this will show you *exactly* what's appening in your server ;) > > #log = /tmp/mysqld.sql > #gdb > #debug = d:t:i:o,/tmp/mysqld.trace > #one-thread > > # Uncomment the following if you are using BDB tables > #bdb_cache_size = 4M > #bdb_max_lock = 10000 > > # The following is the InnoDB configuration > # > # the rest of the innodb config follows: > # don't eat too much memory, we're trying to be safe on 64Mb boxes. > # you might want to bump this up a bit on boxes with more RAM > innodb_buffer_pool_size = 1G > # this is the default, increase if you have lots of tables > innodb_additional_mem_pool_size = 128M > # > # i'd like to use /var/lib/mysql/innodb, but that is seen as a database > :-( > # and upstream wants things to be under /var/lib/mysql/, so that's the > route > # we have to take for the moment > #innodb_data_home_dir = /var/lib/mysql/ > innodb_data_home_dir = /data/mysql/ > innodb_log_arch_dir = /data/mysql/ > innodb_log_group_home_dir = /data/mysql/ > > datadir = /data/mysql/ > #innodb_file_per_table > > # you may wish to change this size to be more suitable for your system > # the max is there to avoid run-away growth on your machine > innodb_data_file_path = ibdata1:10M:autoextend > # we keep this at around 25% of of innodb_buffer_pool_size > # sensible values range from 1MB to > (1/innodb_log_files_in_group*innodb_buffer_pool_size) > innodb_log_file_size = 256M > # this is the default, increase if you have very large transactions. > innodb_log_buffer_size = 256M > # this is the default, and won't hurt you. > # you shouldn't need to tweak it. > set-variable = innodb_log_files_in_group=2 > # see the innodb config docs, the other options are not always safe > innodb_flush_log_at_trx_commit = 1 > innodb_lock_wait_timeout = 50 > > > [mysqldump] > quick > max_allowed_packet = 16M > > [mysql] > # Remove the next comment character if you are not familiar with SQL > #safe-updates > > [isamchk] > key_buffer = 20M > sort_buffer_size = 20M > read_buffer = 2M > write_buffer = 2M > > [myisamchk] > key_buffer = 20M > sort_buffer_size = 20M > read_buffer = 2M > write_buffer = 2M > > [mysqlhotcopy] > interactive-timeout > > #vim: set tabstop=4 : > #vim: set shiftwidth=4 : > > > Krishna Chandra Prajapati >
