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
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
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 returned from
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 what you stored
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 did:
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?).
Hmm, could be.
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 what is the
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
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
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
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:
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
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
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
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
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]
Sent:
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
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, so using
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
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
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
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.
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
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 the
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
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
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
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
28 matches
Mail list logo