Nico,
please post more output. Maybe the SELECT from H.albero is just entering
InnoDB, and therefore the associated transaction has not yet started.
The output shows lots of file reads. There should be running queries visible
in other printouts.
Best regards,
Heikki
Oracle Corp./Innobase
Vitaliy,
- Original Message -
From: "Vitaliy Okulov" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, May 26, 2006 5:28 PM
Subject: innodb database crash
Hi all. I have some InooDB mysql crush logs, can somebody explain what
they mean?
Quote:
060525 18:09:43 Inn
Andrew,
a possible reason for the corruption is that you have enabled write caching
in the disk controller or in the disk, but those caches are not
battery-backed. Then a hard reboot may destroy the contents, and the
database becomes corrupt.
What kind of hardware are you using? Do you have
Hey guys...
Thanks a lot...
Guess I will stick with MySql then
harish
On 5/30/06, peter lovatt <[EMAIL PROTECTED]> wrote:
Hi
We have tables of 1.5M rows 25 fields, in heavy use with frequent inserts
and updates on a P4 with 1GB of RAM. Performance is fine, and the table size
is 400MB
Hi,
yes it makes a huge difference,
as the tables are stored in files and therefore if
the filesystem is case-insensitive (Windows) you can
use either case in your queries, while on a case-sensitive
filesystem (linux etc) you can't.
See: http://dev.mysql.com/doc/refman/5.0/en/cannot-find-table.htm
Dan Trainor wrote:
I highly suggest staying away from PHPMyAdmin.
:-\
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 10:23 +0200 30/5/06, Anthony wrote:
:-\
Very helpful - thanks.
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
What contemptible scoundrel has stolen the cork to my lunch?
-- W.C. Fields
-
On 21.05.2006 00:16 (+0100), Yves Goergen wrote:
> Hello,
> I'm using MySQL Query Browser on Windows XP to connect to a remote MySQL
> 4.0 and 5.0 database server, both on Linux. In Query Browser, I can
> check the options "Use SSL if available" but how do I know if it is
> available and used? I co
Dear MySQL,
I am interested in clustering for MySQL. This claims to offer the
redundancy scalability and performance we require.
One thing I am really disappointed at is that clustering seems not to
offer much Referential Integrity (RI). Specifically, Foreign Key
References.
For better o
[snip]
I need to store something like a couple of million rows is a
MySql
table. Is that ok or do I have to split them up. I intend to index each
of
the columns that I will need to access so as to speed up access.
Insertion
will be done only when there is very little or no load on the server
Thanks Dilipkumar,
the syntax works fine
mysql> grant file on *.* to 'wr'@'localhost';
so the "file" privilege is for ALL databases.
by the way, to allow "alter", the syntax is like :
mysql> grant alter on dr4.* to 'wr'@'localhost';
here the "alter" privilege is specific to a database, o
Hello
I could not find the answer through the online "Search the MySQL manual".
I run MySQL 4.1
In astronomy, RA and DEC are widely used coordinate names.
Then I try to add a column named "DEC" :
mysql> alter table my_table add dec float;
ERROR 1064 (42000): You have an error in your SQL syntax
[snip]
It seems that the reason is that "DEC" is a keyword standing for
"decimal". I do not understand why this cannot be allowed for a column
name.
[/snip]
There are several reserved keywords in MySQL, none of which are
recommended for column names. You can try the SQL statement using
backtick
Hello,
We are aware that some user require FK's and would like to see them
supported in MySQL Cluster.
We are hoping to offer this functionality initially through the MySQL
interface (not the NDB API) some time next year.
Look for announcements on the MySQL Cluster forum and mailing list for it'
At 12:47 pm +0100 30/5/06, Ben Clewett wrote:
>I am interested in clustering for MySQL. This claims to offer the redundancy
>scalability and performance we require.
>
>One thing I am really disappointed at is that clustering seems not to offer
>much Referential Integrity (RI). Specifically, For
Jimmy,
Thanks for the info. I'll look out for FK's in clustering and hopefully
we can do some testing at that time.
Regards,
Ben
Jimmy Guerrero wrote:
Hello,
We are aware that some user require FK's and would like to see them
supported in MySQL Cluster.
We are hoping to offer this func
Hi Gilles!
Just use `dec` and it will work fine. DEC is as you suspected a reserved
word and can only be used as column namne if you put it in
``-syntax.
Example:
create table astronomicalvskeywords (
`dec` float not null,
`ra` float not null
);
...will create:
desc astronomicalvskeywords;
Hi Yves, all!
Yves Goergen wrote:
On 21.05.2006 00:16 (+0100), Yves Goergen wrote:
Hello,
I'm using MySQL Query Browser on Windows XP to connect to a remote MySQL
4.0 and 5.0 database server, both on Linux. In Query Browser, I can
check the options "Use SSL if available" but how do I know if i
Firstly, I apologize for my incorrect db level grant in the syntax I posted.
Secondly, by going to mysql.com/grant I found the GRANT syntax page,
which states:
"The FILE, PROCESS, RELOAD, REPLICATION CLIENT, REPLICATION SLAVE,
SHOW DATABASES, SHUTDOWN, and SUPER privileges are administrative
pr
Is there a way to get the time spent in the server for each query? Write it
in a log or append it to the result ???
Thanks,
Deniz Ersoz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What's the error you are getting? What MySQL version are you using?
On 5/26/06, Neeraj <[EMAIL PROTECTED]> wrote:
Hi all
I have a table with following structure
CREATE TABLE `dsc` (
`ch_code` varchar(255) default NULL,
`name` varchar(255) default NULL,
`inof` blob
) ENGINE=Inn
I am using MySql 5.0.21-community Edition for widows XP. I can successfully
connect to the MySql Server as a root and create a database 'a'. Which creates
a directory 'a' under my mysql\data directory with a single file 'db.opt'. Now
dropping the database 'a' gives the following error
ERROR 10
http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html
-Sheeri
On 5/29/06, Michael Monaghan <[EMAIL PROTECTED]> wrote:
Hi,
I have a machine [Solaris 9 x86] that has MySQL v3.22.xx installed.
I am not familiar with the applications [quite a few] that use this
instance.
I need to install
If it worked on your test box, but not in production, what is
different about those 2 boxes? Common sense says "If it worked on one
box but not another, it's not the software, but a difference between
the 2 boxes."
And you can always file a bug report with MySQL or get a consultant
(through MySQ
People who've asked the same question have gotten the answer that it's
not possible with MySQL, if I'm remembering correctly.
-Sheeri
On 5/29/06, Ghaffar <[EMAIL PROTECTED]> wrote:
Hello all,
I have seen that there are some people asking the same question.
How to bind to multiple ip addresses
I went through a lot of trouble with Load data local infile... There are a
lot of things regarding Local that MySql does not allow due to security
reasons. As mentioned before this you could give us the error... that might
help
alternatively try out mysqlimport
http://dev.mysql.com/doc/refman/5.
Ah yes, the docs.
- Thank you.
~mm
On 5/30/06, sheeri kritzer <[EMAIL PROTECTED]> wrote:
http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html
-Sheeri
On 5/29/06, Michael Monaghan <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a machine [Solaris 9 x86] that has MySQL v3.22.xx installed.
On 30.05.2006 16:28 (+0100), Joerg Bruehe wrote:
> To find out whether your server(s) support(s) or not, you need to check
> the corresponding variables. All this is described in the manual,
> section "5.9.7. Using Secure Connections":
I still think that the client should actually inform me when
Hi Wang,
select 9.10*19.80 wrong result 1782001.97
if <= 9000.10*19.80 right result178201.98
This is similiar to sum(qty*unitpri) result .
Welcome to the world of floating point arithmetic. If you need such
precision, try MySQL 5.0, as it should
At 13:13 -0700 5/30/06, Jeremy Cole wrote:
Hi Wang,
select 9.10*19.80 wrong result 1782001.97
if <= 9000.10*19.80 right result178201.98
This is similiar to sum(qty*unitpri) result .
Welcome to the world of floating point arithmetic. If you need
wang shuming wrote:
Hi,
select 9.10*19.80 wrong result 1782001.97
if <= 9000.10*19.80 right result178201.98
This is very typical floating point error. Computers don't have
infinite precision or it would take infinite time to compute the
answer
You don't need to take it to 16 digits :
mysql 4 :
select 1/666;
+---+
| 1/666 |
+---+
| 0.00 |
+---+
mysql 5.0.18:
select 1/666;
++
| 1/666 |
++
| 0.0015 |
++
George Law
> -Original Message-
> From: Chris W [mailto:[EMAIL PROTECTED]
> Sent: Tuesd
Hi,
You don't need to take it to 16 digits :
mysql 4 :
select 1/666;
+---+
| 1/666 |
+---+
| 0.00 |
+---+
mysql 5.0.18:
select 1/666;
++
| 1/666 |
++
| 0.0015 |
++
Actually, this is an entirely different case, it's a matter of where
MySQL decides how m
George Law wrote:
You don't need to take it to 16 digits :
mysql 4 :
select 1/666;
+---+
| 1/666 |
+---+
| 0.00 |
+---+
mysql 5.0.18:
select 1/666;
++
| 1/666 |
++
| 0.0015 |
++
That has nothing to do with the precision of the calculation. It is due
At 13:46 -0700 5/30/06, Jeremy Cole wrote:
Hi,
You don't need to take it to 16 digits :
mysql 4 :
select 1/666;
+---+
| 1/666 |
+---+
| 0.00 |
+---+
mysql 5.0.18:
select 1/666;
++
| 1/666 |
++
| 0.0015 |
++
Actually, this is an entirely different case,
Setup
TITLES:
TITLE_ID
AUTHORS:
AUTHOR_ID
TITLE_AUTHOR:
(TITLE_ID,AUTHOR_ID)
Problem:
Given a title, I need to find all the authors who aren't connected with
that particular book.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
- Original Message -
From: "John Meyer" <[EMAIL PROTECTED]>
To: "List: MySQL"
Sent: Tuesday, May 30, 2006 5:09 PM
Subject: Query problem
Setup
TITLES:
TITLE_ID
AUTHORS:
AUTHOR_ID
TITLE_AUTHOR:
(TITLE_ID,AUTHOR_ID)
Problem:
Given a title, I need to find all the authors who are
Rhino wrote:
- Original Message - From: "John Meyer" <[EMAIL PROTECTED]>
To: "List: MySQL"
Sent: Tuesday, May 30, 2006 5:09 PM
Subject: Query problem
Setup
TITLES:
TITLE_ID
AUTHORS:
AUTHOR_ID
TITLE_AUTHOR:
(TITLE_ID,AUTHOR_ID)
Problem:
Given a title, I need to find all the aut
(Excuse the beginner's question, but I couldn't find an answer in the
documentation or in searching online. Please cc me on replies if
possible.)
Does mysql have a way to report on the last committed change to the
database? I gather there is no undo in databases, in the sense of an
editing undo,
You are right, the "DEC" is a reserved keyword in the MySQL system.
We use "DE" in our databases, which will be better then "DECL".
cheers,
Gilles MISSONNIER wrote:
Hello
I could not find the answer through the online "Search the MySQL manual".
I run MySQL 4.1
In astronomy, RA and DEC are w
At 15:46 +0200 5/30/06, Gilles MISSONNIER wrote:
Hello
I could not find the answer through the online "Search the MySQL manual".
I run MySQL 4.1
In the 4.1 manual, the reserved words are listed here:
http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html
"DEC" is in the list.
Identifier
41 matches
Mail list logo
