MySQL 5.1 + InnoDB

[sevmax]

Hello, dear community.

I installed MySQL 5.1 64-bit from official RPMs at CentOS 5.2.
If uncomment "use innodb" in config file and run "show engines" inside mysql it show me that innodb available but isn't using. What should I do to run InnoDB at mysql 5.1?

one more question: for 5.0 I start mysql with command "service mysqld start", for 5.1 I can do it with "service mysql start". Can anybody explain why?

Regards,
Max

Not a Fedora question, moved to Linux Chat. CentOS has its own forum here:

http://www.centos.org/modules/newbb/

Wayne

[notageek]

Hi

Step 1:
Edit /etc/my.cnf and add the following:

default-storage-engine=innodb

Step 2:

# service mysqld restart

Step 3:
Voila!

[notageek]

Also there's an alternative to running InnoDB as default, engine can be defined during table creation

create table tablename(
columnname int primary key,
columname2 char(4)
)Engine=InnoDB;

[sevmax]

Thank you for your answers. Now i'm trying to run mysql, it gives me error after I changed my.cnf and tried to restart:

#service mysql start
Starting MySQL.Manager of pid-file quit without updating fi[FAILED]

Can you comment this please.

regards,
Max

[notageek]

I missed the fact that you're running CentOS, therefore I wouldn't know if a service mysql exists.

After editing the /etc/my.cnf the server daemon needs to be restarted and it is mysqld, does CentOS have /etc/init.d/mysql?

[sevmax]

Yes it has.
BTW, thank you for you quick and informative answers

Regards,
Max

[sevmax]

If I comment

default-storage-engine=innodb

, mysql starts well.

[notageek]

Hmm... I'm afraid nuances of CentOS are too great for me, my /etc/my.cnf on Fedora 9 looks like this:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
default-storage-engine=innodb

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

And then restart the mysqld (daemon), I'm not sure what service mysql (/etc/init.d/mysql) in CentOS does.

As I said, CentOS has its own forum. This forum is for FEDORA.

Wayne

[whitingjr]

Originally Posted by sevmax

Thank you for your answers. Now i'm trying to run mysql, it gives me error after I changed my.cnf and tried to restart:



Can you comment this please.

regards,
Max

Try changing the permissions of your directory.

If you have relocated the datadir from the default location then check the permissions of the files and directory. Including the parent directories (which caught me out).

I detected the problem by navigating to the datadir directory as a non-root user. Starting in the root directory then changing one directory at a time.