Hello
Harrison Fisk from MySQL claims in this thread: http://forums.mysql.com/read.php?35,3981,4245#msg-4245
That there are no major differences between InnoDB and MVCC concurrency.
Is this true?
Thank you.
Tim
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly 5 6066
On 10/25/2004 11:53 AM, nd*****@student.hig.se wrote: Hello
Harrison Fisk from MySQL claims in this thread:
http://forums.mysql.com/read.php?35,3981,4245#msg-4245
That there are no major differences between InnoDB and MVCC concurrency.
Is this true?
From a functional point of view, the two appear to do the same thing.
The implementation is certainly different and has pros and cons into
both directions. The statement is absolutely accurate and also explains
why Postgres never had any sort of file structure repair tools. I would
even go further in that you don't want to repair any corrupted files, as
those repair operations might introduce breakage of referential
integrity of your data.
Jan Thank you.
Tim
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to ma*******@postgresql.org so that your message can get through to the mailing list cleanly
--
#================================================= =====================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================= = Ja******@Yahoo.com #
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
On Mon, Oct 25, 2004 at 01:15:33PM -0400, Jan Wieck wrote: On 10/25/2004 11:53 AM, nd*****@student.hig.se wrote:
Is this true?
From a functional point of view, the two appear to do the same thing.
Well, except for one difference. InnoDB will allow you refer to
tables not controlled by the InnoDB table handler, whereas we don't
have that problem with MVCC. So under MVCC, by definition, you can't
have partial transaction failures. (Or, more precisely, any such
partial failure is a bug in PostgreSQL, but in MySQL it might be a
feature.)
A
--
Andrew Sullivan | aj*@crankycanuck.ca
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.
--Brad Holland
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
On 10/25/2004 2:42 PM, Andrew Sullivan wrote: On Mon, Oct 25, 2004 at 01:15:33PM -0400, Jan Wieck wrote: On 10/25/2004 11:53 AM, nd*****@student.hig.se wrote:
>Is this true?
From a functional point of view, the two appear to do the same thing.
Well, except for one difference. InnoDB will allow you refer to tables not controlled by the InnoDB table handler, whereas we don't
That is a (mis)feature of MySQL itself, not of the InnoDB storage engine
if used in a mixed table type query by MySQL. InnoDB does not control
what is done in the "upper management" with the rows it returns from a
scan. This kind of abuse is as much InnoDB's fault as it is your fault
when your quite accurate work is merge-joined with marketing material
for decision making.
Jan
--
#================================================= =====================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================= = Ja******@Yahoo.com #
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
Andrew Sullivan wrote: On Mon, Oct 25, 2004 at 01:15:33PM -0400, Jan Wieck wrote:
On 10/25/2004 11:53 AM, nd*****@student.hig.se wrote:
Is this true?
From a functional point of view, the two appear to do the same thing.
Well, except for one difference. InnoDB will allow you refer to tables not controlled by the InnoDB table handler, whereas we don't have that problem with MVCC.
From MySQL gotchas:
1) And the same "feature" allow also to start a transaction, mix the two
tables and have a warning only after the "rollback" about the inability
destroy the updates done on non INNODB tables.
2) Create or delete and index or alter a table will recreate the entire
table.
3) Our rollback is a O(1) operation not O(N) where N is the operations
performed during the transaction
Regards
Gaetano Mendola
On Mon, Oct 25, 2004 at 03:45:40PM -0400, Jan Wieck wrote: That is a (mis)feature of MySQL itself, not of the InnoDB storage engine if used in a mixed table type query by MySQL.
Sure, but I think this difference is very far from plain in the
marketing literature promoting MySQL with InnoDB. You actually need
to understand the difference between MySQL and its storage engines to
understand why this is the case, and one can't really expect people
who are evaluating different systems to know all that sort of detail
in advance.
A
--
Andrew Sullivan | aj*@crankycanuck.ca
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.
--Brad Holland
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives? http://archives.postgresql.org This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Richard Gabriel |
last post by:
Hi all,
The following keeps happening and I can't pinpoint a query that is
causing it. It did not happen in 3.23.x, but started upon upgrading to
4.0.14. The operating system/hardware...
|
by: I.P. |
last post by:
Hi, it's my story.
I have two 4.0.14 mysql server on one machine with win XP Professional
polish version.
First acts as master: on port 3300
Second acts as slave: on port 3301
below my...
|
by: I.P. |
last post by:
No one has replied to my post.
----- Original Message -----
From: "I.P." <jancio_wodnik@wp.pl>
To: <mysql@lists.mysql.com>
Sent: Monday, August 18, 2003 1:01 PM
Subject: mysql 4.0.14 +...
|
by: Mairhtin O'Feannag |
last post by:
Hello,
I have a client (customer) who asked the question : "Why would I buy and
use UDB, when MySql is free?"
I had to say I was stunned. I have no experience with MySql, so I was
left sort...
|
by: jlee |
last post by:
I'm pretty much a newbie on mysql, and I need some help.
I am running mysql Ver 12.22 Distrib 4.0.24, for portbld-freebsd5.4
(i386) on a server hosting an active website.
The site's developer...
| |
by: Good Man |
last post by:
Hi there
I've noticed some very weird things happening with my current MySQL setup
on my XP Laptop, a development machine.
For a while, I have been trying to get the MySQL cache to work....
|
by: Dudu |
last post by:
Dear Programmers
I try to install mysql version 5.0 and I encountered with a problem
when I tried to start the service. I got error 1067.
I checked the log file and saw the following records...
|
by: Ike |
last post by:
Recently, I began using a different MySQL verver (i.e. different machine as
well as different version#, going from 4.12a to 4.1.9 max).
The following query used to work:
select firstname,...
|
by: jdresow |
last post by:
I installed MySQL on a windows server 2003, in an acxtive directory domain and I get error 32 which is a sharing error. I do not understand this and I am also adding the first several lines of my...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |