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
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?
mount
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 :-) (socket
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
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
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 value
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
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
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
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:
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 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
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
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
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
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 cursor_name
fetch cursor_name into a_variable;
delete from table_name where primary_key_column=a_variable;
commit for every 1000 records;
exit when
16 matches
Mail list logo