Dear all,
Is it possible to take backups of a table or complete database without
stopping the application that continuously inserts and select data from
the tables.
For taking complete backup of a database I follow the below steps :-
1. First stop the application that insert modifies
Hi Adarsh,
I think this is the best option for you:
http://www.percona.com/docs/wiki/percona-xtrabackup:start
There is also a commercial alternative, InnoBackup, but I imagine you like
it free.
Cheers
Claudio
On Jun 7, 2011 7:59 AM, Adarsh Sharma adarsh.sha...@orkash.com wrote:
Dear all,
Is
Can you tell us which storage engine you are using?
On Tue, Jun 7, 2011 at 11:30 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote:
Dear all,
Is it possible to take backups of a table or complete database without
stopping the application that continuously inserts and select data from the
Hi
We use the --single-transaction switch thinking it does less locking or waiting
for a required table lock. You then get a snapshot without stopping.
Subject should have included the word 'hot'? Looking forward to other
suggestions.
Mark
On 2011/06/07 08:00, Adarsh Sharma wrote:
Dear all,
Both MYISAM Innodb Engines are used.
Thanks
Nilnandan Joshi wrote:
Can you tell us which storage engine you are using?
On Tue, Jun 7, 2011 at 11:30 AM, Adarsh Sharma
adarsh.sha...@orkash.com mailto:adarsh.sha...@orkash.com wrote:
Dear all,
Is it possible to take backups of a
- Original Message -
From: Claudio Nanni claudio.na...@gmail.com
I think this is the best option for you:
http://www.percona.com/docs/wiki/percona-xtrabackup:start
I must say, I still haven't looked very well at xtrabackup. How does it take
consistent backups of MyISAM tables? I
Johan De Meersman wrote:
- Original Message -
From: Claudio Nanni claudio.na...@gmail.com
I think this is the best option for you:
http://www.percona.com/docs/wiki/percona-xtrabackup:start
I must say, I still haven't looked very well at xtrabackup. How does it take
- Original Message -
From: Adarsh Sharma adarsh.sha...@orkash.com
Not getting U'r point marked as bold Underline
I checked up in the mean time, and it does not make a truly consistent backup
of MyISAM - it locks all tables - yes, ALL tables - and then copies the files.
Given that
Hi All,
We have very big table with few column contains nearly 10 million records, We
need to tune this table for simple select statement where we check record
exists in table or not and requirement is response time should be less than 10
million second for nearly 1000 concurrent requests,
Hi Anupam,
how do you load data? is it naturally ordered in any way?
Claudio
2011/6/7 Anupam Karmarkar sb_akarmar...@yahoo.com
Hi All,
We have very big table with few column contains nearly 10 million records,
We need to tune this table for simple select statement where we check record
On Jun 6, 2011, at 10:06 PM, Johan De Meersman wrote:
What exactly do you mean by removing the NULL default? Did you set your
colums NOT NULL?
Yes. That's all I did.
Marc
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
On Jun 6, 2011, at 10:06 PM, Johan De Meersman wrote:
What exactly do you mean by removing the NULL default? Did you set
your colums NOT NULL?
Yes. That's all I did.
In stead of getting info drop-by-drop, you might want to share the output of
SHOW CREATE TABLE...,, but my guess
Dear all,
I wish to create a new table from a table that has two columns
country and person_name. Thus from the table below, I'd like to
select all the records of those countries that have person names 'Tom'
and 'Kevin'.
country person name
US Antony
US Tom
Why not GROUP BY?
On Jun 7, 2011, at 10:06 PM, joe j wrote:
Dear all,
I wish to create a new table from a table that has two columns
country and person_name. Thus from the table below, I'd like to
select all the records of those countries that have person names 'Tom'
and 'Kevin'.
Thanks, but I don't see how it will work. Am I missing something?
On Tue, Jun 7, 2011 at 5:24 PM, Willy Mularto sangpr...@gmail.com wrote:
Why not GROUP BY?
On Jun 7, 2011, at 10:06 PM, joe j wrote:
Dear all,
I wish to create a new table from a table that has two columns
country and
ok. here's what I am trying now. First create a table with the code
below with a list of countries that have the two person names I want.
CREATE TABLE `table_new` SELECT t1.country
FROM `table_old` as t1
JOIN
`table_old` as t2
USING(country)
JOIN
`table_old` as t3
USING(country)
WHERE
- Original Message -
From: Claudio Nanni claudio.na...@gmail.com
how do you load data? is it naturally ordered in any way?
Also, what's the record structure, and what are the criteria you use to check
if a record exists?
If you only need to know wether a given record exists, your
- Original Message -
From: sono...@fannullone.us
Yes. That's all I did.
If that's all you did, you indeed 'removed the default NULL' but did not
specify another default. Hence, if you don't explicitly specify a value in your
insert statement, the insert can not happen as the server
18 matches
Mail list logo