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 Messag

RE: Innobase compile problems

2001-03-15 Thread Mehalick, Richard RE SSI-GRAX
, Richard RE SSI-GRAX Cc: [EMAIL PROTECTED] Subject: RE: Innobase compile problems Rick, have you downloaded version 3.23.34 and not 3.23.34a? I downloaded 3.23.34a, untarred it, and mem0dbg.c was in innobase/mem directory. I have attached to this email a copy of mem0dbg.c. Are your Makefile's

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 >prob

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

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

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

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-5

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 Interna

RE: XML support under mySQL

2001-02-21 Thread Mehalick, Richard RE SSI-GRAX
. 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: > >

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] -

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 / P

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

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 test

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 I

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

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: [

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 workin

RE: 3.23.28-gamma Crash and data loss

2001-01-12 Thread Mehalick, Richard RE SSI-GRAX
The MySQL team recommended upgrading to 3.23.29 gamma, especially if using Berkeley DB. - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX / Phone: 281-544-5092(WCK) / Fax:281-544-2646(WCK) / email: [EMAIL PROTE

RE: MySQL transaction problem (Again...)

2001-01-11 Thread Mehalick, Richard RE SSI-GRAX
I have started testing MySQL 3.23.30g with latest MySQL provided Berkeley source (3.2.3g) I am using RedHat 6.2 and RPM source of MySQL. I compiled MySQL and altered my existing tables to BDB. So far my tests show that transactions are working. They are working for new BDB tables and the altere