Jörg, thanks again for your help and your patience with this issue. You
also caught oversights with strace and clarified that this is not a PATH
issue.
I've filed it at:
http://bugs.mysql.com/bug.php?id=53667
You don't state it explicitly, but I take your text to mean
If the MySQL tools are
:
$ /tmp/msource/bin/mysql_install_db --basedir=/tmp/msource
--datadir=/tmp/msource/data
Installing MySQL system tables...
100513 21:53:35 [ERROR] /tmp/msource/libexec/mysqld: unknown option
'--skip-bdb'
100513 21:53:35 [ERROR] Aborting
100513 21:53:35 [Note
21:53:35 [ERROR] /tmp/msource/libexec/mysqld: unknown option
'--skip-bdb'
... even after I manually search for the location where this flag is
passed, and manually edit that source to never issue it.
[[...]]
I am surprised to see that option still occurring in a file in 5.1, that
looks wrong
On Fri, 2010-05-14 at 10:28 +0200, Joerg Bruehe wrote:
The following error just won't go away:
100513 21:53:35 [ERROR] /tmp/msource/libexec/mysqld: unknown option
'--skip-bdb'
... even after I manually search for the location where this flag is
passed, and manually edit that source
Kris wrote:
Hello,
I am trying to produce an automated, reliable, and repeatable way of
testing mysql releases, and I am finding an error that makes this
impossible to accomplish.
I am trying to compile mysql and install it in a non-standard directory.
I do notwant mysql installed in /usr or
Kris, all,
Kris wrote:
On Fri, 2010-05-14 at 10:28 +0200, Joerg Bruehe wrote:
The following error just won't go away:
100513 21:53:35 [ERROR] /tmp/msource/libexec/mysqld: unknown option
'--skip-bdb'
... even after I manually search for the location where this flag is
passed, and manually
, [{WIFEXITED(s) WEXITSTATUS(s) == 0}], 0) = 26000
waitpid(-1, [{WIFEXITED(s) WEXITSTATUS(s) == 0}], 0) = 26002
waitpid(-1, 100514 11:35:18 [ERROR] /tmp/msource/libexec/mysqld: unknown option
'--skip-bdb'
100514 11:35:18 [ERROR] Aborting
100514 11:35:18 [Note] /tmp/msource/libexec/mysqld: Shutdown
Do not install software in /tmp in Linux.
/tmp is not guaranteed to survive a reboot.
Thank you for the heads up. Well... there is *another* bug
where if one specifies in their my.cnf filepaths that are over 100 characters,
the filenames are truncated at 100, hence making it impossible to really
, which is meant
to make it easy to have system-wide settings for multiple instances,
implies that these config files must be compatible with all versions
used on that system - which causes your problem, as the --skip-bdb
option is not compatible with 5.1.
Whether the advantage (system wide settings
Thanks.I know the reason now.:)
On Mon, Jul 21, 2008 at 10:54 PM, Bill Newton [EMAIL PROTECTED]
wrote:
No, its mainly because BDB wasn't very good. Its transactional, but not
MVCC. Take a look at a contemporary article when the acquisition was made :
http://www.computerworld.com
Any reply is appreciated .
--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
On 7/21/08, Moon's Father [EMAIL PROTECTED] wrote:
Any reply is appreciated .
--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
Maybe something to do with this: *BDB support will be removed. * Note that,
as of MySQL 5.1, BDB isn't supported any
Its mainly because it was purchased by Oracle. BDB provided transaction
support. Innodb has been the defacto choice for a ACID transactions,
but Innodb was also purchased by Oracle in its attempt to kill MySQL
after its failed attempt to purchase MySQL. That's why MySQL has been
working
No, its mainly because BDB wasn't very good. Its transactional, but not
MVCC. Take a look at a contemporary article when the acquisition was made :
http://www.computerworld.com/databasetopics/data/software/story/0,10801,108705,00.html
Curtis Maurand wrote:
Its mainly because it was purchased
Hello everyone,
I have a few questions on the use of the BDB engine with MySQL.
If I use the BDB storage engine for a table, is it safe for me to
access the BerkeleyDB file while MySQL may possibly writing to it?
The database commits are nothing more than simple inserts, updates,
and deletes
In a high activity OLTP environment with heavy UPDATE activity, which
table type is better?
I have one table which has many readers a decent amount of UPDATE
activity.
Will BDB or MYIsam result in better performance by how much better (please
quantify?
Bdb tables locks are at page level, how can I determine the number of
pages of my table?
mysql show variables like '%binlog_cache_size%';
+---++
| Variable_name | Value |
+---++
| binlog_cache_size | 32768
Hi, here's my create table:
mysql show create table parametrivaloriplc;
++-+
| Table | Create Table|
++-+
| parametrivaloriplc | CREATE
Maybe i got it! For the chronicle:
I resolved the problem decreasing the max_bdb_lock to the default value
and creating an index on the column used in the where clause of my
query. Probably mysql tried to lock the whole table because the primary
key wasn't in the where clause.
Cheers,
Marco
Hi Marco,
My hint is to read the BDB section of the manual:
http://dev.mysql.com/doc/refman/5.0/en/bdb-start.html
specifically the part that says:
With the bdb_max_lock variable, you can specify the maximum number
of locks that can be active on a BDB table. The default is 10,000. You
should
On 12/7/05, Marco Baroetto [EMAIL PROTECTED] wrote:
Hi,
I have a berkeley db table containing about 5 rows where I do this
transaction (pseudocode follows):
begin work
delete from mytable where myfield='boo' /*delete about 100 rows*/
for (i=0; i=100; i++){
insert into mytable
error:
Lock table is out of available locks
I tried to resolve the problem starting mysqld with -O
bdb_max_lock=6 and later with -O bdb_max_lock=12 but i still
receive the same error.
dbd related variables follows:
mysql show variables like %bdb
Hi,
There is an extensive documentation for InnoDB, but I can't find any
extensive for BDB (except
http://dev.mysql.com/doc/mysql/en/bdb-storage-engine.html ). Can I
change the isolation level in the same way than with InnoDB ? Can I
also do SELECT FOR UPDATE ?
thanks
--
MySQL General
What are the implications of setting the --bdb-no-sync flag when
using the BDB storage engine. I haven't found alot of documentation on
this in the docs or via google.
Does this mean that after every transaction, sync will not be called?
When will sync be called then?
Will setting this flag
What are the implications of setting the --bdb-no-sync flag when
using the BDB storage engine. There isn't alot of documentation on
this.
Does this mean that after every transaction, sync will not be called?
When will sync be called then?
Will setting this flag lead to ACI semantics, ie
Hello.
Your MySQL distribution doesn't have support for BDB.
What do I need to do to enable BDB support on the system that
currently does not have it?
See:
http://dev.mysql.com/doc/mysql/en/BDB_install.html
sol beach [EMAIL PROTECTED] wrote:
I have two systems running mysql
I have two systems running mysql which I have inherited.
On a good day I can spell MYSQL, but I am required to support these DBs.
mysql Ver 11.18 Distrib 3.23.51, for pc-solaris2.7 (i386) ; without BDB support
+---+---+
| Variable_name | Value
i'm considering a situation where i need to update a group of tables with
data. i'd like to be able to either add all the data to all the tables, or
to add none, and report an error.
mysql/google indicates that this is possible if i use a table type=bdb...
i'm trying to understand what i get
.
The pos application should handle some degree of integrity and
transaction safe, both bdb and innodb offers this two things, sooo would
you mind telling me what would you use? and why? =)
Also, pointng me to some url where i can compare bdb vs. innodb
functionality would be greatly appreciated
(Asking again)
After running in production for about seven weeks, our dumps on one of
our BDB tables performed with 'mysqldump --opt' began failing with the
message: 'mysqldump: Error 1030: Got error 12 from table handler when
dumping table `reference` at row: 255233'. The table has about
After running in production for about seven weeks, our dumps on one of
our BDB tables performed with mysqldump began failing with the message:
'mysqldump: Error 1030: Got error 12 from table handler when dumping
table `reference` at row: 255233'.
Reviewing the error log and the MySQL doc, I
What transaction isolation level(s) does BDB support? I can't find any
information on BDB transactions section 7.6 of the manual.
Thanks,
Bill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Mon, Sep 08, 2003 at 03:26:34PM -0700, Bill Todd wrote:
What transaction isolation level(s) does BDB support? I can't find any
information on BDB transactions section 7.6 of the manual.
BDB only does READ COMMITTED.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo
Hi MySQL Fans,
I am sure this question was asked before, but I did not find sufficient info,
so please allow me to ask this question again.
When comparing BDB and InnoDB which one would be (generally speaking) a better
choice for a certain purpose ?
I understood that BDB and InnoDB have
According to Sams Publishing (April 2002):
The Berkeley DB table type is a usable, transaction-safe table type, but it
is not the most optimized table type in the mix. BDB tables support the basic
elements of transactions as well as the AUTOCOMMIT variable, but are not as
popular
Thanks Edward,
Thank you that confirms what I found.
I also found that BDB is not available on Mac and Linux (alpha) architecture.
Best regards
Nils Valentin
Tokyo/Japan
2003 6 12 16:02Becoming Digital :
According to Sams Publishing (April 2002):
The Berkeley DB table type is a usable
Hi,...
We work with MySQL 3.23.55 in a LINUX REDHAT Machine.
It used to work fine with our BDB Tables,.. but now we got the following
errors when we try to start the Database Server:
##
030310 15:09:08 mysqld started
030310 15:09:08 bdb: Log sequence error: page LSN 1:5242731
Hi,
I've got a problem:
I'm using Berkeley DB tables in my database, but mysql fails to restart
after dropping such database. Mysql claims that it can't restore some of
database tables on start and fails to do it, because tables' files do not
physically exists after database dropping...
I can
Description:
When trying to create a type=BDB table under NetBSD 1.6, mysql reports:
ERROR 1005: Can't create table './test/test.frm' (errno: 9)
and the error log shows:
030114 17:10:19 bdb: fstat: Bad file descriptor
030114 17:10:19 bdb: /home/mysql
Hi, does anyone have any experience using db_stat to get statistics on BDB
tables in MySQL. How did you go about this please? Thanks.
Geetika
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
is declared to be a BDB table.
If I dump the table with mysqldump, modify the declaration to include the index,
and then attept to reload, all goes well for a while, then everything dies with
multiple Error 2002 reports.
If I use the normal default table type (ISAM), I can load the respcified version
Description:
When running mysql-test sequence, two of the BDB tests cause mysql to
apparently bomb -- all other tests run ok (used --force to verify)
Extract of test log is:
.
.
.
backup 0.0 0.0 0.1 [ pass ]
bdb-alter-table-1
Dear people,
I have a problem with getting InnoDB and BDB to work. I use
mySQL Max 4.0. I have even made sure that the skip-BDB and
skip-InnoDB
lines in the configuration .xml file are commented out. But still
the 'variables' list in the winmysqladmin shows haveInnoDB and
haveBDB
Paul,
- Original Message -
From: Paul Varkey [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, October 02, 2002 1:41 PM
Subject: Can't stratup InnoDB and BDB for Max 4.0
Dear people,
I have a problem with getting InnoDB and BDB to work. I use
mySQL Max 4.0. I
Sridhar,
Wednesday, September 25, 2002, 6:11:30 PM, you wrote:
SP Currently i get around this issue by analyzing the BDB tables, but this
SP seems to be a temporary solution. The issue is intermittent, keeps
SP surfacing
SP again after a certain no of days. Did not find any related bugs
Description:
Compile MySql with BDB installed as a system package with no build
directory. MySql configure and compile insist on building the included
BDB which is not wanted as the system BDB package contains a more
recent version of Berkeley DB. Adding BDB include and library
Sridhar,
Wednesday, September 25, 2002, 12:23:29 AM, you wrote:
SP One of our MySQL db's containing BDB tables is exhibiting a strange
SP behavior.
SP A query consisting of an ORDER BY clause is returning wrong result set.
SP The
SP same query when used without an ORDER BY clause returns
[EMAIL PROTECTED] wrote:
Sridhar,
Wednesday, September 25, 2002, 12:23:29 AM, you wrote:
SP One of our MySQL db's containing BDB tables is exhibiting a strange
SP behavior.
SP A query consisting of an ORDER BY clause is returning wrong result set.
SP The
SP same query when used without
Dear List,
One of our MySQL db's containing BDB tables is exhibiting a strange
behavior.
A query consisting of an ORDER BY clause is returning wrong result set.
The
same query when used without an ORDER BY clause returns the correct
result
set.
Environment: Sun Solaris 2.7, MySQL 3.23.51, Table
Hi!
Thank you for your test case, thanks to which this bug was solved.
Full fix will appear in the next 3.23 and 4.0 releases.
This is a patch :
= sql_table.cc 1.101 vs edited =
*** /tmp/sql_table.cc-1.101-460 Mon Feb 11 12:56:48 2002
--- edited/sql_table.cc Mon Jul 8 22:05:06
through ;) hihi
I just discovered the power of transactions in databases and was wondering,
which table type is better; BdB or InnoDB ? and if one is better than the
other, why is it? Does BdB also support referential ingegrity as InnoDB
does?
Also, I was wondering what SIGNED or UNSIGNED integer
Salutations.
1:
I personally use InnoDB. I think Bdb tables were the first with
transactions but I don't see a lot of people talking about using them these
days. Also, InnoDB is being activly developed and between sleeping, eating
and coding, Heikki answers questions here! :)
2:
Signed
Hello,
My perception of the InnoDB vs BDB question is that
although the BDB is very impressive and long standing,
it does not get the same level of attention that
InnoDB seems to get from the good folks at MySQL AB.
If I am not mistaken, BDB does not yet offer foreign
key support.
I have chosen
launch mysqldump or a select or alter table drop index.. the result
is the same. Mysql crashes
How can I fix index in BDB table, I did not find any tools in mysql package...
Check http://sleepycat.com, you can find some utilities there ...
DWP just do from mysql prompt :
DWP mysql
mysqldump or a select or alter table drop index.. the result
is the same. Mysql crashes
How can I fix index in BDB table, I did not find any tools in mysql package...
Check http://sleepycat.com, you can find some utilities there ...
DWP just do from mysql prompt :
DWP mysql repair table
You wrote:
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Sat, 22 Jun 2002 12:10:01 +0300
Subject: Re: Re: corrupt index in BDB table
Dicky,
Friday, June 21, 2002, 11:04:32 AM, you wrote:
i have a problem with an index of a BerkeleyDB table because
On Sat, 22 Jun 2002 11:37:29 +0200 (CEST)
Careri Giuseppe [EMAIL PROTECTED] wrote:
DWP just do from mysql prompt :
DWP mysql repair table [tablename]
REPAIR TABLE doesn't repair BDB tables!
Infact I can not repair BDB table, but when a index is corrupted
what can I do
Hi,
mysql select version();
+-+
| version() |
+-+
| 3.23.51-max-log |
+-+
1 row in set (0.00 sec)
Yesterday I sent a message to the list regarding MySql/BDB support for
recovery procedures.
I could not make sense of the binary log and I
.. the result
is the same. Mysql crashes
How can I fix index in BDB table, I did not find any tools in mysql package...
Thanks...
Giuseppe
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
the first 957
If I launch mysqldump or a select or alter table drop index.. the result
is the same. Mysql crashes
How can I fix index in BDB table, I did not find any tools in mysql package...
just do from mysql prompt :
mysql repair table [tablename]
--
I'd crawl over an acre
On Thu, May 09, 2002 at 09:31:06AM +0100, Robert Cross wrote:
BTW, a big thank you to whomever wrote mysqlbinlog as it saved the day!
(my database was well and truely broken)
That's Sasha. He wrote most (all?) of the replication code in MySQL.
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Hello.
On Thu, May 23, 2002 at 11:53:49AM -0400, [EMAIL PROTECTED] wrote:
Hello,
I'm new to MySql. I plan to switch my Java/JDBC web application to use
MySql. The application requires transactions so, as I understand it, I need
the table types to be BDB or InnoDB. Can anyone offer comments
Hello,
I'm new to MySql. I plan to switch my Java/JDBC web application to use
MySql. The application requires transactions so, as I understand it, I need
the table types to be BDB or InnoDB. Can anyone offer comments on which file
type is preferred? Is one more stable than another
Hi!
Robert == Robert Cross [EMAIL PROTECTED] writes:
Robert Anyone seen a message like:
Robert 020509 0:05:30 bdb: txn_begin: transaction ID wrapped. Exit the database
environment
Robert and restart the application as if application failure had occurred
Robert Now for the important
Hi,
In addition to the deadlock problems that I'm having, as described in
previous e-mails (still not solved...), it appears that the
transaction_isolation level setting is not being honoured, at least when
using BDB tables. (I'm running mysql-max-nt 3.23.49a on Windows NT4 SP6
On Mon, Apr 29, 2002 at 12:52:23PM +0100, Steve Hay wrote:
Hi,
In addition to the deadlock problems that I'm having, as described
in previous e-mails (still not solved...), it appears that the
transaction_isolation level setting is not being honoured, at least
when using BDB tables
Hi,
I'm trying to run two separate programs which connect to a single MySQL
database and attempt to perform transactions on its BDB tables. I'm
running MySQL 3.23.49a Max on Windows (NT4). The two programs in
question are both Windows Services written in Perl (5.6.1), and they
are using
in the documentation that
support for BDB and InnoDB table types is activated in precompiled binaries.
Is there something I've missed to configure (I've configured the necessary
innodb_data_file_path and innodb_data_home_dir for InnoDB) or do I have to
recompile MySQL with support for BDB and InnoDB activated? I've
Samim,
- Original Message -
From: Samim [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, April 22, 2002 11:31 AM
Subject: InnoDB, BDB
Hello,
This question is probably repeated each week, but I am an absolute
beginner
with MySQL. Sorry for that. I've installed
for transactions, although it was written in the documentation that
S support for BDB and InnoDB table types is activated in precompiled binaries.
S Is there something I've missed to configure (I've configured the necessary
S innodb_data_file_path and innodb_data_home_dir for InnoDB) or do I have to
S
the records at table employees to
be deleted or updated to value 2 on the field dept_id.
i have InnoDB and BDB working on the System, but I don't know how to do
this, every time I delete from table depts, nothing happens at the records
at table employees, no warnings, no nothing.
Any Idea ?
I'm Using
Hi,
Has anyone got the following error on a BDB table :
read_const: Got error -30996 when reading table
We did some load testing on a particular BDB table and got this when we
tried to run 20 concurrent queries on the table. The query in question
works fine when the database
about MySQL doing a ROLLBACK automatically after some time with InnoDB tables.
What about BDB?
(MySQL ver 3.23.41)
Thanks, Felix.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
Thank you, we shall investigate this problem.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/ www.mysql.com
At 11/02/2002 05:21, Paul DuBois wrote:
At 4:10 +0700 2/11/02, Steven Haryanto wrote:
i believe since 3.23.39 it should not be?
BDB and MyISAM tables have different properties with respect to
AUTO_INCREMENT behavior.
i see, so this is an undocumented feature (i haven't seen this
in http
i believe since 3.23.39 it should not be?
mysql create table t1_b(i int unsigned primary key
auto_increment, j int) type=bdb;
mysql create table t1_m(i int unsigned primary key
auto_increment, j int) type=myisam;
mysql insert into t1_bdb(j)values(0);
mysql insert into t1_bdb(j)values(0);
mysql
i believe since 3.23.39 it should not be?
mysql create table t1_b(i int unsigned primary key
auto_increment, j int) type=bdb;
mysql create table t1_m(i int unsigned primary key
auto_increment, j int) type=myisam;
mysql insert into t1_bdb(j)values(0);
mysql insert into t1_bdb(j)values(0);
mysql
At 4:10 +0700 2/11/02, Steven Haryanto wrote:
i believe since 3.23.39 it should not be?
BDB and MyISAM tables have different properties with respect to
AUTO_INCREMENT behavior.
mysql create table t1_b(i int unsigned primary key auto_increment,
j int) type=bdb;
mysql create table t1_m(i int
At 11/02/2002 05:21, Paul DuBois wrote:
At 4:10 +0700 2/11/02, Steven Haryanto wrote:
i believe since 3.23.39 it should not be?
BDB and MyISAM tables have different properties with respect to
AUTO_INCREMENT behavior.
i see, so this is an undocumented feature (i haven't seen this
in http
Hi!
We shall investigate your test case as soon as we find some time.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
an alter table to make a
change to a table structure ?
I thought maybe this is associated with flush log/checkpoint process
happpens with BDB tables ? Can anyone confirm this ?
--Terribly confused.
-
Before posting, please
I've had many problems with BDB table crashes.
Up until now, I haven't really cared, running safe_mysqld, the database just
restarts, and things proceed as normal.
But recently I've had some strange behaviour, where table data is deleted
after an alter table statement.
Upon looking through
Kalok Lo writes:
I've had many problems with BDB table crashes.
Up until now, I haven't really cared, running safe_mysqld, the database just
restarts, and things proceed as normal.
But recently I've had some strange behaviour, where table data is deleted
after an alter table statement
Description:
Hi all, I'm not exactly sure whether this is a bug or that I'm just the
following proper procedures for starting and stoping the database and
flushing logs.
But I do have repeatable test cases below.(terminal screen dumps)
I'm using version 3.23.36 with BDB tables:
Basically my
Carsten Hammer writes:
Hi,
I just experienced the following bug in tables created as berkeley
tables:
on bdb tables:
mysql SELECT
jobs.number,jobs.status,jobs.filename,jobs.source_file,verarbeitung.name
FROM verarbeitung right join jobs on (verarbeitung.verarbeitung =
jobs.verarbeitung
to the your second result set.
Sinisa I did not use ISAM, but MyISAM though, as this is a table handler that
Sinisa is actively maintained.
Carsten, if you can send us a full test case that we can use to repeat
this problem with BDB tables, we will fix this for next MySQL release.
To answer your
Hi,
With all the recent talk about replication, just wondering if there are
any others out there who have experience replicating BDB tables?
My experience so far has been that the slave instance of MySQL has been
crashing once in a while, when applying perfectly legitimate
On Fri, Jan 25, 2002 at 04:15:18PM +0800, Geoffrey Soh wrote:
Hi,
My experience so far has been that the slave instance of MySQL
has been crashing once in a while, when applying perfectly
legitimate DELETE queries on the replicated BDB tables.
That's a bad sign.
MySQL
Kalok,
Thursday, January 24, 2002, 6:51:26 PM, you wrote:
KL I'm having the same need.
KL It looks like the following is intended for MyISAM tables only:
KL http://www.mysql.com/doc/U/s/Using_mysqlcheck.html
KL Has anyone else had any other luck ?
Sometimes mysqlcheck works for BDB tables
Hi!
CHECK TABLE does not do anything on BDB tables.
On InnoDB and MyISAM tables CHECK TABLE tries to verify the physical
consistency of the table and its indexes.
The way to repair InnoDB or BDB tables is to dump, drop, and reimport them.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order
In the manual at http://www.mysql.com/doc/N/e/News-3.23.x.html, immediately
after introducing MyISAM, BDB, and InnoDB, it says:
Note that only MyISAM is available in the standard binary distribution.
This assumes that I am able to complete the necessary next sentence:
Therefore, to use BDB
Hi Erv,
Hi Erv,
You can check www.innodb.com.
Caterina
-Original Message-
From: Erv Young [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 21, 2002 4:44 PM
To: [EMAIL PROTECTED]
Subject: How to get BDB or InnoDB
In the manual at http://www.mysql.com/doc/N/e/News-3.23.x.html
Therefore, to use BDB or InnoDB, you must
For InnoDB, get or build the Mysql-MAX distribution of the MySQL Server-- if
you are using RPMs, this just means installing the one MAX rpm and you will
have InnoDB capability in addition to the standard MyISAM.
c
--
Chris Lott
http
Hi,
Having some problems with a particular BDB table, which crashes once in a
while. Just wondering if anyone has experienced such BDB table crashes?
The relevant info is included below for troubleshooting. Let me know if I
need to send anything else. Appreciate any help. Thanks
Hi,
I just experienced the following bug in tables created as berkeley
tables:
on bdb tables:
mysql SELECT
jobs.number,jobs.status,jobs.filename,jobs.source_file,verarbeitung.name
FROM verarbeitung right join jobs on (verarbeitung.verarbeitung =
jobs.verarbeitung) order by jobs.number
Carsten Hammer writes:
Hi,
I just experienced the following bug in tables created as berkeley
tables:
[skip]
Is it in general dangerous to use bdb tables?
Best regards,
Carsten Hammer
No, it is not dangerous to use bdb tables.
Can you upload gzipped dump of the tables to :
ftp
Hi,
Just wondering if anyone has received the following error code before on a
BDB table :
ERROR 1030: Got error -30991 from table handler
I have a BDB table consisting of 4 varchar and 2 unsigned bigint columns
with about 30K+ rows. This table is replicated to a slave. Both
I am trying mysql-max 4 with BDB table types and
transaction-isolation-level=READ-COMMITTED.
When I do an update/delete in one session the table row is locked until
rollback or commit for all other sessions. Should this be the case, and if
not how do I get round this?
Regards,
Simon
Simon
Description:
I started using BDB tables in a php program with mysql-3.23.36 that comes with
redhat7.1.
The php program uses a database of 3 myISAM tables to read the schema of the
BDB tables and dynamicaly
generate select/update/insert queries on the BDB tables. The BDB tables form
another
to the myISAM tables. If for some reason, one query cannot be
fulfilled, all queries of the transaction
are undone by calling ROLLBACK. The transaction model makes my app much
simlper and more flexible.
For transaction support, the recommended table handler is InnoDB. For BDB,
though, we
1 - 100 of 254 matches
Mail list logo
