LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 08-07-2003, 04:01 AM   #1
sylye
Member
 
Registered: Feb 2003
Location: Malaysia
Distribution: Mandrake 9.1, Debian 3.1,Centos 5.x,6.x,Slackware 13.37,14.0,14.1
Posts: 49

Rep: Reputation: 1
Unhappy Isn't InnoDB default in MySQL4.0 from Mandrake9.1?


HI, good day !!

I'm having a Mandrake9.1 here, and have installed the MySQL server bundle together, which is version 4.0.11a-gamma.

I have been using InnoDB in my Mandrake 8 long time ago, and the InnoDB features is enabled by me manually through running the mysqld-max. That was the version of MySQL 3.23.53

But now the Mandrake9.1 has MySQL ver 4 bundled with it which saying ,

"In MySQL-4.0 you are not required to do anything specific to enable InnoDB tables. "

from the MySQL latest manual.

but when I create my InnoDB it seems like it goes back to the normal MYISAM table type, and when I do a SQL queries in my mysql client, "show variables", it shows that the MySQL server attributes of "have_InnoDB" is "NO" !!

SO, guys and gals, have you experiencing this as me ? now I'm not sure whether the mysqld binaries we got from MySQL4 is having InnoDB function or not ? or we'll have to goes back to the mysqld-max ?
 
Old 08-07-2003, 05:13 PM   #2
nakkaya
LQ Guru
 
Registered: Jan 2003
Location: Turkey&USA
Distribution: Emacs and linux is its device driver(Slackware,redhat)
Posts: 1,398

Rep: Reputation: 45
beginning with 4.0 inno db is standart in mysql check you my.conf there are some setup option about it in the conf file
 
Old 08-07-2003, 09:51 PM   #3
sylye
Member
 
Registered: Feb 2003
Location: Malaysia
Distribution: Mandrake 9.1, Debian 3.1,Centos 5.x,6.x,Slackware 13.37,14.0,14.1
Posts: 49

Original Poster
Rep: Reputation: 1
Unhappy

As I said, I've been running InnoDB for quite some time with my version of 3.23.53 of MySQL, everything that should be set has been set in the my.cnf, and I've created the folder "ibdata" and "iblog" in /var/lib/mysql.

Actually I'm not requiring how to set InnoDB in the very first place, what I'm wondering is the phrase stated by MySQL website saying that,
"In MySQL-4.0 you are not required to do anything specific to enable InnoDB tables",
what it means is, I'm not needed to do any modification on my my.cnf to have InnoDB running.

If I did add in the setting into my.cnf I used to have with my 3.23.53 version into my current 4.0.11a-gamma, the server will have this error, "unknown variable 'innodb_data_home_dir=/var/lib/mysql/", this giving sense saying the server daemon is not recognizing what is InnoDB in the very first place !!

Here is the my.cnf:

"
[mysqld]
skip-locking
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M

innodb_data_home_dir = /var/lib/mysql
innodb_data_file_path = /var/lib/mysql/ibdata/ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/iblog
innodb_log_arch_dir = /var/lib/mysql/iblog

set-variable = innodb_buffer_pool_size=16M
set-variable = innodb_additional_mem_pool_size=2M
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=8M
set-variable = innodb_file_io_threads=4
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[mysqlhotcopy]
interactive-timeout
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing MySQL4.1 and Installing MySQL4.0.* critical Linux - Software 2 08-04-2005 10:26 PM
innodb engine varun_33 Linux - General 0 05-16-2005 05:45 AM
MySQL Innodb troubles Baltasar Linux - Software 1 04-20-2005 09:01 AM
MySQL & InnoDB riluve Linux - Software 0 03-13-2005 09:19 PM
InnoDB problem with MySQL jerry_redhat Linux - Software 2 07-09-2003 12:20 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 08:14 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration