RE: INNOBASE

2001-03-19 Thread Mehalick, Richard RE SSI-GRAX

Heikki,

When you write your documentation, please include more info on my.cnf
settings.  What I would like to see are some settings documented for
different machines (i.e. machines with 64M, 128M, etc. of memory and also
disk space numbers and how they relate.)

Thanks,
Rick

-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 17, 2001 8:20 AM
To: [EMAIL PROTECTED]
Subject: Re: INNOBASE


Cal,

I will write more documentation during the week beginning 19th of
March, and post that to my website at www.innobase.fi. It will
also appear in the MySQL online manual at www.mysql.com, but
even sooner at my website, since I do not control the version
of the MySQL manual shown at www.mysql.com.

In the documentation I will present the basics of Innobase and also
try to answer to the questions people have presented on this mailing list.
The transaction model of Innobase is relatively close to Oracle, therefore
literature on Oracle will help.

I am sorry the present documentation is sparse, but I have been
busy with the current release, allocating time to different tasks.

Regards,

Heikki 

Cal Evans writes:
 Other than the (sparse) documentation in the manual, is there any other
 documentation available for INNOBASE files?
 Cal
 http://www.calevans.com

 Hi!
 Try :
 http://www.innobase.fi
 Regards,Sinisa


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Innobase compile problems

2001-03-15 Thread Mehalick, Richard RE SSI-GRAX

Hi,

I tried to build from source the latest MySQL 3.23.34a and I found the
following problems:

1) The Makefile in the 'pars' and 'mem' directory have missing ../include/
paths on some dependencies.

2) In the 'mem' directory, the file mem0mem.c tries to include mem0dbg.c,
but I think this should be mem0dbg.ic (I changed it to this anyway???)

3) The mysqld doesn't link.  The function body for mem_init doesn't resolve.
I looked in the innobase directory and couldn't find it anywhere.

I did configure with --with-innobase and the following other configure
options:

--with-mysqld-ldflags=-all-static
--without-bench
--with-extra-charsets=none
--enable-static=yes
--without-debug

Thanks,
Rick

-
/ Rick Mehalick   Senior Consultant
/ Shell Services International SSI-GPAX
/ Phone:  281-544-5092(WCK) 
/ Fax:281-544-2646(WCK)
/ email:  [EMAIL PROTECTED] 
-



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Innobase compile problems

2001-03-15 Thread Mehalick, Richard RE SSI-GRAX

I failed to mention that I used the RedHat Source RPM and I am using RedHat
6.2.

Rick

-Original Message-
From: Mehalick, Richard RE SSI-GRAX 
Sent: Thursday, March 15, 2001 6:10 AM
To: 'Heikki Tuuri'
Cc: '[EMAIL PROTECTED]'
Subject: Innobase compile problems


Hi,

I tried to build from source the latest MySQL 3.23.34a and I found the
following problems:

1) The Makefile in the 'pars' and 'mem' directory have missing ../include/
paths on some dependencies.

2) In the 'mem' directory, the file mem0mem.c tries to include mem0dbg.c,
but I think this should be mem0dbg.ic (I changed it to this anyway???)

3) The mysqld doesn't link.  The function body for mem_init doesn't resolve.
I looked in the innobase directory and couldn't find it anywhere.

I did configure with --with-innobase and the following other configure
options:

--with-mysqld-ldflags=-all-static
--without-bench
--with-extra-charsets=none
--enable-static=yes
--without-debug

Thanks,
Rick

-
/ Rick Mehalick   Senior Consultant
/ Shell Services International SSI-GPAX
/ Phone:  281-544-5092(WCK) 
/ Fax:281-544-2646(WCK)
/ email:  [EMAIL PROTECTED] 
-



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Innobase compile problems

2001-03-15 Thread Mehalick, Richard RE SSI-GRAX

Please see my comments below.

Do you mean that when you compile, on the compiler line there is not the
flag -I../include?

No, not really.  I mean in the dependencies for a target.

If the flag is missing, there obviously is something wrong with our
Makefile.am's or configure.in's. You probably know how to edit the
Makefile's automake has generated? A quick fix is to
add the missing -I's to the compiler lines there.

I was able to fix it, but a new configure will mess it up again.

No, it really should include mem0dbg.c :). I divided debug code and
non-debug code into two files.

The mem0dbg.c file could not be found in the 'mem' directory.

Thanks,
Rick

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Which transaction table type to use

2001-03-12 Thread Mehalick, Richard RE SSI-GRAX

I was wondering what others are thinking with respect to transaction table
type (BDB, Innobase, or Gemini) choices.

It seems to me that if you want transaction support in MySQL, then you must
pick one of the available transaction table types.  And I would also assume
that row level locking would be a better choice than page level locking.

So which one, Innobase or Gemini?  If you are doing typical finacial
transactions, then either would be a reasonable choice, but I wonder which
one would offer better backup/recovery options, etc.

I was hoping for some guidance.  Any takers?

Thanks,
Rick

-
/ Rick Mehalick   Senior Consultant
/ Shell Services International SSI-GPAX
/ Phone:  281-544-5092(WCK) 
/ Fax:281-544-2646(WCK)
/ email:  [EMAIL PROTECTED] 
-



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: BDB tables on Linux

2001-03-06 Thread Mehalick, Richard RE SSI-GRAX

You must compile from source to get BDB support into mysql.  Make sure you
download the appropriate BDB source and place it in the mysql directory.

-
/ Rick Mehalick   Senior Consultant
/ Shell Services International SSI-GPAX
/ Phone:  281-544-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 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-related variables to /etc/my.cnf?


Stephen L. Faustino
Senior Software Engineer
SecureLogix Corporation
Direct/Vmail (210)402-9669x949
mailto:[EMAIL PROTECTED]
 
This email is intended for the named recipient(s) only and may contain
information that is privileged and/or confidential. Nothing in this
email is intended to constitute a waiver of any privilege or the
confidentiality of this message. If you have received this email in
error, please notify me immediately by reply and delete this message. 




-Original Message-
From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 3:51 PM
To: Stephen Faustino
Cc: '[EMAIL PROTECTED]'
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 version with BDB support compiled in?
The output of SHOW VARIBLES will probably tell you. Having not used
them, though, it's hard to say...

Jeremy
-- 
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878Fax: (408) 530-5454
Cell: (408) 439-9951

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: XML support under mySQL

2001-02-22 Thread Mehalick, Richard RE SSI-GRAX

Yes, Ed is correct.  You store data, but it is the trasport of that data
that makes XML look good.  To me, using XML to transport the data is like
using recordsets in Microsoft/ADO.


-
/ Rick Mehalick   Senior Consultant
/ Shell Services International SSI-GPAX
/ Phone:  281-544-5092(WCK) 
/ Fax:281-544-2646(WCK)
/ email:  [EMAIL PROTECTED] 
-



-Original Message-
From: Ed Carp [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 6:18 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: XML support under mySQL


Gorjan Todorovski ([EMAIL PROTECTED]) writes:

 Since XML is a way to exchange data...and it is protocol/platform
indepdnent
 there is a very good reason to have XML docuemts going in and out the

No, it's not.  You store *data* in a database, *not* metadata.  Do you
understand the difference?

--
Ed Carp, N7EKG  [EMAIL PROTECTED]   940/367-2744 cell phone
http://www.pobox.com/~erc   [EMAIL PROTECTED] - text pager

I sometimes wonder if the American people deserve to be free - they seem
so unwilling to fight to preserve the few freedoms they have left.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: XML support under mySQL

2001-02-21 Thread Mehalick, Richard RE SSI-GRAX

Some relational databases return results in XML format.

-
/ Rick Mehalick   Senior Consultant
/ Shell Services International SSI-GPAX
/ Phone:  281-544-5092(WCK) 
/ Fax:281-544-2646(WCK)
/ email:  [EMAIL PROTECTED] 
-



-Original Message-
From: Ed Carp [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 21, 2001 2:48 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: XML support under mySQL


Gorjan Todorovski ([EMAIL PROTECTED]) writes:

 Is there support for XML in mySQL?

No la comprende, senor - XML is a markup language, MySQL is a database.
What does ne have to do with the other?
--
Ed Carp, N7EKG  [EMAIL PROTECTED]   940/367-2744 cell phone
http://www.pobox.com/~erc   [EMAIL PROTECTED] - text pager

I sometimes wonder if the American people deserve to be free - they seem
so unwilling to fight to preserve the few freedoms they have left.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: XML support under mySQL

2001-02-21 Thread Mehalick, Richard RE SSI-GRAX

The database does it.

It is my understanding that MSSQL will return the results of a query in XML.
The idea, as I understand it, is to create web pages with XML data. (I
attended a XML class where we did this) Since the web page contains code to
call the database and the result is in XML, then it should be easier to
present the page. (Note: some browsers can already do this with native XML)

Another reason, maybe even a better one, is that XML is less database
specific.  So too will be the data.  So the result of a query is no longer
tied to the database that produced it.

Rick


-
/ Rick Mehalick   Senior Consultant
/ Shell Services International SSI-GPAX
/ Phone:  281-544-5092(WCK) 
/ Fax:281-544-2646(WCK)
/ email:  [EMAIL PROTECTED] 
-



-Original Message-
From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 21, 2001 1:20 PM
To: Mehalick, Richard RE SSI-GRAX
Cc: 'Ed Carp'; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: XML support under mySQL


On Wed, Feb 21, 2001 at 09:49:40AM -0600, Mehalick, Richard RE SSI-GRAX
wrote:

 Some relational databases return results in XML format.

The *database* does that, or an add-on query tool does that?

It'd be trivial to implement an add-on for mysql (xmlmysql, a
command-line tool maybe) which would do it. But making the database
server itself do it seems rather, uh... strange.

I'm not saying it's a bad idea, but I just don't see the utility in
it. Can someone who would use such a feature explain how and why?
Seeing as how folks ask about this once in a while, I'm more than a
bit curious at this point.

Thanks,

Jeremy
-- 
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878Fax: (408) 530-5454
Cell: (408) 439-9951

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Innobase + transactions row level locks will be released in a few days in MySQL 3.23.3x

2001-02-19 Thread Mehalick, Richard RE SSI-GRAX

Will I be able to change my BDB tables into Innobase tables using Alter
table and how does INNOBASE tables differ from the GEMINI tables (when they
are available)?

-
/ Rick Mehalick   Senior Consultant
/ Shell Services International SSI-GPAX
/ Phone:  281-544-5092(WCK) 
/ Fax:281-544-2646(WCK)
/ email:  [EMAIL PROTECTED] 
-



-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 16, 2001 7:03 AM
To: [EMAIL PROTECTED]
Subject: Innobase + transactions  row level locks will be released in a
few days in MySQL 3.23.3x


Hi, readers of the mailing list!

Monty will roll a new distribution of MySQL 3.23.3x this weekend.
Innobase will be included there and it will provide transactions,
rollback, recovery, row level locking, and Oracle-like consistent read.

Monty will leave for a vacation in Rio on Wednesday, so the
new distribution should be ready at the latest on that day.

Currently, Intel NT and Intel Linux versions have been tested.
We will compile and test Solaris 32-bit and Linux Alpha 64-bit
versions this weekend.

Regards,

Heikki Tuuri
Innobase Oy
Helsinki, Finland


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Transaction issues

2001-02-14 Thread Mehalick, Richard RE SSI-GRAX

Berkeley tables (transactions) works for me.  I am using RedHat 6.2.  I
downloaded the sources and just unzipped/tar the Berkeley directly inside
the MySQL source directly.  I then did .configure and I watched configure
tell me that it found the Berkeley directly and would use it.

I am still testing the transaction support in my code, but the limited tests
have shown that a transaction:  BEGIN ... COMMIT, or BEGIN ... ROLLBACK
works.

Rick
-
/ Rick Mehalick   Senior Consultant
/ Shell Services International SSI-GPAX
/ Phone:  281-544-5092(WCK) 
/ Fax:281-544-2646(WCK)
/ email:  [EMAIL PROTECTED] 
-



-Original Message-
From: Marc Soda [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 2:30 PM
To: [EMAIL PROTECTED]
Subject: Transaction issues


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hello all,

I am new to the list and need assistance.  I noticed this thread in the
archives, but I didn't see an answer.  So, I'll ask it again.

I have tried several times to use  BerkeleyDB with MySQL to provide
transaction support.  It has failed each time, both in my own tests and
through the mysql-test-run utility.  It fails when attempting a rollback.
The actual rollback command returns with no error, but it doesn't 'undo'
anything.  Thus, the test suite fails when attempting to insert the same
value that should have been undone.  My company wishes to use MySQL for a
major web based application, unfortunately this hinges on transaction
support.  I have fought hard to use MySQL for this, but if I can't get
this working it was all for nothing.  I am using MySQL 3.23.33 (I have
tried this with 3.23.32 also) and BerkeleyDB 3.2.3h.  Both of which I
downloaded from mysql.com.  Also, I tried installing BDB compiled in with
MySQL and compiling separately, both failed.  Anyone???

Thanks

- -- 

Marc Soda
ASPRE, Inc.
[EMAIL PROTECTED]
http://www.aspre.net/

Managed e-Business Application Services
- -
t. 215.957.2266 Ext. 2144
f. 215.957.2277
c.215.840.1633

113 Rock Road
Horsham, PA 19044


-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE6iZlX8/oGPCGMSEgRAl02AJ9oQ94mAqtwb89ECqejtLYxL/HOGwCg3mNL
YVffTgj8c96KRZWQRfPyols=
=0eMJ
-END PGP SIGNATURE-


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Concurrent insert/select with BDB

2001-02-14 Thread Mehalick, Richard RE SSI-GRAX

I thought that by using Berkeley tables, concurrent insert/select locks were
based on a page lock.  I have seen the same locking with two clients as you
noted in your email.  What I thought was happening is that since my tables
are small, I was getting the locking behaviour mentioned because rows in the
insert/select where on the same page.  I would very much like to hear if
that is the case.

Rick

-
/ Rick Mehalick   Senior Consultant
/ Shell Services International SSI-GPAX
/ Phone:  281-544-5092(WCK) 
/ Fax:281-544-2646(WCK)
/ email:  [EMAIL PROTECTED] 
-



-Original Message-
From: Philippe MORIN [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 12:38 AM
To: [EMAIL PROTECTED]
Subject: Tr: Concurrent insert/select with BDB


Hi 

I post once more this message, because I didn't receive any answer.

- Message d'origine - 
De : Philippe MORIN 
A : [EMAIL PROTECTED] 
Envoye : vendredi 9 fevrier 2001 09:49
Objet : Concurrent insert/select with BDB


Hi

I'm using MySQL 3.23.32 on Linux.
I try to run concurrent insert/select requests on BDB tables, but it doesn't
work.

I started mysqld with --bdb-shared-data option.

I run mysql on 2 clients (on the same computer). The first one runs a select
request and the second one runs an insert request.
If I use autocommit, the insert waits for the end of the select.
If I don't use autocommit, the insert waits for the commit of my first
client.

Did someone ever use concurrent insert/select with BDB databases ?
Are there some special parameters to initialize, to allow insert and select
at the same time (it doens't matter for me if my first client reads
duplicated records).

Thanks a lot !
__

Philippe Morin - Prologue Software (France)
Software Engineer
Email: [EMAIL PROTECTED]
Internet : http://www.prologue-software.com
___


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: BDB

2001-02-09 Thread Mehalick, Richard RE SSI-GRAX

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 International SSI-GPAX
/ Phone:  281-544-5092(WCK) 
/ Fax:281-544-2646(WCK)
/ email:  [EMAIL PROTECTED] 
-



-Original Message-
From: Michael Widenius [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 08, 2001 6:49 PM
To: Peter Zaitsev
Cc: [EMAIL PROTECTED]
Subject: BDB



Hi!

 "Peter" == Peter Zaitsev [EMAIL PROTECTED] writes:

Peter Hello mysql,
Peter   1) Today I tried to reload my tables with backuing up and
recovering
Peter   whole database by mysqldump - it seems like it does not work -
Peter   mysqld crashed during loading data back even after I've removed all
Peter   bad tables and bdb logs to have a clean system.

Peter   This looks like the same problem as I reported with insert test -
Peter   BDB hanges/crashes during huge multiple insert queries.
Peter   I've uploaded the mysqldump output wich crashes mysqld during load
Peter   to the secret directory as layers_la00.sql.gz.
Peter   The thing is after I've dumped the same data without the extended
Peter   insert I could load it back without any problems.

I will look at this as after the weekend.

Peter   2) Then I was loading the data from .sql file I saw the followings:

Peter onyx:/spylog/db # mysqladmin processlist | grep -v Sleep
Peter
+-+---++-++--+--
-+--
+
Peter | Id  | User  | Host   | db  | Command| Time | State
| Info
|
Peter
+-+---++-++--+--
-+--
+
Peter | 34  | root  | localhost  | la00| Field List | 494  | Repair
by sorting |
|
Peter | 36  | root  | localhost  | lacontrol   | Query  | 64   | System
lock   | insert into layers_la00.g00keywords (counter_id,keyword) values
(106339,'RSBAC') |
Peter | 38  | root  | localhost  | la00| Field List | 468  |
Waiting for table |
|
Peter | 39  | root  | localhost  | layers_la00 | Query  | 0| update
| INSERT INTO g03dirs VALUES
(110912,8288,'pictures/company/itartass/calendar')|
Peter | 81  | root  | localhost  | la00| Field List | 296  |
Waiting for table |
|
Peter | 121 | titan | php.local  | counter | Query  | 5| System
lock   | SELECT lsh.begin AS period, sh.hosts7d,sh.visitors7d
Peter  FROM layers_la00.g00layers_stat_hits
AS ls |
Peter | 125 | root  | localhost  | | Query  | 0|
| show processlist
|
Peter
+-+---++-++--+--
-+--
+

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
Peter lock time several tenths of seconds) this can nothing to do with
Peter recovery (this table was just created by mysqldump couple of minutes
Peter before) - I habe the only explanation which looks ok the  system lock
Peter takes place while many inserts are going to othe table (g03dirs) - as
Peter soon as the table changed all other queries which was in system lock
Peter state got a chance to run. The other thing is mysqldump does not uses
Peter lock tables to insert data so this looks like real perfomance
Peter (concurency) problem Some
Peter more examples:

The "System Lock" means that you got some problem with fnctl() on your
system.

The fix is to restart mysqld with --skip-locking and without
--enable-locking to ensure that fcntl() lock is not used.

If you are using 'mysqldump --opt', it should generate locks for the
tables.  What command did you use ?

Peter onyx:/spylog/db # mysqladmin processlist | grep -v Sleep
Peter
+-+---++-+-+--++

--+
Peter | Id  | User  | Host   | db  | Command | Time | State  |
Info
|
Peter
+-+---++-+-+--++

--+
Peter | 36  | root  | localhost  | lacontrol   | Query   | 384  | update |
replace into layers_la00.g00stat_404refs (layer_id,id,visitors,loads,hits)
values
Peter (2,2,0,4,0),
Peter (2,9, |
Peter | 

RE: Start up MySQL in Transaction Mode

2001-01-30 Thread Mehalick, Richard RE SSI-GRAX

It is my understanding that if AUTOCOMMIT=1 then as long as you don't start
a transaction with BEGIN, all SQL statements act as if BDB was not being
used.  Of course you can't ROLLBACK a transaction either.

Rick

-
/ Rick Mehalick   Senior Consultant
/ Shell Services International SSI-GPAX
/ Phone:  281-544-5092(WCK) 
/ Fax:281-544-2646(WCK)
/ email:  [EMAIL PROTECTED] 
-



-Original Message-
From: Xin Li [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 29, 2001 2:37 PM
To: [EMAIL PROTECTED]
Subject: Start up MySQL in Transaction Mode


Hi,

MySQL supports transaction since 3.23, but we have to create BDB table
to benefit transaction. My question is,

Can we start up MySQL in transaction mode for a while rather than all of
time?

Because we're concerned about performance about BDB, do you guys
experiment any positive or negative feedback on that?

Thank you in advance.

--lix


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Berkeley Tables under NT!

2001-01-25 Thread Mehalick, Richard RE SSI-GRAX

I asked a week ago if BDB tables had ever been tested by the MySQL team on
RedHat 7.  Any ideas?  

-
/ Rick Mehalick   Senior Consultant
/ Shell Services International SSI-GPAX
/ Phone:  281-544-5092(WCK) 
/ Fax:281-544-2646(WCK)
/ email:  [EMAIL PROTECTED] 
-



-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 10:25 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Berkeley Tables under NT!


Harja Robert writes:
  I'd like to know if is possible to use Berkeley Tables under MySql Nt
  version and if the answer is YES, I'd like to know how do I install and
use
  these facility!
  Thanks!


Hi!

This feature for Win32 is in the works.


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaka, Cyprus
  /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
  /*/^^^\*\^^^
 /*/ \*\Developers Team

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




BDB Tables

2001-01-24 Thread Mehalick, Richard RE SSI-GRAX

Will someone from the MySQL team (or anyone with this knowledge) please tell
me if the test suite has been run with RedHat 7.0 and Berkeley tables?

I am currently running RedHat 6.2 and Berkeley tables and transactions DO
work.  I want to upgrade to RedHat 7.0, but not if transactions stop
working.

Please advise.

-
/ Rick Mehalick   Senior Consultant
/ Shell Services International SSI-GPAX
/ Phone:  281-544-5092(WCK) 
/ Fax:281-544-2646(WCK)
/ email:  [EMAIL PROTECTED] 
-



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php