Hi guys,
I am getting very frequent deadlock in mysql 5.1.37. I am not able to
understand why this below deadlock is coming.
*** (1) TRANSACTION:
TRANSACTION 0 1036157191, ACTIVE 0 sec, process no 4101, OS thread id
1908412736 fetching rows
mysql tables in use 1, locked 1
LOCK WAIT 3 lock
You can't make the database, table or field names dynamic with
prepare, only values. Prepare allows you to cache the execution plan,
which wouldn't be valid on a different table.
On Mon, Sep 14, 2009 at 7:09 AM, Manasi Save
manasi.s...@artificialmachines.com wrote:
Hi All,
I have a query about
Hi everyone,
I have an application that spawns various threads for inserting into various
table. Additionally, another thread is launched to delete old records.
They all use JPA and entity managed transactions. I think I'm getting
locking issues, but I'm not sure. So, I'd like to get your
Maybe one of you experts know the answer.
I have a Innodb database that I want to back up. Is there a free tool to
do this?
mysqlhotbackup is a paid tool, is that the only one available?
If I do a mysqldump of the innodb databse, will I be avail to uploaded into
a myisam
database and will it
Sorry, I meant to say that the backup DB does not look the same as the
original DB.
Maybe it has to do with what Todd and Mychael mentioned.
The percona tool does not work on Windows OS. I could not find a windows
executable.
Thanks,
Nestor :-)
On Mon, Sep 14, 2009 at 9:13 AM, Néstor
If I may,
If you have foreign keys on your InnoDB, you can still import your
data to MyISAM but foreign keys will be lost. Otherwise, the data
will load just fine.
- michael dykman
On Mon, Sep 14, 2009 at 11:14 AM, Todd Lyons tly...@ivenue.com wrote:
On Mon, Sep 14, 2009 at 7:44 AM, Néstor
I did it again and using sqlyog did work.
I also found out that the tool that comes with mysql admin 1.1 also has
a backup tool that works.
Thanks to all,
Nestor :-)
On Mon, Sep 14, 2009 at 9:16 AM, Néstor rot...@gmail.com wrote:
Sorry, I meant to say that the backup DB does not look the
I tried this but when I upload the backup it just does not look the same.
Thanks,
Nestor :-
On Mon, Sep 14, 2009 at 8:04 AM, prathiman...@vsnl.net wrote:
Use sqlyog its a freeware
Sent from my BlackBerry® on Reliance Mobile, India's No. 1 Network. Go for
it!
-Original Message-
On Mon, Sep 14, 2009 at 11:15 PM, Kaushal Shriyan
kaushalshri...@gmail.comwrote:
Hi,
I have enabled ubuntu backports in Ubuntu 8.04 to install mysql-5.1
server, but i dont find it after apt-get update ?
Please suggest/guide
Thanks,
Kaushal
Hi, the options from discussion in Ubuntu
On Mon, Sep 14, 2009 at 7:44 AM, Néstor rot...@gmail.com wrote:
Maybe one of you experts know the answer.
I have a Innodb database that I want to back up. Is there a free tool to
do this?
mysqlhotbackup is a paid tool, is that the only one available?
You can also use the free tool from
-Original Message-
From: AndrewJames [mailto:andrewhu...@gmail.com]
Sent: Saturday, September 12, 2009 1:20 AM
To: Kyong Kim; Arthur Fuller
Cc: Claudio Nanni; mysql
Subject: Re: database design
thank you all, i think
You probably wouldn't need Article_Type table if you're going to store
Hi,
I have enabled ubuntu backports in Ubuntu 8.04 to install mysql-5.1
server, but i dont find it after apt-get update ?
Please suggest/guide
Thanks,
Kaushal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
On Mon, Sep 14, 2009 at 8:28 AM, Michael Dykman mdyk...@gmail.com wrote:
If I may,
If you have foreign keys on your InnoDB, you can still import your
data to MyISAM but foreign keys will be lost. Otherwise, the data
will load just fine.
Very good point. My comment was based on the possibly
A mysqldump will work just fine. By default, that dump is going to
explicitly specify the table type .. you will have to edit it if you
want to import to MyISAM.
- michael dykman
On Mon, Sep 14, 2009 at 10:44 AM, Néstor rot...@gmail.com wrote:
Maybe one of you experts know the answer.
I
I'm pulling in a date with the following format
9/14/2009 2:12:48 PM
And using this mask to convert it using the str_to_date() function:
%e %m %Y %r
but it keeps giving me an error. Do I have the right mask?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
In the last episode (Sep 14), John Meyer said:
I'm pulling in a date with the following format
9/14/2009 2:12:48 PM
And using this mask to convert it using the str_to_date() function:
%e %m %Y %r
but it keeps giving me an error. Do I have the right mask?
Nope. Assuming your input string
Dan Nelson wrote:
In the last episode (Sep 14), John Meyer said:
I'm pulling in a date with the following format
9/14/2009 2:12:48 PM
And using this mask to convert it using the str_to_date() function:
%e %m %Y %r
but it keeps giving me an error. Do I have the right mask?
Nope.
17 matches
Mail list logo