Re: switch from gemini to innodb bottlnecks

2003-11-05 Thread Heikki Tuuri
ot Backup - hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ - Original Message - From: ""Nihal"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, November 05, 2003

switch from gemini to innodb bottlnecks

2003-11-05 Thread Nihal
I've recently switched from GEMINI to INNODB, to be able to get continued support and upgrades of MySQL. I'm running into to some major performance issues. The section in the MySQL manual is not very thorough on optimizing INNODB. I'm getting two problems, either all my querie

Re: gemini

2003-10-24 Thread Jeremy Zawodny
On Fri, Oct 24, 2003 at 05:04:28PM +1000, Chris wrote: > They gave up on it eh? > > Was that more because of the legal problems that happened, or due > to BDB and InnoDB continuing to improve and provide better solutions? Leagal issues, probably. -- Jeremy D. Zawodny | Perl, Web, MySQL, Lin

Re: gemini

2003-10-23 Thread Jeremy Zawodny
On Tue, Oct 21, 2003 at 05:22:07PM -0400, Gabriel Ricard wrote: > Someone recently asked about Gemini tables on this list and it got me > curious about what ever happened to that technology... NuSphere still > seems to exist, and they still sell their PHPEd product along with the &g

gemini

2003-10-21 Thread Gabriel Ricard
Someone recently asked about Gemini tables on this list and it got me curious about what ever happened to that technology... NuSphere still seems to exist, and they still sell their PHPEd product along with the "NuSphere Technology Platform" which appears to contain a build of MySQL

Re: GEMINI

2003-10-21 Thread Chris Nolan
Gemini other than what's in some old versions of the MySQL documentation (anyone want to point me in the direction of some solid info on what made this table type stand out?). However, from what I can tell, Gemini was closer to MS SQL and DB2, in that it depended on row locks for almost

GEMINI

2003-10-17 Thread Nihal
Can anyone tell me what happened to GEMINI? We've been customers of MySQL for a while and about two years ago started using Nusphere's version to take advantage of their row level locking/ACID transaction safe table type GEMINI. Things went well for a while but one day I came back fo

Gemini Table

2002-10-14 Thread Alexander Burbello
I would like to know what the exactly diference the ACID nomenclature. I read the mysql documentation, but it´s a little difficult to understand between C and D. Does anybody can explain. Tks. Greetings Alexander sql, query __

gemini/acid or innodb ?

2002-10-03 Thread David yahoo
Hello, I found an other table type for transaction : "The simplicity of ACID transactions is especially important in a distributed database environment where the transactions are being made simultaneously. Learn more about the Gemini table type that supports ACID Transactions."

Re: Gemini Tables and NuSphere Update

2002-02-21 Thread Heikki Tuuri
Hi! >> Or should I look at the InnoDB tables (which are still considered beta). InnoDB tables are classified as gamma by Innobase Oy and MySQL AB. The text on the MySQL-Max download page is lagging behind (says beta), but to balance it, on the front page MySQL AB classifies MySQL-Max as stable

Re: Gemini Tables and NuSphere Update

2002-02-21 Thread Jeremy Zawodny
On Thu, Feb 21, 2002 at 10:17:52AM -0600, Scalper wrote: > I am a new MySQL user, so forgive my stupidity for asking the > following question (perhaps taboo). What is the latest on NuSphere > vs MySQL AB? What about Gemini. I have searched everywhere for > info, but can&#x

Gemini Tables and NuSphere Update

2002-02-21 Thread Scalper
I am a new MySQL user, so forgive my stupidity for asking the following question (perhaps taboo). What is the latest on NuSphere vs MySQL AB? What about Gemini. I have searched everywhere for info, but can't seem to find anything after November of last year. I have serious need

Re: Gemini compile error

2001-11-22 Thread Arjen G. Lentz
Hi Ashley, - Original Message - From: "Ashley M. Kirchner" <[EMAIL PROTECTED]> > While compiling MySQL+Gemini-3.23.41 i received the following error: > [...] > System is RedHat 7.1, with their GCC 2.96-85 No idea about Gemini, but we do have an adviso

Re: Gemini compile error

2001-11-22 Thread Paul DuBois
At 9:43 AM +0100 11/22/01, Attila Beno wrote: >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > >On Thu, 22 Nov 2001, Ashley M. Kirchner wrote: > >> While compiling MySQL+Gemini-3.23.41 i received the following error: >> >> System is RedHat 7.1, wi

Re: Gemini compile error

2001-11-22 Thread Attila Beno
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 22 Nov 2001, Ashley M. Kirchner wrote: > While compiling MySQL+Gemini-3.23.41 i received the following error: > > System is RedHat 7.1, with their GCC 2.96-85 Same here, althogh the binary version starts up fine. >

Gemini compile error

2001-11-22 Thread Ashley M. Kirchner
While compiling MySQL+Gemini-3.23.41 i received the following error: gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../incl -I../msgs -O3 -DDBUG_OFF -c dsmindex.c In file included from dsmindex.c:39: /usr/include/string.h:245: parse error before `(' /usr/include/string.h:245: warning: conflicting

Re: GEMINI Table Type

2001-09-12 Thread Jeremy Zawodny
On Tue, Sep 11, 2001 at 03:29:00PM +0200, Henning Schroeder wrote: > At 11:03 11.09.01, you wrote: > > > does MYSQL.COM has a table type same as GEMINI ( GEMINI > > > >yes. MySQL contains support for BDB and InnoDB tables, that are > >transaction-safe. > > I

Re: GEMINI Table Type

2001-09-11 Thread Henning Schroeder
At 11:03 11.09.01, you wrote: > > does MYSQL.COM has a table type same as GEMINI ( GEMINI > >yes. MySQL contains support for BDB and InnoDB tables, that are >transaction-safe. I don´t want to provoke any anger here, maybe i´m still too new on the list. But actually, i´m a

Re: GEMINI Table Type

2001-09-11 Thread indrek siitan
Hi, > does MYSQL.COM has a table type same as GEMINI ( GEMINI > does not complies with GPL according to what I read) that support > the ACID PROPERTIES ( TRANSACTIONS ) (MyIsam, Inodb ?) ... yes. MySQL contains support for BDB and InnoDB tables, that are transaction-safe. i

Re: GEMINI Table Type

2001-09-10 Thread Paul DuBois
t;I notice they promote a type of table name GEMINI ... >that support the ACID properties ... > >What I understand is that MYSQL.COM <> MYSQL.ORG, but Correct. >does MYSQL.COM has a table type same as GEMINI ( GEMINI does not complies >with GPL according >to what I read)

Re: GEMINI Table Type

2001-09-10 Thread Benjamin Pflugmann
Hello. On Mon, Sep 10, 2001 at 09:20:55AM -0600, [EMAIL PROTECTED] wrote: [...] > What I understand is that MYSQL.COM <> MYSQL.ORG, but > does MYSQL.COM has a table type same as GEMINI ( GEMINI does not complies > with GPL according > to what I read) > that suppor

GEMINI Table Type

2001-09-10 Thread ROGGER ALEXIS VASQUEZ MARTINEZ
Hi : First of all I've test for a short period MYSQL, I think is great ,,, recently I was navigating MYSQL.COM and I found and read about the dispute with MYSQL.ORG I enter the site to see what it was ... I notice they promote a type of table name GEMINI ... that support the ACID prope

Re: Gemini Problems

2001-08-09 Thread Shane Wegner
On Thu, Aug 09, 2001 at 11:07:13PM -0400, Paul wrote: > I've compiled MySQL 3.23.39 with Gemini support. The compile was error > free although the 'make test' skipped the Gemini tests for some reason. In > the mysqld.err log from the test dire

Gemini Problems

2001-08-09 Thread Paul
I've compiled MySQL 3.23.39 with Gemini support. The compile was error free although the 'make test' skipped the Gemini tests for some reason. In the mysqld.err log from the test directory I see this message: 00:18:15 MSGS_DI

Re: mysql+gemini compile errors

2001-08-08 Thread Michael Furgal
- Delivering Enhanced MySQL -- > Hello, > SunOS shaka 5.8 Generic_108529-08 i86pc i386 i86pc > gcc version 2.95.3 20010315 (release) > > I'm trying to compile mysql+gemini-3.23.39 on a x86 Solaris 8 box. &

Re: mysql+gemini compile errors

2001-08-08 Thread Sinisa Milivojevic
Brian P. Millett writes: > Hello, > SunOS shaka 5.8 Generic_108529-08 i86pc i386 i86pc > gcc version 2.95.3 20010315 (release) > > I'm trying to compile mysql+gemini-3.23.39 on a x86 Solaris 8 box. > I get the following error which has me completly confussed: >

mysql+gemini compile errors

2001-08-07 Thread Brian P. Millett
Hello, SunOS shaka 5.8 Generic_108529-08 i86pc i386 i86pc gcc version 2.95.3 20010315 (release) I'm trying to compile mysql+gemini-3.23.39 on a x86 Solaris 8 box. I get the following error which has me completly confussed: ctstset: Compile tstset.cc --> tstset.[c|s] --> tstset.

Re: mysql 3.23.40-Solaris8-Gcc3.0 error compiling with gemini

2001-07-30 Thread Sinisa Milivojevic
Faine, Mark writes: > I'm trying to intall mysql 3.23.40 on Solaris 8 ( GCC 3.0 ) but I'm having a > little difficulty. Whenever it gets to the gemini directory it errors out > with the following: > > /usr/local/bin/gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../incl -I../msg

mysql 3.23.40-Solaris8-Gcc3.0 error compiling with gemini

2001-07-30 Thread Faine, Mark
I'm trying to intall mysql 3.23.40 on Solaris 8 ( GCC 3.0 ) but I'm having a little difficulty. Whenever it gets to the gemini directory it errors out with the following: /usr/local/bin/gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../incl -I../msgs-O3 -DDBUG_OFF -O6 -DHAVE_CURSES_H -I/ex

Re: gemini tables in mysql

2001-07-21 Thread Sinisa Milivojevic
Jeremy Zawodny writes: > On Fri, Jul 20, 2001 at 01:19:57PM +0300, Sinisa Milivojevic wrote: > Does this mean they'll re-appear in the manual as well? > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-593

Re: gemini tables in mysql

2001-07-21 Thread Jeremy Zawodny
On Fri, Jul 20, 2001 at 01:19:57PM +0300, Sinisa Milivojevic wrote: > > Yes, in 3.23.41 source tarball only. > > We will not put Gemini tables in our binaries due to several reasons > of which stability is just one. Does this mean they'll re-appear in the manual as well? -

Re: string errors compiling mysql+gemini-3.23.39 on Athlon running Linux 2.4.3-12

2001-07-20 Thread Shane Wegner
On Fri, Jul 20, 2001 at 06:44:29AM -0400, Jonathan Buhacoff wrote: > -- > >Description: > I get errors when I try to compile the distribution. The first one happens > in the gemini tree and is caused by a prototype mismatch between the bzero() &g

string errors compiling mysql+gemini-3.23.39 on Athlon running Linux 2.4.3-12

2001-07-20 Thread Jonathan Buhacoff
-- >Description: I get errors when I try to compile the distribution. The first one happens in the gemini tree and is caused by a prototype mismatch between the bzero() defined in and the one defined in the mysql source. Apparently, the one on my system take

Re: gemini tables in mysql

2001-07-20 Thread Sinisa Milivojevic
Pete Kuczynski writes: > Hi, > since Nusphere release the source code for gemini yesterday I believe it > was, I was wondering if Mysql AB was going to incorporate it into a > future release if it's database. > > I realise in light of recent .org

gemini tables in mysql

2001-07-19 Thread Pete Kuczynski
Hi, since Nusphere release the source code for gemini yesterday I believe it was, I was wondering if Mysql AB was going to incorporate it into a future release if it's database. I realise in light of recent .org events Pete -- ___ Pete Kuczyns

Re: InnoDB, BDB, and Gemini

2001-05-13 Thread Jeremy Zawodny
On Fri, May 11, 2001 at 11:39:32AM -0700, Eric J. Schwertfeger wrote: > > Aside from what's in the manual, I have a little to offer. I just > got InnoDB working yesterday, so take what I have to say with a > grain of salt. And I'll add a bit, too. :-) > Gemini: Curren

Re: MYISAM v.s. GEMINI Tables

2001-05-12 Thread Jeremy Zawodny
e > there is no chance of me starting/stopping a clock watch at the > wrong time, etc etc. Just for the record, I've seen similarly good performance in my Gemini testing. But I seem to be more skilled at breaking it than using it. :-( Jeremy -- Jeremy D. Zawodny, <[EMAIL PROT

Re: MYISAM v.s. GEMINI Tables

2001-05-12 Thread BAUMEISTER Alexandre
Bonjour Warren, What about InnoDB tables ? Could you change the TYPE to INNODB and run the same test ? This would be great to compare MYISAM, GEMINI and INNODB. Regards, Alex. WvdM> Goodday to you all WvdM> For those that are interested, I have managed to get my GEMINI

MYISAM v.s. GEMINI Tables

2001-05-12 Thread Warren van der Merwe
Goodday to you all For those that are interested, I have managed to get my GEMINI tables working successfully, and changed one of my reports to use the MYSQL tables instead of my original MSACCESS ones. Had a couple problems with the initial altering of some tables from MYISAM to GEMINI, but

Re: InnoDB, BDB, and Gemini

2001-05-11 Thread Eric J. Schwertfeger
On Fri, 11 May 2001, Kevin McBrearty wrote: > I have re-read the appropriate manual sections several times, trying to > decide what is the best option for my database table types. I am using > 3.32.37 on > Linux, and am torn between InnoDB, BDB, and Gemini table types. Transaction &

RE: InnoDB, BDB, and Gemini

2001-05-11 Thread Warren van der Merwe
In all honesty, I have personally not done any testing of Gemini v.s. other types as yet. I am busy converting my app from MS Access to MYSQL, once this is finished I will then be in a better position to answer this as I can test it. Regards Warren ~ Warren van

RE: InnoDB, BDB, and Gemini

2001-05-11 Thread Robert Henkel
Have you noticed a significant speed decline using Gemini tables? RH -Original Message- From: Warren van der Merwe [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 11:31 AM To: 'Steve Ruby'; 'Kevin McBrearty'; [EMAIL PROTECTED] Subject: RE: InnoDB, BDB, and Gem

RE: InnoDB, BDB, and Gemini

2001-05-11 Thread Warren van der Merwe
Goodday to you all Gemini tables are busy being beta tested, and therefore are available. I personally use them and so far so good. I really love having row level locking in MYSQL, and it works like a dream. contact www.nusphere.com for more info. There are currently running with 3.23.36 Enjoy

Re: InnoDB, BDB, and Gemini

2001-05-11 Thread Steve Ruby
InnoDB definately provides more features that BDB, and is probably going to be faster, Gemini isn't available yet. BDB might be more complete/stable. So I'd say Gemini is out of the picture unless you are looking longer term. I'd do some testing with both we found some bugs

InnoDB, BDB, and Gemini

2001-05-11 Thread Kevin McBrearty
I have re-read the appropriate manual sections several times, trying to decide what is the best option for my database table types. I am using 3.32.37 on Linux, and am torn between InnoDB, BDB, and Gemini table types. Transaction handling is very important for my application (commit, rollback

Comparison of BDB/Gemini/Innobase tables?

2001-03-12 Thread Ray Cote
Can someone point me to a comparison of the three different transaction-based table types in MySQL? It is unclear from the on-line documentation what the benefits/features/limitations are for each of these types. Thanks Ray -- --

gemini

2001-01-29 Thread Andrei Cojocaru
Where can we find more information about gemini and when it will be done exactly (date)? -- -Spinlock EmpireQuest Creator http://www.empirequest.com - Before posting, please check: http://www.mysql.com/manual.php (the

Date for Gemini project

2001-01-29 Thread Patrick FICHE
Hi, Does anyone have an idea of the date when the developments of Gemini project will be integrated into MySQL ? Will it be integrated in the MySQL 4.0 version ? Will it be integrated in the standard MySQL sources without changing the license agreement ? I read that this project resulted in the