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, Yaho
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:02、Becoming Digital さんは書きました:
> According to Sams Publishing (April 2002):
> The Berkeley DB table t
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 or as develop
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]
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
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" stateme
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 the
On Tuesday 04 December 2001 12:00 pm, [EMAIL PROTECTED] wrote:
> The concept of a transaction is important to my app because the number of
> queries and the number of tables
> to be modified during a particular transaction is not easy to calculate. It
is
> obtained from the result of
> the que
On Thu, Oct 25, 2001 at 04:22:33PM +0800, Geoffrey Soh wrote:
> Hi All,
>
> I'm new to this list and have some questions about BDB tables and
> replication. Hope some of the more enlightened ones on this list
> might shed some light on the following :
>
> 1. I've a master-slave replication setu
l releases, but
3.23.41 should be fine. Im using .42 and having no more problems.
dpk
- Original Message -
From: <[EMAIL PROTECTED]>
To: "'Dana Powers'" <[EMAIL PROTECTED]>
Cc: "mysql mailing list (E-Mail)" <[EMAIL PROTECTED]>
Sent: T
Hi Dana
> -Original Message-
> From: Dana Powers [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 19, 2001 7:19 PM
> To: [EMAIL PROTECTED]
> Cc: mysql mailing list (E-Mail)
> Subject: Re: BDB table : different results on adjacent queries
>
>
> What i
What is the query you are running + what version of mysql are you using?
dpk
- Original Message -
From: <[EMAIL PROTECTED]>
To: "mysql mailing list (E-Mail)" <[EMAIL PROTECTED]>
Sent: Wednesday, September 19, 2001 2:12 AM
Subject: BDB table : different results on adjacent queries
> hi a
Hi!
> "Dana" == Dana Powers <[EMAIL PROTECTED]> writes:
Dana> Thanks for the reply! I can understand the situation with muti statement
Dana> transactions, but I'm not using transactions ( at least from my
Dana> perspective ); Im only issuing single 'atomic' statements. It would make
Dana> m
and that seems so
cumbersome given that the solution is the same in every case.
dpk
- Original Message -
From: "Michael Widenius" <[EMAIL PROTECTED]>
To: "Dana Powers" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: M
Hi!
> "Dana" == Dana Powers <[EMAIL PROTECTED]> writes:
Dana> Certainly I understand how the deadlock can occur, but the question is why
Dana> is this acceptable behaviour? Is the application developer expected to
Dana> handle this case? If so, how? and shouldnt this be included in the manu
t; <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, September 16, 2001 2:14 AM
Subject: Re: BDB table error
> Dana,
>
> if you have page level locking, you can easily
> get a deadlock from an atomic insert done as
> a single tran
Dana,
if you have page level locking, you can easily
get a deadlock from an atomic insert done as
a single transaction, and another user doing
an atomic select in another single transaction.
It happens this way:
User A User B
insert recordselect record from second
I can totally understand that, but the problem is, my queries are only
interested in one row each ( accessed by primary key ). Perhaps it has to do
with the extra unique index?
The flow is this:
insert row.
grab newly created primary key ( autoincrement ) + generate a unique 32 byte
char string
I've found the answer to my problem in the bdb source...
>From bdb/include/db.src:
#defineDB_LOCK_DEADLOCK(-30996)/* Deadlock. */
So the question is: how can a bunch of simultaneous connections that only
work on 1 table create a deadlock. And how can I write my code to avoid this
At 9:55 PM +0530 9/9/01, Nilesh Parmar wrote:
> Hi
> I just came across these words in the mailing lists.
> Can anyone tell me what are "BDB tables" and "InnoDB tables" .
>I am new to mysql and would like to know what are they .
>thanx in advance
>Nilesh
(1) Go to http://www.mysql.com
Hi
I just came across these words in the mailing lists.
Can anyone tell me what are "BDB tables" and "InnoDB tables" .
I am new to mysql and would like to know what are they .
thanx in advance
Nilesh
-
On Tue, Aug 28, 2001 at 11:39:54AM -0700, Sheena Sidhu wrote:
>
> I had 2 questions related to using BDB and mysql. I don't see any
> startup options for BDB, so can I safely assume that there are'nt
> any , so don't need a my.cnf file?
There are several. Look in the docs here:
http://www.mys
On Sat, Sep 01, 2001 at 11:42:52AM -0400, Jocelyn Bernier wrote:
> Hi everybody,
>
> I am currently looking the transactional part of MySQL and I'm
> wandering which one is best to use in regard to efficiency and
> reliability. Which one is the most stable, etc?
While I have some of experien
Bruce,
you are right. There is only a small note about the
10M limit in the options list in the manual.
I will add a note also right after Win option examples.
Regards,
Heikki
http://www.innodb.com
...
Thanks guys.
Just one thing, why isn't this somewhere in the docs?
A small note
Thanks guys.
Just one thing, why isn't this somewhere in the docs?
A small note near the beginning of section 7.6.2 InnoDB startup options
would seem to be an ideal place.
cheers,
Bruce
At 03:30 PM 8/17/2001 +0300, you wrote:
>Bruce,
>
>the tablespace must be >= 10 MB. You have only
>specified
Bruce,
the tablespace must be >= 10 MB. You have only
specified 5M.
I tested with .41 and got the following error
message:
C:\trybuild\client_debug>mysqld --console
InnoDB: Error: tablespace size must be at least 10 MB
010817 15:28:15 Can't init databases
Regards,
Heikki
Copied message:
...
At 11:50 17/08/2001 +0100, Bruce Scharlau wrote:
Hi!
>Thanks for the input Heikki,
>
>I got it the right version mysql-max-nt going now. The problem was that
>winmysqladmin automatically started the wrong service- mysqld - so I had
>to uninstall that service before it would recognise any changed
Thanks for the input Heikki,
I got it the right version mysql-max-nt going now. The problem was that
winmysqladmin automatically started the wrong service- mysqld - so I had to
uninstall that service before it would recognise any changed I made in the
my.ini file done with winmysqladmin.
Now
Sinisa,
there is no separate Windows distribution of -Max :). From the
-Max page:
Note: The MySQL 3.23.38 (and newer) distribution for Windows includes both
the normal MySQL and MySQL-Max binaries.
Regards,
Heikki
Sinisa writes:
.
Bruce Scharlau writes:
> Hi all,
>
> I'm t
Bruce Scharlau writes:
> Hi all,
>
> I'm trying to work out which distribution of mysql supports BDB or InnoDB
> tables.
> I've downloaded 3.23.40 and checked 'show variables' asnd it says these
> tables are not supported.
> I know the docs say they should be available in the distro, but it see
Hello Michael,
Thursday, May 31, 2001, 11:19:03 PM, you wrote:
MW> Hi!
>> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter>> Hello bugs,
Peter>> mysql 3.23.38
Peter>> Linux diamond 2.4.4.SuSE-12-4GB-SMP #8 SMP Sat May 19 21:24:05 MSD
Peter>> 2001 i686 unknown
Peter>> SUSE 7.1 (G
On Thursday 12 April 2001 14:03, Ken Menzel wrote:
> Hi Sasha,
>
> > Looks like you found two bugs at once. The first one is that someone
> mysqld
> > segfaults, probably a bug in processing some query or possibly some
> OS issue,
> > but there is not much we can tell at this point - the only way
Hi Sasha,
> Looks like you found two bugs at once. The first one is that someone
mysqld
> segfaults, probably a bug in processing some query or possibly some
OS issue,
> but there is not much we can tell at this point - the only way to
track it
> down would be if you had full logging enabled and
On Thursday 12 April 2001 10:49, Ken Menzel wrote:
> We had a crash of MySQL this morning for some reason. (Why who
> knows!) The real problem was it would not restart until the log.*
> files were deleted. It looks like it was trying to perform a recovery
> on a dropped database. The server wo
On Tue, Apr 10, 2001 at 12:37:10PM +0300, Yusuf Incekara wrote:
>
> does mysql binary win32 dist support innobase and bdb tables. if
> yes how ? if not when will you implement?
I don't think Innobase is availabe on Windows yet.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo
.
Cedric.
-Original Message-
From: Scott McCool [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 3:29 PM
To: 'Stephen Faustino'; '[EMAIL PROTECTED]'
Subject: RE: BDB table corruption when inserting/retrieving a BLOB into
a BDB table
I can also verify that the dat
001 2:51 PM
To: '[EMAIL PROTECTED]'
Subject: RE: BDB table corruption when inserting/retrieving a BLOB into
a BDB table
We have also experienced the same exact behavior, also using the mm.mysql
driver, on Linux. However, our problem is intermittent. There are times
(though these
We have also experienced the same exact behavior, also using the mm.mysql
driver, on Linux. However, our problem is intermittent. There are times
(though these times cannot be accurately predicted) where the data is
retrieved correctly, which implies that the data is stored correclty. We
have v
-5092(WCK)
/ Fax:281-544-2646(WCK)
/ email: [EMAIL PROTECTED]
-
-Original Message-
From: Stephen Faustino [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 4:11 PM
To: '[EMAIL PROTECTED]'
Subject: RE: BDB tables on Linux
show
I never successful rollback if I compile mysql from source in RedHat 7.0, I
think it is the compile problem...
-Original Message-
From: Stephen Faustino [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 5:44 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]&#x
On Mon, Mar 05, 2001 at 04:10:59PM -0600, Stephen Faustino wrote:
>
> show variables showed that have_bdb is no, and none of the bdb
> variables are there. So does this mean that BDB is NOT compiled
> into the binary included in the Linux RPM, or does it mean that I
> need to add the necesary BDB
As far I can tell, you have to rebuild from source.
BDB works very bad for me (linuxppc). Extremely slow and errors.
Christian.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.m
ECTED]'
Subject: Re: BDB tables on Linux
On Mon, Mar 05, 2001 at 03:44:20PM -0600, Stephen Faustino wrote:
>
> Yes, I specified that the table should use the BDB table handler,
> but it does not appear that the table was created as a BDB table.
Are you *sure* you're running a
On Mon, Mar 05, 2001 at 03:44:20PM -0600, Stephen Faustino wrote:
>
> Yes, I specified that the table should use the BDB table handler,
> but it does not appear that the table was created as a BDB table.
Are you *sure* you're running a version with BDB support compiled in?
The output of SHOW VARI
y [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 3:29 PM
To: Stephen Faustino
Cc: '[EMAIL PROTECTED]'
Subject: Re: BDB tables on Linux
On Mon, Mar 05, 2001 at 11:27:54AM -0600, Stephen Faustino wrote:
>
> I've installed 3.23.33 on both Solaris and Linux RH 6.2 using th
On Mon, Mar 05, 2001 at 11:27:54AM -0600, Stephen Faustino wrote:
>
> I've installed 3.23.33 on both Solaris and Linux RH 6.2 using the
> tarball for Solaris and the RPM for Linux. The BDB tables work as
> expected on Solaris, but they did not not work under Linux. What
> I'm seeing is that I ca
Hi!
> "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes:
Sasha> I do have a patch for it now. From what I understood in the code, this is
Sasha> actually a more correct way to do things, but I would like to get Monty's
Sasha> approval to be sure. After the patch, MySQL still passes our
Hi Sasha,
The patch you sent me seems to have created other problems,
or simply has allowed to find new ones :)
I'm working on isolating exactly which query makes the bdb
tables crash. Full bug report on the way.
So far, it looks like left joins on bdb tables does something weird.
I was using
On Thursday 01 March 2001 13:32, Quentin Bennett wrote:
>
>
>After the patch, MySQL still passes our test suite, which is a good sign.
>
>
>
>But how come it passed the test suite with the bug in place ?? ;-)
It does not any more, with the bug not fixed, that is. We update the test
suite every
After the patch, MySQL still passes our test suite, which is a good sign.
But how come it passed the test suite with the bug in place ?? ;-)
Quentin
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
reci
On Wednesday 28 February 2001 22:04, [EMAIL PROTECTED] wrote:
>Hi folks, I'm having a hard time using bdb tables. Here are the
>details...
>
>I've create a few BDB tables, which are causing me great amounts
>of grief. The tables worked fine for a while, then suddenly
>started crashing mysqld. I de
On Wednesday 28 February 2001 22:04, [EMAIL PROTECTED] wrote:
>Hi folks, I'm having a hard time using bdb tables. Here are the
>details...
>
>I've create a few BDB tables, which are causing me great amounts
>of grief. The tables worked fine for a while, then suddenly
>started crashing mysqld. I de
On Thu, Mar 01, 2001 at 12:04:27AM -0500, [EMAIL PROTECTED] wrote:
>
> I've replicated this problem on 3 different machines, and
> on 3.23.33 and 3.23.32. I had been using BDB tables for a
> couple weeks now in testing, without a hitch until the above
> query starting being used. I also tried to
On Wednesday 28 February 2001 22:04, [EMAIL PROTECTED] wrote:
>Hi folks, I'm having a hard time using bdb tables. Here are the
>details...
>
>I've create a few BDB tables, which are causing me great amounts
>of grief. The tables worked fine for a while, then suddenly
>started crashing mysqld. I de
[EMAIL PROTECTED] writes:
> Hi folks, I'm having a hard time using bdb tables. Here are the
> details...
>
> I've create a few BDB tables, which are causing me great amounts
> of grief. The tables worked fine for a while, then suddenly
> started crashing mysqld. I decided to drop the offend
Guenther Pewny writes:
> It's a miracle.
>
> Which version of the BDB patch do you use?
> I'm using 3.2.9a.
> (Previously, there has been a version 3.2.3g...)
>
> Thanks...
>
> Günther Pewny
>
Hi!
I used latest source tarball from our 3.23 page.
Regards,
Sinisa
__
It's a miracle.
Which version of the BDB patch do you use?
I'm using 3.2.9a.
(Previously, there has been a version 3.2.3g...)
Thanks...
Günther Pewny
Sinisa Milivojevic wrote:
> Guenther Pewny writes:
> > Hi folks,
> >
> > I have a problem with BDB tables. Please look at this short mysql s
Guenther Pewny writes:
> Hi folks,
>
> I have a problem with BDB tables. Please look at this short mysql session:
>
> mysql> create table sample (
> id1 int(8) not null,
> id2 int(8) not null,
> primary key (id1,id2))
> type=BDB;
> Query OK, 0 rows affected (0.67 sec)
Hi!
> "Mehalick," == Mehalick, Richard RE SSI-GRAX <[EMAIL PROTECTED]> writes:
Mehalick,> When using the BDB tables and RedHat 6.2 or 7.0, should --skip-locking be
Mehalick,> used or not? I know it was recommended for earlier versions of RedHat, like
Mehalick,> version 5.x.
Now when CHECK
Hello Michael,
Friday, February 09, 2001, 3:48:53 AM, you wrote:
Peter>> as you see here one thread is doing repear as this happened after
Peter>> mysqld crash, but note first insert query in system lock state (I've
Peter>> saw several queries at this place, but all of them spent in system
Pet
When using the BDB tables and RedHat 6.2 or 7.0, should --skip-locking be
used or not? I know it was recommended for earlier versions of RedHat, like
version 5.x.
Thanks in advance,
Rick
-
/ Rick Mehalick Senior Consultant
/ Shell Services I
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello Michael,
Peter> Friday, January 26, 2001, 12:20:43 AM, you wrote:
MW> Hi!
>>> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello monty,
Peter> As I remember according to documentation MYSQL should
Hello Michael,
Friday, January 26, 2001, 12:20:43 AM, you wrote:
MW> Hi!
>> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter>> Hello monty,
Peter>> As I remember according to documentation MYSQL should support check
Peter>> table on BDB tables:
Peter>> `CHECK TABLE' only wo
63 matches
Mail list logo
