Hello! Have this anwer from mysql,
++
| TIMEDIFF(Date,now()) |
-++
| 70:56:06 |
++
Is it possible to
- Original Message -
From: Rocio Gomez Escribano r.go...@ingenia-soluciones.com
Hello! Have this anwer from mysql,
++
| TIMEDIFF(Date,now()) |
-++
| 70:56:06 |
Hi Folks,
I am trying to change the datadir for mysql. For this I performed the following
steps:
1: Create a new location for my datadir, e.g.: /media/spare/databases
2: Changed the ownership and permissions of this directory, e.g. chown -R
mysql:mysql /media/spare/databases and chmod -R 755
Hi all,
yesterday the mysql process on a database server became totallly unresponsive
after some long semaphore waits (load/cpu/memory were OK, as were all other
processes). The debug output started with this:
InnoDB: Warning: a long semaphore wait:
--Thread 140054029002496 has waited at
This may be entirely down the wrong path, but I seem vaguely to remember that
RedHat has the datadir and stuff (semi-) hardcoded in /etc/init.d/mysql.
- Original Message -
From: Mario Deng mariod...@googlemail.com
To: mysql@lists.mysql.com
Sent: Tuesday, 24 May, 2011 1:08:41 PM
- Original Message -
From: r...@grib.nl
I may be wrong here, but I tend to interpret this as '140054029002496' is
trying to get an exclusive lock on 0x78733f8, on which it already has an
exclusive lock, and hence is deadlocked in some manner. Am I right there? How
can this happen?
I may be wrong here, but I tend to interpret this as '140054029002496' is
trying to get an exclusive lock on 0x78733f8, on which it already has an
exclusive lock, and hence is deadlocked in some manner. Am I right
there? How can this happen?
I'm not too hot on the internals, but yes,
- Original Message -
From: Rik Wasmus r...@grib.nl
2 simultaneous queries with the same thread-id? Is that possible?
No, not with the same thread-id. Deadlock occurs when two threads attempt to
lock the same resources, but do so in an order which causes both sides to hold
part of
It looks like there’s no way to rename a database. Is that true?
I have two reasons for wanting to do this:
- I want to get a current version of a database out of the way so that I can
load in an older version, without having to pay the penalty of reloading the
current version.
- I
Instead of renaming it, revoke permissions to it. If it's being used you
should see some problems in the application due to access denied.
Andy
On Tue, May 24, 2011 at 4:19 PM, Jerry Schwartz je...@gii.co.jp wrote:
It looks like there’s no way to rename a database. Is that true?
I have two
- Original Message -
From: Jerry Schwartz je...@gii.co.jp
It looks like there’s no way to rename a database. Is that true?
Yes. Silly oversight, although there's probably complexity reasons behind it.
- I want to get a current version of a database out of the way so
that I can load
On 2011-05-24 16:30:13 you wrote:
2 simultaneous queries with the same thread-id? Is that possible?
No, not with the same thread-id. Deadlock occurs when two threads attempt
to lock the same resources, but do so in an order which causes both sides
to hold part of the resources the other
- Original Message -
From: Rik Wasmus r...@grib.nl
OK, but that would mean that the answer to the question:
I may be wrong here, but I tend to interpret this as
'140054029002496' is trying to get an exclusive lock on 0x78733f8, on which
it already has
an exclusive lock, and
-Original Message-
From: Johan De Meersman [mailto:vegiv...@tuxera.be]
Sent: Tuesday, May 24, 2011 11:52 AM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Renaming a database?
- Original Message -
From: Jerry Schwartz je...@gii.co.jp
It looks like there's no way to
-Original Message-
From: Andrew Moore [mailto:eroomy...@gmail.com]
Sent: Tuesday, May 24, 2011 11:31 AM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Renaming a database?
Instead of renaming it, revoke permissions to it. If it's being used you
should see some problems in the
Could you try restoring the other db with another name and changing the
connection string in the app?
On 24 May 2011 16:20, Jerry Schwartz je...@gii.co.jp wrote:
It looks like there’s no way to rename a database. Is that true?
I have two reasons for wanting to do this:
- I want to get a
From: Andrew Moore [mailto:eroomy...@gmail.com]
Sent: Tuesday, May 24, 2011 2:56 PM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Renaming a database?
Could you try restoring the other db with another name and changing the
connection string in the app?
[JS] I could, but it
-Original Message-
On Tue, May 24, 2011 at 4:19 PM, Jerry Schwartz je...@gii.co.jp wrote:
It looks like there’s no way to rename a database. Is that true?
I know. Retarded right? Version 5.1.x and still what would seem the most basic
of tasks is still impossible.
Maybe Oracle can
18 matches
Mail list logo
