I failed over the server and ran a short backup and there were no
"didn't compare" errors where on the first server, they are there
pretty reliably. I guess this confirms some hardware on the first
server is flipping bits. Essentially, users could have any number of
munged files (most files are
Sure, but that wasn't really the question.
-Original Message-
From: Michael Dykman [mailto:[EMAIL PROTECTED]
Sent: Monday, September 17, 2007 2:56 PM
To: Robert DiFalco
Cc: Baron Schwartz; mysql@lists.mysql.com
Subject: Re: Rollback on a Transaction with No Updates
If your transaction ar
I guess I will watch it closely for now and if it trips up again
failover to the drbd peer and see what happens there. I suppose I
could even deattach the local disks and have it run using the peer
over the wire. That should eliminate the local I/O subsystem.
It's kind of scary there is no en
Is there any difference between calling rollback or commit on a
transaction that did not alter data? For example, not a read-only
transaction but a transaction that only performed read-only selects. Any
difference in performance between calling rollback or commit? I know
they are functionally the s
If your transaction are only 1 query deep, why use them at all? An
individual query is already atomic, regardless of table type/server
mode.
- michael dkyman
On 9/17/07, Robert DiFalco <[EMAIL PROTECTED]> wrote:
> While it is functionally equivalent I wonder if it the code paths taken
> are th
While it is functionally equivalent I wonder if it the code paths taken
are the same. I suppose for both commit and rollback mysql would have to
look for any pending work, if there were none both would do nothing.
That's what makes me think that there is probably no performance
difference between t
I'm noticing, that the problem lies with my server getting blocked,
because of too many bad tries.
Could that be, that after some time, this is not shown as an error
anymore, and the client just waits there forever?
It seems that I'm only getting blocked when the load is high on the
server. I'
Robert DiFalco wrote:
Is there any difference between calling rollback or commit on a
transaction that did not alter data? For example, not a read-only
transaction but a transaction that only performed read-only selects. Any
difference in performance between calling rollback or commit? I know
the
Just a quick note to add to this conversation:
Pete Harlan wrote:
On Fri, Sep 14, 2007 at 01:33:51AM -0700, Jeremy Cole wrote:
MySQL's optimizer cannot reorder the joins because it has the potential
to change the result of the query.
Not in all cases. If a LEFT JOIN query also has a WHERE cl
Hi Maurice,
If you're running into corruption both in ext3 metadata and in MySQL
data, it is certainly not he fault of MySQL as you're likely aware.
I am hoping they are not related. The problems with MySQL surfaced
almost immediately after upgrading to 5.0.x.
It's possible that they are no
On Fri, Sep 14, 2007 at 01:33:51AM -0700, Jeremy Cole wrote:
> Hi Shawn, Lucio,
>
> >SELECT STRAIGHT_JOIN
> >FROM ...
> >LEFT JOIN ...
> >WHERE ...
> >...
>
> Just to correct a point here... if a query uses only LEFT JOIN or RIGHT
> JOIN, the join order is fixed by the query's order itself,
Jasper does have a commercial offering, but it is still an open source
project.. (readers of this list may be familiar with the arrangement)
I'm not sure what license they are using these days (used to be GPL)
but the web site is a little counter-intuitive.
- michael
On 9/17/07, Daevid Vincent
It's not "free" in that you have to buy the product, but it is "free" in
that you make ONE report and get multiple export modules that you don't have
to write yourself. That alone is awesome!
http://www.jaspersoft.com
:)
> -Original Message-
> From: chombee [mailto:[EMAIL PROTECTED]
>
Hi Maurice,
If you're running into corruption both in ext3 metadata and in MySQL
data, it is certainly not he fault of MySQL as you're likely aware.
I am hoping they are not related. The problems with MySQL surfaced
almost immediately after upgrading to 5.0.x.
[details deleted]
You can s
Hi Maurice,
Do you mean a Serially-Attached SCSI aka SAS controller, I assume?
Is this a custom build machine or a vendor integrated one?
Regards,
Jeremy
Maurice Volaski wrote:
On Sep 17, 2007 13:31 -0400, Maurice Volaski wrote:
In using drbd 8.0.5 recently, I have come across at least tw
Hi Maurice,
If you're running into corruption both in ext3 metadata and in MySQL
data, it is certainly not he fault of MySQL as you're likely aware.
There are absolutely many places where corruption could occur between
MySQL and the physical bits on disk. The corruption you're seeing does
n
On Sep 17, 2007 13:31 -0400, Maurice Volaski wrote:
In using drbd 8.0.5 recently, I have come across at least two
instances where a bit on disk apparently flipped spontaneously in the
ext3 metadata on volumes running on top of drbd.
Also, I have been seeing regular corruption of a mysql dat
Hey guys,
I'm using SSL encrypted MySQL connections between my Servers. Suddenly
today, the connection to one of my servers stopped working.
When I try to connect from the outside, I enter the password, and then
nothing happens, it just stays blank:
# mysql -h beta.kilu.de -p
Enter password:
In using drbd 8.0.5 recently, I have come across at least two
instances where a bit on disk apparently flipped spontaneously in the
ext3 metadata on volumes running on top of drbd.
Also, I have been seeing regular corruption of a mysql database,
which runs on top of drbd, and when I reported t
Hi,
John Comerford wrote:
Hi Folks,
My problem is that the IS_FREE_LOCK always returns true.
I have done some testing with two instances of the Query Browser
running. In one I execute:
SELECT GET_LOCK('testing',10)
> 1
In the second I execute :
SELECT IS_FREE_LOCK('testing');
> 1
Ma
Can anyone recommend an easy, free way to generate reports from a MySQL
database in a nicely readable form? e.g. in plain text, HTML, PDF, or
even visualised in the form of graphs and charts.
For example, if I have constructed several queries and want to run them
and export all of their results to
On 9/16/07, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi Baron,
>
> Still i am able to connect through the following command.
> mysql -h 192.168.1.10 -u test -p test
>
> although drop user can be used to drop the user but revoke command should
> work properly. I don't understand wha
> > > I currently use MyISAM, but I just tried a simple
> > > create(InnoDB)/show full columns from/ and
> > > it actually does return the JSON strings I put in.
> >
> > Try it on columns with a foreign key constraint.
>
> I did and it still works (maybe the behaviour is version
> dependent?).
> > I currently use MyISAM, but I just tried a simple
> > create(InnoDB)/show full columns from/ and
> > it actually does return the JSON strings I put in.
>
> Try it on columns with a foreign key constraint.
I did and it still works (maybe the behaviour is version
dependent?).
Here is what I di
> > > Do you have any comments about this approach?
> > > What could possibly go very bad about relying on
> > > this usage of the COMMENT?
> >
> > Yes, in different storage engines, different stuff is returned.
> >
> > For example, in InnoDB, what you get returned from
> > SHOW FULL COLUMNS is not
On 9/17/07, Martijn Tonies <[EMAIL PROTECTED]> wrote:
> > Do you have any comments about this approach?
> > What could possibly go very bad about relying on
> > this usage of the COMMENT?
>
> Yes, in different storage engines, different stuff is returned.
>
> For example, in InnoDB, what you get re
Hi,
> I'm thinking of using the "COMMENT" of columns when
> creating tables to store some metadata about the
> column, for instance: valid_range of numbers,
> validation regexp, etc.
>
> I did some tests with including this information as
> a JSON (JavaScript Object Notation) string which can
> th
Hi,
I'm thinking of using the "COMMENT" of columns when
creating tables to store some metadata about the
column, for instance: valid_range of numbers,
validation regexp, etc.
I did some tests with including this information as
a JSON (JavaScript Object Notation) string which can
then be easily de
28 matches
Mail list logo
