You might want to check out Baron Schwartz's maatkit:
http://maatkit.sourceforge.net/
It has scripts which let you take dumps and do restores using multiple
threads. It might help speed things up for you.
-Dan
On 2/15/08 1:55 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> Hi:
>
> I am
Did you get a chance to look at mysqlhotcopy?
http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html
?
M-
- Original Message -
From: "P. Evans" <[EMAIL PROTECTED]>
To:
Sent: Friday, February 15, 2008 11:50 AM
Subject: [EMAIL PROTECTED] locations
> Greetings,
> I've got a retail ope
Hi:
I am restoring a 10 million row table using a dump file
created via mysqldump. On a very fast server, It finishes in 8 hours.
Is it something normal ? I know the alternative to copy file
directly but here is not an option . So can I say mysql does
not have its own way for high performance
Are you currently dumping raw SQL? If so, how? One table at a time, or by
obtaining a lock on all tables?
If you're getting a lock on all tables now, I don't think anything would
change if you switched to a transactional engine like InnoDB and did the
same thing. The database is "frozen" for a
Greetings,
I've got a retail operation with mysql 5.0.22 on linux pc's across the
country, and i need some input on setting up a backup strategy, preferrably
without purchasing a package. We're currently using MyISAM, with the databases
being dumped to a filesystem on a separate drive, in cas
Dynamic SQL would work for Imbedding String for the IN clause.
That would be too messy for such a little query.
Here is a crazy suggestion
CREATE PROCEDURE additems ()
BEGIN
DECLARE grammatures VARCHAR(128) DEFAULT '7,12,1,13,2,5,14,21';
DECLARE newids VARCHAR(128);
SELECT GROU
At 07:55 AM 2/15/2008, you wrote:
Hi lists,
I have innodb tables with millions of records. How can i add index without
locking the table.
Saravanan
Saravanan,
I don't see any way of doing it without locking the table. Otherwise as
the index is being built, user's would be modifying, add
Since both of these work, I was wondering which one would be faster.
Here is an EXPLAIN on a similar test I did on one of my test tables.
(NO index on field1, WinXP, MySQL 5.0.41-community-nt, SQLyog query
window)
SELECT COUNT(*) FROM tblClients
(1660 row(s) returned)
(0 ms taken)
I've posted this problem before, but thought I had somehow addressed
it. Today however the problem returned. In a nutshell:
MySQL (version 5.0.45, on OS X 10.4.11, Xserve dual G5 2GHz) will
after either a day or three weeks of uptime, suddenly usage way more
CPU that it should. That is to s
Hi Shawn, all !
Shawn Cummings wrote (re-formatted):
If I have (2) tables. Like
GROUP , CODE
GRP1, AA
GRP1, AB
GRP1, AC
GRP2, BA
GRP2, BB
GRP2, BC
And;
USER , UCODE
ME, AA
ME, AC
YOU, AA
What's the best way to query to find out if "ME" has all codes in either of
the groups?
In other
Hi lists,
I have innodb tables with millions of records. How can i add index without
locking the table.
Saravanan
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
--
MySQL Ge
Shawn Cummings schrieb:
If I have (2) tables. Like
GROUP , CODE
GRP1, AA
GRP1, AB
GRP1, AC
GRP2, BA
GRP2, BB
GRP2, BC
And;
USER , UCODE
ME, AA
ME, AC
YOU, AA
What's the best way to query to find out if "ME" has all codes in either of
the groups?
In other words
Hello everyone!
Hopefully somone can enlight me, i am hanging on this vor a few hours now :/
i have this stored procedure:
CREATE PROCEDURE additems ()
BEGIN
DECLARE grammatures VARCHAR(128) DEFAULT '7,12,1,13,2,5,14,21';
DECLARE newids VARCHAR(128);
SELECT GROUP_CONCAT(a_id,newi
13 matches
Mail list logo
