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 queries pile up
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 8:38 PM
Subject: switch from gemini to innodb bottlnecks
I've recently
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, Linux
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
NuSphere
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 every
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. Did
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 for help
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
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.
Find in nusphere
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 needs
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't seem to find anything
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
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 types
-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.
While I'm
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, with their GCC 2.96-85
Same here, althogh
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 advisory against using gcc 2.96
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 don´t want to provoke any anger here, maybe i´m
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.
if you are downloading
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 bit sick of the current
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 properties
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 support the ACID PROPERTIES ( TRANSACTIONS
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)
I think you may be referring to material that predates Gemini's
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_DIR tag failed -1
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 directory I see this message
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:
cut
--
Brian Millett
- 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.
I get the following error
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.o
Assembler
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/export/home6
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../msgs-O3
-DDBUG_OFF -O6
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?
--
Jeremy D. Zawodny
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-5936 --
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 events
Pete
--
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 strings.h and the one defined in the mysql source. Apparently,
the one on my system
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()
defined in strings.h
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 Kuczynski
Sr
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: Currently in Beta testing
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
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 tables
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 PROTECTED]
Technical Yahoo - Yahoo
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
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 in the 3.23.37
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
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 Gemini
Goodday to you
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
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
handling is very
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
--
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
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
48 matches
Mail list logo