If the table has a primary key column then i would do this.
cursor cursor_name select primary_key_column from tabl_name where id <
300;
open
fetch into a_variable;
delete from table_name where primary_key_column=a_variable;
commit for every 1000 records;
exit when cursor does not fetch any m
Hello all,
I recent started employment with a company which has a lot of mysql
servers (100+ is my best estimate so far) and have all of their
database servers, masters and slaves alike, using one of 2 SANs for
data storage. They servers are connected to dedicated switches with
fibre to to SANs
2 items
I would increase bump key_buffer_size as suggested here
http://dev.mysql.com/doc/refman/5.1/en/delete-speed.html
also TRUNCATE instead of DELETE where TRANSACTION is not active
Martin
__
Disclaimer and confidentiality note
Everything in this
Hello
I would not recommend delete massive numbers of records in a single sql
statement. I have had problems doing this on a system with few records (1.7
million) and doing a delete with a condition clause of "where 1 = 1". The
server had problems with this.
The MySQL server is probably buil
Hi all,
I have a table I needed to prune because it had grown to 5 million rows and
it appeared that that app that uses it couldnt anymore.
I am in the process of:
DELETE FROM mytable WHERE id < 300;
the above has been running for close than an hour and I am starting to get a
little nervou
Hello,
Check out:
--replicate-do-db=db_name
http://dev.mysql.com/doc/refman/5.0/en/replication-options.html
-- Jimmy
Kandy Wong wrote:
Hi,
Is there a replication setup method just to replicate a specific
database not all the databases or exclude a specific database not to be
replicated?
Hi,
Is there a replication setup method just to replicate a specific
database not all the databases or exclude a specific database not to be
replicated?
Thank you.
Kandy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[E
Hello,
On Sep/25/2008, Ananda Kumar wrote:
> On the new machine its on a different partition than the database.
>
> Also did u try to analyze the table and run the query
I will do it (maybe on Saturday, as I guess that will take long time to
do it). But I think that I did last weekend when I mo
My web server is running drupal. Yesterday it started giving error messages
instead of displaying the hom page. The error says, "The MySQL error was:
Host 'web1.math.wisc.edu' is blocked because of many connection errors;
unblock with 'mysqladmin flush-hosts'."
I want to find out why that happ
Agador-
Thats LOT of errors
I would recommend using the error log to determine whats causing these errors
(and then fix)
HTH
Martin
__
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official busines
On the new machine its on a different partition than the database.
Also did u try to analyze the table and run the query
On 9/25/08, Carles Pina i Estany <[EMAIL PROTECTED]> wrote:
>
>
> Hello,
>
> On Sep/25/2008, Ananda Kumar wrote:
> > is /tmpdir parameter on both machines using the default va
Hello,
On Sep/25/2008, Ananda Kumar wrote:
> does it have the same network speed as your old server.
yes, it has. But I'm running the query from localhost :-) (socket
connection). Even, the query only returns one number and I don't have
any federated tables, etc.
>
> On 9/25/08, Carles Pina i
Hello,
On Sep/25/2008, Ananda Kumar wrote:
> is /tmpdir parameter on both machines using the default value
Old machine: yes.
New machine: I have tried two places (different partitions, same FS
-ext3-, same hard disk). On the old machine it's in a different
partition of the same hard disk than t
is /tmpdir parameter on both machines using the default value
On 9/25/08, Carles Pina i Estany <[EMAIL PROTECTED]> wrote:
>
>
> Hello,
>
> On Sep/25/2008, Ananda Kumar wrote:
> > does it have the same network speed as your old server.
>
> yes, it has. But I'm running the query from localhost :-) (
does it have the same network speed as your old server.
On 9/25/08, Carles Pina i Estany <[EMAIL PROTECTED]> wrote:
>
>
> Hello,
>
> On Sep/24/2008, Phil wrote:
> > Just a wild guess but, did you perhaps change the filesystem to a
> > journalling filsystem when moving to the different server?
>
>
Hello,
On Sep/24/2008, Phil wrote:
> Just a wild guess but, did you perhaps change the filesystem to a
> journalling filsystem when moving to the different server?
mount reports the same (ext3)
> I once accidently moved my database from an ext2 to an ext3 partition and it
> took me a while to f
16 matches
Mail list logo
